Results for “hr_s_sub_classn_rules_f”
40 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:
- SUB_CLASSIFICATION_RULE_ID — surrogate primary key identifying each rule; also the referencing key to PAY_SHADOW_SUB_CLASSI_RULES.
- EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — the validity window that makes each row a dated version of the rule.
- ELEMENT_TYPE_ID — the payroll/HR element type (business key) to which the rule applies.
- CLASSIFICATION_ID — the classification the element is mapped into; defines the subclass target.
- BUSINESS_GROUP_ID — the HR business group (security/partitioning context).
- LEGISLATION_CODE — the legislation (country) under which the rule is valid.
- NEW_SUB_CLASS_RULE_FLAG — a status/indicator flag marking the rule's current/new state.
- LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — standard WHO audit columns.
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.
-
- Retrofitted
-
- Retrofitted
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2
-
12.2.2 DBA Data 12.2.2
-
eTRM - PER Tables and Views 12.2.2
Table to store NQF Training info for a person
-
eTRM - PER Tables and Views 12.1.1
Table to store NQF Training info for a person
-
12.2.2 DBA Data 12.2.2
-
12.1.1 DBA Data 12.1.1
-
eTRM - PER Tables and Views 12.1.1
Table to store NQF Training info for a person
-
eTRM - PER Tables and Views 12.2.2
Table to store NQF Training info for a person