Oracle Fusion/HCM/Global HR

PER_ALL_ASSIGNMENTS_M

Employment assignments — job, grade, position, department, payroll and status, date-effective per person.

Key Columns

ASSIGNMENT_IDPERSON_IDASSIGNMENT_NUMBERASSIGNMENT_TYPEEFFECTIVE_START_DATEORGANIZATION_IDJOB_IDGRADE_IDPOSITION_IDASSIGNMENT_STATUS_TYPE_ID

Parent Table

PER_ALL_PEOPLE_F

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

Child Tables

PER_ASSIGNMENT_SUPERVISORS_F

Manager relationships per assignment — supports multiple manager types (line, project, functional).

Common Joins

PER_JOBS_Fvia JOB_ID

The job assigned.

PER_GRADES_Fvia GRADE_ID

The grade assigned.

HR_ALL_ORGANIZATION_UNITS_Fvia ORGANIZATION_ID

The assignment's department / organization.

PER_ASSIGNMENT_SUPERVISORS_Fvia ASSIGNMENT_ID

The line manager(s) for the assignment.

Used In

Global HRPayrollCompensation

Notes

ASSIGNMENT_TYPE 'E' = employee, 'C' = contingent worker, 'P' = pending worker. The _M suffix means it is both date-effective and edition-aware.

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_ALL_ASSIGNMENTS_M