Search Results per_career_paths_fk1

Overview

HR.PER_CAREER_PATHS is a transactional configuration table in the Oracle E-Business Suite Human Resources (HR) module. It stores the master list of career paths defined for an enterprise, each of which expresses a possible progression route from one job to another. In Oracle EBS 12.1.1 and 12.2.2 this object serves as the header anchor for career path definitions that are subsequently detailed by the PER_CAREER_PATH_ELEMENTS table. It is owned by the HR schema and registered in FND Design Data as PER.PER_CAREER_PATHS, with a status of VALID.

Under a heuristic Data Vault classification derived from its foreign key structure, PER_CAREER_PATHS is satellite-leaning. It carries a system-generated primary key but no composite hub-and-link topology of its own; instead, it depends on the business group context and functions as an attribute-bearing descriptive parent. The table is physically stored in the APPS_TS_TX_DATA tablespace with PCT Free 10, while its primary and unique indexes reside in APPS_TS_TX_IDX.

Key Information Stored

The surrogate primary key is CAREER_PATH_ID, defined by the unique index PER_CAREER_PATHS_PK. Two business-key candidates are documented through unique indexes: CAREER_PATH_ID itself, and the PER_CAREER_PATHS_UK2 composite of NAME and BUSINESS_GROUP_ID, which enforces that a career path name is unique within a business group.

• CAREER_PATH_ID — System-generated primary key (NUMBER(15)); the parent reference for all path elements.
• BUSINESS_GROUP_ID — Foreign key to HR_ORGANIZATION_UNITS; identifies the business group that owns the career path and forms the partitioning key for the NAME uniqueness rule.
• NAME — VARCHAR2(30); the career path name, mandatory for the unique business key.
• COMMENTS — Free-text descriptive field for the path.
• REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE — Standard concurrent program / Who columns that capture the process which last manipulated the row.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — Standard Who audit columns for change tracking and data lineage.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE20 — Descriptive flexfield structure and segment columns allowing client-specific extension without schema change.

The table contains 34 documented columns in total. Tenure and progression detail does not sit here; it is held by the child elements table, keeping this object narrow and attribute-oriented.

Common Use Cases and Queries

Typical usage centres on retrieving the set of defined career paths for a business group, and on resolving job-to-job progression reporting by joining to the element detail. A representative query lists paths for a given business group:

SELECT cp.career_path_id, cp.name, cp.comments
FROM   hr.per_career_paths cp
WHERE  cp.business_group_id = :p_business_group_id
ORDER  BY cp.name;

To report progression steps, join to the child elements table:

SELECT cp.name AS career_path, cpe.*
FROM   hr.per_career_paths cp,
       hr.per_career_path_elements cpe
WHERE  cp.career_path_id = cpe.career_path_id
AND    cp.business_group_id = :p_business_group_id;

Common scenarios include career development and succession reporting, validating that no duplicate path names exist within a business group, and auditing changes through the Who and concurrent program columns. Flexfield segments (ATTRIBUTE_CATEGORY and ATTRIBUTE1–20) can be surfaced for region-specific or client-specific reporting where a DFF has been configured.

Related Objects

• HR.PER_CAREER_PATH_ELEMENTS — Child table; joins on CAREER_PATH_ID. Holds the individual job-to-job steps that make up the path. This is the principal dependent object.
• HR.HR_ALL_ORGANIZATION_UNITS — Referenced by BUSINESS_GROUP_ID; supplies the business group definition.
• PER_CAREER_PATHS_PK / PER_CAREER_PATHS_UK2 — Primary and unique indexes enforcing identity and the NAME-plus-business-group business key.
• PER_CAREER_PATHS_FK1 — Non-unique index supporting the BUSINESS_GROUP_ID foreign key.
• FND Design Data PER.PER_CAREER_PATHS — Registration metadata used by the Application Object Library for diagnostics and patching.

Because the table is a configuration parent for career path elements, any extract or interface that consumes progression data must traverse the CAREER_PATH_ID relationship. Deletion or modification of a path header has referential implications for its element rows, so validation against the child table should precede any maintenance operation.