Search Results per_career_path_elements_fk1

Overview

PER_CAREER_PATH_ELEMENTS is a Human Resources (HR) schema table in Oracle E-Business Suite that holds the definition of progression paths from one job to another. Each row represents a single element within a career path, establishing a directed relationship between a parent job and a subordinate job. Organizations use this table to model structured career ladders, succession flows, and job progression hierarchies that support talent management, career development planning, and workforce mobility reporting.

In the ETRM documentation for releases 12.1.1 and 12.2.2, the object is registered under the FND Design Data reference PER.PER_CAREER_PATH_ELEMENTS, carries VALID status in the HR schema, and resides in the APPS_TS_TX_DATA tablespace with PCT Free of 10. From a Data Vault modeling perspective, the heuristic classification mined from the foreign key structure suggests treating this object as a link. It connects independent business entities — jobs (PER_JOBS), career paths (PER_CAREER_PATHS), and the business group organization (HR_ALL_ORGANIZATION_UNITS) — through surrogate key references. Each row is effectively a relationship record: a subordinate job positioned beneath a parent job within a named career path.

Key Information Stored

The table contains fourteen documented columns. The most significant are summarized below.

• CAREER_PATH_ELEMENT_ID — System-generated primary key, defined by the unique index PER_CAREER_PATH_ELEMENTS_PK. This surrogate key uniquely identifies each progression element.
• BUSINESS_GROUP_ID — Foreign key to HR_ORGANIZATION_UNITS, scoping the element to a specific business group. Non-unique index PER_CAREER_PATH_ELEMENTS_FK1 supports this column, and no separate business-key unique index exists beyond the PK.
• CAREER_PATH_ID — Foreign key to PER_CAREER_PATHS, identifying the parent career path definition to which this element belongs. Indexed by PER_CAREER_PATH_ELEMENTS_FK4.
• PARENT_JOB_ID — Foreign key to PER_JOBS, identifying the higher-level job in the progression step. Indexed by PER_CAREER_PATH_ELEMENTS_FK3.
• SUBORDINATE_JOB_ID — Foreign key to PER_JOBS, identifying the lower-level job that reports into or follows the parent job. This is the column most frequently queried when tracing career path flow; it is indexed by PER_CAREER_PATH_ELEMENTS_FK2.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Standard concurrent-program Who columns recording the process that inserted or updated the row.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — Standard audit (Who) columns used for change tracking and data lineage.

The single unique index is the primary key index; no alternate unique business key is documented in ETRM metadata, so the surrogate CAREER_PATH_ELEMENT_ID remains the definitive row identifier.

Common Use Cases and Queries

Typical scenarios include rendering career path diagrams, validating job progression rules during succession planning, and reporting which subordinate jobs align beneath a given parent job. A common pattern joins the table to PER_JOBS twice to resolve both job names, as in the following example.

• Resolve a progression step: SELECT cpe.career_path_element_id, pj.job_definition_name parent_job, sj.job_definition_name subordinate_job FROM per_career_path_elements cpe, per_jobs pj, per_jobs sj WHERE cpe.parent_job_id = pj.job_id AND cpe.subordinate_job_id = sj.job_id and cpe.career_path_id = :path_id;
• Find career paths containing a specific job: Query on SUBORDINATE_JOB_ID to identify all career paths where that job appears as a downstream step.
• Business group scoping: Filter by BUSINESS_GROUP_ID to isolate career path definitions belonging to a legal employer or organization hierarchy.
• Audit and load monitoring: Use REQUEST_ID and LAST_UPDATE_DATE to trace which concurrent program populated career path elements during a data load.

Related Objects

• HR.PER_JOBS — Referenced twice, via PARENT_JOB_ID and SUBORDINATE_JOB_ID; the source of job definitions for both ends of each progression step.
• HR.PER_CAREER_PATHS — Parent table referenced by CAREER_PATH_ID; defines the named career path grouping.
• HR.HR_ALL_ORGANIZATION_UNITS — Referenced by BUSINESS_GROUP_ID; supplies business group context.
• HR.PER_CAREER_PATH_ELEMENTS_PK / FK1–FK4 indexes — Physical access paths supporting primary key lookups and foreign key joins on career path, parent job, subordinate job, and business group.