Results for “cagr_mandatory”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.PER_CAGR_ENTITLEMENT_LINES_D is a denormalized reporting view in Oracle EBS Human Capital Management (Core HR / Compensation and Grading, "CAGR"). It exposes the entitlement line records used within Collective Agreement (CAGR) grade step progression configurations, joining the transactional entitlement lines stored in PER_CAGR_ENTITLEMENT_LINES_F to the descriptive grade, spine, spinal point, and eligibility profile information required for interpretation. Its principal value is that it resolves internal foreign keys and lookup codes into human-readable descriptions — most notably the MANDATORY_DESC column, which decodes the CAGR_MANDATORY lookup against the MANDATORY code on the underlying line, and STATUS_DESC, which decodes CAGR_STATUS. Because the view is read-only and pre-joined, it is the natural access point for concurrent programs, OBIEE/BIP reports, and integration extracts that need entitlement line detail without reproducing the decode and join logic.

Underlying Base Objects

The view is defined over PER_CAGR_ENTITLEMENT_LINES_F (the base entitlement lines table, accessed via a synonym), resolved against a set of descriptive and eligibility objects. The effective-dated date-track table supplies EFFECTIVE_START_DATE and EFFECTIVE_END_DATE. Grade and spine context comes from PER_GRADE_SPINES_V (D_GRADE as GRADE_NAME) and PER_PARENT_SPINES (NAME as PARENT_SPINE_NAME). Three aliases of PER_SPINAL_POINT_STEPS_V (PSPS1, PSPS2, PSPS3) resolve the single step and the from/to step range into SPINAL_POINT, FROM_SPINAL_POINT, and TO_SPINAL_POINT. Eligibility is carried by BEN_PRTN_ELIG_V, BEN_PRTN_ELIG_PRFL_V, and BEN_ELIGY_PRFL_V, producing ELIGIBLITY_PROFILE_NAME. All of these joins are outer joins ((+) syntax), so entitlement lines are retained even when grade, spine, spinal point, or eligibility data is absent. FND_USER supplies LAST_UPDATED_BY, and the HR_GENERAL package function DECODE_LOOKUP performs the lookup translation at query time.

Key Columns

• CAGR_ENTITLEMENT_LINE_ID — primary key of the entitlement line.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — date-tracked validity of the line.
• MANDATORY_DESC — decoded description of the CAGR_MANDATORY lookup applied to MANDATORY; indicates whether the entitlement is mandatory. This column is the direct answer to a "cagr_mandatory" search.
• VALUE, RANGE_FROM, RANGE_TO — the entitlement value and its numeric range bounds.
• GRADE_NAME, PARENT_SPINE_NAME, SPINAL_POINT, FROM_SPINAL_POINT, TO_SPINAL_POINT — grading structure context for the line.
• STATUS_DESC — decoded CAGR_STATUS description.
• ELIGIBLITY_PROFILE_NAME — eligibility profile governing the line.
• LAST_UPDATE_DATE, LAST_UPDATED_BY — audit columns resolved to the FND_USER user name.

Common Use Cases and Queries

Typical usage includes auditing which entitlement lines are mandatory, reporting entitlement ranges by grade and spinal point, and extracting eligibility-linked entitlement data for interfaces. To filter on the mandatory flag, query the decoded column:

• SELECT cagr_entitlement_line_id, grade_name, spinal_point, mandatory_desc, value, range_from, range_to FROM apps.per_cagr_entitlement_lines_d WHERE mandatory_desc = 'Yes';
• SELECT grade_name, spinal_point, eligibility_profile_name, status_desc FROM apps.per_cagr_entitlement_lines_d WHERE TRUNC(effective_start_date) <= SYSDATE AND NVL(effective_end_date, SYSDATE+1) > SYSDATE;

Because MANDATORY_DESC is produced by HR_GENERAL.DECODE_LOOKUP, filtering on it invokes the package per row; for high-volume extracts it is more efficient to join PER_CAGR_ENTITLEMENT_LINES_F to FND_LOOKUP_VALUES on lookup type CAGR_MANDATORY. The view remains the recommended read-only access path for standard reporting on CAGR entitlement lines in both 12.1.1 and 12.2.2.