Search Results sys_il0000044076c00020

Overview

The HR.HR_S_BENEFIT_CLASSIFICATIONS table is a date-tracked (datetrack) interface shadow table that stores the definition of benefit classifications within Oracle E-Business Suite Human Resources. A benefit classification is a grouping construct that determines how a benefit plan or program is administered: whether beneficiaries and dependents are permitted, whether contributions are used, how COBRA continuation is handled, and which processing rules apply. The table resides in the APPS_TS_INTERFACE tablespace, is owned by the HR schema, and is registered under the FND Design Data application PER (Human Resources). Oracle flags this object as Oracle Internal Use Only, meaning supported access is limited to standard Oracle Applications programs rather than direct DML.

Despite the "interface" tablespace designation, this object serves as the classification definition repository used by the benefits setup and processing flows. Heuristically, the metadata's Data Vault classification is standalone, which suggests the object be modeled as an independent hub or reference table rather than as part of a link or satellite structure. Its primary key, BENEFIT_CLASSIFICATION_ID, participates in a foreign-key relationship pointing to BEN_BENEFIT_CLASSIFICATIONS.

Key Information Stored

The table contains 20 documented columns. The most significant include:

• BENEFIT_CLASSIFICATION_ID (NUMBER(15)) — the surrogate primary key uniquely identifying each classification record.
• BUSINESS_GROUP_ID (NUMBER(15)) — the enterprise or business group owning the definition, providing multi-tenant partitioning.
• BENEFIT_CLASSIFICATION_NAME (VARCHAR2(80)) — the user-facing name of the classification.
• BENEFIT_CLASSIFICATION_TYPE (VARCHAR2(30)) — the category of classification, driving downstream processing.
• ACTIVE_FLAG (VARCHAR2(30)) — indicates whether the classification is currently enabled.
• BENEFICIARY_ALLOWED_FLAG, DEPENDENTS_ALLOWED_FLAG, CHARGEABLE_FLAG, COBRA_FLAG (VARCHAR2(30)) — behavioral flags controlling eligibility, cost recovery, and continuation coverage.
• LEGISLATION_CODE (VARCHAR2(30)) — the legislative context governing the classification.
• CONTRIBUTIONS_USED, DFLT_POST_TERMINATION_RULE, DFLT_PROCESSING_TYPE, BEN_CLASS_PROCESSING_RULE (VARCHAR2(30)) — configuration controlling contribution handling and post-termination/processing behavior.
• Audit columns LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE, and the COMMENTS CLOB holding free-form notes.

The documented unique index SYS_IL0000044076C00020$$ is a LOB index on the COMMENTS column rather than a business-key candidate; the effective business identity is typically BENEFIT_CLASSIFICATION_ID scoped by BUSINESS_GROUP_ID.

Common Use Cases and Queries

Implementers query this table to audit benefit classification configuration across business groups, confirm which classifications permit dependents or COBRA, and reconcile setup before benefit plan enrollment cycles.

• Reporting active classifications: SELECT BENEFIT_CLASSIFICATION_ID, BENEFIT_CLASSIFICATION_NAME, BENEFIT_CLASSIFICATION_TYPE FROM HR.HR_S_BENEFIT_CLASSIFICATIONS WHERE ACTIVE_FLAG = 'Y';
• Legislative filtering: WHERE LEGISLATION_CODE = :leg_code to isolate classifications applicable to a country.
• Flag analysis to determine which classifications allow beneficiaries or dependents for plan design reviews.
• Joining to BEN_BENEFIT_CLASSIFICATIONS on BENEFIT_CLASSIFICATION_ID to reconcile datetracked definitions.

Related Objects

• BEN_BENEFIT_CLASSIFICATIONS — referenced by the foreign key on BENEFIT_CLASSIFICATION_ID; the base (non-datetracked) benefits classification definition.
• HR.HR_S_BENEFIT_CLASSIFICATIONS# — the datetrack shadow table referenced by this object.

Additional benefits plan, program, and eligibility objects typically join back to the classification identifier for processing and reporting.