Search Results per_cagr_entitlement_lines_pk

Overview

The PER_CAGR_ENTITLEMENT_LINES_F 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 functions as a child table in the configuration of Career and Grade (CAGR) entitlements. This table stores the detailed, date-effective line items that define the specific salary spines or progression points associated with a broader career or grade entitlement. Its role is to provide the granular, time-sensitive mapping between an entitlement definition and the applicable salary structures, enabling precise compensation management and progression rules over an employee's tenure.

Key Information Stored

As a date-tracked table (indicated by the '_F' suffix and the EFFECTIVE_START_DATE and EFFECTIVE_END_DATE columns), it maintains a historical record of entitlement line configurations. The primary identifier is CAGR_ENTITLEMENT_LINE_ID. The table's structure centers on two critical foreign key relationships. The CAGR_ENTITLEMENT_ID column links each line to its parent entitlement definition in the PER_CAGR_ENTITLEMENTS table. The PARENT_SPINE_ID column links the line to a specific salary spine or point defined in the PER_PARENT_SPINES table. The effective date columns ensure that changes to these associations are managed with full auditability and compliance.

Common Use Cases and Queries

This table is central to processes involving the determination of eligible salary ranges for employees based on their assigned grade or career path. Common use cases include generating reports on grade-specific compensation structures, auditing changes to entitlement rules over time, and supporting the logic for automated salary progression and promotions. A typical analytical query would join this table to its parent and related spine tables to list all active entitlement lines.

SELECT pel.cagr_entitlement_line_id,
       pe.entitlement_name,
       ps.spine_name,
       pel.effective_start_date,
       pel.effective_end_date
FROM   per_cagr_entitlement_lines_f pel,
       per_cagr_entitlements pe,
       per_parent_spines ps
WHERE  pel.cagr_entitlement_id = pe.cagr_entitlement_id
AND    pel.parent_spine_id = ps.parent_spine_id
AND    SYSDATE BETWEEN pel.effective_start_date AND pel.effective_end_date
ORDER BY pe.entitlement_name;

Related Objects

The table is integrally connected to other key HRMS objects. Its primary foreign key dependency is on PER_CAGR_ENTITLEMENTS, which holds the master entitlement definition. Its second critical relationship is with PER_PARENT_SPINES, which contains the salary spine definitions. The primary key constraint PER_CAGR_ENTITLEMENT_LINES_PK enforces uniqueness on the line ID and effective dates. This table is likely referenced by various HRMS APIs, seeded reports, and compensation workflow engines that process grade and career progression rules.