Search Results per_cagr_entitlement_lines_pk




Overview
Explore in AI Chat

Overview

The HR.PER_CAGR_ENTITLEMENT_LINES_F table is a core data structure within the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Human Resources (HRMS) module. It functions as a detailed child table within the Compensation and Grade Rules (CAGR) framework. Its primary role is to store the individual condition lines that define the specific eligibility and entitlement criteria for compensation or grade progression rules. Each record represents a single, effective-dated line item that is part of a broader entitlement definition, allowing for complex, rule-based compensation management. The table's design follows the standard EBS pattern for effective-dated (time-tracked) entities, as indicated by the '_F' suffix and the EFFECTIVE_START_DATE and EFFECTIVE_END_DATE columns.

Key Information Stored

The table stores detailed criteria for compensation entitlements. Key columns include the CAGR_ENTITLEMENT_ID, which links the line to its parent entitlement definition in a related table. The CAGR_ENTITLEMENT_LINE_ID, combined with the effective dates, forms the primary key (PER_CAGR_ENTITLEMENT_LINES_PK). Critical business columns define the rule's logic: ELIGY_PRFL_ID links to an eligibility profile; VALUE, RANGE_FROM, and RANGE_TO hold specific criteria values; and GRADE_SPINE_ID, PARENT_SPINE_ID, STEP_ID, FROM_STEP_ID, and TO_STEP_ID relate to grade and step structures. The MANDATORY flag indicates if the criterion is compulsory, and STATUS tracks the line's lifecycle. Standard EBS audit columns (CREATED_BY, LAST_UPDATE_DATE, etc.) and OBJECT_VERSION_NUMBER for optimistic locking are also present.

Common Use Cases and Queries

This table is central to reporting on and troubleshooting compensation rule configurations. A common use case involves analyzing all condition lines for a specific entitlement to verify business logic. For instance, an HR analyst might run a query to see all active lines for a given entitlement ID. Another critical scenario is identifying entitlements that reference a specific grade spine or eligibility profile during a system upgrade or data cleanup. Sample queries often join this table to its parent entitlement table and related reference tables like BEN_OIPL (via OIPL_ID) or grade structures. A typical pattern retrieves active rules as of a specific date by filtering on EFFECTIVE_START_DATE and EFFECTIVE_END_DATE. Due to Oracle's warning against direct data manipulation, these queries are primarily for diagnostic or reporting purposes within approved customizations.

Related Objects

The table has defined relationships with several other EBS objects. The primary key constraint PER_CAGR_ENTITLEMENT_LINES_PK ensures uniqueness of the line identifier and effective dates. The foreign key constraint PER_CAGR_ENTITLEMENT_LINES_FK1, on the CAGR_ENTITLEMENT_ID column, establishes a critical dependency on the parent table, likely named PER_CAGR_ENTITLEMENT_F or similar, which holds the header-level entitlement definition. As noted in the column metadata, the OIPL_ID column is a foreign key to BEN_OIPL (Option Insurance Plan Line), linking compensation rules to specific benefit plan details. The table is also intrinsically related to grade and spine tables (implied by GRADE_SPINE_ID, PARENT_SPINE_ID) and eligibility profile tables (via ELIGY_PRFL_ID).