Search Results per_cagr_entitlement_results

Overview

The PER_CAGR_ENTITLEMENT_RESULTS table is a core transactional data store within the Oracle E-Business Suite Human Resources (PER) module, specifically for versions 12.1.1 and 12.2.2. It functions as a detailed log or result set for entitlements processed under a Collective Agreement (CAGR). A Collective Agreement is a formal contract defining terms and conditions of employment for a specific group of workers. This table captures the concrete outcomes of applying the rules and formulas defined within an agreement's entitlements to individual employees or assignments. Its role is to persist the calculated results, which may include monetary values, days, hours, or other units, enabling audit trails, reporting, and downstream processing.

Key Information Stored

The table's structure centers on linking the calculated result to its defining components and the specific agreement context. The primary key, CAGR_ENTITLEMENT_RESULT_ID, uniquely identifies each result record. The table's foreign keys are critical for understanding its data relationships: CAGR_ENTITLEMENT_ID links to the specific entitlement rule (PER_CAGR_ENTITLEMENTS) that was processed, while CAGR_ENTITLEMENT_ITEM_ID connects to the detailed item or element (PER_CAGR_ENTITLEMENT_ITEMS) within that entitlement. The COLLECTIVE_AGREEMENT_ID ties the result back to the overarching agreement (PER_COLLECTIVE_AGREEMENTS). While the provided metadata does not list all columns, typical data stored would include the calculated result value, the effective date or period of calculation, the person or assignment identifier to whom the result applies, and status flags indicating whether the result is provisional or finalized.

Common Use Cases and Queries

This table is central to reporting and verifying the application of collective labor agreements. Common use cases include generating statements of entitlements earned by employees, auditing batch entitlement calculation runs, and reconciling payroll inputs. A typical analytical query would join this table to its related master tables to produce a human-readable report.

Sample Query Pattern:
SELECT ca.agreement_name,
      ce.entitlement_name,
      cer.result_value,
      cer.effective_date
FROM per_cagr_entitlement_results cer,
     per_collective_agreements ca,
     per_cagr_entitlements ce
WHERE cer.collective_agreement_id = ca.collective_agreement_id
  AND cer.cagr_entitlement_id = ce.cagr_entitlement_id
  AND ca.agreement_name = '<Agreement_Name>';

Related Objects

As indicated by its foreign keys, PER_CAGR_ENTITLEMENT_RESULTS has direct, dependent relationships with three primary master tables:

• PER_COLLECTIVE_AGREEMENTS: The parent table defining the overall agreement.
• PER_CAGR_ENTITLEMENTS: Stores the header-level definition of a specific entitlement within an agreement.
• PER_CAGR_ENTITLEMENT_ITEMS: Holds the detailed components or formulas that make up an entitlement.

This table is likely referenced by various HR and payroll interfaces, custom reports, and potentially by standard Oracle EBS views that aggregate entitlement data for end-user inquiry forms. It sits at the intersection of agreement definition and transactional result.