Search Results career_path_element_id

Overview

The PER_CAREER_PATH_ELEMENTS table is a core data structure within the Oracle E-Business Suite Human Resources (PER) module, specifically for versions 12.1.1 and 12.2.2. It defines and stores the hierarchical progression relationships between different jobs, enabling the modeling of career ladders within an organization. Each record in this table represents a specific node in a career path, linking a subordinate job to a potential parent or next-level job. This object is fundamental for talent management, succession planning, and workforce development functionalities, providing the underlying data model that supports career progression analysis and reporting.

Key Information Stored

The table's primary purpose is to establish job-to-job relationships within a defined career path. Key columns include CAREER_PATH_ELEMENT_ID, the unique primary key identifier. The CAREER_PATH_ID is a foreign key linking the element to its parent career path definition in the PER_CAREER_PATHS table. The core relationship is defined by SUBORDINATE_JOB_ID and PARENT_JOB_ID, which are foreign keys to the PER_JOBS table, indicating the "from" and "to" positions in the progression. The BUSINESS_GROUP_ID, a foreign key to HR_ALL_ORGANIZATION_UNITS, secures the data by mandating organization context. Additional columns typically manage data integrity, such as SEQUENCE_NUMBER for ordering elements within a path, and standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) for auditing.

Common Use Cases and Queries

This table is central to queries analyzing career progression. Common use cases include generating reports to visualize all possible career ladders for a given job, identifying potential successor pools for a senior role, and analyzing promotion pathways. A typical query might join PER_CAREER_PATH_ELEMENTS to PER_JOBS (twice) to resolve job names for both the subordinate and parent roles.

• Sample Query: To list all career paths and their constituent job progressions for a specific business group:
  SELECT cpe.CAREER_PATH_ID, cp.NAME AS PATH_NAME, subj.NAME AS SUBORDINATE_JOB, parj.NAME AS PARENT_JOB, cpe.SEQUENCE_NUMBER FROM PER_CAREER_PATH_ELEMENTS cpe JOIN PER_CAREER_PATHS cp ON cpe.CAREER_PATH_ID = cp.CAREER_PATH_ID JOIN PER_JOBS subj ON cpe.SUBORDINATE_JOB_ID = subj.JOB_ID JOIN PER_JOBS parj ON cpe.PARENT_JOB_ID = parj.JOB_ID WHERE cpe.BUSINESS_GROUP_ID = &BUSINESS_GROUP ORDER BY cpe.CAREER_PATH_ID, cpe.SEQUENCE_NUMBER;
• Data in this table may also be accessed via dedicated HRMS APIs or forms for maintenance, rather than through direct SQL updates, to preserve business logic and validation.

Related Objects

PER_CAREER_PATH_ELEMENTS is intrinsically linked to several key HRMS tables, as indicated by its foreign key constraints. The PER_CAREER_PATHS table is the parent definition for the overall path. It has two critical foreign key relationships to the PER_JOBS table: one for the SUBORDINATE_JOB_ID and another for the PARENT_JOB_ID. All records are scoped to a BUSINESS_GROUP_ID, linking to HR_ALL_ORGANIZATION_UNITS. This table is a foundational element for any custom reporting or integration that involves career development, succession planning, or organizational hierarchy analysis based on job roles. Views or public APIs within the HR module likely abstract direct access to this table for application logic.