Results for “pay_element_classifications_vl”

35 results




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

Overview

PAY_ELEMENT_CLASSIFICATIONS_VL is a validation-level (VL) view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It is registered under the PAY (Payroll) product family and holds a VALID status in the ETRM data model. The view presents element classifications — the high-level categories that group payroll elements such as Earnings, Deductions, Information, and Balance Initialization — together with their translated display names and descriptions. Because it is a VL view, it joins the base transaction table to its translation (TL) table and filters the translation rows by the session's language via USERENV('LANG'), so each query returns a single, language-appropriate row per classification. This makes the view the standard reporting and integration entry point for element classification lookups, since it removes the burden of manually joining the _TL table and applying language filtering. The view is commonly consumed by concurrent programs, Discoverer workbooks, BI Publisher reports, and inbound interfaces that must resolve a classification ID to a user-facing name.

Underlying Base Objects

The view is defined over two documented base objects, both referenced as synonyms in the APPS schema:

The join condition is B.CLASSIFICATION_ID = T.CLASSIFICATION_ID AND T.LANGUAGE = USERENV('LANG'). The view also exposes B.ROWID as ROW_ID to give the underlying row identity. There is no aggregation, filtering, or derived logic beyond the translation join, so the view is a straightforward denormalized read layer over the two tables.

Key Columns

The view exposes twenty-four columns. The most significant are:

Common Use Cases and Queries

Typical uses include LOV population, report lookups, interface validation, and reconciliation of element setup. A basic lookup follows:

  • SELECT classification_id, classification_name FROM pay_element_classifications_vl ORDER BY classification_name;
  • SELECT classification_id, classification_name, costable_flag FROM pay_element_classifications_vl WHERE business_group_id = :p_bg_id AND legislation_code = :p_leg;
  • SELECT c.classification_name, COUNT(*) FROM pay_element_types_vl e, pay_element_classifications_vl c WHERE e.classification_id = c.classification_id GROUP BY c.classification_name;

Restricting on BUSINESS_GROUP_ID and LEGISLATION_CODE is recommended to avoid returning classifications outside the caller's security and legislative scope.