Results for “benefit_classification_name”

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

Overview

PER_EMPLOYEE_BENEFITS_V is an APPS-owned view in the Oracle E-Business Suite PER (Human Resources) product, holding VALID status in the ETRM repository for 12.1.1 and 12.2.2. The documented purpose is to support the user interface, and its structure confirms this: it is a denormalized, presentation-oriented projection that flattens benefit element, classification, contribution, and lookup data into a single row per assignment and element. Rather than storing data, the view assembles it at runtime so that Oracle Forms-based benefits screens and related self-service pages can display coverage, cost, and COBRA information without issuing multiple joins directly against the underlying payroll and benefits tables.

Because the view is built on effective-dated tables and resolves input values using the current FND_SESSIONS effective date, its output is context-sensitive. Querying through the applications tier is therefore preferable to ad hoc SQL in reporting environments where session context is not established.

Underlying Base Objects

The documented base objects are BEN_BENEFIT_CLASSIFICATIONS, BEN_BENEFIT_CONTRIBUTIONS_F, FND_SESSIONS, HR_LOOKUPS, PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_ENTRY_VALUES_F, PAY_ELEMENT_LINKS_F, PAY_ELEMENT_TYPES_F, PAY_ELEMENT_TYPES_F_TL, PAY_INPUT_VALUES_F, plus the FND_NUMBER and HR_API packages. Most are referenced through APPS synonyms.

• BEN_BENEFIT_CLASSIFICATIONS supplies classification names and the COBRA_FLAG that drives the COBRA column.
• BEN_BENEFIT_CONTRIBUTIONS_F provides employer and employee contribution amounts per benefit contribution record.
• PAY_ELEMENT_ENTRIES_F, PAY_ELEMENT_LINKS_F, and PAY_ELEMENT_TYPES_F/F_TL establish the element-to-assignment relationship and resolved element name.
• PAY_ELEMENT_ENTRY_VALUES_F and PAY_INPUT_VALUES_F supply actual screen entry values and defined input value defaults for coverage and contributions.
• HR_LOOKUPS resolves meanings for coverage, COBRA, and unit of measure.
• FND_SESSIONS restricts the effective date used to validate element types, links, and related date-tracked rows.
• FND_NUMBER performs canonical-to-number conversion on contribution amounts.

Key Columns

• ASSIGNMENT_ID — the assignment for which benefit element data is presented.
• ELEMENT_NAME / ELEMENT_TYPE_ID — the payroll element and its type identifier.
• BENEFIT_CLASSIFICATION_NAME — classification from BEN_BENEFIT_CLASSIFICATIONS.
• COVERAGE / COVERAGE_MEANING — coverage value, resolved via screen entry value or input value default, and its lookup meaning.
• COBRA — derived with DECODE on the classification COBRA_FLAG: when the flag equals 'Y' one lookup meaning is returned, otherwise another. This is the column most relevant to searches for "cobra_flag".
• UOM — unit of measure lookup meaning.
• ER_CONT / EE_CONT / TOTAL_CONT — employer contribution, employee contribution, and their sum, each resolved from screen entry value, then contribution record, then input value default.

Common Use Cases and Queries

The view is used to render benefit element information and to expose COBRA-eligible classifications for downstream checks.

SELECT assignment_id,
       element_name,
       benefit_classification_name,
       coverage_meaning,
       cobra,
       er_cont,
       ee_cont,
       total_cont
FROM   apps.per_employee_benefits_v
WHERE  assignment_id = :p_assignment_id;

To identify classifications currently marked COBRA-eligible in a session, filter on the COBRA column against the lookup meaning produced when COBRA_FLAG is 'Y'. Because the view depends on FND_SESSIONS and USERENV('SESSIONID'), direct SQL outside a connected session may return no rows; in such cases a wrapper function or concurrent program context should be used. For integration or extract purposes, join ASSIGNMENT_ID back to PER_ALL_ASSIGNMENTS_F to enrich the output with person and payroll details.