Results for “assignment_category”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

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:

• ORIG_SYSTEM / ORIG_SYSTEM_ID — The business-key candidate pair forming the unique index PER_EMPDIR_ASSIGNMENTS_PK. ORIG_SYSTEM identifies the source system, while ORIG_SYSTEM_ID is the record's identifier within that system. There is no separate single-column surrogate primary key documented; the composite unique index serves as the business key.
• PERSON_ID — The internal person identifier linking the row to the underlying employee or applicant record.
• POSITION_ID, JOB_ID, LOCATION_ID, ORGANIZATION_ID — Foreign references describing the assignment's position, job, work location, and organization.
• SUPERVISOR_ID, SUPERVISOR_ASSIGNMENT_ID — Identify the supervisory person and the specific supervisor assignment record.
• PRIMARY_FLAG, ACTIVE — Indicate whether the assignment is the person's primary assignment and whether it is currently active.
• ASSIGNMENT_NUMBER — The human-readable assignment identifier.
• DISCRETIONARY_TITLE, EMPLOYEE_CATEGORY, EMPLOYMENT_CATEGORY, ASSIGNMENT_CATEGORY — Classification and descriptive attributes used in directory display and reporting.
• WORK_AT_HOME — Boolean-style flag for remote or home-based work arrangements.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the Oracle framework for concurrency control.
• ASS_ATTRIBUTE1 through ASS_ATTRIBUTE30 and ASS_ATTRIBUTE_CATEGORY — The descriptive flexfield segments carrying extensible, customer-defined assignment attributes.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, and CREATION_DATE capture standard WHO audit information.
• PARTITION_ID, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Support concurrent program processing and data-partitioning metadata.

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.