Dashboards - Business Intelligence

Oracle HRMS key Tables (1)

Aug 5, 2006 ERP Tables

HR_ORGANIZATION_UNITS holds the definitions that identify business groups and the organization units within a single business group. Additional information about classifications and information types for each organization is held in HR_ORGANIZATION_INFORMATION.

HR_ALL_POSITIONS_F is the datetracked table holding position definitions. A position is defined as the unique occurrence of a job in one organization. There can be many different positions that share the same JOB_ID and ORGANIZATION_ID, but each position is uniquely identified by the POSITION_ID and by the NAME. The position name
is a concatenation of flexfield segments stored in the PER_POSITION_DEFINITIONS table.

HR_OPERATING_UNITS is a view based on HR_ORGANIZATION_UNITS and
HR_ORGANIZATION_INFORMATION that returns information about operating units.