Results for “new_sub_class_rule_flag”

12 results




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

Overview

HR_S_SUB_CLASSN_RULES_F is a Human Resources (PER) module table in the Oracle EBS 12.1.1 / 12.2.2 schema owned by APPS-supporting HR. It holds "retrofitted" data associated with sub-classification rules applied to payroll or HR elements. Sub-classification rules define how an element or assignment is further categorized within a broader classification (for example, classifying a pay element under a statutory or user-defined subclass), and govern which sub-classification treatment applies to a given element type over a dated effective range. The "_F" suffix and pattern of columns (EFFECTIVE_START_DATE, EFFECTIVE_END_DATE) indicate this is a date-tracked ("F" for date-effective/full) table rather than a pure "_ALL" or event table, so rows represent versioned rule definitions valid across time.

From a Data Vault modeling perspective, the metadata classifies this table heuristically as standalone, meaning it is not treated as a classic hub, link, or satellite; in practice its dated, versioned nature makes it behave most like a satellite-style attribute store keyed by a rule identifier and an effective date. This classification is a suggested modeling convenience, not a physical constraint.

Key Information Stored

The table contains 13 documented columns. The most important are:

The documented surrogate key is SUB_CLASSIFICATION_RULE_ID. Business-key candidates are the combination of ELEMENT_TYPE_ID, CLASSIFICATION_ID, BUSINESS_GROUP_ID, LEGISLATION_CODE, and the effective dates, which typically form the natural unique index for a given rule.

Common Use Cases and Queries

Typical uses include retrieving the active rule for an element as of a date, and reporting rule coverage by legislation or business group.

SELECT element_type_id, classification_id, legislation_code,
       effective_start_date, effective_end_date
FROM   hr_s_sub_classn_rules_f
WHERE  business_group_id = :p_bg
AND    :p_as_of BETWEEN effective_start_date AND NVL(effective_end_date, :p_high)
AND    NVL(new_sub_class_rule_flag,'Y') = 'Y';

Reporters use it to audit which elements have subclass mappings, to detect missing or expired rules, and to reconcile the shadow rules held in PAY_SHADOW_SUB_CLASSI_RULES against the HR-owned definition. Because it is date-tracked, queries must always anchor on effective dates to avoid returning obsolete versions.

Related Objects

  • PAY_SHADOW_SUB_CLASSI_RULES — referenced via SUB_CLASSIFICATION_RULE_ID; the primary FK target.
  • PAY_ELEMENT_TYPES_F — source of ELEMENT_TYPE_ID values.
  • PAY_CLASSIFICATIONS / classification tables — resolve CLASSIFICATION_ID.
  • HR_ALL_ORGANIZATION_UNITS (via BUSINESS_GROUP_ID) — business group context.
  • FND_LEGAL_ENTITIES / legislation lookup — resolves LEGISLATION_CODE.
  • HR_S_SUB_CLASSN_RULES_F (date-effective views) — public synonyms/views exposing active rules.