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:
- PAY_ELEMENT_CLASSIFICATIONS — the core (non-translated) table, aliased as B, which stores the classification attributes, flags, legislation context, and audit columns.
- PAY_ELEMENT_CLASSIFICATIONS_TL — the translation table, aliased as T, which supplies CLASSIFICATION_NAME and DESCRIPTION per language.
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:
- CLASSIFICATION_ID — primary key linking the classification to its elements and to the translation row.
- CLASSIFICATION_NAME and DESCRIPTION — the translated, user-facing labels sourced from the _TL table.
- BUSINESS_GROUP_ID — the business group owning the classification, critical for multi-organization and security predicates.
- LEGISLATION_CODE and LEGISLATION_SUBGROUP — localization context that determines which statutory classifications apply.
- COSTABLE_FLAG, DISTRIBUTABLE_OVER_FLAG, NON_PAYMENTS_FLAG — flags controlling costing and distribution behavior.
- DEFAULT_PRIORITY, DEFAULT_HIGH_PRIORITY, DEFAULT_LOW_PRIORITY — ordering used when the application defaults to or sequences classifications.
- COSTING_DEBIT_OR_CREDIT and PARENT_CLASSIFICATION_ID — accounting direction and hierarchy linkage.
- CREATE_BY_DEFAULT_FLAG, BALANCE_INITIALIZATION_FLAG, FREQ_RULE_ENABLED — behavioral switches for default creation, balance initialization, and frequency rules.
- Standard 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 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.
-
APPS.PAY_ELEMENT_CLASSIFICATIONS_VL·↳ PAY_ELEMENT_CLASSIFICATIONS·↳ PAY_ELEMENT_CLASSIFICATIONS_TL·Explore PAY module →
-
APPS.PAY_ELEMENT_CLASSIFICATIONS_VL·↳ PAY_ELEMENT_CLASSIFICATIONS·↳ PAY_ELEMENT_CLASSIFICATIONS_TL·Explore PAY module →
-
APPS.PAYLV_ELEMENT_CLASSIFICATION_V·↳ HR_BIS·↳ PAY_ELEMENT_CLASSIFICATIONS_VL·↳ DUAL·Explore PAY module →
-
APPS.PAYLV_ELEMENT_CLASSIFICATION_V·↳ HR_BIS·↳ PAY_ELEMENT_CLASSIFICATIONS_VL·↳ DUAL·Explore PAY module →
-
APPS.PAYBV_ELEMENT_CLASSIFICATION_V·↳ HR_BIS·↳ PAY_ELEMENT_CLASSIFICATIONS_VL·Explore PAY module →
-
APPS.PAYBV_ELEMENT_CLASSIFICATION_V·↳ HR_BIS·↳ PAY_ELEMENT_CLASSIFICATIONS_VL·Explore PAY module →
-
12.1.1 DBA Data 12.1.1
-
12.1.1 FND Design Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - PAY Tables and Views 12.1.1
Temporary table used to hold invalid location addresses.
-
eTRM - PAY Tables and Views 12.2.2
Temporary table used to hold invalid location addresses.
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - PAY Tables and Views 12.1.1
Temporary table used to hold invalid location addresses.
-
eTRM - PAY Tables and Views 12.2.2
Temporary table used to hold invalid location addresses.