Search Results per_cagr_entitlements_uk1

Overview

The HR.PER_CAGR_ENTITLEMENTS table is a core data structure within the Oracle E-Business Suite Human Resources (HRMS) module, specifically for the Collective Agreements functionality in releases 12.1.1 and 12.2.2. It functions as a junction or assignment table that links specific entitlement items to collective agreements, defining the period and rules for which an entitlement is valid under a given agreement. This table is critical for managing and calculating employee benefits, wage components, or other entitlements governed by negotiated collective bargaining agreements. Access to this data is intended strictly through standard Oracle Applications programs, as indicated by the internal use warning.

Key Information Stored

The table stores the assignment details of an entitlement item to a collective agreement. Key columns include CAGR_ENTITLEMENT_ID (the primary key surrogate identifier), CAGR_ENTITLEMENT_ITEM_ID (foreign key to the type of entitlement), and COLLECTIVE_AGREEMENT_ID (foreign key to the specific agreement). The temporal validity is managed via START_DATE and END_DATE. The STATUS column tracks the active state of the assignment. For calculation purposes, FORMULA_ID and FORMULA_CRITERIA define the computation rule and its parameters, while UNITS_OF_MEASURE and MESSAGE_LEVEL control output. Standard EBS audit columns (CREATED_BY, LAST_UPDATE_DATE, etc.) and OBJECT_VERSION_NUMBER for data versioning are also present.

Common Use Cases and Queries

This table is central to processes that determine which entitlements apply to an employee based on their assigned collective agreement. Common use cases include the batch calculation of entitlements for payroll processing, generating reports on benefits covered by specific agreements, and administering agreement terms. A typical query would join this table to its parent tables to list all active entitlements for an agreement.

SELECT caagr.NAME AS agreement_name,
       item.NAME AS entitlement_item,
       ent.START_DATE,
       ent.END_DATE,
       ent.STATUS
FROM hr.per_cagr_entitlements ent,
     hr.per_cagr_entitlement_items item,
     hr.per_collective_agreements caagr
WHERE ent.cagr_entitlement_item_id = item.cagr_entitlement_item_id
  AND ent.collective_agreement_id = caagr.collective_agreement_id
  AND ent.STATUS = 'ACTIVE'
  AND SYSDATE BETWEEN ent.START_DATE AND NVL(ent.END_DATE, SYSDATE)
ORDER BY caagr.NAME, item.NAME;

Related Objects

The table maintains defined relationships with several key objects in the Collective Agreements schema, primarily through foreign key constraints.

• Parent Tables (Referenced by PER_CAGR_ENTITLEMENTS):
  • PER_CAGR_ENTITLEMENT_ITEMS: Via CAGR_ENTITLEMENT_ITEM_ID. Defines the master list of available entitlement types.
  • PER_COLLECTIVE_AGREEMENTS: Via COLLECTIVE_AGREEMENT_ID. Defines the master collective bargaining agreements.
• Child Tables (Referencing PER_CAGR_ENTITLEMENTS):
  • PER_CAGR_ENTITLEMENT_LINES_F: References CAGR_ENTITLEMENT_ID. Stores detailed line-level data or instances of the entitlement for individuals or groups.
  • PER_CAGR_ENTITLEMENT_RESULTS: References CAGR_ENTITLEMENT_ID. Likely stores the calculated output or results from processing the entitlement.

The unique key PER_CAGR_ENTITLEMENTS_UK1 (CAGR_ENTITLEMENT_ITEM_ID, COLLECTIVE_AGREEMENT_ID) enforces that a specific entitlement item can only be assigned once to a given collective agreement.