Results for “ben_prtt_enrt_actn_f”

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

Overview

BEN.BEN_PRTT_ENRT_ACTN_F is a transactional table within the Oracle Advanced Benefits (BEN) module that stores participants' outstanding enrollment actions. In Oracle EBS 12.1.1 and 12.2.2, this table acts as a worklist of actionable enrollment items generated for a participant — for example, required or optional elections, beneficiary designations, dependent coverage actions, and other enrollment tasks that must be completed or acknowledged before an enrollment result becomes final. Each row represents a discrete enrollment action tied to a participant's life event (PER_IN_LER) and a specific action type (ACTN_TYP).

From a Data Vault modeling perspective, the metadata's FK structure suggests this object behaves as a link table — it connects a participant life-event record (BEN_PER_IN_LER) to an action-type definition (BEN_ACTN_TYP) and carries descriptive attributes. The table is date-tracked via EFFECTIVE_START_DATE and EFFECTIVE_END_DATE, consistent with EBS date-effective datetrack patterns.

Key Information Stored

The primary key is BEN_PRTT_ENRT_ACTN_F_PK, composed of PRTT_ENRT_ACTN_ID, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE. PRTT_ENRT_ACTN_ID is the surrogate identifier for the enrollment action; the two date columns form the datetrack business-key portion.

• PRTT_ENRT_ACTN_ID — Surrogate primary key for the enrollment action record.
• PER_IN_LER_ID — Foreign key to BEN_PER_IN_LER; the participant life-event (or enrollment) that spawned this action.
• ACTN_TYP_ID — Foreign key to BEN_ACTN_TYP; classifies the action (e.g., elect plan, add dependent).
• PRTT_ENRT_RSLT_ID — Links the action to its enrollment result.
• RQD_FLAG — Indicates whether the action is required or optional.
• DUE_DT — Deadline by which the action should be completed.
• CMPLTD_DT — Date the action was completed; null implies outstanding.
• PL_BNF_ID — Plan beneficiary reference associated with the action.
• ELIG_CVRD_DPNT_ID — Eligible covered dependent tied to the action.
• BUSINESS_GROUP_ID — Partitioning column for multi-BG installations.
• PEA_ATTRIBUTE_CATEGORY and PEA_ATTRIBUTE1–30 — Descriptive flexfield segments capturing additional action attributes.
• LAST_UPDATE_DATE / LAST_UPDATED_BY / CREATION_DATE / CREATED_BY — Standard WHO audit columns.
• OBJECT_VERSION_NUMBER — Optimistic locking control for concurrent updates.

Common Use Cases and Queries

Typical uses include building enrollment worklists, driving self-service reminders, and reporting on outstanding or overdue actions during Open Enrollment or after a qualifying life event.

• Outstanding actions per participant: query rows where CMPLTD_DT IS NULL ordered by DUE_DT.
• Overdue reporting: filter WHERE CMPLTD_DT IS NULL AND DUE_DT < SYSDATE for escalation dashboards.
• Required-only worklists: add WHERE RQD_FLAG = 'Y'.
• Life-event linkage: join to BEN_PER_IN_LER on PER_IN_LER_ID to retrieve participant context.
• Action-type grouping: join to BEN_ACTN_TYP via ACTN_TYP_ID to summarize counts by action category.

Sample pattern:

SELECT a.PRTT_ENRT_ACTN_ID, a.DUE_DT, a.CMPLTD_DT, t.ACTN_TYP_ID
FROM BEN.BEN_PRTT_ENRT_ACTN_F a, BEN.BEN_ACTN_TYP t
WHERE a.ACTN_TYP_ID = t.ACTN_TYP_ID
AND a.CMPLTD_DT IS NULL
AND a.BUSINESS_GROUP_ID = :bg_id;

Related Objects

• BEN_PER_IN_LER — joined via BEN_PRTT_ENRT_ACTN_F.PER_IN_LER_ID = BEN_PER_IN_LER.PER_IN_LER_ID; the participant life-event driving the action.
• BEN_ACTN_TYP — joined via BEN_PRTT_ENRT_ACTN_F.ACTN_TYP_ID = BEN_ACTN_TYP.ACTN_TYP_ID; action-type lookup.
• BEN_PRTT_ENRT_RSLT_F — enrollment result linked through PRTT_ENRT_RSLT_ID.
• BEN_PL_F / BEN_PL_BENF / BEN_PL_BNF — plan and beneficiary tables referenced through PL_BNF_ID.
• BEN_ELIG_CVRD_DPNT_F — eligible covered dependent referenced via ELIG_CVRD_DPNT_ID.
• PER_ALL_PEOPLE_F — participant identity resolved through the person linked to the life event.
• BEN_PRTT_ENRT_ACTN (or its API, ben_prtt_enrt_actn_api) — programmatic maintenance of enrollment actions.