Results for “ben_bndry_perd”

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

Overview

APPS.BENBV_ELIG_PER_V is a business view (the "BV" prefix denotes a Business View object in the Oracle Benefits schema) built over the eligibility period definition table BEN_ELIG_PER_F. It exposes the full set of configurable eligibility criteria that determine whether a person, dependent, or program participant qualifies for a given benefit offering, including age, length of service, hours worked, compensation references, part-time status, waiting periods, and the various override, waiver, and reason codes that govern exception processing. In Oracle EBS 12.1.1 and 12.2.2, this view is used primarily by Benefits reporting, extracts, and integration layers that need the eligibility period rules rendered alongside their decoded (user-facing) meanings rather than raw lookup codes.

Underlying Base Objects

The view is defined over two documented objects:

• BEN_ELIG_PER_F (accessed via a SYNONYM) — the eligibility period definition base table. All columns in the view are sourced from this table's aliased row, PEP.
• HR_BIS (PACKAGE) — the Benefits business intelligence/decoding package. It is invoked repeatedly through HR_BIS.BIS_DECODE_LOOKUP to translate stored lookup codes into their decoded display values.

The view therefore mirrors BEN_ELIG_PER_F one-to-one, adding no aggregation or joins to entity tables; its added value is the decode layer supplied through HR_BIS and the descriptive flexfield placeholder exposed for BEN_ELIG_PER_F.

Key Columns

• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — date-tracked validity of the eligibility period definition.
• PL_ORDR_NUM, PLIP_ORDR_NUM, PTIP_ORDR_NUM — ordering/sequence numbers used when multiple eligibility records are evaluated.
• CMBN_AGE_N_LOS_VAL, AGE_VAL, LOS_VAL, AGE_UOM, LOS_UOM — combined age-and-length-of-service criteria, with decoded time units via BEN_TM_UOM.
• HRS_WKD_VAL, HRS_WKD_BNDRY_PERD_CD, PCT_FL_TM_VAL — hours-worked and full-time-percentage thresholds, including boundary period decoding.
• COMP_REF_AMT, COMP_REF_UOM, RT_COMP_REF_AMT — compensation reference amounts and their units.
• PRTN_STRT_DT, PRTN_END_DT, PRTN_OVRIDN_THRU_DT, PRTN_OVRIDN_RSN_CD — part-time coverage dates and the part-time override reason, decoded from BEN_PRTN_OVRRIDN_RSN. This is the column family targeted by searches for ben_prtn_ovrridn_rsn.
• WV_PRTN_RSN_CD, WV_CTFN_TYP_CD — waiver of part-time coverage reason and certification type, decoded from BEN_WV_PRTN_RSN and BEN_WV_PRTN_CTFN_TYP.
• WAIT_PERD_STRT_DT, WAIT_PERD_CMPLTN_DT — waiting period start and completion dates.
• ELIG_FLAG, PL_WVD_FLAG, PL_HGHLY_COMPD_FLAG, PL_KEY_EE_FLAG, DSTR_RSTCN_FLAG, DPNT_OTHR_PL_CVRD_RL_FLAG, ONCE_R_CNTUG_CD, INELG_RSN_CD — the various yes/no flags, "once and continuing" codes, and ineligibility reasons, each accompanied by a decoded value.
• _DF:BEN:BEN_ELIG_PER_F:PEP — placeholder for the descriptive flexfield attached to BEN_ELIG_PER_F.

Common Use Cases and Queries

Typical usage includes auditing part-time override reasons, extracting eligibility rules for plan configuration reviews, and feeding downstream reports that require decoded values.

• List eligibility periods with part-time override reasons:

  SELECT EFFECTIVE_START_DATE, PARTN_OVRIDN_RSN_CD
  FROM APPS.BENBV_ELIG_PER_V
  WHERE PRTN_OVRIDN_RSN_CD IS NOT NULL;

• Retrieve eligibility rules for a specific effective date window:

  SELECT AGE_VAL, LOS_VAL, HRS_WKD_VAL, ELIG_FLAG
  FROM APPS.BENBV_ELIG_PER_V
  WHERE TRUNC(SYSDATE) BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;

• Review ineligibility reasons and waiver flags for compliance reporting, decoding via the HR_BIS-supplied columns already present in the view.

Because the view relies on HR_BIS and returns decoded text, it is best suited to reporting and read-only integration rather than high-volume transactional processing.