Oracle Fusion/HCM/Global HR

HR_ALL_POSITIONS_F

Position definitions — date-effective positions with their job, department, grade and headcount.

Key Columns

POSITION_IDPOSITION_CODENAMEJOB_IDORGANIZATION_IDEFFECTIVE_START_DATE

Common Joins

PER_JOBS_Fvia JOB_ID

The job the position is an instance of.

Used In

Global HR

HCM work structures: jobs, grades, positions, organizations

Assignments reference jobs (PER_JOBS_F), grades (PER_GRADES_F), positions (HR_ALL_POSITIONS_F) and organizations (HR_ALL_ORGANIZATION_UNITS_F, names in HR_ORGANIZATION_UNITS_F_TL). Locations live in HR_LOCATIONS_ALL.

Ask Oracle AI about HR_ALL_POSITIONS_F

HR_ALL_POSITIONS_F

Key Columns

Common Joins

Used In

Related