Search Results per_empdir_jobs




Overview
Explore in AI Chat

Overview

PER_EMPDIR_JOBS is a Human Resources (PER) module table owned by the HR schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores job-related information used by the Oracle Employee Directory (EmpDir) feature, which publishes employee and organizational data to a directory repository. The table operates as a staging and classification table that maps externally sourced or internally defined job records to the Employee Directory data model, keyed by a combination of originating system, language, and originating identifier.

The ETRM metadata documents this object as VALID with 38 physical columns. With respect to Data Vault modeling heuristics, the FK structure suggests a standalone classification, meaning the table functions largely as an independent reference or staging object rather than a hub, link, or satellite within a normalized vault design. It carries descriptive attributes alongside foreign key references, making it a candidate for a reference or link-satellite implementation in an analytical model.

Key Information Stored

The most significant columns are:

The unique index PER_EMPDIR_JOBS_PK covers (ORIG_SYSTEM_ID, ORIG_SYSTEM, LANGUAGE) and is the documented business-key candidate. No separate surrogate primary key column is defined in the metadata; the composite forms the effective identity.

Common Use Cases and Queries

Typical reporting and integration scenarios include resolving directory job names to defined jobs, reconciling source systems, and validating the Employee Directory sync load.

SELECT ej.NAME, ej.ORIG_SYSTEM, ej.ORIG_SYSTEM_ID, jd.NAME AS job_definition
FROM   PER_EMPDIR_JOBS ej, PER_JOB_DEFINITIONS jd
WHERE  ej.JOB_DEFINITION_ID = jd.JOB_DEFINITION_ID
AND    ej.LANGUAGE = USERENV('LANG')
AND    ej.BUSINESS_GROUP_ID = :p_business_group_id;

Administrators also query this table to identify stale records from a discontinued originating system, or to audit which jobs lack a valid JOB_DEFINITION_ID linkage.

Related Objects

  • PER_JOB_DEFINITIONS — via JOB_DEFINITION_ID; the master job definition.
  • HZ_ORIG_SYSTEMS_B — via ORIG_SYSTEM_ID; the originating system registry.
  • JTF_FM_PARTITION_X_REQUEST — via PARTITION_ID; partition/request mapping.

These relationships, together with the composite primary key PER_EMPDIR_JOBS_PK, define the principal navigation paths used in queries and in Employee Directory integration routines.