Search Results per_cagr_entitelment_items_uk1

Overview

The PER_CAGR_ENTITLEMENT_ITEMS table is a core data structure within the Oracle E-Business Suite Human Resources (PER) module, specifically supporting the Compensation and Grade Rates (CAGR) functionality. It serves as a junction table that defines the specific calculation components for an entitlement. An entitlement represents a compensation element, such as a salary or an allowance, that is determined by applying a predefined calculation rule (API) with specific parameters. This table acts as the central link, associating an entitlement definition with its corresponding calculation API and the input values required for that calculation, thereby enabling the automated and rule-based determination of compensation items.

Key Information Stored

The table stores the relationships that define how an entitlement is calculated. Its primary columns include the surrogate key CAGR_ENTITLEMENT_ITEM_ID. The critical foreign key columns establish the essential links: CAGR_API_ID references the calculation rule in PER_CAGR_APIS, and CAGR_API_PARAM_ID points to the specific parameter for that rule in PER_CAGR_API_PARAMETERS. Furthermore, the table stores ELEMENT_TYPE_ID and INPUT_VALUE_ID, which link the entitlement to a specific payroll element and its associated input value, ensuring the calculated result is mapped to the correct component in the payroll processing system. The combination of ELEMENT_TYPE_ID and INPUT_VALUE_ID is protected by a unique key constraint (PER_CAGR_ENTITELMENT_ITEMS_UK1).

Common Use Cases and Queries

This table is primarily accessed for configuring and auditing compensation rules. A common operational query involves listing all calculation components for a specific entitlement or grade rate structure. For example, to audit the setup of a particular entitlement, one might join to PER_CAGR_ENTITLEMENTS and the API tables. Reporting use cases include validating that all required input values are mapped for active calculation rules. A typical diagnostic SQL pattern would join PER_CAGR_ENTITLEMENT_ITEMS (PEI) to PER_CAGR_APIS (PCA) and PER_CAGR_API_PARAMETERS (PCAP) to verify the integrity of the setup:

• SELECT pei.cagr_entitlement_item_id, pca.api_name, pcap.parameter_name, pei.element_type_id FROM hr.per_cagr_entitlement_items pei, hr.per_cagr_apis pca, hr.per_cagr_api_parameters pcap WHERE pei.cagr_api_id = pca.cagr_api_id AND pei.cagr_api_param_id = pcap.cagr_api_param_id;

This table is also critical during the batch calculation process, where the system reads these definitions to execute the appropriate logic and populate the PER_CAGR_ENTITLEMENT_RESULTS table.

Related Objects

PER_CAGR_ENTITLEMENT_ITEMS is a central hub within the CAGR data model. It has direct foreign key relationships with several key tables. It is a child of PER_CAGR_APIS and PER_CAGR_API_PARAMETERS, sourcing the calculation logic. Conversely, it is a parent table to PER_CAGR_ENTITLEMENTS, which defines the high-level entitlement (the link via CAGR_ENTITLEMENT_ITEM_ID), and to PER_CAGR_ENTITLEMENT_RESULTS, which stores the output values generated by executing the defined calculation. This structure clearly positions it as the essential connector between an entitlement's definition, its calculation rule, and the subsequent calculated results.