Search Results hr_s_element_sets




Overview
Explore in AI Chat

Overview

HR_S_ELEMENT_SETS is a Human Resources (PER) table within the Oracle E-Business Suite 12.1.1 and 12.2.2 data model. Its description is documented as "- Retrofitted," indicating that the object was reconstructed or back-ported into the ETRM reference repository rather than being catalogued through its original native publication path. In functional terms, the table stores element set definitions used by Oracle Payroll and Human Resources to group payroll elements for processing, reporting, and eligibility determination. Element sets allow payroll administrators and implementers to reference a named collection of elements rather than enumerating each element individually.

From a Data Vault modeling perspective, the mined metadata classifies this object as a standalone structure with no parent lookups beyond a single foreign key. Heuristically, it is closest to a hub candidate: the record carries its own business identity (an element set name and type) and is not a transactional event log or a pure descriptive satellite. Any Data Vault implementation should treat this classification only as a suggestion and validate it against business-key uniqueness and change frequency.

Key Information Stored

The documented physical schema exposes eleven columns, with SYS_IL0000044112C00011$$ listed as an index on the object. The most significant columns are:

  • ELEMENT_SET_ID — the surrogate primary key of the row and the column that anchors the foreign-key relationship to PAY_ELEMENT_SETS.
  • ELEMENT_SET_NAME — the user-visible name of the element set, and the primary business-key candidate for identification.
  • ELEMENT_SET_TYPE — categorizes the element set (for example, distinguishing how the set is consumed by payroll processing or reporting).
  • BUSINESS_GROUP_ID — scopes the definition to a specific business group, enforcing multi-tenant separation within HR.
  • LEGISLATION_CODE — identifies the legislative context under which the element set is valid, which drives statutory behavior.
  • COMMENTS — free-text description for administrative reference.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — the standard Oracle Applications auditing columns that record who created and last modified the row and when.

The unique index SYS_IL0000044112C00011$$ is a system-generated LOB or index segment name; the true business-key candidate is the combination of ELEMENT_SET_NAME together with BUSINESS_GROUP_ID and LEGISLATION_CODE, which together scope the name uniquely.

Common Use Cases and Queries

Typical scenarios include validating element set configuration after a patch or upgrade, auditing which element sets exist per business group and legislation, and driving reports that resolve element-set membership. A basic inventory query follows:

  • SELECT element_set_id, element_set_name, element_set_type, business_group_id, legislation_code FROM hr.hr_s_element_sets WHERE business_group_id = :p_bg_id;
  • SELECT * FROM hr.hr_s_element_sets WHERE element_set_name = :p_name AND legislation_code = :p_leg;
  • Join to PAY_ELEMENT_SETS on ELEMENT_SET_ID to confirm that each HR element set has a corresponding payroll-side definition, which is useful when reconciling retrofitted or migrated configurations.

Because the table is a definitional object rather than a transactional one, reporting is generally limited to configuration extracts, setup comparisons between environments, and seed-data validation during implementations.

Related Objects

The documented foreign key establishes the principal dependency: HR_S_ELEMENT_SETS.ELEMENT_SET_ID references PAY_ELEMENT_SETS. Other objects that typically reference or depend on these definitions include the payroll element and element-set membership structures, the element set entry tables that enumerate members, and the HR element forms that query this table. The five to ten most relevant objects are:

  • PAY_ELEMENT_SETS — parent/related table joined on ELEMENT_SET_ID.
  • PAY_ELEMENT_SET_ENTRIES — holds the individual elements that make up a given set.
  • PAY_ELEMENTS — the underlying payroll elements referenced by sets.
  • HR_S_ELEMENT_SETS related LOB/index segments used for storage of long columns.
  • FND_BUSINESS_GROUPS — resolves BUSINESS_GROUP_ID to a named business group.
  • FND_LEGAL_ENTITIES / legislative reference tables — contextualizes LEGISLATION_CODE.

Reconciliation across HR_S_ELEMENT_SETS and PAY_ELEMENT_SETS is the most common integrity check, since discrepancies between the two indicate incomplete retrofits or migration gaps.