Results for “acty_ref_perd_cd”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
BEN_FLX_ENRT_UOM_INFO_V is a valid Oracle E-Business Suite view owned by the APPS schema and delivered under the BEN (Advanced Benefits) product family. It is documented in ETRM for both 12.1.1 and 12.2.2 and is described as "Retrofitted," indicating it was introduced or reworked during the OAF/HTML-based Benefits enrollment redesign introduced in Release 12. The view exposes the unit of measure (UOM) and activity reference period information associated with election choices available to a participant within a specific program and life event. Its primary role is to support the Flex Enrollment user interface and associated reporting by resolving the list of eligible elective choices and their associated UOM and period code context for the currently connected session.
Underlying Base Objects
The view is defined over several base objects in the APPS schema, all surfaced as synonyms at runtime:
- BEN_ELIG_PER_ELCTBL_CHC (EPE) — the eligibility record linking a program to the elective choices a participant may elect.
- BEN_PIL_ELCTBL_CHC_POPL (PEL) — the participant-level population records carrying the UOM and ACTY_REF_PERD_CD attributes.
- BEN_PER_IN_LER (PIL) — the person-in-life-event record that anchors the individual to a life event.
- HR_LOOKUPS (HL1) — the lookup view supplying the MEANING for the period code from the lookup type
BEN_ACTY_REF_PERD. - FND_SESSIONS (SE) — used to obtain the effective date for the active session.
- HR_API — referenced as a package dependency.
Joins link PIL.PER_IN_LER_ID to PEL.PER_IN_LER_ID and PGM_ID/ PER_IN_LER_ID to EPE respectively, so the view effectively projects only those elective choices whose eligibility, population, and person-in-life-event records are consistent and current.
Key Columns
- UOM — the unit of measure associated with the participant's election choice population.
- ACTY_REF_PERD_CD — the activity reference period code. This is the column of interest to users searching on this term; it identifies the reference period (e.g. plan year, month) applicable to the election activity.
- MEANING — the lookup meaning for ACTY_REF_PERD_CD, retrieved from HR_LOOKUPS via
LOOKUP_TYPE = 'BEN_ACTY_REF_PERD'. - PERSON_ID, LER_ID, PER_IN_LER_ID, PGM_ID, BUSINESS_GROUP_ID — the identity and context keys linking the record to the person, life event, program, and operating unit.
Common Use Cases and Queries
Because the view is session-driven (it joins FND_SESSIONS and filters on USERENV('SESSIONID')), it is most useful when called from within an active Applications session or from a report that has established an effective date. A typical query to view the period codes and their meanings is:
SELECT uom, acty_ref_perd_cd, meaning, person_id, pgm_id FROM apps.ben_flx_enrt_uom_info_v WHERE acty_ref_perd_cd IS NOT NULL;
Common scenarios include validating that the correct activity reference period is applied to a participant's open enrollment record, debugging enrollment display issues where the UOM appears incorrect, and reconciling the period codes returned by the UI against the BEN_ACTY_REF_PERD lookup. Because the view depends on FND_SESSIONS, it is important to note that it will return no rows outside an established session context; for batch or extract reporting, the underlying BEN_PIL_ELCTBL_CHC_POPL table joined directly to HR_LOOKUPS is typically a more reliable source.
-
- Retrofitted
APPS.BEN_FLX_ENRT_UOM_INFO_V·↳ BEN_ELIG_PER_ELCTBL_CHC·↳ BEN_PER_IN_LER·↳ BEN_PIL_ELCTBL_CHC_POPL·Explore BEN module →
-
- Retrofitted
APPS.BEN_FLX_ENRT_UOM_INFO_V·↳ BEN_ELIG_PER_ELCTBL_CHC·↳ BEN_PER_IN_LER·↳ BEN_PIL_ELCTBL_CHC_POPL·Explore BEN module →
-
Table: PQH_PA_WHATIF_RESULTS 12.1.1
Stores the comparative results of the current and the ?What If? benefits.
-
This view identifies the benefit pool ledger details for a participant and a benefit provider pool.
APPS.BENBV_BNFT_PRVDD_LDGR_V·↳ BEN_BNFT_PRVDD_LDGR_F·↳ HR_BIS·Explore BEN module →
-
View: BENBV_PRTT_RT_VAL_V 12.1.1
This view identifies the information about standard rates, total flex credits, and imputed income calculated for a person enrolled in a plan or option in plan.
APPS.BENBV_PRTT_RT_VAL_V·↳ BEN_PRTT_RT_VAL·↳ HR_BIS·Explore BEN module →
-
This view identifies the benefit pool ledger details for a participant and a benefit provider pool.
APPS.BENBV_BNFT_PRVDD_LDGR_V·↳ BEN_BNFT_PRVDD_LDGR_F·↳ HR_BIS·Explore BEN module →
-
- Retrofitted
APPS.BEN_ENRT_RSLT_CHC_MISC_V·↳ BEN_ELIG_PER_ELCTBL_CHC·↳ BEN_ENRT_BNFT·↳ BEN_LER_F·Explore BEN module →
-
APPS.BEN_ENRT_MISC_LOV_INFO_V·↳ BEN_ELIG_PER_ELCTBL_CHC·↳ BEN_ENRT_BNFT·↳ BEN_LER_F·Explore BEN module →
-
APPS.BEN_ENRT_MISC_LOV_INFO_V·↳ BEN_ELIG_PER_ELCTBL_CHC·↳ BEN_ENRT_BNFT·↳ BEN_LER_F·Explore BEN module →
-
This view identifies the persons and the programs or plans not in program for which they have electable choices as a result of a life event.
APPS.BENBV_PIL_ELCTBL_CHC_POPL_V·↳ BEN_PIL_ELCTBL_CHC_POPL·↳ HR_BIS·Explore BEN module →
-
View: BEN_BNFT_PRVDD_LDGR 12.2.2
APPS.BEN_BNFT_PRVDD_LDGR·↳ BEN_BNFT_PRVDD_LDGR_F·↳ FND_SESSIONS·Explore BEN module →
-
APPS.BEN_BACK_OUT_PRTT_RT_VAL_V·↳ BEN_LE_CLSN_N_RSTR·↳ BEN_PRTT_RT_VAL·Explore BEN module →
-
View: BEN_BNFT_PRVDD_LDGR_V 12.2.2
APPS.BEN_BNFT_PRVDD_LDGR_V·↳ BEN_BNFT_PRVDD_LDGR_F·↳ FND_SESSIONS·Explore BEN module →
-
View: BEN_BNFT_PRVDD_LDGR 12.1.1
APPS.BEN_BNFT_PRVDD_LDGR·↳ BEN_BNFT_PRVDD_LDGR_F·↳ FND_SESSIONS·Explore BEN module →
-
LOV for BENEMSEB
APPS.BEN_ENRT_MISC_LOV_INFO_LE_V·↳ BEN_ELIG_PER_ELCTBL_CHC·↳ BEN_ENRT_BNFT·↳ BEN_LER_F·Explore BEN module →
-
LOV for BENEMSEB
APPS.BEN_ENRT_MISC_LOV_INFO_LE_V·↳ BEN_ELIG_PER_ELCTBL_CHC·↳ BEN_ENRT_BNFT·↳ BEN_LER_F·Explore BEN module →
-
- Retrofitted
APPS.BEN_ENRT_RSLT_CHC_MISC_V·↳ BEN_ELIG_PER_ELCTBL_CHC·↳ BEN_ENRT_BNFT·↳ BEN_LER_F·Explore BEN module →
-
- Retrofitted
APPS.BEN_ENRT_RSLT_ELIG_CHC_V·↳ BEN_ELIG_PER_ELCTBL_CHC·↳ BEN_LER_F·↳ BEN_PER_IN_LER·Explore BEN module →
-
Rate for participant enrolled in compensation object.
-
Rate for participant enrolled in compensation object.
-
View: BEN_BNFT_PRVDD_LDGR_V 12.1.1
APPS.BEN_BNFT_PRVDD_LDGR_V·↳ BEN_BNFT_PRVDD_LDGR_F·↳ FND_SESSIONS·Explore BEN module →
-
View: BENBV_PRTT_RT_VAL_V 12.2.2
This view identifies the information about standard rates, total flex credits, and imputed income calculated for a person enrolled in a plan or option in plan.
APPS.BENBV_PRTT_RT_VAL_V·↳ BEN_PRTT_RT_VAL·↳ HR_BIS·Explore BEN module →
-
View: BEN_PGM_X 12.2.2
- Retrofitted
-
View: BEN_ACTL_PREM_V 12.2.2
- Retrofitted
APPS.BEN_ACTL_PREM_V·↳ BEN_ACTL_PREM_F·↳ FND_SESSIONS·Explore BEN module →
-
View: BEN_ACTL_PREM_X 12.2.2
- Retrofitted
-
View: BEN_PGM_V 12.2.2
- Retrofitted
APPS.BEN_PGM_V·↳ BEN_PGM_F·↳ FND_SESSIONS·Explore BEN module →
-
View: BEN_PGM_X 12.1.1
- Retrofitted
-
The premium for plan and option in plan.
-
Table: PQH_PA_WHATIF_RESULTS 12.2.2
Stores the comparative results of the current and the ?What If? benefits.
-
The electable choice a person may have for a program or plan due to a life event.
-
View: BEN_BNFT_PRVDD_LDGR_X 12.1.1
APPS.BEN_BNFT_PRVDD_LDGR_X·↳ BEN_BNFT_PRVDD_LDGR_F·Explore BEN module →
-
APPS.BEN_BACK_OUT_PRTT_RT_VAL_V·↳ BEN_LE_CLSN_N_RSTR·↳ BEN_PRTT_RT_VAL·Explore BEN module →
-
This view identifies the persons and the programs or plans not in program for which they have electable choices as a result of a life event.
APPS.BENBV_PIL_ELCTBL_CHC_POPL_V·↳ BEN_PIL_ELCTBL_CHC_POPL·↳ HR_BIS·Explore BEN module →
-
View: BEN_VRBL_RT_PRFL_V 12.2.2
APPS.BEN_VRBL_RT_PRFL_V·↳ BEN_VRBL_RT_PRFL_F·↳ FND_SESSIONS·Explore BEN module →
-
View: BEN_VRBL_RT_PRFL_X 12.1.1
APPS.BEN_VRBL_RT_PRFL_X·↳ BEN_VRBL_RT_PRFL_F·Explore BEN module →
-
View: BEN_VRBL_RT_PRFL_X 12.2.2
APPS.BEN_VRBL_RT_PRFL_X·↳ BEN_VRBL_RT_PRFL_F·Explore BEN module →
-
View: BENBV_PGM_V 12.2.2
This view identifies the details for a compensation program. A program is a way to group plans together which are typically offered as a package of benefits to a group of people.
-
View: BEN_ACTL_PREM_V 12.1.1
- Retrofitted
APPS.BEN_ACTL_PREM_V·↳ BEN_ACTL_PREM_F·↳ FND_SESSIONS·Explore BEN module →
-
View: BENBV_CWB_PL_DSGN_V 12.1.1
This view captures Plan Design for Compensation Workbench
APPS.BENBV_CWB_PL_DSGN_V·↳ BEN_BIS_UTILS·↳ BEN_CWB_PL_DSGN·↳ HR_BIS·Explore BEN module →
-
View: BEN_VRBL_RT_PRFL 12.2.2
APPS.BEN_VRBL_RT_PRFL·↳ BEN_VRBL_RT_PRFL_F·↳ FND_SESSIONS·Explore BEN module →
-
CWB Plan Design
-
The benefit program.
-
View: BENBV_CWB_PL_DSGN_V 12.2.2
This view captures Plan Design for Compensation Workbench
APPS.BENBV_CWB_PL_DSGN_V·↳ BEN_BIS_UTILS·↳ BEN_CWB_PL_DSGN·↳ HR_BIS·Explore BEN module →
-
The electable choice a person may have for a program or plan due to a life event.
-
View: BEN_VRBL_RT_PRFL 12.1.1
APPS.BEN_VRBL_RT_PRFL·↳ BEN_VRBL_RT_PRFL_F·↳ FND_SESSIONS·Explore BEN module →
-
Variable rate profile.