Results for “ben_benefit_classifications”

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

Overview

BEN_BENEFIT_CLASSIFICATIONS is a core configuration table in the Oracle EBS Human Resources (PER) product. It stores the classifications used to categorize benefits offered to employees, such as pension, health, life insurance, and flexible spending plans. The table resides in the HR schema and is a foundational reference used throughout Oracle Advanced Benefits (OAB) and the broader Benefits module. Each row defines a distinct benefit class that groups related benefit plans and programs for reporting, processing, and eligibility purposes. Because classifications drive downstream plan design and element linkage, the table acts as a master reference for the entire benefits configuration hierarchy.

From a Data Vault modeling perspective, the metadata suggests a hub-leaning classification. The natural business key—BENEFIT_CLASSIFICATION_NAME combined with BUSINESS_GROUP_ID and LEGISLATION_CODE—lends itself to a hub entity, with descriptive attributes such as ACTIVE_FLAG and processing rules suggesting a satellite structure. This is a modeling suggestion only, derived heuristically from the foreign key topology.

Key Information Stored

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

• BENEFIT_CLASSIFICATION_ID — surrogate primary key (BEN_BENEFIT_CLASSIFICATION_PK), uniquely identifying each classification.
• BENEFIT_CLASSIFICATION_NAME — user-facing name; part of the unique business key BEN_BENEFIT_CLASSIFICATION_UK2.
• BUSINESS_GROUP_ID — the HR business group owning the classification; also part of the unique key.
• LEGISLATION_CODE — the legislative context; the third component of the business key.
• BENEFIT_CLASSIFICATION_TYPE — categorizes the classification (e.g., pension, health).
• ACTIVE_FLAG — controls whether the classification is available for use.
• BENEFICIARY_ALLOWED_FLAG and DEPENDENTS_ALLOWED_FLAG — govern whether beneficiaries or dependents may participate.
• CHARGEABLE_FLAG — indicates whether costs may be charged against the classification.
• COBRA_FLAG — supports COBRA continuation coverage rules.
• CONTRIBUTIONS_USED — identifies applicable contribution structures.
• DFLT_POST_TERMINATION_RULE and DFLT_PROCESSING_TYPE — default processing behavior on termination.
• BEN_CLASS_PROCESSING_RULE — the processing rule applied to the classification.
• ZD_EDITION_NAME — the Oracle editioning column present in 12.2 online patching architecture.
• Audit columns such as CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, and LAST_UPDATE_DATE capture change history.

Common Use Cases and Queries

The table is frequently queried when configuring or auditing benefit plan design. A typical reporting query lists active classifications for a business group:

SELECT benefit_classification_id, benefit_classification_name, benefit_classification_type FROM ben_benefit_classifications WHERE business_group_id = :p_bg_id AND active_flag = 'Y' AND TRUNC(SYSDATE) BETWEEN start_date AND NVL(end_date, SYSDATE);

Analysts often join it to PAY_ELEMENT_TYPES_F to trace which payroll elements are linked to a benefit class, supporting element configuration validation. It is also used to verify COBRA and dependent eligibility setups, and to build LOV queries behind OAB configuration forms.

Related Objects

The following objects reference or depend on BEN_BENEFIT_CLASSIFICATIONS:

• PAY_ELEMENT_TYPES_F — references BENEFIT_CLASSIFICATION_ID, linking payroll elements to a benefit class.
• HR_S_BENEFIT_CLASSIFICATIONS — the secure view layer over this table.
• HR_S_ELEMENT_TYPES_F — secure view exposing element-to-classification linkage.
• Benefit plan and program tables in the BEN schema, which consume classifications for plan design.
• OAB configuration forms and concurrent programs that validate classification setup before processing enrollments.

Together these relationships position BEN_BENEFIT_CLASSIFICATIONS as a central configuration hub within the Oracle Benefits data model.