DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.BENBV_PL_V

Object Details
Object Name: BENBV_PL_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewBEN.BENBV_PL_V
Subobject Name:
Status: VALID

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns
Name Datatype Length Mandatory Comments
EFFECTIVE_START_DATE DATE
Yes Effective start date.
EFFECTIVE_END_DATE DATE
Yes Effective end date.
NAME VARCHAR2 (240) Yes Plan name.
ORDR_NUM NUMBER (15)
Plan not in program sequence number.
MX_CVG_WCFN_AMT NUMBER

Plan general coverage restrictions max with certification.
MX_CVG_WCFN_MLT_NUM NUMBER (15)
Plan general coverage restrictions max multiple with certifications.
MN_CVG_ALWD_AMT NUMBER

Plan general coverage restrictions min val.
PRORT_PRTL_YR_CVG_RSTRN_RL NUMBER (15)
Foreign Key to FF_FORMULAS_F
MN_OPTS_RQD_NUM NUMBER (15)
Plan general number of options min value.
MX_OPTS_ALWD_NUM NUMBER (15)
Plan general number of options max value.
MX_WTG_PERD_PRTE_VAL NUMBER (15)
Plan participation maximum waiting period value.
MX_CVG_INCR_ALWD_AMT NUMBER

Plan general coverage restrictions life event increases max.
MX_CVG_MLT_INCR_NUM NUMBER (15)
Plan general coverage restrictions multiple increases max.
DFLT_TO_ASN_PNDG_CTFN_RL NUMBER (15)
Foreign Key to FF_FORMULAS_F
MX_CVG_INCR_WCF_ALWD_AMT NUMBER

Plan general coverage restrictions life event increases with certification.
MX_CVG_MLT_INCR_WCF_NUM NUMBER (15)
Plan general coverage restrictions multiple increases with certification.
MX_CVG_ALWD_AMT NUMBER

Plan general coverage restrictions max value.
MN_CVG_RQD_AMT NUMBER

Plan general coverage restrictions min value.
ENRT_RL NUMBER (15)
Foreign Key to FF_FORMULAS_F
MX_WTG_DT_TO_USE_RL NUMBER (15)
Foreign Key to FF_FORMULAS_F
RQD_PERD_ENRT_NENRT_UOM VARCHAR2 (30)
Plan general required period of enrollment unit of measure.
RQD_PERD_ENRT_NENRT_VAL NUMBER

Plan general option required period of enrollment value.
RQD_PERD_ENRT_NENRT_RL NUMBER (15)
Foreign Key to FF_FORMULAS_F
URL_REF_NAME VARCHAR2 (240)
Plan general web address.
INCPTN_DT DATE

Plan inception date.
BNF_INCRMT_AMT NUMBER

Limitations increment amount.
BNF_MN_DSGNTBL_AMT NUMBER

Minimum designatable amount.
BNF_MN_DSGNTBL_PCT_VAL NUMBER (15)
Minimum designatable percent.
BNF_PCT_INCRMT_VAL NUMBER (15)
Limitations increment percent.
IVR_IDENT VARCHAR2 (90)
Plan integrated voice response.
RT_END_DT_RL NUMBER (15)
Foreign Key to FF_FORMULAS_F
RT_STRT_DT_RL NUMBER (15)
Foreign Key to FF_FORMULAS_F
POSTELCN_EDIT_RL NUMBER (15)
Foreign Key to FF_FORMULAS_F
PLN_MN_CVG_ALWD_AMT NUMBER (15)
Plan minimum coverage allowed amount.
AUTO_ENRT_MTHD_RL NUMBER (15)
Foreign Key to FF_FORMULAS_F
MX_WTG_PERD_RL NUMBER (15)
Foreign Key to FF_FORMULAS_F
MN_CVG_RL NUMBER (15)
Foreign Key to FF_FORMULAS_F
MX_CVG_RL NUMBER (15)
Foreign Key to FF_FORMULAS_F
MX_WTG_PERD_PRTE_UOM VARCHAR2 (30)
Plan participation maximum waiting period unit of measure (Lookup code based on lookup type BEN_TM_UOM).
MX_WTG_PERD_PRTE_UOM_M VARCHAR2 (4000)
Plan participation maximum waiting period unit of measure (Lookup meaning based on lookup type BEN_TM_UOM).
NIP_PL_UOM VARCHAR2 (30)
Plan not in program currency.
COBRA_PYMT_DUE_DY_NUM NUMBER (15)
Plan general cobra payment day.
NIP_DFLT_ENRT_DET_RL NUMBER (15)
Foreign Key to FF_FORMULAS_F
DPNT_CVG_END_DT_RL NUMBER (15)
Foreign Key to FF_FORMULAS_F
DPNT_CVG_STRT_DT_RL NUMBER (15)
Foreign Key to FF_FORMULAS_F
ENRT_CVG_END_DT_RL NUMBER (15)
Foreign Key to FF_FORMULAS_F
ENRT_CVG_STRT_DT_RL NUMBER (15)
Foreign Key to FF_FORMULAS_F
VRFY_FMLY_MMBR_RL NUMBER (15)
Foreign Key to FF_FORMULAS_F
FRFS_DISTR_MTHD_RL NUMBER (15)
Foreign Key to FF_FORMULAS_F
FRFS_MX_CRYFWD_VAL NUMBER

