Results for “prsvr_bdgt_cd”

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

Overview

BEN_ENRT_PERD is the Enrollment Period table within the Oracle Advanced Benefits (BEN) module of Oracle E-Business Suite 12.1.1 and 12.2.2. It defines the discrete windows of time during which eligible participants may enroll in, modify, or terminate benefit elections. Each row represents a single enrollment period and serves as the central control record that drives scheduled enrollment processing, eligibility determination, rate calculation, and communication scheduling across the benefits lifecycle.

The table is owned by the BEN schema and is documented as VALID in ETRM. It contains 83 columns and is anchored by the primary key constraint BEN_ENRT_PERD_PK on the surrogate key ENRT_PERD_ID. Foreign keys link the enrollment period to the benefit year period (BEN_YR_PERD via YR_PERD_ID), to within-year periods (BEN_WTHN_YR_PERD via WTHN_YR_PERD_ID), and to HR position structure versions (PER_POS_STRUCTURE_VERSIONS via POS_STRUCTURE_VERSION_ID). Based on the foreign-key topology, in which many dependent objects reference this table by ENRT_PERD_ID, a Data Vault modeling exercise would classify BEN_ENRT_PERD as hub-leaning — a durable business entity around which satellites (attributes) and links (relationships) revolve.

Key Information Stored

The most significant data held in BEN_ENRT_PERD includes:

• ENRT_PERD_ID — the surrogate primary key (BEN_ENRT_PERD_PK) that uniquely identifies each enrollment period and is the principal foreign key referenced throughout the BEN schema.
• BUSINESS_GROUP_ID — scopes the record to the appropriate enterprise business group, supporting multi-organization deployments.
• YR_PERD_ID — links the enrollment period to its parent benefit year period in BEN_YR_PERD.
• WTHN_YR_PERD_ID — associates the record with a within-year benefit period in BEN_WTHN_YR_PERD.
• POPL_ENRT_TYP_CYCL_ID — identifies the population enrollment type cycle that governs participation.
• STRT_DT and END_DT — the effective start and end dates of the enrollment period itself.
• DFLT_ENRT_DT — the default enrollment date applied when participants do not act explicitly.
• ENRT_CVG_STRT_DT and ENRT_CVG_END_DT, with the related _CD and _RL columns (ENRT_CVG_STRT_DT_CD, ENRT_CVG_END_DT_CD, ENRT_CVG_STRT_DT_RL, ENRT_CVG_END_DT_RL) — govern the coverage start and end dates and the rules or codes used to derive them.
• RT_STRT_DT_RL and RT_END_DT_RL — rules determining rate effective start and end dates.
• PROCG_END_DT and DATA_FREEZE_DATE — the processing cut-off and data freeze dates that constrain late or retroactive changes.
• AUTO_DISTR_FLAG, USES_BDGT_FLAG, and PRSVR_BDGT_CD — operational flags and budget code controlling automatic distribution and budget-preserver behavior.
• REINSTATE_CD and DEFER_DEENROL_FLAG — govern reinstatement logic and deferral of de-enrollment processing.
• POS_STRUCTURE_VERSION_ID and HRCHY_TO_USE_CD — identify the position hierarchy version and hierarchy used for eligibility and approval routing.
• APPPROVAL_MODE_CD, HRCHY_RL, and HRCHY_AME_APP_ID — define whether approvals are required and the AME (Approval Management Engine) hierarchy and rules that process them.
• OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit and optimistic-locking columns.

The 30 ENP_ATTRIBUTE columns and the ENP_ATTRIBUTE_CATEGORY descriptor column provide a flexible descriptive-flexfield extension area for customer-specific data.

Common Use Cases and Queries

Typical usage includes identifying currently open enrollment periods, driving scheduled enrollment batch processes, reconciling participant populations to periods, and reporting enrollment activity by benefit year. The following pattern locates the active enrollment period for a business group:

• SELECT enrt_perd_id, strt_dt, end_dt, dflt_enrt_dt FROM ben.ben_enrt_perd WHERE business_group_id = :p_bg_id AND SYSDATE BETWEEN strt_dt AND end_dt ORDER BY strt_dt DESC;

A frequent join resolves the enrollment period to its benefit year period:

• SELECT ep.enrt_perd_id, yp.yr_perd_id, yp.strt_dt, yp.end_dt FROM ben.ben_enrt_perd ep, ben.ben_yr_perd yp WHERE ep.yr_perd_id = yp.yr_perd_id AND ep.enrt_perd_id = :p_enrt_perd_id;

Because many dependent tables share the ENRT_PERD_ID key, reporting queries commonly join BEN_ENRT_PERD to BEN_CM_TYP_USG_F, BEN_ENRT_PERD_FOR_PL_F, or BEN_PIL_ELCTBL_CHC_POPL to enumerate the communication types, plan offerings, and elective choice populations defined for a period. Queries filtering on AUTO_DISTR_FLAG, USES_BDGT_FLAG, or REINSTATE_CD support operational diagnostics and reconciliation after scheduled enrollment runs.

Related Objects

The following objects are the most significant of those that reference or depend on BEN_ENRT_PERD:

• BEN_YR_PERD — parent benefit year period, joined via BEN_ENRT_PERD.YR_PERD_ID.
• BEN_WTHN_YR_PERD — within-year benefit period, joined via WTHN_YR_PERD_ID.
• PER_POS_STRUCTURE_VERSIONS — position hierarchy version used for eligibility, joined via POS_STRUCTURE_VERSION_ID.
• BEN_CM_TYP_USG_F — communication type usage, joined via BEN_CM_TYP_USG_F.ENRT_PERD_ID.
• BEN_ENRT_PERD_FOR_PL_F — enrollment period plan offerings, joined via ENRT_PERD_ID.
• BEN_PIL_ELCTBL_CHC_POPL — elective choice population defined for the period, joined via ENRT_PERD_ID.
• BEN_PTNL_LER_FOR_PER and BEN_PTNL_LER_FOR_PER_RBV — potential life events for the period, joined via ENRT_PERD_ID.
• BEN_SCHEDD_ENRT_RL_F — scheduled enrollment rules, joined via ENRT_PERD_ID.
• BEN_BENEFIT_ACTIONS and BEN_CWB_PL_DSGN — benefit actions and plan designs referencing the enrollment period through ENRT_PERD_ID.

These relationships confirm that BEN_ENRT_PERD anchors a broad network of configuration, eligibility, and communication objects, making its ENRT_PERD_ID the primary join key across Advanced Benefits reporting and processing logic.