Results for “pay_shadow_sub_classi_rule_pk”

16 results




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

Overview

The HR.PAY_SHADOW_SUB_CLASSI_RULES table is a shadow-schema object within Oracle E-Business Suite that models the PAY_SUB_CLASSIFICATION_RULES_F table from the element template shadow schema. Its purpose is to hold the rule definitions that govern how payroll elements are classified into sub-classifications, and how template exclusion rules apply to those classifications. The table resides in the HR schema with FND design data registered under PAY.PAY_SHADOW_SUB_CLASSI_RULES, is stored in the APPS_TS_TX_DATA tablespace with PCT Free 10, and is documented as VALID in both EBS 12.1.1 and 12.2.2. Because it duplicates the runtime structure of the payroll sub-classification rules in a shadow schema, it supports element template processing and comparison operations without touching the live definitions directly.

The heuristic Data Vault classification derived from the foreign key structure suggests treating this object as a link. It resolves a many-to-many style association between shadow element types and template exclusion rules, with the sub-classification rule identifier acting as the driving key of that relationship. This is a modeling suggestion rather than an enforced construct; the physical table is a conventional relational structure with standard WHO audit columns.

Key Information Stored

The table contains eleven documented columns. The most significant are the following:

Common Use Cases and Queries

Typical scenarios include reconciling shadow sub-classification rules against their runtime counterparts during element template validation, troubleshooting why a payroll element is or is not excluded from a template, and reporting on classification coverage by element type. A representative query joins the shadow element types to the rules and their exclusion rules:

  • Retrieve all rules for a given element type: SELECT sub_classification_rule_id, element_classification, exclusion_rule_id FROM pay_shadow_sub_classi_rules WHERE element_type_id = :p_element_type_id;
  • Join to exclusion rules to inspect the governing rule text: SELECT s.sub_classification_rule_id, s.element_classification, e.rule_name FROM pay_shadow_sub_classi_rules s, pay_template_exclusion_rules e WHERE s.exclusion_rule_id = e.exclusion_rule_id;
  • Locate a specific rule by primary key: SELECT * FROM pay_shadow_sub_classi_rules WHERE sub_classification_rule_id = :p_id;
  • Count rules per classification for coverage analysis: SELECT element_classification, COUNT(*) FROM pay_shadow_sub_classi_rules GROUP BY element_classification;

Related Objects

The following objects are documented as directly related through foreign key or primary key dependencies:

  • PAY_SHADOW_ELEMENT_TYPES — referenced by ELEMENT_TYPE_ID; the parent list of shadow element types.
  • PAY_TEMPLATE_EXCLUSION_RULES — referenced by EXCLUSION_RULE_ID; defines the exclusion rules applicable to classifications.
  • HR_S_SUB_CLASSN_RULES_F — references this table through SUB_CLASSIFICATION_RULE_ID, indicating a dependent shadow or staging structure that consumes these rule identifiers.
  • PAY_SHADOW_SUB_CLASSI_RULE_PK, _FK1, _FK2 — the unique and non-unique indexes in APPS_TS_TX_IDX that support the primary key and the two foreign key lookups.
  • PAY_SUB_CLASSIFICATION_RULES_F — the runtime element template table that this shadow object models; used for shadow-versus-live comparisons.