Search Results acty_ref_perd_cd_m

Overview

APPS.BENBV_ACTL_PREM_V is a Business Intelligence (BI) reporting view in the Oracle E-Business Suite Advanced Benefits (BEN) module. It exposes the "Actual Premium" entity (BEN_ACTL_PREM_F) in a denormalized, presentation-ready form suitable for operational reporting, XML Publisher extracts, discoverer workbooks, and OBIEE/BIP integration. The "BV" prefix denotes a Business View, and the view is designed to be consumed directly by end-user reporting tools rather than by application transaction logic.

The view flattens the underlying premium definition into a single row per effective-dated record, and — critically for analytical consumption — decodes every code column into its human-readable lookup meaning. It also resolves the associated compensation object (either a Plan or an Option in Plan) into a display name, and injects a descriptive flexfield token (_DF:BEN:BEN_ACTL_PREM_F:APR) so that reporting engines can render the DFF segment values without an additional join.

The user's search term ben_prspctv_r_rtspctv corresponds to the lookup BEN_PRSPCTV_R_RTSPCTV, which is decoded in this view via the column PRSPTV_R_RTSPTV_CD. This lookup governs the perspective and retro-perspective relationship used when calculating and reporting premiums.

Underlying Base Objects

The view is defined over three documented referenced base objects:

BEN_ACTL_PREM_F (SYNONYM) — the actual premium definition table. The view aliases this as APR and selects nearly all of its columns, including effective dating, value/rounding rules, limits, and WHO columns.
BEN_BIS_UTILS (PACKAGE) — provides the helper functions GET_PL_NAME and GET_OIPL_NAME, used in a CASE expression to return the name of the Plan (PL_ID) or Option in Plan (OIPL_ID) that the premium is attached to.
HR_BIS (PACKAGE) — provides the BIS_DECODE_LOOKUP function, which translates each stored lookup code into its meaning using the Oracle HR lookup framework.

The view performs no joins to child tables in the visible excerpt; relationships to plans, options, organizations, and cost allocation keyflexes are surfaced only as foreign-key ID columns plus the resolved COMP_OBJECT name. The BUSINESS_GROUP_ID scopes every row to a specific business group, which is the standard multi-tenancy segregation in BEN.

Key Columns

EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — effective dating for the premium definition; used for date-tracked reporting.
NAME, UOM, VAL — the premium's name, unit of measure, and value.
PRTL_MO_DET_MTHD_RL / PRTL_MO_DET_MTHD_CD — partial-month determination method rule and its decoded lookup (BEN_PRTL_MO_DET_MTHD).
VAL_CALC_RL, RNDG_RL, RNDG_CD — value calculation rule and rounding rule/code (BEN_RNDG).
UPR_LMT_VAL / LWR_LMT_VAL with corresponding calculation rules — upper and lower premium limits.
CR_LKBK_VAL, CR_LKBK_UOM, CR_LKBK_CRNT_PY_ONLY_FLAG — credit lookback value and the yes/no indicator decoded via YES_NO.
VRBL_RT_ADD_ON_CALC_RL — variable rate add-on calculation rule.
COMP_OBJECT — resolved plan or option-in-plan name.
PRSPTV_R_RTSPTV_CD — decoded via BEN_PRSPCTV_R_RTSPCTV; this is the lookup the user searched for, controlling perspective/retro-perspective treatment.
ACTL_PREM_TYP_CD, PREM_ASNMT_CD, PREM_ASNMT_LVL_CD, PREM_PYR_CD, PRDCT_CD, MLT_CD, RT_TYP_CD, BNFT_RT_TYP_CD, ACTY_REF_PERD_CD — each exposed with its BIS_DECODE_LOOKUP meaning.
ID columns: ACTL_PREM_ID, BUSINESS_GROUP_ID, COST_ALLOCATION_KEYFLEX_ID, ORGANIZATION_ID, OIPL_ID, PL_ID, COMP_LVL_FCTR_ID, plus WHO columns (LAST_UPDATE_DATE, LAST_UPDATED_BY).

Common Use Cases and Queries

Typical uses include auditing premium definitions, verifying rounding and limit configuration, and driving premium calculation extracts. A basic listing by effective date and perspective/retro-perspective:

SELECT actl_prem_id, name, effective_start_date, effective_end_date,
       uom, val, val_calc_rl, rndg_cd,
       prspvt_r_rtspvt_cd
FROM   apps.benbv_actl_prem_v
WHERE  business_group_id = :p_bg_id
AND    TRUNC(SYSDATE) BETWEEN effective_start_date AND effective_end_date
ORDER BY name;