Maximum forfeiture carry-forward value.
SHORT_CODE VARCHAR2 (30)
Plan short code.
SHORT_NAME VARCHAR2 (30)
Plan short name.
MAPPING_TABLE_NAME VARCHAR2 (60)
Mapping table name.
FUNCTION_CODE VARCHAR2 (30)
Function code.
LEGISLATION_CODE VARCHAR2 (30)
Foreign key to FND_TERRITORIES.
LEGISLATION_SUBGROUP VARCHAR2 (30)
Further identifies the legislation of startup data.
GROUP_PLAN VARCHAR2 (4000)
Group Plan.
_DF:PLN CHAR (20)
PL_CD VARCHAR2 (30) Yes Plan usage (Lookup code based on lookup type BEN_PL).
PL_CD_M VARCHAR2 (4000)
Plan usage (Lookup meaning based on lookup type BEN_PL).
CVG_INCR_R_DECR_ONLY_CD VARCHAR2 (30)
Plan general coverage change restrictions (Lookup code based on lookup type BEN_CVG_INCR_R_DECR_ONLY).
CVG_INCR_R_DECR_ONLY_CD_M VARCHAR2 (4000)
Plan general coverage change restrictions (Lookup meaning based on lookup type BEN_CVG_INCR_R_DECR_ONLY).
SUBJ_TO_IMPTD_INCM_CD VARCHAR2 (30)
Plan general subject to imputed income (Lookup code based on lookup type BEN_IMPTD_INCM_TYP).
SUBJ_TO_IMPTD_INCM_CD_M VARCHAR2 (4000)
Plan general subject to imputed income (Lookup meaning based on lookup type BEN_IMPTD_INCM_TYP).
SUBJ_TO_IMPTD_INCM_TYP_CD VARCHAR2 (30)
Plan general subject to imputed income type (Lookup code based on lookup type BEN_IMPTD_INCM_TYP).
SUBJ_TO_IMPTD_INCM_TYP_CD_M VARCHAR2 (4000)
Plan general subject to imputed income type (Lookup meaning based on lookup type BEN_IMPTD_INCM_TYP).
UNSSPND_ENRT_CD VARCHAR2 (30)
Plan general coverage restrictions interim unsuspend code (Lookup code based on lookup type BEN_UNSSPND_ENRT).
UNSSPND_ENRT_CD_M VARCHAR2 (4000)
Plan general coverage restrictions interim unsuspend code (Lookup meaning based on lookup type BEN_UNSSPND_ENRT).
IMPTD_INCM_CALC_CD VARCHAR2 (30)
Plan restrictions imputed income type (Lookup code based on lookup type BEN_IMPTD_INCM_TYP).
IMPTD_INCM_CALC_CD_M VARCHAR2 (4000)
Plan restrictions imputed income type (Lookup meaning based on lookup type BEN_IMPTD_INCM_TYP).
RT_END_DT_CD VARCHAR2 (30)
Plan general rate end date code (Lookup code based on lookup type BEN_RT_END).
RT_END_DT_CD_M VARCHAR2 (4000)
Plan general rate end date code (Lookup meaning based on lookup type BEN_RT_END).
RT_STRT_DT_CD VARCHAR2 (30)
Plan general rate start date code (Lookup code based on lookup type BEN_RT_STRT).
RT_STRT_DT_CD_M VARCHAR2 (4000)
Plan general rate start date code (Lookup meaning based on lookup type BEN_RT_STRT).
PER_CVRD_CD VARCHAR2 (30)
Plan eligibility rates eligibility check (Lookup code based on lookup type BEN_PER_CVRD).
PER_CVRD_CD_M VARCHAR2 (4000)
Plan eligibility rates eligibility check (Lookup meaning based on lookup type BEN_PER_CVRD).
BNFT_OR_OPTION_RSTRCTN_CD VARCHAR2 (30)
Plan general coverage restrict plan change based on code (Lookup code based on lookup type BEN_BNFT_R_OPT_RSTRN).
BNFT_OR_OPTION_RSTRCTN_CD_M VARCHAR2 (4000)
Plan general coverage restrict plan change based on code (Lookup meaning based on lookup type BEN_BNFT_R_OPT_RSTRN).
PCP_CD VARCHAR2 (30)
Primary care provider (Lookup code based on lookup type BEN_PCP_CD).
PCP_CD_M VARCHAR2 (4000)
Primary care provider (Lookup meaning based on lookup type BEN_PCP_CD).
MX_WTG_DT_TO_USE_CD VARCHAR2 (30)
Plan participation maximum waiting period date to use code (Lookup code based on lookup type BEN_MX_WTG_DT_TO_USE).
MX_WTG_DT_TO_USE_CD_M VARCHAR2 (4000)
Plan participation maximum waiting period date to use code (Lookup meaning based on lookup type BEN_MX_WTG_DT_TO_USE).
BNF_DFLT_BNF_CD VARCHAR2 (30)
Default beneficiary code (Lookup code based on lookup type BEN_BNF_DFLT).
BNF_DFLT_BNF_CD_M VARCHAR2 (4000)
Default beneficiary code (Lookup meaning based on lookup type BEN_BNF_DFLT).
BNF_PCT_AMT_ALWD_CD VARCHAR2 (30)
Percent / amount benefit allowed (Lookup code based on lookup type BEN_BNF_PCT_AMT_ALWD).
BNF_PCT_AMT_ALWD_CD_M VARCHAR2 (4000)
Percent / amount benefit allowed (Lookup meaning based on lookup type BEN_BNF_PCT_AMT_ALWD).
CMPR_CLMS_TO_CVG_OR_BAL_CD VARCHAR2 (30)
Compare claims to coverage or balance (Lookup code based on lookup type BEN_CMPR_CLMS_TO_CVG_OR_BAL).
CMPR_CLMS_TO_CVG_OR_BAL_CD_M VARCHAR2 (4000)
Compare claims to coverage or balance (Lookup meaning based on lookup type BEN_CMPR_CLMS_TO_CVG_OR_BAL).
DPNT_CVG_END_DT_CD VARCHAR2 (30)
Dependent coverage end date code (Lookup code based on lookup type BEN_DPNT_CVG_END).
DPNT_CVG_END_DT_CD_M VARCHAR2 (4000)
Dependent coverage end date code (Lookup meaning based on lookup type BEN_DPNT_CVG_END).
DPNT_CVG_STRT_DT_CD VARCHAR2 (30)
Dependent coverage start date code (Lookup code based on lookup type BEN_DPNT_CVG_STRT).
DPNT_CVG_STRT_DT_CD_M VARCHAR2 (4000)
Dependent coverage start date code (Lookup meaning based on lookup type BEN_DPNT_CVG_STRT).
DPNT_DSGN_CD VARCHAR2 (30)
Plan dependent designation code (Lookup code based on lookup type BEN_DPNT_DSGN).
DPNT_DSGN_CD_M VARCHAR2 (4000)
Plan dependent designation code (Lookup meaning based on lookup type BEN_DPNT_DSGN).
NIP_DFLT_ENRT_CD VARCHAR2 (30)
Plan not in program default enrollment code (Lookup code based on lookup type BEN_DFLT_ENRT).
NIP_DFLT_ENRT_CD_M VARCHAR2 (4000)
Plan not in program default enrollment code (Lookup meaning based on lookup type BEN_DFLT_ENRT).
BNF_DSGN_CD VARCHAR2 (30)
Plan beneficiary designation code (Lookup code based on lookup type BEN_BNF_DSGN).
BNF_DSGN_CD_M VARCHAR2 (4000)
Plan beneficiary designation code (Lookup meaning based on lookup type BEN_BNF_DSGN).
PRMRY_FNDG_MTHD_CD VARCHAR2 (30)
Plan general primary funding method (Lookup code based on lookup type BEN_PRMRY_FNDG_MTHD).
PRMRY_FNDG_MTHD_CD_M VARCHAR2 (4000)
Plan general primary funding method (Lookup meaning based on lookup type BEN_PRMRY_FNDG_MTHD).
DFLT_TO_ASN_PNDG_CTFN_CD VARCHAR2 (30)
Plan general coverage restrictions interim assign code (Lookup code based on lookup type BEN_DFLT_TO_ASN_PNDG_CTFN).
DFLT_TO_ASN_PNDG_CTFN_CD_M VARCHAR2 (4000)
Plan general coverage restrictions interim assign code (Lookup meaning based on lookup type BEN_DFLT_TO_ASN_PNDG_CTFN).
ENRT_MTHD_CD VARCHAR2 (30)
Plan general enrollment method (Lookup code based on lookup type BEN_ENRT_MTHD).
ENRT_MTHD_CD_M VARCHAR2 (4000)
Plan general enrollment method (Lookup meaning based on lookup type BEN_ENRT_MTHD).
HC_SVC_TYP_CD VARCHAR2 (30)
Plan general health services (Lookup code based on lookup type BEN_HLTH_CARE_SVC_TYP).
HC_SVC_TYP_CD_M VARCHAR2 (4000)
Plan general health services (Lookup meaning based on lookup type BEN_HLTH_CARE_SVC_TYP).
NIP_ACTY_REF_PERD_CD VARCHAR2 (30)
Plan not in program activity reference period (Lookup code based on lookup type BEN_ACTY_REF_PERD).
NIP_ACTY_REF_PERD_CD_M VARCHAR2 (4000)
Plan not in program activity reference period (Lookup meaning based on lookup type BEN_ACTY_REF_PERD).
ENRT_CD VARCHAR2 (30)
Enrollment code (Lookup code based on lookup type BEN_ENRT).
ENRT_CD_M VARCHAR2 (4000)
Enrollment code (Lookup meaning based on lookup type BEN_ENRT).
PRORT_PRTL_YR_CVG_RSTRN_CD VARCHAR2 (30)
Prorate partial year coverage restriction (Lookup code based on lookup type BEN_PRORT_PRTL_YR_CVG_RSTRN).
PRORT_PRTL_YR_CVG_RSTRN_CD_M VARCHAR2 (4000)
Prorate partial year coverage restriction (Lookup meaning based on lookup type BEN_PRORT_PRTL_YR_CVG_RSTRN).
PL_STAT_CD VARCHAR2 (30)
Plan status (Lookup code based on lookup type BEN_STAT).
PL_STAT_CD_M VARCHAR2 (4000)
Plan status (Lookup meaning based on lookup type BEN_STAT).
ENRT_CVG_STRT_DT_CD VARCHAR2 (30)
Plan general enrollment coverage start date code (Lookup code based on lookup type BEN_ENRT_CVG_STRT).
ENRT_CVG_STRT_DT_CD_M VARCHAR2 (4000)
Plan general enrollment coverage start date code (Lookup meaning based on lookup type BEN_ENRT_CVG_STRT).
ENRT_CVG_END_DT_CD VARCHAR2 (30)
Plan general enrollment coverage end date code (Lookup code based on lookup type BEN_ENRT_CVG_END).
ENRT_CVG_END_DT_CD_M VARCHAR2 (4000)
Plan general enrollment coverage end date code (Lookup meaning based on lookup type BEN_ENRT_CVG_END).
NIP_ENRT_INFO_RT_FREQ_CD VARCHAR2 (30)
Plan not in program enrollment rate/frequency (Lookup code based on lookup type BEN_ENRT_INFO_RT_FREQ).
NIP_ENRT_INFO_RT_FREQ_CD_M VARCHAR2 (4000)
Plan not in program enrollment rate/frequency (Lookup meaning based on lookup type BEN_ENRT_INFO_RT_FREQ).
VRFY_FMLY_MMBR_CD VARCHAR2 (30)
Plan general family member code (Lookup code based on lookup type BEN_FMLY_MMBR).
VRFY_FMLY_MMBR_CD_M VARCHAR2 (4000)
Plan general family member code (Lookup meaning based on lookup type BEN_FMLY_MMBR).
FRFS_DISTR_MTHD_CD VARCHAR2 (30)
Forfeitures determination code (Lookup code based on lookup type BEN_FRFS_DISTR_MTHD).
FRFS_DISTR_MTHD_CD_M VARCHAR2 (4000)
Forfeitures determination code (Lookup meaning based on lookup type BEN_FRFS_DISTR_MTHD).
FRFS_CNTR_DET_CD VARCHAR2 (30)
Forfeitures contribution determination code (Lookup code based on lookup type BEN_FRFS_CNTR_DET).
FRFS_CNTR_DET_CD_M VARCHAR2 (4000)
Forfeitures contribution determination code (Lookup meaning based on lookup type BEN_FRFS_CNTR_DET).
FRFS_DISTR_DET_CD VARCHAR2 (30)
Forfeitures distribution determination code (Lookup code based on lookup type BEN_FRFS_DISTR_DET).
FRFS_DISTR_DET_CD_M VARCHAR2 (4000)
Forfeitures distribution determination code (Lookup meaning based on lookup type BEN_FRFS_DISTR_DET).
FRFS_VAL_DET_CD VARCHAR2 (30)
FRFS_VAL_DET_CD_M VARCHAR2 (4000)
FRFS_PORTION_DET_CD VARCHAR2 (30)
FRFS_PORTION_DET_CD_M VARCHAR2 (4000)
BNDRY_PERD_CD VARCHAR2 (30)
BNDRY_PERD_CD_M VARCHAR2 (4000)
USE_CSD_RSD_PRCCNG_CD VARCHAR2 (30)
Use Coverage and/or Rate Start Date for Processing Code (Lookup Code of Lookup Type BEN_USE_CSD_RSD_PRCCNG)
USE_CSD_RSD_PRCCNG_CD_M VARCHAR2 (4000)
Use Coverage and/or Rate Start Date for Processing Code (Lookup meaning of Lookup Type BEN_USE_CSD_RSD_PRCCNG)
DRVBL_DPNT_ELIG_FLAG VARCHAR2 (30) Yes Coverage eligibility requirements derivable factors apply (Lookup code based on lookup type YES_NO).
DRVBL_DPNT_ELIG_FLAG_M VARCHAR2 (4000)
Coverage eligibility requirements derivable factors apply (Lookup meaning based on lookup type YES_NO).
DRVBL_FCTR_PRTN_ELIG_FLAG VARCHAR2 (30) Yes Plan eligibility profile rule derivable factors apply (Lookup code based on lookup type YES_NO).
DRVBL_FCTR_PRTN_ELIG_FLAG_M VARCHAR2 (4000)
Plan eligibility profile rule derivable factors apply (Lookup meaning based on lookup type YES_NO).
DPNT_NO_CTFN_RQD_FLAG VARCHAR2 (30) Yes Suspend enrollment if not provided no certification needed (Lookup code based on lookup type YES_NO).
DPNT_NO_CTFN_RQD_FLAG_M VARCHAR2 (4000)
Suspend enrollment if not provided no certification needed (Lookup meaning based on lookup type YES_NO).
MAY_ENRL_PL_N_OIPL_FLAG VARCHAR2 (30) Yes Plan general enroll in plan and option (Lookup code based on lookup type YES_NO).
MAY_ENRL_PL_N_OIPL_FLAG_M VARCHAR2 (4000)
Plan general enroll in plan and option (Lookup meaning based on lookup type YES_NO).
DPNT_CVD_BY_OTHR_APLS_FLAG VARCHAR2 (30) Yes Maximum plans exceedable (Lookup code based on lookup type YES_NO).
DPNT_CVD_BY_OTHR_APLS_FLAG_M VARCHAR2 (4000)
Maximum plans exceedable (Lookup meaning based on lookup type YES_NO).
DPNT_ADRS_RQD_FLAG VARCHAR2 (30) Yes Suspend enrollment if not provided address (Lookup code based on lookup type YES_NO).
DPNT_ADRS_RQD_FLAG_M VARCHAR2 (4000)
Suspend enrollment if not provided address (Lookup meaning based on lookup type YES_NO).
DPNT_LEG_ID_RQD_FLAG VARCHAR2 (30) Yes Suspend enrollment if not provided dependents ssn/legislative id (Lookup code based on lookup type YES_NO).
DPNT_LEG_ID_RQD_FLAG_M VARCHAR2 (4000)
Suspend enrollment if not provided dependents ssn/legislative id (Lookup meaning based on lookup type YES_NO).
DPNT_DOB_RQD_FLAG VARCHAR2 (30) Yes Suspend enrollment if not provided date of birth (Lookup code based on lookup type YES_NO).
DPNT_DOB_RQD_FLAG_M VARCHAR2 (4000)
Suspend enrollment if not provided date of birth (Lookup meaning based on lookup type YES_NO).
DRVBL_FCTR_APLS_RTS_FLAG VARCHAR2 (30) Yes Derivable factors applies to rate (Lookup code based on lookup type YES_NO).
DRVBL_FCTR_APLS_RTS_FLAG_M VARCHAR2 (4000)
Derivable factors applies to rate (Lookup meaning based on lookup type YES_NO).
ELIG_APLS_FLAG VARCHAR2 (30) Yes Eligibility applies (Lookup code based on lookup type YES_NO).
ELIG_APLS_FLAG_M VARCHAR2 (4000)
Eligibility applies (Lookup meaning based on lookup type YES_NO).
NO_MX_OPTS_NUM_APLS_FLAG VARCHAR2 (30) Yes Plan general number of options no max (Lookup code based on lookup type YES_NO).
NO_MX_OPTS_NUM_APLS_FLAG_M VARCHAR2 (4000)
Plan general number of options no max (Lookup meaning based on lookup type YES_NO).
ALWS_QDRO_FLAG VARCHAR2 (30) Yes Plan restrictions allow qualified domestic relations order (Lookup code based on lookup type YES_NO).
ALWS_QDRO_FLAG_M VARCHAR2 (4000)
Plan restrictions allow qualified domestic relations order (Lookup meaning based on lookup type YES_NO).
ALWS_QMCSO_FLAG VARCHAR2 (30) Yes Plan restrictions allow qualified medical child support order (Lookup code based on lookup type YES_NO).
ALWS_QMCSO_FLAG_M VARCHAR2 (4000)
Plan restrictions allow qualified medical child support order (Lookup meaning based on lookup type YES_NO).
HGHLY_CMPD_RL_APLS_FLAG VARCHAR2 (30) Yes Plan restrictions highly compensated rule applies (Lookup code based on lookup type YES_NO).
HGHLY_CMPD_RL_APLS_FLAG_M VARCHAR2 (4000)
Plan restrictions highly compensated rule applies (Lookup meaning based on lookup type YES_NO).
ENRT_PL_OPT_FLAG VARCHAR2 (30) Yes Plan general enroll in plan and options (Lookup code based on lookup type YES_NO).
ENRT_PL_OPT_FLAG_M VARCHAR2 (4000)
Plan general enroll in plan and options (Lookup meaning based on lookup type YES_NO).
FRFS_APLY_FLAG VARCHAR2 (30) Yes Forfeitures apply (Lookup code based on lookup type YES_NO).
FRFS_APLY_FLAG_M VARCHAR2 (4000)
Forfeitures apply (Lookup meaning based on lookup type YES_NO).
SVGS_PL_FLAG VARCHAR2 (30) Yes Plan general savings plan (Lookup code based on lookup type YES_NO).
SVGS_PL_FLAG_M VARCHAR2 (4000)
Plan general savings plan (Lookup meaning based on lookup type YES_NO).
TRK_INELIG_PER_FLAG VARCHAR2 (30) Yes Plan eligibility rates track ineligible person (Lookup code based on lookup type YES_NO).
TRK_INELIG_PER_FLAG_M VARCHAR2 (4000)
Plan eligibility rates track ineligible person (Lookup meaning based on lookup type YES_NO).
USE_ALL_ASNTS_ELIG_FLAG VARCHAR2 (30) Yes Plan eligibility rates use all assignments for eligibility (Lookup code based on lookup type YES_NO).
USE_ALL_ASNTS_ELIG_FLAG_M VARCHAR2 (4000)
Plan eligibility rates use all assignments for eligibility (Lookup meaning based on lookup type YES_NO).
USE_ALL_ASNTS_FOR_RT_FLAG VARCHAR2 (30) Yes Plan eligibility rates use all assignments for rates (Lookup code based on lookup type YES_NO).
USE_ALL_ASNTS_FOR_RT_FLAG_M VARCHAR2 (4000)
Plan eligibility rates use all assignments for rates (Lookup meaning based on lookup type YES_NO).
VSTG_APLS_FLAG VARCHAR2 (30) Yes Vesting applies (Lookup code based on lookup type YES_NO).
VSTG_APLS_FLAG_M VARCHAR2 (4000)
Vesting applies (Lookup meaning based on lookup type YES_NO).
PRTN_ELIG_OVRID_ALWD_FLAG VARCHAR2 (30) Yes Plan eligibility rates allows override (Lookup code based on lookup type YES_NO).
PRTN_ELIG_OVRID_ALWD_FLAG_M VARCHAR2 (4000)
Plan eligibility rates allows override (Lookup meaning based on lookup type YES_NO).
HC_PL_SUBJ_HCFA_APRVL_FLAG VARCHAR2 (30) Yes Plan restrictions subject to health care financing administration (Lookup code based on lookup type YES_NO).
HC_PL_SUBJ_HCFA_APRVL_FLAG_M VARCHAR2 (4000)
Plan restrictions subject to health care financing administration (Lookup meaning based on lookup type YES_NO).
WVBL_FLAG VARCHAR2 (30) Yes Plan eligibility rates participation is waivable (Lookup code based on lookup type YES_NO).
WVBL_FLAG_M VARCHAR2 (4000)
Plan eligibility rates participation is waivable (Lookup meaning based on lookup type YES_NO).
INVK_FLX_CR_PL_FLAG VARCHAR2 (30) Yes Plan restrictions flex credit plan (Lookup code based on lookup type YES_NO).
INVK_FLX_CR_PL_FLAG_M VARCHAR2 (4000)
Plan restrictions flex credit plan (Lookup meaning based on lookup type YES_NO).
INVK_DCLN_PRTN_PL_FLAG VARCHAR2 (30) Yes Plan restrictions waive plan (Lookup code based on lookup type YES_NO).
INVK_DCLN_PRTN_PL_FLAG_M VARCHAR2 (4000)
Plan restrictions waive plan (Lookup meaning based on lookup type YES_NO).
ALWS_REIMBMTS_FLAG VARCHAR2 (30) Yes Allows reimbursement (Lookup code based on lookup type YES_NO).
ALWS_REIMBMTS_FLAG_M VARCHAR2 (4000)
Allows reimbursement (Lookup meaning based on lookup type YES_NO).
ALWS_UNRSTRCTD_ENRT_FLAG VARCHAR2 (30) Yes Plan general allows unrestricted enrollment (Lookup code based on lookup type YES_NO).
ALWS_UNRSTRCTD_ENRT_FLAG_M VARCHAR2 (4000)
Plan general allows unrestricted enrollment (Lookup meaning based on lookup type YES_NO).
BNF_ADDL_INSTN_TXT_ALWD_FLAG VARCHAR2 (30) Yes Additional instruction text allowed (Lookup code based on lookup type YES_NO).
BNF_ADDL_INSTN_TXT_ALWD_FLAG_M VARCHAR2 (4000)
Additional instruction text allowed (Lookup meaning based on lookup type YES_NO).
BNF_ADRS_RQD_FLAG VARCHAR2 (30) Yes Address needed (Lookup code based on lookup type YES_NO).
BNF_ADRS_RQD_FLAG_M VARCHAR2 (4000)
Address needed (Lookup meaning based on lookup type YES_NO).
BNF_CTFN_RQD_FLAG VARCHAR2 (30) Yes No certification needed (Lookup code based on lookup type YES_NO).
BNF_CTFN_RQD_FLAG_M VARCHAR2 (4000)
No certification needed (Lookup meaning based on lookup type YES_NO).
BNF_CNTNGT_BNFS_ALWD_FLAG VARCHAR2 (30) Yes Contingent beneficiaries allowed (Lookup code based on lookup type YES_NO).
BNF_CNTNGT_BNFS_ALWD_FLAG_M VARCHAR2 (4000)
Contingent beneficiaries allowed (Lookup meaning based on lookup type YES_NO).
BNF_LEGV_ID_RQD_FLAG VARCHAR2 (30) Yes Suspend enrollment if not provided ssn/legislative id (Lookup code based on lookup type YES_NO).
BNF_LEGV_ID_RQD_FLAG_M VARCHAR2 (4000)
Suspend enrollment if not provided ssn/legislative id (Lookup meaning based on lookup type YES_NO).
BNF_MAY_DSGT_ORG_FLAG VARCHAR2 (30) Yes May designate organization as beneficiary (Lookup code based on lookup type YES_NO).
BNF_MAY_DSGT_ORG_FLAG_M VARCHAR2 (4000)
May designate organization as beneficiary (Lookup meaning based on lookup type YES_NO).
BNF_QDRO_RL_APLS_FLAG VARCHAR2 (30) Yes Qualified domestic relations rule applies (Lookup code based on lookup type YES_NO).
BNF_QDRO_RL_APLS_FLAG_M VARCHAR2 (4000)
Qualified domestic relations rule applies (Lookup meaning based on lookup type YES_NO).
BNF_DSGE_MNR_TTEE_RQD_FLAG VARCHAR2 (30) Yes Minor designee requires trustee (Lookup code based on lookup type YES_NO).
BNF_DSGE_MNR_TTEE_RQD_FLAG_M VARCHAR2 (4000)
Minor designee requires trustee (Lookup meaning based on lookup type YES_NO).
NO_MN_CVG_AMT_APLS_FLAG VARCHAR2 (30) Yes Plan general coverage restrictions no min (Lookup code based on lookup type YES_NO).
NO_MN_CVG_AMT_APLS_FLAG_M VARCHAR2 (4000)
Plan general coverage restrictions no min (Lookup meaning based on lookup type YES_NO).
NO_MX_CVG_AMT_APLS_FLAG VARCHAR2 (30) Yes Plan general coverage restrictions no max (Lookup code based on lookup type YES_NO).
NO_MX_CVG_AMT_APLS_FLAG_M VARCHAR2 (4000)
Plan general coverage restrictions no max (Lookup meaning based on lookup type YES_NO).
NO_MN_CVG_INCR_APLS_FLAG VARCHAR2 (30) Yes Plan general coverage restrictions life event no min (Lookup code based on lookup type YES_NO).
NO_MN_CVG_INCR_APLS_FLAG_M VARCHAR2 (4000)
Plan general coverage restrictions life event no min (Lookup meaning based on lookup type YES_NO).
NO_MX_CVG_INCR_APLS_FLAG VARCHAR2 (30) Yes Plan general coverage restrictions life event no max (Lookup code based on lookup type YES_NO).
NO_MX_CVG_INCR_APLS_FLAG_M VARCHAR2 (4000)
Plan general coverage restrictions life event no max (Lookup meaning based on lookup type YES_NO).
NO_MN_OPTS_NUM_APLS_FLAG VARCHAR2 (30) Yes Plan general number of options no min (Lookup code based on lookup type YES_NO).
NO_MN_OPTS_NUM_APLS_FLAG_M VARCHAR2 (4000)
Plan general number of options no min (Lookup meaning based on lookup type YES_NO).
BNF_DOB_RQD_FLAG VARCHAR2 (30) Yes Date of birth required (Lookup code based on lookup type YES_NO).
BNF_DOB_RQD_FLAG_M VARCHAR2 (4000)
Date of birth required (Lookup meaning based on lookup type YES_NO).
ALWS_TMPRY_ID_CRD_FLAG VARCHAR2 (30) Yes Plan restrictions allow temporary identification (Lookup code based on lookup type YES_NO).
ALWS_TMPRY_ID_CRD_FLAG_M VARCHAR2 (4000)
Plan restrictions allow temporary identification (Lookup meaning based on lookup type YES_NO).
NIP_DFLT_FLAG VARCHAR2 (30) Yes Plan not in program assign on default (Lookup code based on lookup type YES_NO).
NIP_DFLT_FLAG_M VARCHAR2 (4000)
Plan not in program assign on default (Lookup meaning based on lookup type YES_NO).
POST_TO_GL_FLAG VARCHAR2 (30) Yes Forfeiture post to gl (Lookup code based on lookup type YES_NO).
POST_TO_GL_FLAG_M VARCHAR2 (4000)
Forfeiture post to gl (Lookup meaning based on lookup type YES_NO).
PL_YR_NOT_APPLCBL_FLAG VARCHAR2 (30) Yes Plan year not applicable (Lookup code based on lookup type YES_NO).
PL_YR_NOT_APPLCBL_FLAG_M VARCHAR2 (4000)
Plan year not applicable (Lookup meaning based on lookup type YES_NO).
PL_ID NUMBER (15) Yes System generated primary key column.
PL_TYP_ID NUMBER (15) Yes Foreign key to BEN_PL_TYP_F.
BUSINESS_GROUP_ID NUMBER (15)
Foreign Key to HR_ORGANIZATION_UNITS.
ACTL_PREM_ID NUMBER (15)
Foreign key to BEN_ACTL_PREM_F.
BNFT_PRVDR_POOL_ID NUMBER (15)
Foreign key to BEN_BNFT_PRVDR_POOL_F.
CR_DSTR_BNFT_PRVDR_POOL_ID NUMBER (15)
Foreign key to BEN_CR_DSTR_BNFT_PRVDR_POOL_F.
COST_ALLOC_KEYFLEX_1_ID NUMBER (15)
Foreign Key To PAY_COST_ALLOCATION_KEYFLEX.
COST_ALLOC_KEYFLEX_2_ID NUMBER (15)
Foreign Key To PAY_COST_ALLOCATION_KEYFLEX.
MAPPING_TABLE_PK_ID NUMBER

