Results for “pay_element_sets”

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

Overview

PAY_ELEMENT_SETS is a Payroll (PAY) module table owned by the HR schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It groups payroll elements into named sets, which are then used to restrict payroll runs to a specific collection of elements, to customize element selection windows, or to serve as a distribution set for cost allocation. Because elements carry the earning, deduction, and employer charge definitions that drive gross-to-net calculations, the ability to organize them into reusable sets is fundamental to controlling which elements participate in a given payroll process.

The table sits at the center of a hub-leaning structure. Under a heuristic Data Vault classification mined from its foreign-key footprint, PAY_ELEMENT_SETS behaves as a hub: it holds the durable identity of each element set, while link tables such as PAY_ELEMENT_LINKS_F associate sets with individual element definitions, and rules tables define classification and eligibility logic. This hub orientation makes the table a stable anchor for downstream references across payroll processing and costing.

Key Information Stored

The table comprises 12 documented columns. The surrogate primary key is ELEMENT_SET_ID, enforced by the PAY_ELEMENT_SETS_PK unique index (ELEMENT_SET_ID, ZD_EDITION_NAME). In the 12.2.2 schema the unique index includes ZD_EDITION_NAME, reflecting the editioning and online-patching model introduced in that release.

• ELEMENT_SET_ID — surrogate primary key uniquely identifying each element set.
• ELEMENT_SET_NAME — the user-visible business name of the set; the principal business-key candidate along with the set type and business group.
• ELEMENT_SET_TYPE — the functional category of the set, determining whether it is used for payroll run restriction, window customization, or cost distribution.
• BUSINESS_GROUP_ID — the enterprise or business group that owns the set, anchoring it to a specific legislative and organizational context.
• LEGISLATION_CODE — the legislation (country) under which the set is defined, governing which elements are eligible for inclusion.
• COMMENTS — free-form text describing the purpose or scope of the set.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit columns recording who created and last modified the row.
• ZD_EDITION_NAME — editioning identifier supporting the 12.2.2 online patching architecture.

Common Use Cases and Queries

Typical scenarios include auditing which element sets are defined for a legislation, identifying the sets referenced by a payroll action, and tracing which elements belong to a set. Because sets filter payroll run scope, they are frequently examined during reconciliation of a payroll run or when diagnosing why an element was omitted from processing.

A representative query lists sets for a business group and legislation:

SELECT element_set_id, element_set_name, element_set_type
FROM   hr.pay_element_sets
WHERE  business_group_id = :p_bg_id
AND    legislation_code = :p_leg_code
ORDER BY element_set_name;

To find the elements associated with a set, join to the link table PAY_ELEMENT_LINKS_F on ELEMENT_SET_ID. To determine which payroll actions consume a given set, join PAY_PAYROLL_ACTIONS on ELEMENT_SET_ID. Reporting on set usage supports configuration review before a payroll run and cost distribution verification.

Related Objects

The following objects reference or depend on PAY_ELEMENT_SETS through the documented foreign keys, joining on ELEMENT_SET_ID:

• PAY_ELEMENT_LINKS_F — associates elements with the set; the primary link between sets and element definitions.
• PAY_ELEMENT_TYPE_RULES — defines element type inclusion rules scoped to the set.
• PAY_ELE_CLASSIFICATION_RULES — defines classification-based rules that populate or restrict the set.
• PAY_PAYROLL_ACTIONS — payroll run actions that reference an element set to limit processing scope.
• PAY_EVENT_GROUP_USAGES — ties event groups to element sets for event-driven processing.
• PAY_BATCH_ELEMENT_LINKS — links batch element definitions to the set.
• HR_S_ELEMENT_SETS and HR_S_ELEMENT_TYPE_RULES / HR_S_ELE_CLASSN_RULES — secure (datetracked) versions supporting effective-dated access.
• PSB_WS_ELEMENT_LINES and PSB_WS_ACCOUNT_LINES — worksheet element and account lines referencing the set for cost distribution.