PER_ALL_PEOPLE_F
Person records — one date-effective row set per person, holding person number and identifiers.
Key Columns
Child Tables
PER_PERSON_NAMES_F
Person names — date-effective, one row per name type (GLOBAL, LEGAL, etc.).
PER_ALL_ASSIGNMENTS_M
Employment assignments — job, grade, position, department, payroll and status, date-effective per person.
PER_PERIODS_OF_SERVICE
Work relationship periods — hire date, termination date and legal employer for each period of service.
PER_EMAIL_ADDRESSES
Person email addresses — one row per email type (work, home) per person.
PER_PHONES
Person phone numbers — date-ranged, one row per phone type (work, mobile, home).
PER_NATIONAL_IDENTIFIERS
National identifiers — government-issued IDs (SSN, NI number, etc.) per person and country.
Common Joins
PER_PERSON_NAMES_Fvia PERSON_IDThe person's name(s) — filter NAME_TYPE = 'GLOBAL' for the primary name.
PER_ALL_ASSIGNMENTS_Mvia PERSON_IDThe person's employment assignments (job, grade, department, manager).
PER_PERIODS_OF_SERVICEvia PERSON_IDHire-to-termination service periods for the legal employer.
Used In
Notes
Date-effective: apply TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE.
Related
Fusion HCM person and employment data model
A worker is a person (PER_ALL_PEOPLE_F) with names (PER_PERSON_NAMES_F), one or more work relationships (PER_PERIODS_OF_SERVICE) and assignments (PER_ALL_ASSIGNMENTS_M) that carry job, grade, position, department and manager. Most rows are date-effective and need a TRUNC(SYSDATE) BETWEEN filter.