Search Results per_cagr_entitlement_items




Overview
Explore in AI Chat

Overview

The PER_CAGR_ENTITLEMENT_ITEMS table resides in the HR schema and belongs to the PER (Human Resources) product family within Oracle E-Business Suite 12.1.1 and 12.2.2. It is a configuration and definition table for the Compensation and Benefits Administration (CAGR) entitlement engine. Each row defines a single entitlement item — a discrete unit of entitlement value that the engine evaluates, calculates, or awards when processing a participant's eligibility against a benefit or compensation plan.

Functionally, the table acts as the metadata layer between the entitlement calculation APIs (PER_CAGR_APIS and PER_CAGR_API_PARAMETERS) and the transactional results generated for individual participants (PER_CAGR_ENTITLEMENT_RESULTS). It specifies the name of an item, the data type and size expected, the input value or element type that feeds it, the unit of measure, and the business rules or formula invoked to derive the value.

From a Data Vault modeling perspective, the mined foreign key structure classifies this table as satellite-leaning. It holds descriptive attributes and references to parent API and parameter entities, but it does not behave as a pure hub or a pure link. Modelers treating it as a satellite would anchor it to a hub derived from CAGR_ENTITLEMENT_ITEM_ID.

Key Information Stored

The most significant columns include:

The remaining columns are standard audit and editioning fields such as LAST_UPDATE_DATE, CREATED_BY, and OBJECT_VERSION_NUMBER.

Common Use Cases and Queries

Typical use cases include reporting on which entitlement items are defined per business group, auditing the API bindings for each item, and troubleshooting why a participant's entitlement result was produced or skipped.

A representative query listing items with their API definitions:

  • SELECT i.item_name, i.element_type_id, i.input_value_id, i.uom, a.api_name
  • FROM per_cagr_entitlement_items i
  • JOIN per_cagr_apis a ON a.cagr_api_id = i.cagr_api_id
  • WHERE i.business_group_id = :p_bg_id;

Another common pattern traces results back to their defining item, joining PER_CAGR_ENTITLEMENT_RESULTS to PER_CAGR_ENTITLEMENT_ITEMS on CAGR_ENTITLEMENT_ITEM_ID to correlate an award with its element type and legislation.

Related Objects

  • PER_CAGR_APIS — referenced via CAGR_API_ID.
  • PER_CAGR_API_PARAMETERS — referenced via CAGR_API_PARAM_ID.
  • PER_CAGR_ENTITLEMENTS — references this table through CAGR_ENTITLEMENT_ITEM_ID.
  • PER_CAGR_ENTITLEMENT_RESULTS — references this table through CAGR_ENTITLEMENT_ITEM_ID.

These four objects constitute the primary dependency chain for entitlement definition and evaluation in the PER module.