Search Results per_cagr_entitlements




Overview
Explore in AI Chat

Overview

PER_CAGR_ENTITLEMENTS is a Human Resources (PER) module table within the Oracle E-Business Suite 12.1.1 and 12.2.2 data model. It stores collective agreement entitlement definitions used by Oracle's Collective Agreements (CAGR) functionality, which governs rules-based entitlements such as leave accrual, severance, and other benefits derived from labor agreements. Each row associates a specific entitlement item with a collective agreement and carries the validity window, status, formula reference, units of measure, and audit information required to drive entitlement calculation.

The table is owned by the HR schema and holds 16 documented columns. Based on the foreign key structure provided in the ETRM metadata, the table is best characterized as satellite-leaning. Its functional purpose is to hold the descriptive and contextual attributes of entitlements within the CAGR model. Because it depends on both PER_CAGR_ENTITLEMENT_ITEMS and PER_COLLECTIVE_AGREEMENTS while being referenced by entitlement lines and results, it functions as a configuration-level entity in the entitlement definition chain rather than as a transaction hub.

Key Information Stored

The surrogate primary key is CAGR_ENTITLEMENT_ID, enforced by the PER_CAGR_ENTITLEMENTS_PK index. This identifier uniquely labels each entitlement definition and is the column carried by downstream dependent tables.

Two business-key candidates are documented. PER_CAGR_ENTITLEMENTS_PK establishes CAGR_ENTITLEMENT_ID as the surrogate key, while PER_CAGR_ENTITLEMENTS_UK1 defines a unique constraint across CAGR_ENTITLEMENT_ITEM_ID and COLLECTIVE_AGREEMENT_ID. This composite effectively enforces that a given entitlement item may appear only once per collective agreement.

  • CAGR_ENTITLEMENT_ITEM_ID — foreign key to PER_CAGR_ENTITLEMENT_ITEMS, identifying the type of entitlement being defined.
  • COLLECTIVE_AGREEMENT_ID — foreign key to PER_COLLECTIVE_AGREEMENTS, linking the entitlement to its governing labor agreement.
  • START_DATE / END_DATE — the effective date range during which the entitlement definition is valid.
  • STATUS — lifecycle indicator controlling whether the entitlement is active or otherwise.
  • FORMULA_ID / FORMULA_CRITERIA — reference to the formula used to compute the entitlement and any qualifying criteria.
  • UNITS_OF_MEASURE — the unit in which the entitlement quantity is expressed.
  • MESSAGE_LEVEL — severity or messaging control used during entitlement processing.
  • OBJECT_VERSION_NUMBER — optimistic locking column for concurrent update protection.
  • Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical usage centers on resolving which entitlement definitions apply to an employee based on the collective agreement covering their assignment, and within what effective period. A representative query joins the entitlement to its collective agreement and item:

  • Retrieve active entitlements for an agreement: SELECT CAGR_ENTITLEMENT_ID, CAGR_ENTITLEMENT_ITEM_ID, START_DATE, END_DATE FROM PER_CAGR_ENTITLEMENTS WHERE COLLECTIVE_AGREEMENT_ID = :id AND STATUS = 'A'.
  • Date-effective lookup: constrain START_DATE <= :as_of AND (END_DATE IS NULL OR END_DATE >= :as_of).
  • Formula troubleshooting: select FORMULA_ID and FORMULA_CRITERIA to trace how an amount is derived.
  • Reconciliation reporting: join to PER_CAGR_ENTITLEMENT_RESULTS to compare defined entitlements against calculated outcomes.

Related Objects

The following objects are documented as directly related through primary and foreign key relationships:

  • PER_CAGR_ENTITLEMENT_ITEMS — referenced via CAGR_ENTITLEMENT_ITEM_ID.
  • PER_COLLECTIVE_AGREEMENTS — referenced via COLLECTIVE_AGREEMENT_ID.
  • PER_CAGR_ENTITLEMENT_LINES_F — references this table via CAGR_ENTITLEMENT_ID.
  • PER_CAGR_ENTITLEMENT_RESULTS — references this table via CAGR_ENTITLEMENT_ID.