Results for “cagr_message_level”
12 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
APPS.PER_CAGR_ENTITLEMENTS_V is a reporting and integration view within the Oracle E-Business Suite Enterprise Technology and Reporting Model (ETRM), specifically aligned with the Collective Agreements (CAGR) functionality used by Oracle Payroll and Oracle Human Resources. The view exposes entitlement records defined against collective agreements, joining the transactional entitlement rows in PER_CAGR_ENTITLEMENTS with descriptive attributes resolved from the entitlement item definition view (PER_CAGR_ENTITLEMENT_ITEMS_V) and the collective agreement header (PER_COLLECTIVE_AGREEMENTS). Its principal design objective is to present decoded, human-readable values in place of internal lookup codes — status, beneficial rule, formula criteria, and message level are all passed through HR_GENERAL.DECODE_LOOKUP — so that downstream reports, extracts, and interfaces do not need to re-implement lookup translation logic. The object is defined in the APPS schema and is available in both EBS 12.1.1 and 12.2.2, with documented metadata recorded against the 12.2.2 ETRM release.
Underlying Base Objects
The view text is constructed from four primary sources. PER_CAGR_ENTITLEMENTS (referenced through a synonym) supplies the entitlement header, including its collective agreement, dates, status, formula, and message level. PER_CAGR_ENTITLEMENT_ITEMS_V provides the item-level definition, contributing ITEM_NAME, CATEGORY_NAME, BENEFICIAL_RULE, PARAMETER_LOOKUP_TYPE, ELEMENT_NAME, ELEMENT_TYPE_ID, INPUT_VALUE_NAME, INPUT_VALUE_ID, UOM_DESC, and the flexfield value set identifiers. PER_COLLECTIVE_AGREEMENTS (also a synonym) supplies the agreement name, and FF_FORMULAS is outer-joined so that entitlements without an associated formula are still returned. FND_SESSIONS is included in the WHERE clause to satisfy effective-date and session context; the join uses HR_GENERAL.END_OF_TIME for open-ended entitlements. Supporting packages listed in the metadata — HR_API, HR_CHKFMT, HR_GENERAL, and PAY_INPUT_VALUES_PKG — provide the lookup decoding, date handling, and input value validation used by the underlying item view.
Key Columns
- CAGR_ENTITLEMENT_ID / CAGR_ENTITLEMENT_ITEM_ID — Primary identifiers linking to the entitlement and its parent item definition.
- COLLECTIVE_AGREEMENT_ID / COLLECTIVE_AGREEMENT_NAME — The agreement to which the entitlement belongs, with a resolved name for display.
- START_DATE / END_DATE — Effective window of the entitlement; END_DATE is nullable for open-ended records.
- STATUS / STATUS_DESC — Internal status code and its decoded equivalent (lookup type CAGR_STATUS).
- MESSAGE_LEVEL / MESSAGE_LEVEL_DESC — The message-level indicator stored on PER_CAGR_ENTITLEMENTS, decoded through the CAGR_MESSAGE_LEVEL lookup and truncated to 80 characters. This is the column most directly relevant to the search term "cagr_message_level".
- BENEFICIAL_RULE / BENEFICIAL_RULE_DESC — Rule governing entitlement benefit, decoded via CAGR_BENEFICIAL_RULE.
- FORMULA_CRITERIA / FORMULA_CRITERIA_DESC — Criteria type applied to the formula, decoded via CAGR_CRITERIA_TYPE.
- FORMULA_ID / FORMULA_NAME — Associated Fast Formula, with the name resolved from FF_FORMULAS.
- ELEMENT_NAME, INPUT_VALUE_NAME, UOM_DESC, FLEX_VALUE_SET_NAME — Payroll element, input value, unit of measure, and flexfield context supplied by the item definition.
- 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 reporting entitlement coverage by collective agreement, exporting entitlement definitions for payroll validation, and auditing decoded status or message-level values without re-deriving lookup meanings.
To list entitlements for a collective agreement with decoded status and message level:
SELECT collective_agreement_name, item_name, status_desc,
message_level_desc, start_date, end_date, formula_name
FROM apps.per_cagr_entitlements_v
WHERE status = 'A'
ORDER BY collective_agreement_name, item_name;
To find entitlements carrying a specific message level, filtering on the decoded description avoids hard-coding lookup codes:
SELECT cagr_entitlement_id, collective_agreement_name, item_name,
message_level_desc
FROM apps.per_cagr_entitlements_v
WHERE UPPER(message_level_desc) LIKE '%WARNING%';
Because the view restricts results to sessions current on the system date against the entitlement's effective window, queries return only entitlements active for the invoking session — a behaviour worth noting when historical or future-dated records are required.