Mapping table primary key id
GROUP_PL_ID NUMBER (15)
Group Plan Identifier.
LAST_UPDATE_DATE DATE

Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY NUMBER (15)
Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
CREATED_BY NUMBER (15)
Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
CREATION_DATE DATE

Standard who column - date when this row was created.
Query Text

Cut, paste (and edit) the following text to query this object:


SELECT EFFECTIVE_START_DATE
,      EFFECTIVE_END_DATE
,      NAME
,      ORDR_NUM
,      MX_CVG_WCFN_AMT
,      MX_CVG_WCFN_MLT_NUM
,      MN_CVG_ALWD_AMT
,      PRORT_PRTL_YR_CVG_RSTRN_RL
,      MN_OPTS_RQD_NUM
,      MX_OPTS_ALWD_NUM
,      MX_WTG_PERD_PRTE_VAL
,      MX_CVG_INCR_ALWD_AMT
,      MX_CVG_MLT_INCR_NUM
,      DFLT_TO_ASN_PNDG_CTFN_RL
,      MX_CVG_INCR_WCF_ALWD_AMT
,      MX_CVG_MLT_INCR_WCF_NUM
,      MX_CVG_ALWD_AMT
,      MN_CVG_RQD_AMT
,      ENRT_RL
,      MX_WTG_DT_TO_USE_RL
,      RQD_PERD_ENRT_NENRT_UOM
,      RQD_PERD_ENRT_NENRT_VAL
,      RQD_PERD_ENRT_NENRT_RL
,      URL_REF_NAME
,      INCPTN_DT
,      BNF_INCRMT_AMT
,      BNF_MN_DSGNTBL_AMT
,      BNF_MN_DSGNTBL_PCT_VAL
,      BNF_PCT_INCRMT_VAL
,      IVR_IDENT
,      RT_END_DT_RL
,      RT_STRT_DT_RL
,      POSTELCN_EDIT_RL
,      PLN_MN_CVG_ALWD_AMT
,      AUTO_ENRT_MTHD_RL
,      MX_WTG_PERD_RL
,      MN_CVG_RL
,      MX_CVG_RL
,      MX_WTG_PERD_PRTE_UOM
,      MX_WTG_PERD_PRTE_UOM_M
,      NIP_PL_UOM
,      COBRA_PYMT_DUE_DY_NUM
,      NIP_DFLT_ENRT_DET_RL
,      DPNT_CVG_END_DT_RL
,      DPNT_CVG_STRT_DT_RL
,      ENRT_CVG_END_DT_RL
,      ENRT_CVG_STRT_DT_RL
,      VRFY_FMLY_MMBR_RL
,      FRFS_DISTR_MTHD_RL
,      FRFS_MX_CRYFWD_VAL
,      SHORT_CODE
,      SHORT_NAME
,      MAPPING_TABLE_NAME
,      FUNCTION_CODE
,      LEGISLATION_CODE
,      LEGISLATION_SUBGROUP
,      GROUP_PLAN
,      _DF:PLN
,      PL_CD
,      PL_CD_M
,      CVG_INCR_R_DECR_ONLY_CD
,      CVG_INCR_R_DECR_ONLY_CD_M
,      SUBJ_TO_IMPTD_INCM_CD
,      SUBJ_TO_IMPTD_INCM_CD_M
,      SUBJ_TO_IMPTD_INCM_TYP_CD
,      SUBJ_TO_IMPTD_INCM_TYP_CD_M
,      UNSSPND_ENRT_CD
,      UNSSPND_ENRT_CD_M
,      IMPTD_INCM_CALC_CD
,      IMPTD_INCM_CALC_CD_M
,      RT_END_DT_CD
,      RT_END_DT_CD_M
,      RT_STRT_DT_CD
,      RT_STRT_DT_CD_M
,      PER_CVRD_CD
,      PER_CVRD_CD_M
,      BNFT_OR_OPTION_RSTRCTN_CD
,      BNFT_OR_OPTION_RSTRCTN_CD_M
,      PCP_CD
,      PCP_CD_M
,      MX_WTG_DT_TO_USE_CD
,      MX_WTG_DT_TO_USE_CD_M
,      BNF_DFLT_BNF_CD
,      BNF_DFLT_BNF_CD_M
,      BNF_PCT_AMT_ALWD_CD
,      BNF_PCT_AMT_ALWD_CD_M
,      CMPR_CLMS_TO_CVG_OR_BAL_CD
,      CMPR_CLMS_TO_CVG_OR_BAL_CD_M
,      DPNT_CVG_END_DT_CD
,      DPNT_CVG_END_DT_CD_M
,      DPNT_CVG_STRT_DT_CD
,      DPNT_CVG_STRT_DT_CD_M
,      DPNT_DSGN_CD
,      DPNT_DSGN_CD_M
,      NIP_DFLT_ENRT_CD
,      NIP_DFLT_ENRT_CD_M
,      BNF_DSGN_CD
,      BNF_DSGN_CD_M
,      PRMRY_FNDG_MTHD_CD
,      PRMRY_FNDG_MTHD_CD_M
,      DFLT_TO_ASN_PNDG_CTFN_CD
,      DFLT_TO_ASN_PNDG_CTFN_CD_M
,      ENRT_MTHD_CD
,      ENRT_MTHD_CD_M
,      HC_SVC_TYP_CD
,      HC_SVC_TYP_CD_M
,      NIP_ACTY_REF_PERD_CD
,      NIP_ACTY_REF_PERD_CD_M
,      ENRT_CD
,      ENRT_CD_M
,      PRORT_PRTL_YR_CVG_RSTRN_CD
,      PRORT_PRTL_YR_CVG_RSTRN_CD_M
,      PL_STAT_CD
,      PL_STAT_CD_M
,      ENRT_CVG_STRT_DT_CD
,      ENRT_CVG_STRT_DT_CD_M
,      ENRT_CVG_END_DT_CD
,      ENRT_CVG_END_DT_CD_M
,      NIP_ENRT_INFO_RT_FREQ_CD
,      NIP_ENRT_INFO_RT_FREQ_CD_M
,      VRFY_FMLY_MMBR_CD
,      VRFY_FMLY_MMBR_CD_M
,      FRFS_DISTR_MTHD_CD
,      FRFS_DISTR_MTHD_CD_M
,      FRFS_CNTR_DET_CD
,      FRFS_CNTR_DET_CD_M
,      FRFS_DISTR_DET_CD
,      FRFS_DISTR_DET_CD_M
,      FRFS_VAL_DET_CD
,      FRFS_VAL_DET_CD_M
,      FRFS_PORTION_DET_CD
,      FRFS_PORTION_DET_CD_M
,      BNDRY_PERD_CD
,      BNDRY_PERD_CD_M
,      USE_CSD_RSD_PRCCNG_CD
,      USE_CSD_RSD_PRCCNG_CD_M
,      DRVBL_DPNT_ELIG_FLAG
,      DRVBL_DPNT_ELIG_FLAG_M
,      DRVBL_FCTR_PRTN_ELIG_FLAG
,      DRVBL_FCTR_PRTN_ELIG_FLAG_M
,      DPNT_NO_CTFN_RQD_FLAG
,      DPNT_NO_CTFN_RQD_FLAG_M
,      MAY_ENRL_PL_N_OIPL_FLAG
,      MAY_ENRL_PL_N_OIPL_FLAG_M
,      DPNT_CVD_BY_OTHR_APLS_FLAG
,      DPNT_CVD_BY_OTHR_APLS_FLAG_M
,      DPNT_ADRS_RQD_FLAG
,      DPNT_ADRS_RQD_FLAG_M
,      DPNT_LEG_ID_RQD_FLAG
,      DPNT_LEG_ID_RQD_FLAG_M
,      DPNT_DOB_RQD_FLAG
,      DPNT_DOB_RQD_FLAG_M
,      DRVBL_FCTR_APLS_RTS_FLAG
,      DRVBL_FCTR_APLS_RTS_FLAG_M
,      ELIG_APLS_FLAG
,      ELIG_APLS_FLAG_M
,      NO_MX_OPTS_NUM_APLS_FLAG
,      NO_MX_OPTS_NUM_APLS_FLAG_M
,      ALWS_QDRO_FLAG
,      ALWS_QDRO_FLAG_M
,      ALWS_QMCSO_FLAG
,      ALWS_QMCSO_FLAG_M
,      HGHLY_CMPD_RL_APLS_FLAG
,      HGHLY_CMPD_RL_APLS_FLAG_M
,      ENRT_PL_OPT_FLAG
,      ENRT_PL_OPT_FLAG_M
,      FRFS_APLY_FLAG
,      FRFS_APLY_FLAG_M
,      SVGS_PL_FLAG
,      SVGS_PL_FLAG_M
,      TRK_INELIG_PER_FLAG
,      TRK_INELIG_PER_FLAG_M
,      USE_ALL_ASNTS_ELIG_FLAG
,      USE_ALL_ASNTS_ELIG_FLAG_M
,      USE_ALL_ASNTS_FOR_RT_FLAG
,      USE_ALL_ASNTS_FOR_RT_FLAG_M
,      VSTG_APLS_FLAG
,      VSTG_APLS_FLAG_M
,      PRTN_ELIG_OVRID_ALWD_FLAG
,      PRTN_ELIG_OVRID_ALWD_FLAG_M
,      HC_PL_SUBJ_HCFA_APRVL_FLAG
,      HC_PL_SUBJ_HCFA_APRVL_FLAG_M
,      WVBL_FLAG
,      WVBL_FLAG_M
,      INVK_FLX_CR_PL_FLAG
,      INVK_FLX_CR_PL_FLAG_M
,      INVK_DCLN_PRTN_PL_FLAG
,      INVK_DCLN_PRTN_PL_FLAG_M
,      ALWS_REIMBMTS_FLAG
,      ALWS_REIMBMTS_FLAG_M
,      ALWS_UNRSTRCTD_ENRT_FLAG
,      ALWS_UNRSTRCTD_ENRT_FLAG_M
,      BNF_ADDL_INSTN_TXT_ALWD_FLAG
,      BNF_ADDL_INSTN_TXT_ALWD_FLAG_M
,      BNF_ADRS_RQD_FLAG
,      BNF_ADRS_RQD_FLAG_M
,      BNF_CTFN_RQD_FLAG
,      BNF_CTFN_RQD_FLAG_M
,      BNF_CNTNGT_BNFS_ALWD_FLAG
,      BNF_CNTNGT_BNFS_ALWD_FLAG_M
,      BNF_LEGV_ID_RQD_FLAG
,      BNF_LEGV_ID_RQD_FLAG_M
,      BNF_MAY_DSGT_ORG_FLAG
,      BNF_MAY_DSGT_ORG_FLAG_M
,      BNF_QDRO_RL_APLS_FLAG
,      BNF_QDRO_RL_APLS_FLAG_M
,      BNF_DSGE_MNR_TTEE_RQD_FLAG
,      BNF_DSGE_MNR_TTEE_RQD_FLAG_M
,      NO_MN_CVG_AMT_APLS_FLAG
,      NO_MN_CVG_AMT_APLS_FLAG_M
,      NO_MX_CVG_AMT_APLS_FLAG
,      NO_MX_CVG_AMT_APLS_FLAG_M
,      NO_MN_CVG_INCR_APLS_FLAG
,      NO_MN_CVG_INCR_APLS_FLAG_M
,      NO_MX_CVG_INCR_APLS_FLAG
,      NO_MX_CVG_INCR_APLS_FLAG_M
,      NO_MN_OPTS_NUM_APLS_FLAG
,      NO_MN_OPTS_NUM_APLS_FLAG_M
,      BNF_DOB_RQD_FLAG
,      BNF_DOB_RQD_FLAG_M
,      ALWS_TMPRY_ID_CRD_FLAG
,      ALWS_TMPRY_ID_CRD_FLAG_M
,      NIP_DFLT_FLAG
,      NIP_DFLT_FLAG_M
,      POST_TO_GL_FLAG
,      POST_TO_GL_FLAG_M
,      PL_YR_NOT_APPLCBL_FLAG
,      PL_YR_NOT_APPLCBL_FLAG_M
,      PL_ID
,      PL_TYP_ID
,      BUSINESS_GROUP_ID
,      ACTL_PREM_ID
,      BNFT_PRVDR_POOL_ID
,      CR_DSTR_BNFT_PRVDR_POOL_ID
,      COST_ALLOC_KEYFLEX_1_ID
,      COST_ALLOC_KEYFLEX_2_ID
,      MAPPING_TABLE_PK_ID
,      GROUP_PL_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATED_BY
,      CREATION_DATE
FROM APPS.BENBV_PL_V;

Dependencies

[top of page]

APPS.BENBV_PL_V references the following:

SchemaAPPS
PL/SQL PackageBEN_BIS_UTILS - show dependent code
SynonymBEN_PL_F
PL/SQL PackageHR_BIS - show dependent code

APPS.BENBV_PL_V is not referenced by any database object