Skip to main content
OracleOps AI
← All tables
Oracle Fusion/HCM/Global HR

PER_PERIODS_OF_SERVICE

Work relationship periods — hire date, termination date and legal employer for each period of service.

Key Columns

PERIOD_OF_SERVICE_IDPERSON_IDDATE_STARTACTUAL_TERMINATION_DATELEGAL_EMPLOYER_NAMEPERIOD_TYPE

Parent Table

PER_ALL_PEOPLE_F

Person records — one date-effective row set per person, holding person number and identifiers.

Used In

Global HRPayroll

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.

Ask Oracle AI about PER_PERIODS_OF_SERVICE