>> PER_ALL_PEOPLE_F
This is the base
table for all date-tracked personal details and provides the very basic information about employee/contingent
worker/applicant. The
columns START_DATE, EFFECTIVE_START_DATE and EFFECTIVE_END_DATE are all maintained
by DateTrack. The START_DATE is the date when the first record for this
person was created. The earliest EFFECTIVE_START_DATE for a person is equal to
the START_DATE. The very data from
the first screen we see when we open the ‘People à Enter and Maintain’ form goes into this
table.
>> PER_ALL_ASSIGNMENTS_F
A DateTracked table
that holds information about employee assignments (People àEnter
and Maintain à Assignment). Employees
can have multiple assignments at any time, but there must always be a
designated primary assignment. Each assignment has an assignment status that
can change over time.
>> PER_PERSON_TYPES
Holds the list of
names that may be used when entering or changing person types. Valid person
types for a specific function are selected by joining to PER_FORM_FUNCTIONS. At
any time, only one active USER_PERSON_TYPE can be the default for a SYSTEM_PERSON_TYPE.
>> PER_PERSON_TYPES_TL
Holds the translated
USER_PERSON_TYPE information for a particular person type record
>> PER_PERSON_TYPE_USAGES_F
Identifies what type
of person the associated person is within the HR system e.g Employee,
Applicant.
Note: We should always use the
per_person_type_usages_f table to identify the correct person type for an
employee/contingent worker/applicant. We
should never depend on the person type present in the per_all_people_f table.
Instead we need to link the person_id with this table and get the correct
person type.
No comments:
Post a Comment