To compare premiums by their decoded perspective/retro-perspective meaning and view the compensation object they attach to:

SELECT name, comp_object, val, uom,
       bis_decode_lookup('BEN_PRSPCTV_R_RTSPCTV', prspvt_r_rtspvt_cd) meaning
FROM   apps.benbv_actl_prem_v
WHERE  business_group_id = :p_bg_id
AND    pl_id IS NOT NULL;

For a limit-and-rounding audit:

SELECT name, val, rndg_cd, upr_lmt_val, lwr_lmt_val,
       upr_lmt_calc_rl, lwr_lmt_calc_rl
FROM   apps.benbv_actl_prem_v
WHERE  business_group_id = :p_bg_id
AND    val IS NOT NULL;

Because every lookup is pre-decoded, reports built on BENBV_ACTL_PREM_V avoid the need to join FND lookups directly, simplifying SQL and reducing maintenance. The view is best used for query/reporting only; DML against it is not supported, and all updates must be made against the base table BEN_ACTL_PREM_F through the standard Benefits forms or concurrent processes.

VIEW: APPS.BENBV_ACTL_PREM_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:BEN.BENBV_ACTL_PREM_V, object_name:BENBV_ACTL_PREM_V, status:VALID,
VIEW: APPS.BENBV_BNFT_PRVDD_LDGR_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:BEN.BENBV_BNFT_PRVDD_LDGR_V, object_name:BENBV_BNFT_PRVDD_LDGR_V, status:VALID,
VIEW: APPS.BENBV_ACTL_PREM_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:BEN.BENBV_ACTL_PREM_V, object_name:BENBV_ACTL_PREM_V, status:VALID,
VIEW: APPS.BENBV_BNFT_PRVDD_LDGR_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:BEN.BENBV_BNFT_PRVDD_LDGR_V, object_name:BENBV_BNFT_PRVDD_LDGR_V, status:VALID,
View: BENBV_BNFT_PRVDD_LDGR_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:BEN.BENBV_BNFT_PRVDD_LDGR_V, object_name:BENBV_BNFT_PRVDD_LDGR_V, status:VALID, product: BEN - Advanced Benefits , description: This view identifies the benefit pool ledger details for a participant and a benefit provider pool. , implementation_dba_data: APPS.BENBV_BNFT_PRVDD_LDGR_V ,
View: BENBV_BNFT_PRVDD_LDGR_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:BEN.BENBV_BNFT_PRVDD_LDGR_V, object_name:BENBV_BNFT_PRVDD_LDGR_V, status:VALID, product: BEN - Advanced Benefits , description: This view identifies the benefit pool ledger details for a participant and a benefit provider pool. , implementation_dba_data: APPS.BENBV_BNFT_PRVDD_LDGR_V ,
View: BENBV_PRTT_RT_VAL_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:BEN.BENBV_PRTT_RT_VAL_V, object_name:BENBV_PRTT_RT_VAL_V, status:VALID, product: BEN - Advanced Benefits , description: 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. , implementation_dba_data: APPS.BENBV_PRTT_RT_VAL_V ,
View: BENBV_PIL_ELCTBL_CHC_POPL_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:BEN.BENBV_PIL_ELCTBL_CHC_POPL_V, object_name:BENBV_PIL_ELCTBL_CHC_POPL_V, status:VALID, product: BEN - Advanced Benefits , description: 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. , implementation_dba_data: APPS.BENBV_PIL_ELCTBL_CHC_POPL_V ,
View: BENBV_PRTT_RT_VAL_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:BEN.BENBV_PRTT_RT_VAL_V, object_name:BENBV_PRTT_RT_VAL_V, status:VALID, product: BEN - Advanced Benefits , description: 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. , implementation_dba_data: APPS.BENBV_PRTT_RT_VAL_V ,
View: BENBV_PIL_ELCTBL_CHC_POPL_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:BEN.BENBV_PIL_ELCTBL_CHC_POPL_V, object_name:BENBV_PIL_ELCTBL_CHC_POPL_V, status:VALID, product: BEN - Advanced Benefits , description: 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. , implementation_dba_data: APPS.BENBV_PIL_ELCTBL_CHC_POPL_V ,
View: BENBV_ACTL_PREM_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:BEN.BENBV_ACTL_PREM_V, object_name:BENBV_ACTL_PREM_V, status:VALID, product: BEN - Advanced Benefits , implementation_dba_data: APPS.BENBV_ACTL_PREM_V ,
View: BENBV_ACTL_PREM_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:BEN.BENBV_ACTL_PREM_V, object_name:BENBV_ACTL_PREM_V, status:VALID, product: BEN - Advanced Benefits , implementation_dba_data: APPS.BENBV_ACTL_PREM_V ,
VIEW: APPS.BENBV_PRTT_RT_VAL_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:BEN.BENBV_PRTT_RT_VAL_V, object_name:BENBV_PRTT_RT_VAL_V, status:VALID,
VIEW: APPS.BENBV_PRTT_RT_VAL_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:BEN.BENBV_PRTT_RT_VAL_V, object_name:BENBV_PRTT_RT_VAL_V, status:VALID,
View: BENBV_PGM_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:BEN.BENBV_PGM_V, object_name:BENBV_PGM_V, status:VALID, product: BEN - Advanced Benefits , description: 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. , implementation_dba_data: APPS.BENBV_PGM_V ,
VIEW: APPS.BENBV_PIL_ELCTBL_CHC_POPL_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:BEN.BENBV_PIL_ELCTBL_CHC_POPL_V, object_name:BENBV_PIL_ELCTBL_CHC_POPL_V, status:VALID,
View: BENBV_CWB_PL_DSGN_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:BEN.BENBV_CWB_PL_DSGN_V, object_name:BENBV_CWB_PL_DSGN_V, status:VALID, product: BEN - Advanced Benefits , description: This view captures Plan Design for Compensation Workbench , implementation_dba_data: APPS.BENBV_CWB_PL_DSGN_V ,
VIEW: APPS.BENBV_PIL_ELCTBL_CHC_POPL_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:BEN.BENBV_PIL_ELCTBL_CHC_POPL_V, object_name:BENBV_PIL_ELCTBL_CHC_POPL_V, status:VALID,
View: BENBV_CWB_PL_DSGN_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:BEN.BENBV_CWB_PL_DSGN_V, object_name:BENBV_CWB_PL_DSGN_V, status:VALID, product: BEN - Advanced Benefits , description: This view captures Plan Design for Compensation Workbench , implementation_dba_data: APPS.BENBV_CWB_PL_DSGN_V ,
View: BENBV_PGM_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:BEN.BENBV_PGM_V, object_name:BENBV_PGM_V, status:VALID, product: BEN - Advanced Benefits , description: 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. , implementation_dba_data: APPS.BENBV_PGM_V ,
VIEW: APPS.BENBV_CWB_PL_DSGN_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:BEN.BENBV_CWB_PL_DSGN_V, object_name:BENBV_CWB_PL_DSGN_V, status:VALID,
VIEW: APPS.BENBV_CWB_PL_DSGN_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:BEN.BENBV_CWB_PL_DSGN_V, object_name:BENBV_CWB_PL_DSGN_V, status:VALID,
View: BENBV_VRBL_RT_PRFL_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:BEN.BENBV_VRBL_RT_PRFL_V, object_name:BENBV_VRBL_RT_PRFL_V, status:VALID, product: BEN - Advanced Benefits , description: This view identifies the values for a rate based on that fact that a person satisfies the criteria that have been defined for the profile. , implementation_dba_data: APPS.BENBV_VRBL_RT_PRFL_V ,
View: BENBV_VRBL_RT_PRFL_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:BEN.BENBV_VRBL_RT_PRFL_V, object_name:BENBV_VRBL_RT_PRFL_V, status:VALID, product: BEN - Advanced Benefits , description: This view identifies the values for a rate based on that fact that a person satisfies the criteria that have been defined for the profile. , implementation_dba_data: APPS.BENBV_VRBL_RT_PRFL_V ,
VIEW: APPS.BENBV_PGM_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:BEN.BENBV_PGM_V, object_name:BENBV_PGM_V, status:VALID,
VIEW: APPS.BENBV_PGM_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:BEN.BENBV_PGM_V, object_name:BENBV_PGM_V, status:VALID,
VIEW: APPS.BENBV_VRBL_RT_PRFL_V 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:BEN.BENBV_VRBL_RT_PRFL_V, object_name:BENBV_VRBL_RT_PRFL_V, status:VALID,
VIEW: APPS.BENBV_VRBL_RT_PRFL_V 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:BEN.BENBV_VRBL_RT_PRFL_V, object_name:BENBV_VRBL_RT_PRFL_V, status:VALID,
eTRM - BEN Tables and Views 12.2.2
description: Start and End periods. ,
eTRM - BEN Tables and Views 12.1.1
description: Start and End periods. ,