Results for “batch_benft_cert_id”

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

Overview

BEN_BATCH_BNFT_CERT_INFO is a transactional table in the BEN (Advanced Benefits) product schema of Oracle E-Business Suite, documented as VALID in both release 12.1.1 and 12.2.2. It stores benefit certification information created during batch run processing. In the Advanced Benefits lifecycle, certification is the mechanism by which participants attest to eligibility-related facts (for example, student status, disability, or dependent verification) so that a benefit enrollment or life event can be approved. When that certification work is executed through concurrent batch processes rather than through online self-service pages, the resulting certification instances are written to this table.

The object carries a heuristic Data Vault classification of standalone, meaning the mined foreign-key structure does not indicate a classic hub-and-satellite cluster. From a modeling perspective, this suggests treating the table as an independent record set keyed by its own surrogate identifier, with the benefit action and action type references acting as contextual lookups rather than as part of a composite business key. This classification should be regarded as a design suggestion, not an enforced constraint.

Key Information Stored

The documented physical schema exposes 18 columns. The most significant are:

• BATCH_BENFT_CERT_ID — the surrogate primary key, enforced by the unique index BEN_BATCH_BNFT_CERT_INFO_PK. It is the sole documented business-key candidate and uniquely identifies each batch-generated certification row.
• BENEFIT_ACTION_ID — foreign key to BEN_BENEFIT_ACTIONS. It links the certification record to the benefit action (enrollment, life event, or other processing event) that the certification supports.
• ACTN_TYP_ID — foreign key to BEN_ACTN_TYP. It identifies the category of the associated action, allowing transactions to be classified by action type.
• PERSON_ID — identifies the participant, or the person on whose behalf the certification was created, within the batch run.
• TYP_CD — the certification type code, distinguishing the kind of attestation being captured.
• ENRT_CTFN_RECD_DT — the date the enrollment certification was received, which drives compliance reporting and follow-up tracking.
• OBJECT_VERSION_NUMBER — the standard EBS optimistic locking column, used to detect concurrent updates.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY — the audit columns recording who created and last modified each row, and when.
• COL_16343092 through COL_16343097 — six columns exposed in the documented metadata under generated physical names rather than descriptive names; their semantics are not published in the excerpt and should be treated cautiously in reporting.

Common Use Cases and Queries

Typical reporting use cases include reconciling batch certification output, auditing missing or late certifications, and tracing certifications back to the driving benefit action. Certification volume by type and action can be aggregated for operational dashboards.

A representative join uses the documented foreign keys:

• SELECT c.batch_benft_cert_id, c.person_id, c.typ_cd, c.enrt_ctfn_recd_dt, a.benefit_action_id FROM ben.ben_batch_bnft_cert_info c, ben.ben_benefit_actions a WHERE c.benefit_action_id = a.benefit_action_id;
• SELECT typ_cd, COUNT(*) FROM ben.ben_batch_bnft_cert_info GROUP BY typ_cd;
• A count of certifications per action type joins ACTN_TYP_ID to BEN_ACTN_TYP to decode the action category.

Related Objects

• BEN_BENEFIT_ACTIONS — referenced through BENEFIT_ACTION_ID; the parent of each certification's driving action.
• BEN_ACTN_TYP — referenced through ACTN_TYP_ID; supplies action type classification.
• BEN_BATCH_BNFT_CERT_INFO_PK — the unique index backing the primary key on BATCH_BENFT_CERT_ID.
• PER_ALL_PEOPLE_F — the standard person table joined via PERSON_ID to resolve participant identities in reports.
• BEN_BATCH_BNFT_CERT and related batch control objects — commonly consulted to reconcile run-level output.
• Concurrent programs and APIs in Advanced Benefits that create certification records during batch processing populate this table indirectly.