Results for “element_classification”
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.
- SUB_CLASSIFICATION_RULE_ID — Surrogate primary key, enforced through the PAY_SHADOW_SUB_CLASSI_RULE_PK unique index. This is the column referenced by dependent objects.
- ZD_EDITION_NAME — Editioning column included in the primary key index, reflecting the edition-based redefinition strategy adopted in EBS 12.2.x.
- ELEMENT_TYPE_ID — Foreign key to PAY_SHADOW_ELEMENT_TYPES identifying the shadow element type governed by the rule.
- EXCLUSION_RULE_ID — Foreign key to PAY_TEMPLATE_EXCLUSION_RULES linking the classification rule to a template exclusion rule.
- ELEMENT_CLASSIFICATION — Holds the classification value assigned to the shadow element type under the rule.
- OBJECT_VERSION_NUMBER — Optimistic locking column used by the Oracle Application Object Library (AOL) to detect concurrent updates.
- LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard WHO (audit) columns capturing the most recent modification.
- CREATED_BY, CREATION_DATE — Standard audit columns capturing the original insert.
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.
-
Element Template Shadow Sub-Classification Rules
-
Element Template Shadow Balance Classifications
-
APPS.PAY_APAC_PAYSLIP_ELEMENTS_V·↳ FND_DATE·↳ FND_NUMBER·↳ PAY_ACTION_INFORMATION·Explore PAY module →
-
APPS.PAY_APAC_PAYSLIP_ELEMENTS_V·↳ FND_DATE·↳ FND_NUMBER·↳ PAY_ACTION_INFORMATION·Explore PAY module →
-
Element Template Shadow Balance Classifications
-
Element Template Shadow Sub-Classification Rules
-
APPS.PAY_AC_EMP_DEDN_ACTION_INFO_V·↳ FND_COMMON_LOOKUPS·↳ FND_GLOBAL·↳ FND_NUMBER·Explore PAY module →
-
APPS.PAY_AC_EMP_DEDN_ACTION_INFO_V·↳ FND_COMMON_LOOKUPS·↳ FND_GLOBAL·↳ FND_NUMBER·Explore PAY module →
-
APPS.PAY_AC_EMP_EARN_ACTION_INFO_V·↳ FND_DATE·↳ FND_NUMBER·↳ HR_GENERAL·Explore PAY module →
-
APPS.PAY_AC_EMP_EARN_ACTION_INFO_V·↳ FND_DATE·↳ FND_NUMBER·↳ HR_GENERAL·Explore PAY module →
-
PACKAGE: APPS.PAY_SSR_SHD 12.2.2
-
PACKAGE: APPS.PAY_SBC_SHD 12.1.1
-
PACKAGE: APPS.PAY_SSR_SHD 12.1.1
-
PACKAGE: APPS.PAY_IN_SOE 12.1.1
-
PACKAGE: APPS.PAY_SBC_SHD 12.2.2
-
PACKAGE: APPS.PAY_IN_SOE 12.2.2