Results for “pay_element_sets_fv”

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

Overview

PAY_ELEMENT_SETS_FV is a read-only, formula/view object owned by the APPS schema within the Oracle Payroll (PAY) module. Its primary purpose is to present element set definitions with a denormalized, translated meaning for the ELEMENT_SET_TYPE column. Element sets are logical groupings of payroll elements (earnings, deductions, and other compensation items) that drive processing rules, costing, reporting, and eligibility logic throughout Oracle Payroll. The suffix "FV" denotes a "formula view," often used to expose a flattened, lookup-decorated dataset to forms, reports, and integrations.

The view exists in both Oracle EBS 12.1.1 and 12.2.2. It is especially relevant when users search for element_set_type, since the view not only returns the raw lookup code but also joins to HR_LOOKUPS to surface the human-readable meaning of that code. This makes it suitable for reporting layers and interfaces where description text is preferred over internal codes.

Underlying Base Objects

The documented view text joins two sources: PAY_ELEMENT_SETS_VL (aliased B) and HR_LOOKUPS (aliased HL). The join is an inner join constrained by HL.LOOKUP_TYPE = 'ELEMENT_SET_TYPE' matching HL.LOOKUP_CODE = B.ELEMENT_SET_TYPE. The view text also references HR_API, a package commonly used by the _VL and _FV constructs to apply row-level security and business-group filtering.

• PAY_ELEMENT_SETS_VL — the core view over the base table PAY_ELEMENT_SETS (and its translations). It supplies element set identifiers, names, types, legislation, and audit columns.
• HR_LOOKUPS — the lookups view providing the meaning/description for the element set type lookup code.
• HR_API — the package encapsulating security policies and derived attributes.

The _VL (base view) and _FV (formula view) layering means the view inherits business-group security and date-effective handling from the underlying database objects.

Key Columns

• ELEMENT_SET_ID — Unique identifier for the element set; the primary key used in joins.
• ROW_ID — Surrogate row identifier.
• BUSINESS_GROUP_ID — Business group owning the record; drives security filtering.
• LEGISLATION_CODE — Country/legislation context for the element set.
• BASE_ELEMENT_SET_NAME — Untranslated/base name.
• ELEMENT_SET_NAME — Display name of the element set.
• ELEMENT_SET_TYPE — The lookup code classifying the set (e.g., the value users search for).
• ELEMENT_SET_TYPE_MEANING — The decoded meaning of the type from HR_LOOKUPS.
• COMMENTS — Free-text description.
• Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN.

Common Use Cases and Queries

The view is commonly queried for reporting on element set configurations, validating assignments, and feeding interfaces that require decoded type meanings.

SELECT element_set_id, element_set_name, element_set_type,
       element_set_type_meaning, legislation_code
  FROM apps.pay_element_sets_fv
 WHERE element_set_type = :p_type;

SELECT element_set_name, element_set_type_meaning
  FROM apps.pay_element_sets_fv
 WHERE business_group_id = :p_bg_id
   AND legislation_code = :p_leg;

Typical scenarios include enumerating all element sets of a given type, cross-checking which element sets are available to a legislation, and joining to element set member tables to report composition. Because it applies business-group security, results are automatically scoped to the querying user's accessible business groups.