All persons related data are stored in
table PER_ALL_PEOPLE_F. This table stores the historic and current information
of the employee based on the Date track mode used during the record updates.
Tables below present the same data, but in a
different ways :
- PER_ALL_PEOPLE_F:
Stores the Person data with Date Track
- PER_PEOPLE_F:
a view over PER_ALL_PEOPLE_F with additional security on records.
Like, which user can see what all records?
- PER_PEOPLE_X:
shows up only the currently active record as of SYSDATE.
- PER_PEOPLE_V:
a view used by E-Biz forms to show the data with additional security using
security profiles.
- PER_ALL_PEOPLE_D:
a view that shows the date track history.
Below are the tables which are linked to
PER_ALL_PEOPLE_F using person_id.
- PER_ADDRESSES:
stores the address of a person. It’s a DATED table.
- PER_PHONES:
stores the Phone numbers of a person.
- PER_CONTACT_RELATIONSHIPS:
stores the contacts of a person.
- PER_DISABILITIES_F:
stores the disability information of a person.
- PER_PERSON_TYPE_USAGES_F:
stores the person type of a person (example: Employee, Ex-employee, Beneficiary etc.)
- PER_QUALIFICATIONS:
stores the qualification of a person.
