Results for “pl_opt_name”

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

Overview

The BEN_PNDG_WRKFLW_APPRVLS_V view is an APPS-owned database view delivered as part of the BEN (Advanced Benefits) product family in Oracle E-Business Suite 12.1.1 and 12.2.2. It exposes benefit election and rate information for compensation and benefits transactions that are currently routed through the Oracle Workflow approval process. Specifically, the view reports the attributes associated with the HRSSA workflow item type — the seeded HR_COMP_UPDATE_PRC process — where the transaction has been submitted by the user (indicated by a SUBMIT attribute of 'Y') and remains in an ACTIVE status.

The view is primarily used by Benefits administrators and reporting integrators to identify pending approvals against benefit enrollments, plan elections, rates, coverage amounts, and related attributes before the transaction is finally written to the base benefit tables. It effectively joins the workflow engine's runtime status and attribute tables to the HR API transaction staging tables so that the raw numeric/date/varchar values captured during a workflow-driven transaction can be presented in a readable form. Because it exposes the WORKFLOW instance context, it is useful for diagnosing stalled or "stuck" approvals in the benefits self-service and compensation workstream.

Underlying Base Objects

The view is defined over several synonym-referenced base objects owned by APPS, including:

• HR_API_TRANSACTION_STEPS (synonym) — the step definition records for the HR API transaction; aliased as STEP and referenced by transaction_step_id in the WHERE clause.
• HR_API_TRANSACTION_VALUES (synonym) — the attribute/value staging table, aliased fifteen times (VLV, VLV1–VLV14), each occurrence isolating a specific value by attribute name. Filters include VLV.NUMBER_VALUE IS NOT NULL, i.e. PERSON_ID must exist.
• WF_ITEM_ACTIVITY_STATUSES (synonym) — aliased as PROCESS and PROCESS2; supplies activity status and instance linkage. The status filter ACTIVITY_STATUS = 'ACTIVE' restricts output to open approvals.
• WF_ITEM_ATTRIBUTE_VALUES (synonym) — aliased SUBMIT_ATTRIBUTE; used to confirm the submit attribute value is 'Y'.
• WF_PROCESS_ACTIVITIES (synonym) — aliased ACTIVITY1 and ACTIVITY2; constrains the workflow to the HRSSA item type and the HR_COMP_UPDATE_PRC/ROOT process chain.

Key Columns

• PERSON_ID — from VLV.NUMBER_VALUE; the person whose transaction is awaiting approval.
• ELIG_PER_ELCTBL_CHC_ID — the eligible plan election record identifier.
• BNFT_AMT, RT_VAL, LIMIT_RT_VAL — numeric benefit amount, rate value, and rate limit.
• PL_OPT_NAME — plan option name chosen.
• ENRT_CVG_STRT_DT, RT_STRT_DT, RT_END_DT — enrollment coverage start date and rate effective start/end dates.
• JUSTIFICATION, FREQUENCY — reason text and pay frequency.
• RT_UOM_MEANING, BNFT_UOM_MEANING, ACTY_REF_PERD_MEANING, BNFT_TYP_MEANING — decoded unit-of-measure and benefit type meanings.
• CREATION_DATE, CREATED_BY — audit columns from the transaction values row.

Common Use Cases and Queries

A frequent diagnostic query lists all persons with currently pending benefits workflow approvals and the election details of each:

SELECT person_id, elig_per_elctbl_chc_id, pl_opt_name,
       bnft_amt, rt_val, rt_strt_dt, rt_end_dt
  FROM apps.ben_pndg_wrkflw_aprvls_v
 WHERE person_id = :p_person_id;

Administrators may also join this view to PER_ALL_PEOPLE_F to resolve PERSON_ID to employee name and number for reporting, or filter by creation_date to monitor stale approvals. Because the view only surfaces ACTIVE workflow items at the HRSSA item type, it can be used in conjunction with WF_ITEM_ACTIVITY_STATUSES diagnostics to identify approvals that have been pending beyond a threshold and require administrator intervention.