Search Results hr_s_element_type_rules




Overview
Explore in AI Chat

Overview

HR_S_ELEMENT_TYPE_RULES is a Human Resources (PER) table in the Oracle E-Business Suite that governs the scope of element eligibility across element sets. It is one of the "retrofitted" HR tables — legacy Oracle HRMS objects carried forward into the EBS data model and maintained under the HR schema alongside the payroll (PAY) and core HR (PER) schema families. In functional terms, the table records whether a given element type is included in or excluded from a named element set, allowing administrators to build reusable groupings of earnings, deductions, and other payroll elements without re-listing each element individually. The table is documented with eight columns in the ETRM 12.2.2 physical schema.

Heuristic Data Vault classification based on the mined foreign-key structure is standalone. This suggests a modeling interpretation in which the table is treated as a dependent or reference structure rather than a true hub or link. Practically, it behaves as an associative mapping between an element type and an element set — conceptually a link between two business entities — and the only documented foreign key (ELEMENT_SET_ID to PAY_ELEMENT_SETS) reinforces that reading. No independent surrogate key is exposed in the documented column list, so the classification should be treated as a suggestion rather than a definitive determination.

Key Information Stored

The table is deliberately narrow; the columns that carry functional meaning are few, with the remainder serving standard EBS audit purposes.

  • ELEMENT_TYPE_ID — Identifies the payroll element type whose membership in the set is being asserted. This is a business-key candidate and the principal discriminator of the rule.
  • ELEMENT_SET_ID — Identifies the element set to which the rule applies. This is the only documented foreign key, referencing PAY_ELEMENT_SETS. It is the second half of the composite business key.
  • INCLUDE_OR_EXCLUDE — The rule action. It determines whether the referenced element type is added to or removed from the set, enabling subtractive set definitions.
  • LAST_UPDATE_DATE — Timestamp of the most recent change, used for delta extraction and audit.
  • LAST_UPDATED_BY — The application user who performed the last update.
  • LAST_UPDATE_LOGIN — The login/session identifier associated with the last update.
  • CREATED_BY — The user credited with creating the rule row.
  • CREATION_DATE — Timestamp of initial row creation.

No surrogate primary key column is documented in the excerpt; the functional identity of a row is the combination of element type and element set, and the audit columns follow the WHO columns convention used throughout EBS.

Common Use Cases and Queries

Typical usage centers on answering which elements belong to which set, and diagnosing why an element is or is not processed for a given assignment or payroll run.

  • Listing all rules attached to a specific element set: SELECT element_type_id, include_or_exclude, last_update_date FROM hr_s_element_type_rules WHERE element_set_id = :p_set_id;
  • Finding every set that references a given element type: SELECT element_set_id, include_or_exclude FROM hr_s_element_type_rules WHERE element_type_id = :p_element_type_id;
  • Audit and change tracking, filtering on last_update_date to extract rules modified since a baseline date.
  • Reconciliation reports that compare include/exclude direction counts to validate set composition after a payroll configuration change.

Because the table is a reference structure with a single documented FK, joins are almost always driven from the element set or element type side rather than from this table outward.

Related Objects

The following objects are the most significant for querying and integrating this table.

  • PAY_ELEMENT_SETS — the documented foreign-key target; joined on HR_S_ELEMENT_TYPE_RULES.ELEMENT_SET_ID = PAY_ELEMENT_SETS.ELEMENT_SET_ID.
  • PAY_ELEMENT_TYPES — supplies the element type name and classification for ELEMENT_TYPE_ID.
  • PAY_ELEMENT_CLASSIFICATIONS — contextualizes element types used in sets.
  • PAY_ELEMENT_SET_USAGES — indicates where element sets are applied, extending the analysis beyond set membership.
  • FF_FORMULAS / FF_FORMULA_TYPES — formula objects frequently consuming element sets during payroll processing.
  • PER_ASSIGNMENTS — determines which employees fall under the payroll and element configurations affected by set rules.
  • PAY_PAYROLL_ACTIONS — the run-time context in which set membership ultimately matters.