Search Results per_empdir_positions




Overview
Explore in AI Chat

Overview

The PER_EMPDIR_POSITIONS table is a Human Resources (PER) module object owned by the HR schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It underpins position-related data consumed by the Employee Directory (EmpDir) functionality, providing the linkage between positions, jobs, locations, organizations, and their originating source systems. The table carries 41 documented columns and is classified as VALID in the ETRM 12.2.2 physical schema repository.

The mined Data Vault classification for this object is standalone, suggesting that from a modeling perspective the table behaves as an independent structure rather than a pure hub, link, or satellite. Its only foreign key relationships point outward to two reference tables (HZ_ORIG_SYSTEMS_B and JTF_FM_PARTITION_X_REQUEST), reinforcing that it functions largely as a self-contained directory staging or denormalized entity. Because the primary unique index PER_EMPDIR_POSITIONS_PK spans ORIG_SYSTEM_ID, ORIG_SYSTEM, and LANGUAGE, the table effectively identifies a position record by source system plus language — a pattern typical of multi-source, multi-lingual directory integrations.

Key Information Stored

The most significant columns fall into identification, business context, and audit categories:

Common Use Cases and Queries

Typical reporting scenarios include retrieving all positions for a given business group, listing positions by source system, or joining position names to jobs and locations for directory rendering.

  • Query positions within a business group:
    SELECT NAME, JOB_ID, LOCATION_ID, ORGANIZATION_ID FROM HR.PER_EMPDIR_POSITIONS WHERE BUSINESS_GROUP_ID = :p_bg_id;
  • Identify records sourced from a specific external system:
    SELECT ORIG_SYSTEM_ID, NAME, LANGUAGE FROM HR.PER_EMPDIR_POSITIONS WHERE ORIG_SYSTEM = :p_orig_system;
  • Reconcile concurrent-program loads using REQUEST_ID and PROGRAM_ID to audit a batch run.
  • Extract multi-lingual directory content filtered by LANGUAGE = 'US' or SOURCE_LANG = 'US'.

Related Objects

  • HZ_ORIG_SYSTEMS_B — referenced via ORIG_SYSTEM_ID; the registered source systems registry.
  • JTF_FM_PARTITION_X_REQUEST — referenced via PARTITION_ID; used for partitioned/request-scoped processing.
  • PER_POSITION_DEFINITIONS — implied by POSITION_DEFINITION_ID; holds the underlying position definition.
  • HR_ALL_ORGANIZATION_UNITS — implied by ORGANIZATION_ID.
  • PER_JOBS — implied by JOB_ID.
  • HR_LOCATIONS_ALL — implied by LOCATION_ID.

These relationships make PER_EMPDIR_POSITIONS a central integration point between the external directory source systems and the core HR position/job/location model.