Results for “egd_attribute30”

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

Overview

BEN_ELIG_DPNT_RBV is a table in the BEN schema (Oracle Advanced Benefits) that stores eligibility and rate/benefit-version information for dependents associated with a participant's enrollment. The "_RBV" naming pattern (Rule/Result Benefit Version) indicates this is a date-effective, version-aware staging or result table holding computed eligibility outcomes for dependents evaluated against benefit program eligibility rules. It is a core operational object during the benefits eligibility evaluation cycle in Oracle EBS 12.1.1 and 12.2.2.

The metadata's heuristic Data Vault classification is "standalone," meaning it does not participate in a classic hub-link-satellite dependency pattern and carries its own surrogate/business keys independently. Notably, five foreign keys exist (to BEN_ELIG_DPNT, BEN_ELIG_PER_ELCTBL_CHC, BEN_PER_IN_LER, BEN_BENEFIT_ACTIONS, and BEN_PERSON_ACTIONS), so a modeling suggestion would be to treat it as a hybrid: a link tying a dependent from BEN_ELIG_DPNT to an eligibility result, with satellite-like descriptive and rule attributes stored locally.

Key Information Stored

BEN_ELIG_DPNT_RBV contains 58 documented columns. The most significant are:

• ELIG_DPNT_ID — FK to BEN_ELIG_DPNT; identifies the eligible dependent record being evaluated. Part of the unique key.
• BENEFIT_ACTION_ID — FK to BEN_BENEFIT_ACTIONS; ties the row to a lifecycle benefits action. Part of the unique key.
• DPNT_PERSON_ID — the person ID of the dependent.
• DPNT_INELIG_FLAG and INELG_RSN_CD — indicate ineligibility status and the reason code.
• OVRDN_FLAG, OVRDN_THRU_DT — capture manual override of eligibility and its expiration.
• ELIG_STRT_DT, ELIG_THRU_DT — effective eligibility window for the dependent.
• ELIG_PER_ELCTBL_CHC_ID, ELIG_PER_ID, ELIG_PER_OPT_ID, ELIG_CVRD_DPNT_ID, PER_IN_LER_ID — links to the participant's elected plan, option, covered dependent, and learner/person-in-LE record.
• PERSON_ACTION_ID, BUSINESS_GROUP_ID, REQUEST_ID, PROGRAM_ID, OBJECT_VERSION_NUMBER — standard EBS action, security, concurrency, and auditing columns.

The documented unique index BEN_ELIG_DPNT_RBV_PK (BENEFIT_ACTION_ID, ELIG_DPNT_ID) is the business-key candidate. There is no single surrogate column; the composite provides uniqueness. WHO columns (CREATE_DT, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, PROGRAM_APPLICATION_ID) are present for auditing.

Common Use Cases and Queries

Report writers frequently join this table to BEN_ELIG_DPNT and BEN_BENEFIT_ACTIONS to produce dependent eligibility audit reports. A representative query to find ineligible dependents for a benefit action:

• SELECT r.ELIG_DPNT_ID, r.DPNT_PERSON_ID, r.INELG_RSN_CD, r.ELIG_STRT_DT, r.ELIG_THRU_DT FROM BEN.BEN_ELIG_DPNT_RBV r WHERE r.BENEFIT_ACTION_ID = :action_id AND r.DPNT_INELIG_FLAG = 'Y';

Because the table holds up to 30 descriptive EGD_ATTRIBUTE# columns, it also supports flexfield-style reporting on eligibility rule attributes. Typical use cases include reconciliation of enrollments against computed eligibility, identification of override records (OVRDN_FLAG = 'Y'), and period-based eligibility reporting using ELIG_STRT_DT/ELIG_THRU_DT.

Related Objects

• BEN_ELIG_DPNT — parent eligible-dependent definition; join on ELIG_DPNT_ID.
• BEN_BENEFIT_ACTIONS — lifecycle action context; join on BENEFIT_ACTION_ID.
• BEN_PERSON_ACTIONS — person-level action; join on PERSON_ACTION_ID.
• BEN_PER_IN_LER — participant life-event/LE record; join on PER_IN_LER_ID.
• BEN_ELIG_PER_ELCTBL_CHC — eligible plan/electable choice; join on ELIG_PER_ELCTBL_CHC_ID.

These relationships position BEN_ELIG_DPNT_RBV as a bridge between eligibility rule definitions and the participant's enrollment/action lifecycle, making it essential for eligibility diagnostics and audit reporting.