Search Results per_empdir_assignments




Overview
Explore in AI Chat

Overview

PER_EMPDIR_ASSIGNMENTS is a Human Resources (PER) product table owned by the HR schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It functions as a directory-facing staging and synchronization table that holds employee assignment information originating from an external or source system, designated by the ORIG_SYSTEM and ORIG_SYSTEM_ID key pair. Rather than acting as the master assignment store — that role belongs to PER_ALL_ASSIGNMENTS_F — this object captures a denormalized, externally sourced view of assignment attributes that feeds the Employee Directory and related person/assignment discovery features.

The ETRM metadata classifies this object heuristically as standalone within a Data Vault modeling context. This suggests it is best treated as an independent structure rather than a true hub or satellite, though in practice it behaves much like a satellite attached to an origination-system business key, with the natural key being ORIG_SYSTEM combined with ORIG_SYSTEM_ID.

Key Information Stored

The table contains 60 documented columns spanning identity, assignment classification, supervisory hierarchy, and descriptive flexfield attributes. The most operationally significant columns include:

Common Use Cases and Queries

This table is typically queried in integration and directory-synchronization scenarios. A common pattern retrieves active primary assignments for a given source system:

  • Joining PER_EMPDIR_ASSIGNMENTS to PER_ALL_PEOPLE_F on PERSON_ID to resolve the display name of an employee directory entry.
  • Filtering on PRIMARY_FLAG = 'Y' AND ACTIVE = 'Y' to produce current directory listings.
  • Resolving ORIG_SYSTEM_ID against HZ_ORIG_SYSTEMS_B to validate the originating system reference.
  • Reporting on WORK_AT_HOME to track remote-work populations for HR analytics.
  • Reading the ASS_ATTRIBUTE flexfield columns to surface customer-defined assignment metadata in custom reports.

A representative query shape joins the assignment row to person, position, and job tables on their respective ID columns, filtering by ORIG_SYSTEM to isolate a particular source feed.

Related Objects

The documented foreign key relationships and expected joins include:

  • HZ_ORIG_SYSTEMS_B — referenced via ORIG_SYSTEM_ID; validates the source system registration.
  • JTF_FM_PARTITION_X_REQUEST — referenced via PARTITION_ID; ties the row to partition/request processing.
  • PER_ALL_ASSIGNMENTS_F — the master assignment table commonly joined on PERSON_ID and assignment attributes.
  • PER_ALL_PEOPLE_F — joined on PERSON_ID to resolve person-level details.
  • PER_JOBS / PER_POSITIONS — joined on JOB_ID and POSITION_ID respectively for descriptive lookup.
  • HR_LOCATIONS_ALL — joined on LOCATION_ID for location details.

These relationships support both referential validation and the denormalized reporting typical of employee directory and integration workflows in Oracle EBS.