Results for “ecc_attribute_category”

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

Overview

BEN_ELCTBL_CHC_CTFN_RBV is a transactional table in the BEN (Advanced Benefits) schema of Oracle E-Business Suite, available in releases 12.1.1 and 12.2.2. The object name encodes its purpose: "ELCTBL_CHC_CTFN" refers to eligible choice certifications, and the trailing "RBV" suffix indicates that the physical table is surfaced to the application through a runtime business view layer. In practical terms, the table captures certification requirements attached to benefit elections — the conditions a participant must satisfy, and in some cases document, before an enrollment in an eligible choice can be confirmed as valid. It bridges benefit enrollment activity with the certification engine used during enrolment processing, life-event processing, and periodic eligibility re-evaluation.

Mined from its foreign-key structure, the ETRM metadata classifies this object heuristically as standalone rather than as a hub, link, or satellite in a Data Vault sense. This should be read as a modeling suggestion only: although the table carries several foreign keys, the certification record is treated as an independent, self-sufficient functional unit rather than a pure junction or reference entity. The table is recorded as VALID with 49 documented columns in the 12.2.2 physical schema.

Key Information Stored

The documented unique index, BEN_ELCTBL_CHC_CTFN_RBV_PK, is defined on the column pair (BENEFIT_ACTION_ID, ELCTBL_CHC_CTFN_ID). This pair is the closest documented business-key candidate; note that the surrogate identity of a row is effectively composite rather than a single generated sequence key. The most significant columns include:

• ELCTBL_CHC_CTFN_ID — identifier of the eligibility choice certification definition being applied.
• BENEFIT_ACTION_ID and PERSON_ACTION_ID — the benefit action and person action contexts in which the certification is evaluated or satisfied.
• ELIG_PER_ELCTBL_CHC_ID — the person-level eligible choice instance to which the certification belongs.
• ENRT_BNFT_ID — the enrollment benefit record associated with the certification.
• ENRT_CTFN_TYP_CD — the enrollment certification type code controlling processing behaviour.
• RQD_FLAG — indicates whether the certification is mandatory for the election to stand.
• BUSINESS_GROUP_ID — the HR business group that owns the record, essential for multi-tenant filtering.
• ECC_ATTRIBUTE_CATEGORY and ECC_ATTRIBUTE1 through ECC_ATTRIBUTE30 — a descriptive flexfield block for customer-defined certification attributes.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the BEN APIs.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, CREATION_DATE, and the PROGRAM_* / REQUEST_ID columns — WHO/WHEN audit trail and concurrent program provenance.

Common Use Cases and Queries

Typical scenarios include identifying participants with outstanding mandatory certifications, reconciling certification records against enrollment outcomes, and reporting on certifications created by a specific concurrent process.

A representative query locating mandatory certifications for a business group:

• SELECT ecct.elctbl_chc_ctfn_id, ecct.elig_per_elctbl_chc_id, ecct.enrt_bnft_id, ecct.enrt_ctfn_typ_cd, ecct.rqd_flag FROM ben.ben_elctbl_chc_ctfn_rbv ecct WHERE ecct.business_group_id = :p_bg_id AND ecct.rqd_flag = 'Y';

Audit and troubleshooting queries commonly filter on REQUEST_ID, PROGRAM_ID, or LAST_UPDATE_DATE to trace which concurrent program inserted or updated certification rows. Because the object is exposed as a runtime business view, reporting and extracts should query it by its documented name rather than attempting direct DML; inserts and updates are normally performed through the Advanced Benefits certification and enrollment APIs, which maintain OBJECT_VERSION_NUMBER integrity.

Related Objects

The documented foreign keys define the principal join paths:

• BEN_ELCTBL_CHC_CTFN — joined on ELCTBL_CHC_CTFN_ID; holds the certification definition.
• BEN_ELIG_PER_ELCTBL_CHC — joined on ELIG_PER_ELCTBL_CHC_ID; the person-level eligible choice.
• BEN_ENRT_BNFT — joined on ENRT_BNFT_ID; the enrollment benefit record.
• BEN_BENEFIT_ACTIONS — joined on BENEFIT_ACTION_ID; the benefit action context and part of the unique key.
• BEN_PERSON_ACTIONS — joined on PERSON_ACTION_ID; the underlying person action driving the certification.

Surrounding processing is delivered through the BEN enrollment and certification APIs, and reporting commonly joins PER_ALL_PEOPLE_F via the person action or eligible-choice path to present participant-identifiable output.