Results for “cbr_per_in_ler_id”

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

Overview

BENBV_CBR_PER_IN_LER_V is a read-only Oracle EBS Advanced Benefits (BEN) view owned by the APPS schema. It exposes persons who have experienced a life event that may qualify them to participate in extended benefits as legislated under COBRA. In the COBRA regulatory model, a qualifying event (such as termination, divorce, or a dependent aging out) triggers a limited window during which a former participant — or a covered dependent — may elect to continue coverage. This view surfaces those persons together with the prior eligibility period end date, the initial event indicator, and the identifiers linking the person, the life event, and the qualified beneficiary record. Because it is defined with WITH READ ONLY, it is intended strictly for query and reporting access rather than for transaction processing.

Underlying Base Objects

The view is defined over the APPS synonym BEN_CBR_PER_IN_LER, which resolves to the COBRA person-in-life-event base table. Its DDL selects from that synonym as alias CRP and applies an organizational security filter: WHERE CRP.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, CRP.BUSINESS_GROUP_ID). This restricts returned rows to the business group established by the user's HR security profile, unless no profile is set, in which case all business groups are returned. The view also references the HR_BIS package through HR_BIS.BIS_DECODE_LOOKUP('YES_NO', CRP.INIT_EVT_FLAG), which translates the stored YES/NO flag into its descriptive meaning for reporting. A descriptive flexfield token is projected as the pseudo-column "_DF:CRP", signalling that the DFF defined as BEN_CBR_PER_IN_LER_F is attached to the underlying entity.

Key Columns

• PRVS_ELIG_PERD_END_DT — The prior eligibility period end date; the point at which coverage or eligibility ceased and from which the COBRA continuation window is measured. This is the column most frequently referenced by users searching this view.
• CNT_NUM — Contact number identifying the person for whom the life event was recorded.
• INIT_EVT_FLAG — Flag indicating whether the life event is the initial qualifying event.
• INIT_EVT_FLAG_M — The decoded, displayable form of the initial event flag derived via HR_BIS.BIS_DECODE_LOOKUP.
• CBR_PER_IN_LER_ID — Primary identifier of the COBRA person-in-life-event row.
• PER_IN_LER_ID — Identifier of the associated person life event record.
• CBR_QUALD_BNF_ID — Identifier of the related COBRA qualified beneficiary.
• BUSINESS_GROUP_ID — The business group used for the security profile filter.
• Who columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, and CREATION_DATE, standard audit attributes.
• "_DF:CRP" — Descriptive flexfield token associated with the BEN_CBR_PER_IN_LER_F flexfield.

Common Use Cases and Queries

Typical uses include COBRA eligibility audits, identifying persons whose prior eligibility period ended within a given range, and reporting on initial qualifying events. Because security filtering is embedded, results automatically honour the querying user's business group unless overridden by a NULL profile.

List persons with their prior eligibility period end date:

SELECT cnt_num,
       prvs_elig_perd_end_dt,
       init_evt_flag_m,
       cbr_per_in_ler_id,
       cbr_quald_bnf_id
FROM   apps.benbv_cbr_per_in_ler_v
WHERE  prvs_elig_perd_end_dt BETWEEN :p_start_dt AND :p_end_dt
ORDER BY prvs_elig_perd_end_dt;

Isolate initial qualifying events only:

SELECT cnt_num,
       prvs_elig_perd_end_dt,
       cbr_per_in_ler_id
FROM   apps.benbv_cbr_per_in_ler_v
WHERE  init_evt_flag = 'Y';

Project the attached flexfield for descriptive context:

SELECT cnt_num,
       prvs_elig_perd_end_dt,
       "_DF:CRP" AS dff_context
FROM   apps.benbv_cbr_per_in_ler_v;

Queries should avoid DML against this object; it is defined WITH READ ONLY, and any data maintenance must be performed against the base BEN_CBR_PER_IN_LER entity through the supported COBRA processes.