Results for “pay_shadow_sub_classi_rules”

50+ results




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

Overview

PAY_SHADOW_SUB_CLASSI_RULES is a Payroll (PAY) module table owned by the HR schema in Oracle E-Business Suite 12.1.1 and 12.2.2. The table stores shadow sub-classification rules for element templates, providing the rule definitions that determine how element types are classified for costing and classification purposes within the payroll shadow schema used by Oracle Payroll and related modules such as Oracle Time and Labor and Oracle Advanced Benefits. The shadow tables mirror the primary payroll element model and allow classification logic to be evaluated without modifying the live element definitions.

From a Data Vault modeling perspective, the metadata suggests a link classification. This is a heuristic derived from the foreign key structure: the table resolves many-to-many style associations between PAY_SHADOW_ELEMENT_TYPES and PAY_TEMPLATE_EXCLUSION_RULES, placing it at the intersection of two business entities rather than acting as a standalone hub or a descriptive satellite. The link interpretation is advisory and does not represent a documented Oracle design intent.

Key Information Stored

The table contains 11 documented columns. The most significant are described below.

The business-key candidate is the composite of SUB_CLASSIFICATION_RULE_ID and ZD_EDITION_NAME, which forms the primary key index. Oracle does not document a separate natural business key beyond the surrogate identifier.

Common Use Cases and Queries

Typical uses include investigating how an element template excludes or classifies specific shadow element types, tracing why a payroll element received a particular classification during template processing, and building reconciliation reports between shadow and primary element definitions.

A common query joins the table to the shadow element types to retrieve classification rules for a given element type:

  • SELECT r.sub_classification_rule_id, r.element_classification, r.exclusion_rule_id FROM hr.pay_shadow_sub_classi_rules r WHERE r.element_type_id = :element_type_id;
  • SELECT r.*, e.element_type_name FROM hr.pay_shadow_sub_classi_rules r, hr.pay_shadow_element_types e WHERE r.element_type_id = e.element_type_id AND r.element_classification = :classification;
  • Audit reporting on the most recently modified rules: SELECT sub_classification_rule_id, last_update_date, last_updated_by FROM hr.pay_shadow_sub_classi_rules ORDER BY last_update_date DESC;

Because this is a rules table, direct DML is generally performed through the Payroll application and seed data is maintained via element template loading. Reporting should therefore be read-only in production environments.

Related Objects

  • PAY_SHADOW_ELEMENT_TYPES — Joined on ELECTION_TYPE_ID via PAY_SHADOW_SUB_CLASSI_RULES.ELEMENT_TYPE_ID; source of shadow element type definitions.
  • PAY_TEMPLATE_EXCLUSION_RULES — Joined on EXCLUSION_RULE_ID; supplies the exclusion rule definition applied to the classification.
  • HR_S_SUB_CLASSN_RULES_F — References PAY_SHADOW_SUB_CLASSI_RULES through SUB_CLASSIFICATION_RULE_ID; a shadow/interface table propagating sub-classification rule identifiers into the HR schema processing stream.
  • PAY_SHADOW_ELEMENT_TYPES (reverse navigation) — Any reporting layer combining element classifications with template metadata should expect this table to act as the link between element types and exclusion rules.
  • Oracle Payroll element template APIs — Element template creation and update processes populate this table indirectly by way of shadow element processing.