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

PER_ASSIGNMENT_SUPERVISORS_F

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

Key Columns

ASSIGNMENT_SUPERVISOR_IDASSIGNMENT_IDPERSON_IDMANAGER_IDMANAGER_TYPEEFFECTIVE_START_DATE

Parent Table

PER_ALL_ASSIGNMENTS_M

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

Used In

Global HR

Notes

MANAGER_ID is the manager's PERSON_ID; MANAGER_TYPE = 'LINE_MANAGER' is the primary reporting line.

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_ASSIGNMENT_SUPERVISORS_F