Results for “category_name_desc”

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

Overview

PER_CAGR_ENTITLEMENTS_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, defined within the PER (Human Resources) product family. It exposes collective agreement entitlements — the individual benefit or compensation rules negotiated under a collective agreement and assigned to employees or groups through Oracle HRMS. The view is a denormalized presentation layer that joins the entitlement definition table to its item definition, the parent collective agreement, the associated Fast Formula, and the current FND session. Its purpose is to flatten the underlying normalized data and resolve coded lookup values into their human-readable descriptions, so that reports, concurrent programs, and integrations can consume entitlement data without repeatedly re-implementing decode logic.

The view is particularly relevant to the MESSAGE_LEVEL attribute, which controls how the entitlement communicates validation or informational messages during entitlement processing. Rather than storing only the internal lookup code, the view surfaces both the raw MESSAGE_LEVEL column and a decoded MESSAGE_LEVEL_DESC, allowing downstream consumers to present meaningful text.

Underlying Base Objects

The view is defined over four primary sources plus supporting packages. PER_CAGR_ENTITLEMENTS (accessed via synonym) supplies the entitlement header rows, including dates, status, formula linkage, units of measure, and the MESSAGE_LEVEL code. PER_CAGR_ENTITLEMENT_ITEMS_V supplies item-level detail such as item name, category, beneficial rule, element and input value metadata, and flexfield value set information. PER_COLLECTIVE_AGREEMENTS (synonym) provides the collective agreement name. FF_FORMULAS (view) is outer-joined on FORMULA_ID to retrieve the formula name where a formula is attached. FND_SESSIONS is joined on the session identifier returned by USERENV('SESSIONID') and filtered so that the session effective date falls between the entitlement start date and its end date (or end of time), thereby restricting results to entitlements active for the current session's effective date.

Decoding of lookup values is performed through the HR_GENERAL package, specifically HR_GENERAL.DECODE_LOOKUP, against lookup types CAGR_BENEFICIAL_RULE, CAGR_STATUS, CAGR_CRITERIA_TYPE, and CAGR_MESSAGE_LEVEL. Additional referenced objects include HR_API, HR_CHKFMT, and PAY_INPUT_VALUES_PKG, which support the business logic behind item and input value resolution.

Key Columns

• CAGR_ENTITLEMENT_ID / CAGR_ENTITLEMENT_ITEM_ID — Primary and foreign keys linking the entitlement to its item definition.
• ITEM_NAME, CATEGORY_NAME, CATEGORY_NAME_DESC — Identity and classification of the entitlement item.
• BENEFICIAL_RULE / BENEFICIAL_RULE_DESC — The rule governing benefit accrual or eligibility, with decoded description.
• COLLECTIVE_AGREEMENT_ID / COLLECTIVE_AGREEMENT_NAME — The parent agreement under which the entitlement sits.
• START_DATE, END_DATE, STATUS / STATUS_DESC — Validity window and lifecycle status of the entitlement.
• FORMULA_CRITERIA / FORMULA_CRITERIA_DESC, FORMULA_ID, FORMULA_NAME — Criteria type and the Fast Formula used to evaluate the entitlement.
• ELEMENT_NAME, ELEMENT_TYPE_ID, INPUT_VALUE_NAME, INPUT_VALUE_ID, UNITS_OF_MEASURE, UOM_DESC — Payroll element and input value mapping through which the entitlement is delivered.
• MESSAGE_LEVEL / MESSAGE_LEVEL_DESC — The message severity or handling level associated with the entitlement, decoded via the CAGR_MESSAGE_LEVEL lookup.
• FLEX_VALUE_SET_ID, FLEX_VALUE_SET_NAME — Value set used for any flexfield-based parameter validation.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER.

Common Use Cases and Queries

Typical uses include auditing active entitlements, verifying formula and element mappings, and inspecting message handling behavior. Because the view self-filters on FND_SESSIONS, callers must have an active session context.

List active entitlements with decoded status and message level:

• SELECT entitlement_id, item_name, collective_agreement_name, status_desc, message_level_desc FROM per_cagr_entitlements_v WHERE status = 'A';

Identify entitlements routed through a specific formula:

• SELECT item_name, formula_name, formula_criteria_desc FROM per_cagr_entitlements_v WHERE formula_id IS NOT NULL;

Audit MESSAGE_LEVEL distribution across agreements:

• SELECT collective_agreement_name, message_level_desc, COUNT(*) FROM per_cagr_entitlements_v GROUP BY collective_agreement_name, message_level_desc;