Search Results per_cagr_entitlements




Overview
Explore in AI Chat

Overview

The PER_CAGR_ENTITLEMENTS table is a core data object within the Oracle E-Business Suite (EBS) Human Resources (HR) module, specifically for versions 12.1.1 and 12.2.2. It serves as a master junction table that defines and links specific entitlement items to collective agreements. In the context of Oracle HR, a collective agreement is a formal contract governing employment terms for a group of workers. This table is fundamental for managing the detailed compensation, benefit, and work rule entitlements stipulated within such agreements. Its role is to establish the relationship between the agreement header and the library of available entitlement items, forming the basis for subsequent entitlement calculations and result tracking for employees covered under the agreement.

Key Information Stored

The table's structure is designed to manage the relationship between agreements and their constituent entitlements. Its primary columns, as defined by the provided metadata, are the keys that enforce data integrity and define these relationships. The CAGR_ENTITLEMENT_ID column is the table's unique primary identifier. The two critical foreign key columns are COLLECTIVE_AGREEMENT_ID, which links to the PER_COLLECTIVE_AGREEMENTS table to identify the specific agreement, and CAGR_ENTITLEMENT_ITEM_ID, which links to the PER_CAGR_ENTITLEMENT_ITEMS table to specify the type of entitlement (e.g., a particular overtime rate, a specific leave accrual rule, or a bonus calculation). The combination of the collective agreement ID and the entitlement item ID is enforced as a unique key (PER_CAGR_ENTITLEMENTS_UK1), preventing the same entitlement item from being assigned multiple times to a single agreement.

Common Use Cases and Queries

This table is central to reporting and auditing what entitlements are configured for any given collective agreement. A common use case is generating a summary report of all entitlements attached to an agreement for review by HR administrators or union representatives. Another critical scenario involves troubleshooting entitlement calculations by verifying the base setup. Sample SQL queries often join this table to its related master tables. For example, to list all entitlements for a specific agreement named 'US_TECH_2024', a query would be:

  • SELECT ca.NAME AGREEMENT_NAME, cei.NAME ENTITLEMENT_NAME FROM PER_CAGR_ENTITLEMENTS pce, PER_COLLECTIVE_AGREEMENTS ca, PER_CAGR_ENTITLEMENT_ITEMS cei WHERE pce.COLLECTIVE_AGREEMENT_ID = ca.COLLECTIVE_AGREEMENT_ID AND pce.CAGR_ENTITLEMENT_ITEM_ID = cei.CAGR_ENTITLEMENT_ITEM_ID AND ca.NAME = 'US_TECH_2024';

Data from this table is also essential for processes that generate individual entitlement lines and results for employees covered by the agreement.

Related Objects

As indicated by the foreign key constraints, PER_CAGR_ENTITLEMENTS sits at the center of a key data model. It has a direct foreign key dependency on PER_COLLECTIVE_AGREEMENTS (the agreement header) and PER_CAGR_ENTITLEMENT_ITEMS (the catalog of entitlement types). More importantly, it is a parent table referenced by crucial transactional tables. The PER_CAGR_ENTITLEMENT_LINES_F table stores the calculated entitlement instances for employees, linking back to the base entitlement definition via CAGR_ENTITLEMENT_ID. Similarly, the PER_CAGR_ENTITLEMENT_RESULTS table, which likely stores the final calculated values or statuses, also references this table. This hierarchy ensures that all employee-specific entitlement data traces back to a valid master definition in PER_CAGR_ENTITLEMENTS.