Results for “inelig_text”

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

Overview

The BEN_BATCH_ELIG_INFO table is a core Advanced Benefits (BEN) object in Oracle EBS 12.1.1 and 12.2.2 that stores eligibility information generated during program batch eligibility runs. When a benefits eligibility batch process executes, either on demand or scheduled, the program evaluates a population of persons against the eligibility rules defined for a program or plan and records the results in this table. Each row captures the outcome for a specific person against a specific benefit offering, indicating whether the person is eligible or ineligible, and providing explanatory text where applicable.

From a dimensional modeling perspective, the ETRM Data Vault classification heuristic suggests this object is satellite-leaning. This reflects its design: it holds descriptive, attribute-rich rows keyed to a primary identifier, referencing a parent action record rather than acting as a conformed hub or a pure associative link. Analysts building a data vault or warehouse layer should treat it as a descriptive satellite dependent on the batch process context it references.

Key Information Stored

The table is owned by the BEN schema and contains 15 documented columns. Its surrogate primary key is BATCH_ELIG_ID, enforced by the unique index BEN_BATCH_ELIG_INFO_PK. No additional business-key unique indexes are documented, so BATCH_ELIG_ID serves as the sole guaranteed unique row identifier.

The most significant business and descriptive columns include:

• BENEFIT_ACTION_ID — foreign key to BEN_BENEFIT_ACTIONS; ties each eligibility row to the benefit action that produced it.
• PERSON_ID — identifies the person evaluated during the batch run.
• BUSINESS_GROUP_ID — scopes the row to the appropriate HR business group.
• PGM_ID — the benefit program under evaluation.
• PL_ID — the plan associated with the eligibility determination.
• OIPL_ID — the option-in-plan identifier, allowing granularity down to the plan option level.
• ELIG_FLAG — the resulting eligibility status (eligible or ineligible).
• INELIG_TEXT — explanatory text describing the reason for an ineligible outcome.
• OBJECT_VERSION_NUMBER — supports optimistic locking used by the Oracle framework.

Standard EBS audit columns are present: LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, and CREATION_DATE.

Common Use Cases and Queries

Typical scenarios center on auditing and troubleshooting batch eligibility outcomes and feeding downstream eligibility reporting. A common query retrieves ineligible persons with reasons for a given program:

• Filtering by ELIG_FLAG = 'N' and joining INELIG_TEXT to explain failures.
• Joining on PERSON_ID to PER_ALL_PEOPLE_F to enrich with employee name and assignment data.
• Reporting eligibility results by PGM_ID, PL_ID, or OIPL_ID to assess rule coverage.
• Reconciling batch output by BENEFIT_ACTION_ID against the originating action record.

A representative pattern selects row-level results joined to the benefit action and person master, restricted by business group and batch date windows.

Related Objects

• BEN_BENEFIT_ACTIONS — parent referenced via BENEFIT_ACTION_ID; defines the action context for the batch run.
• PER_ALL_PEOPLE_F — joined on PERSON_ID for person demographics.
• BEN_PGM_F — program definition referenced by PGM_ID.
• BEN_PL_F — plan definition referenced by PL_ID.
• BEN_OIPL_F — option-in-plan definition referenced by OIPL_ID.
• HR_ORGANIZATION_UNITS and business group lookups — for scoping by BUSINESS_GROUP_ID.