Results for “pay_sub_classification_rules_f”

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

Overview

PAY_SUB_CLASSIFICATION_RULES_F is a Payroll (PAY) module table owned by the HR schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the rules that determine whether a given payroll element is included in a secondary element classification. Primary element classifications, held in PAY_ELEMENT_CLASSIFICATIONS, drive fundamental payroll processing behavior — for example, whether an element is treated as earnings, deductions, or information items. Secondary classifications refine that behavior, and this table supplies the mapping logic that decides which elements participate in each secondary grouping.

From a dimensional modeling perspective, the documented metadata suggests a satellite-leaning classification. The table is date-effective, keyed on a surrogate rule identifier combined with effective start and end dates, and carries descriptive and operational attributes (legislation code, business group, audit columns) that qualify the business relationship rather than defining it. The relationship to PAY_ELEMENT_CLASSIFICATIONS via CLASSIFICATION_ID is the anchor reference, with the temporal and business-context columns behaving as satellite attributes. This should be treated as a heuristic modeling suggestion rather than an authoritative Data Vault designation.

Key Information Stored

• SUB_CLASSIFICATION_RULE_ID — surrogate identifier for the rule. It forms the leading column of the primary key PAY_SUB_CLASSIFICATION_RUL_PK.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — date-effective dating range that makes the rule temporal. Both columns participate in the primary key and in the unique index PAY_SUB_CLASSIFICATION_RUL_PK, alongside ZD_EDITION_NAME.
• ELEMENT_TYPE_ID — identifies the element type to which the inclusion rule applies.
• CLASSIFICATION_ID — foreign key referencing PAY_ELEMENT_CLASSIFICATIONS, tying the rule to its classification.
• BUSINESS_GROUP_ID — the enterprise or business group owning the rule, enabling multi-tenant separation within a single installation.
• LEGISLATION_CODE — the legislative context (country/regulatory region) governing the rule.
• ZD_EDITION_NAME — the edition/version column used by Oracle's date-effective (ZD) framework; it appears in the unique index and supports edition-based redefinition in 12.2.x.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, and CREATION_DATE provide standard WHO-column tracking.

The surrogate key is SUB_CLASSIFICATION_RULE_ID. The unique index PAY_SUB_CLASSIFICATION_RUL_PK (SUB_CLASSIFICATION_RULE_ID, EFFECTIVE_START_DATE, EFFECTIVE_END_DATE, ZD_EDITION_NAME) represents the business-key candidate that enforces temporal uniqueness.

Common Use Cases and Queries

Typical usage centers on troubleshooting why an element is or is not picked up in a secondary classification, and on reporting the current rule set for a given legislation or business group. Because the table is date-effective, queries should filter on SYSDATE between the effective dates.

• Identify active rules for an element type:

  SELECT scr.sub_classification_rule_id, scr.classification_id,
         scr.element_type_id, scr.legislation_code
  FROM   pay_sub_classification_rules_f scr
  WHERE  SYSDATE BETWEEN scr.effective_start_date AND scr.effective_end_date
  AND    scr.element_type_id = :element_type_id;
  

• Join to PAY_ELEMENT_CLASSIFICATIONS to resolve classification names:

  SELECT ec.classification_name, scr.legislation_code
  FROM   pay_sub_classification_rules_f scr,
         pay_element_classifications ec
  WHERE  ec.classification_id = scr.classification_id
  AND    SYSDATE BETWEEN scr.effective_start_date AND scr.effective_end_date;
  

• Report rules by business group and legislation for audit or configuration review.
• Detect overlapping effective-date ranges for the same rule as a data-integrity check.

Related Objects

• PAY_ELEMENT_CLASSIFICATIONS — referenced through CLASSIFICATION_ID (SCR.CLASSIFICATION_ID = EC.CLASSIFICATION_ID); the parent classification definition.
• PAY_ELEMENT_TYPES_F — the element type referenced by ELEMENT_TYPE_ID; supplies element metadata.
• PAY_ELEMENT_CLASSIFICATIONS_TL — translated classification names for reporting.
• PAY_ELEMENT_CLASS_USAGES — related classification usage configuration.
• FND_ID_FLEX_STRUCTURES and related key flexfield tables — context for classification structures.
• HR_ALL_ORGANIZATION_UNITS — resolves BUSINESS_GROUP_ID to an organization name.
• FND_LEGAL_ENTITIES / FND_TERRITORIES — resolves LEGISLATION_CODE to a territory description.