BEN_PL_F_VL

Details

• Schema: FUSION

• Object owner: BEN

• Object type: VIEW

Columns

Name

PL_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE NAME ALWS_QDRO_FLAG ALWS_QMCSO_FLAG ALWS_REIMBMTS_FLAG ASNT_RQD_FOR_ENRT_FLAG BNF_ADDL_INSTN_ALWD_FLAG BNF_ADRS_RQD_FLAG BNF_CNTNGT_BNFS_ALWD_FLAG BNF_CTFN_RQD_FLAG BNF_DOB_RQD_FLAG BNF_DSGE_MNR_TTEE_RQD_FLAG BNF_INCRMT_AMT BNF_DFLT_BNF_CD BNF_LEGV_ID_RQD_FLAG BNF_MAY_DSGT_ORG_FLAG BNF_MN_DSGNTBL_AMT BNF_MN_DSGNTBL_PCT_VAL BNF_PCT_INCRMT_VAL BNF_PCT_AMT_ALWD_CD BNF_QDRO_RL_APLS_FLAG DFLT_TO_ASN_PNDG_CTFN_CD DFLT_TO_ASN_PNDG_CTFN_RL DRVBL_FCTR_APLS_RTS_FLAG DRVBL_FCTR_PRTN_ELIG_FLAG ELIG_APLS_FLAG INVK_DCLN_PRTN_PL_FLAG INVK_FLX_CR_PL_FLAG INVK_IMPTD_INCM_PL_FLAG DRVBL_DPNT_ELIG_FLAG TRK_INELIG_PER_FLAG PL_CD AUTO_ENRT_MTHD_RL IVR_IDENT CMPR_CLMS_TO_CVG_OR_BAL_CD COBRA_PYMT_DUE_DY_NUM_CD DMSTC_PRTR_RT_TRTMT_FLAG DPNT_CVD_BY_OTHR_APLS_FLAG ENRT_MTHD_CD ENRT_CD ENRT_CVG_STRT_DT_CD ENRT_CVG_END_DT_CD FRFS_APLY_FLAG HC_PL_SUBJ_HCFA_APRVL_FLAG HGHLY_CMPD_RL_APLS_FLAG INCPTN_DT MN_CVG_RQD_AMT MN_OPTS_RQD_NUM MX_CVG_ALWD_AMT MX_OPTS_ALWD_NUM MX_CVG_WCFN_MLT_NUM MX_CVG_WCFN_AMT MX_CVG_INCR_ALWD_AMT MX_CVG_INCR_WCF_ALWD_AMT MX_CVG_MLT_INCR_NUM MX_CVG_MLT_INCR_WCF_NUM MX_WTG_DT_TO_USE_CD MX_WTG_DT_TO_USE_RL MX_WTG_PERD_PRTE_APLS_FLAG MX_WTG_PERD_PRTE_DET_CD MX_WTG_PERD_PRTE_DET_RL MX_WTG_PERD_PRTE_UOM MX_WTG_PERD_PRTE_VAL NIP_DFLT_ENRT_CD NIP_DFLT_ENRT_DET_RL DPNT_CVG_END_DT_CD DPNT_CVG_END_DT_RL DPNT_CVG_STRT_DT_CD DPNT_CVG_STRT_DT_RL DPNT_LEG_ID_RQD_FLAG DPNT_NO_CTFN_RQD_FLAG NO_MN_OPTS_NUM_APLS_FLAG NO_MX_OPTS_NUM_APLS_FLAG NIP_PL_UOM NIP_ACTY_REF_PERD_CD NIP_RQD_ENRL_PERD_TCO_CD NIP_ENRT_INFO_RT_FREQ_CD PER_CVRD_CD ENRT_CVG_END_DT_RL POSTELCN_EDIT_RL ENRT_CVG_STRT_DT_RL PRORT_PRTL_YR_CVG_RSTRN_CD PRORT_PRTL_YR_CVG_RSTRN_RL PRTN_ELIG_OVRID_ALWD_FLAG SVGS_PL_FLAG SUBJ_TO_IMPUT_INC_FLAG USE_ALL_ASNTS_ELIG_FLAG USE_ALL_ASNTS_FOR_RT_FLAG VSTG_APLS_FLAG WVBL_FLAG HC_SVC_TYP_CD PL_STAT_CD PRMRY_FNDG_MTHD_CD RT_END_DT_CD RT_END_DT_RL RT_STRT_DT_RL RT_STRT_DT_CD ENRL_PL_OPT_FLAG ENRT_RL MAY_ENRL_PL_N_OIPL_FLAG RQD_PERD_ENRT_NENRT_UOM RQD_PERD_ENRT_NENRT_VAL RQD_PERD_ENRT_NENRT_RL ORDR_NUM ALWS_UNRSTRCTD_ENRT_FLAG BNFT_R_OPT_RSTRN_CD CVG_INCR_R_DECR_ONLY_CD PL_TYP_ID ACTL_PREM_ID BNFT_PRVDR_POOL_ID BUSINESS_GROUP_ID PLN_ATTRIBUTE_CATEGORY PLN_ATTRIBUTE1 PLN_ATTRIBUTE2 PLN_ATTRIBUTE3 PLN_ATTRIBUTE4 PLN_ATTRIBUTE5 PLN_ATTRIBUTE6 PLN_ATTRIBUTE7 PLN_ATTRIBUTE8 PLN_ATTRIBUTE9 PLN_ATTRIBUTE10 PLN_ATTRIBUTE11 PLN_ATTRIBUTE12 PLN_ATTRIBUTE13 PLN_ATTRIBUTE14 PLN_ATTRIBUTE15 PLN_ATTRIBUTE16 PLN_ATTRIBUTE17 PLN_ATTRIBUTE18 PLN_ATTRIBUTE19 PLN_ATTRIBUTE20 PLN_ATTRIBUTE21 PLN_ATTRIBUTE22 PLN_ATTRIBUTE23 PLN_ATTRIBUTE24 PLN_ATTRIBUTE25 PLN_ATTRIBUTE26 PLN_ATTRIBUTE27 PLN_ATTRIBUTE28 PLN_ATTRIBUTE29 PLN_ATTRIBUTE30 LAST_UPDATE_DATE LAST_UPDATED_BY LAST_UPDATE_LOGIN CREATED_BY CREATION_DATE OBJECT_VERSION_NUMBER ENRT_PL_OPT_FLAG BNFT_OR_OPTION_RSTRCTN_CD MN_CVG_ALWD_AMT SUBJ_TO_IMPTD_INCM_CD SUBJ_TO_IMPTD_INCM_TYP_CD URL_REF_NAME UNSSPND_ENRT_CD IMPTD_INCM_CALC_CD PLN_MN_CVG_ALWD_AMT PCP_CD MX_WTG_PERD_RL COBRA_PYMT_DUE_DY_NUM CR_DSTR_BNFT_PRVDR_POOL_ID NIP_DFLT_FLAG VRFY_FMLY_MMBR_CD VRFY_FMLY_MMBR_RL ALWS_TMPRY_ID_CRD_FLAG FRFS_DISTR_MTHD_CD FRFS_DISTR_MTHD_RL FRFS_CNTR_DET_CD FRFS_DISTR_DET_CD COST_ALLOC_KEYFLEX_1_ID COST_ALLOC_KEYFLEX_2_ID POST_TO_GL_FLAG FRFS_VAL_DET_CD FRFS_MX_CRYFWD_VAL FRFS_PORTION_DET_CD BNDRY_PERD_CD SHORT_CODE SHORT_NAME FUNCTION_CODE MAPPING_TABLE_NAME MAPPING_TABLE_PK_ID PL_YR_NOT_APPLCBL_FLAG LEGISLATION_CODE LEGISLATION_SUBGROUP GROUP_PL_ID USE_CSD_RSD_PRCCNG_CD SUSP_IF_CTFN_NOT_PRVD_FLAG SUSP_IF_CTFN_NOT_BNF_FLAG BNF_CTFN_DETERMINE_CD GLOBAL_FLAG CVG_AMT_LMT_RL CVG_MLT_LMT_RL MN_CVG_RQD_MLT_NUM MX_CVG_ALWD_MLT_NUM UNSSPND_ENRT_RL UNSSPND_RT_CD UNSSPND_RT_RL DSGN_SELF_AS_BNF_FLAG PLN_ATTRIBUTE_NUMBER1 PLN_ATTRIBUTE_NUMBER2 PLN_ATTRIBUTE_NUMBER3 PLN_ATTRIBUTE_NUMBER4 PLN_ATTRIBUTE_NUMBER5 PLN_ATTRIBUTE_NUMBER6 PLN_ATTRIBUTE_NUMBER7 PLN_ATTRIBUTE_NUMBER8 PLN_ATTRIBUTE_NUMBER9 PLN_ATTRIBUTE_NUMBER10 PLN_ATTRIBUTE_NUMBER11 PLN_ATTRIBUTE_NUMBER12 PLN_ATTRIBUTE_NUMBER13 PLN_ATTRIBUTE_NUMBER14 PLN_ATTRIBUTE_NUMBER15 PLN_ATTRIBUTE_NUMBER16 PLN_ATTRIBUTE_NUMBER17 PLN_ATTRIBUTE_NUMBER18 PLN_ATTRIBUTE_NUMBER19 PLN_ATTRIBUTE_NUMBER20 PLN_ATTRIBUTE_DATE1 PLN_ATTRIBUTE_DATE2 PLN_ATTRIBUTE_DATE3 PLN_ATTRIBUTE_DATE4 PLN_ATTRIBUTE_DATE5 PLN_ATTRIBUTE_DATE6 PLN_ATTRIBUTE_DATE7 PLN_ATTRIBUTE_DATE8 PLN_ATTRIBUTE_DATE9 PLN_ATTRIBUTE_DATE10 PLN_ATTRIBUTE_DATE11 PLN_ATTRIBUTE_DATE12 PLN_ATTRIBUTE_DATE13 PLN_ATTRIBUTE_DATE14 PLN_ATTRIBUTE_DATE15 CARRIER_ID CARRIER_PL_NAME CONFIG_ID_1 CONFIG_ID_2 CONFIG_ID_3 CONFIG_ID_4 CONFIG_ID_5 CONFIG_NUM_1 CONFIG_NUM_2 CONFIG_NUM_3 CONFIG_NUM_4 CONFIG_NUM_5 CONFIG_CHAR_1 CONFIG_CHAR_2 CONFIG_CHAR_3 CONFIG_CHAR_4 CONFIG_CHAR_5 CONFIG_DATE_1 CONFIG_DATE_2 CONFIG_DATE_3 CONFIG_DATE_4 CONFIG_DATE_5

Query

SQL_Statement

SELECT PL.PL_ID, PL.EFFECTIVE_START_DATE, PL.EFFECTIVE_END_DATE, NVL(TL.NAME, PL.NAME) NAME, PL.ALWS_QDRO_FLAG, PL.ALWS_QMCSO_FLAG, PL.ALWS_REIMBMTS_FLAG, PL.ASNT_RQD_FOR_ENRT_FLAG, PL.BNF_ADDL_INSTN_ALWD_FLAG, PL.BNF_ADRS_RQD_FLAG, PL.BNF_CNTNGT_BNFS_ALWD_FLAG, PL.BNF_CTFN_RQD_FLAG, PL.BNF_DOB_RQD_FLAG, PL.BNF_DSGE_MNR_TTEE_RQD_FLAG, PL.BNF_INCRMT_AMT, PL.BNF_DFLT_BNF_CD, PL.BNF_LEGV_ID_RQD_FLAG, PL.BNF_MAY_DSGT_ORG_FLAG, PL.BNF_MN_DSGNTBL_AMT, PL.BNF_MN_DSGNTBL_PCT_VAL, PL.BNF_PCT_INCRMT_VAL, PL.BNF_PCT_AMT_ALWD_CD, PL.BNF_QDRO_RL_APLS_FLAG, PL.DFLT_TO_ASN_PNDG_CTFN_CD, PL.DFLT_TO_ASN_PNDG_CTFN_RL, PL.DRVBL_FCTR_APLS_RTS_FLAG, PL.DRVBL_FCTR_PRTN_ELIG_FLAG, PL.ELIG_APLS_FLAG, PL.INVK_DCLN_PRTN_PL_FLAG, PL.INVK_FLX_CR_PL_FLAG, PL.INVK_IMPTD_INCM_PL_FLAG, PL.DRVBL_DPNT_ELIG_FLAG, PL.TRK_INELIG_PER_FLAG, PL.PL_CD, PL.AUTO_ENRT_MTHD_RL, PL.IVR_IDENT, PL.CMPR_CLMS_TO_CVG_OR_BAL_CD, PL.COBRA_PYMT_DUE_DY_NUM_CD, PL.DMSTC_PRTR_RT_TRTMT_FLAG, PL.DPNT_CVD_BY_OTHR_APLS_FLAG, PL.ENRT_MTHD_CD, PL.ENRT_CD, PL.ENRT_CVG_STRT_DT_CD, PL.ENRT_CVG_END_DT_CD, PL.FRFS_APLY_FLAG, PL.HC_PL_SUBJ_HCFA_APRVL_FLAG, PL.HGHLY_CMPD_RL_APLS_FLAG, PL.INCPTN_DT, PL.MN_CVG_RQD_AMT, PL.MN_OPTS_RQD_NUM, PL.MX_CVG_ALWD_AMT, PL.MX_OPTS_ALWD_NUM, PL.MX_CVG_WCFN_MLT_NUM, PL.MX_CVG_WCFN_AMT, PL.MX_CVG_INCR_ALWD_AMT, PL.MX_CVG_INCR_WCF_ALWD_AMT, PL.MX_CVG_MLT_INCR_NUM, PL.MX_CVG_MLT_INCR_WCF_NUM, PL.MX_WTG_DT_TO_USE_CD, PL.MX_WTG_DT_TO_USE_RL, PL.MX_WTG_PERD_PRTE_APLS_FLAG, PL.MX_WTG_PERD_PRTE_DET_CD, PL.MX_WTG_PERD_PRTE_DET_RL, PL.MX_WTG_PERD_PRTE_UOM, PL.MX_WTG_PERD_PRTE_VAL, PL.NIP_DFLT_ENRT_CD, PL.NIP_DFLT_ENRT_DET_RL, PL.DPNT_CVG_END_DT_CD, PL.DPNT_CVG_END_DT_RL, PL.DPNT_CVG_STRT_DT_CD, PL.DPNT_CVG_STRT_DT_RL, PL.DPNT_LEG_ID_RQD_FLAG, PL.DPNT_NO_CTFN_RQD_FLAG, PL.NO_MN_OPTS_NUM_APLS_FLAG, PL.NO_MX_OPTS_NUM_APLS_FLAG, PL.NIP_PL_UOM, PL.NIP_ACTY_REF_PERD_CD, PL.NIP_RQD_ENRL_PERD_TCO_CD, PL.NIP_ENRT_INFO_RT_FREQ_CD, PL.PER_CVRD_CD, PL.ENRT_CVG_END_DT_RL, PL.POSTELCN_EDIT_RL, PL.ENRT_CVG_STRT_DT_RL, PL.PRORT_PRTL_YR_CVG_RSTRN_CD, PL.PRORT_PRTL_YR_CVG_RSTRN_RL, PL.PRTN_ELIG_OVRID_ALWD_FLAG, PL.SVGS_PL_FLAG, PL.SUBJ_TO_IMPUT_INC_FLAG, PL.USE_ALL_ASNTS_ELIG_FLAG, PL.USE_ALL_ASNTS_FOR_RT_FLAG, PL.VSTG_APLS_FLAG, PL.WVBL_FLAG, PL.HC_SVC_TYP_CD, PL.PL_STAT_CD, PL.PRMRY_FNDG_MTHD_CD, PL.RT_END_DT_CD, PL.RT_END_DT_RL, PL.RT_STRT_DT_RL, PL.RT_STRT_DT_CD, PL.ENRL_PL_OPT_FLAG, PL.ENRT_RL, PL.MAY_ENRL_PL_N_OIPL_FLAG, PL.RQD_PERD_ENRT_NENRT_UOM, PL.RQD_PERD_ENRT_NENRT_VAL, PL.RQD_PERD_ENRT_NENRT_RL, PL.ORDR_NUM, PL.ALWS_UNRSTRCTD_ENRT_FLAG, PL.BNFT_R_OPT_RSTRN_CD, PL.CVG_INCR_R_DECR_ONLY_CD, PL.PL_TYP_ID, PL.ACTL_PREM_ID, PL.BNFT_PRVDR_POOL_ID, PL.BUSINESS_GROUP_ID, PL.PLN_ATTRIBUTE_CATEGORY, PL.PLN_ATTRIBUTE1, PL.PLN_ATTRIBUTE2, PL.PLN_ATTRIBUTE3, PL.PLN_ATTRIBUTE4, PL.PLN_ATTRIBUTE5, PL.PLN_ATTRIBUTE6, PL.PLN_ATTRIBUTE7, PL.PLN_ATTRIBUTE8, PL.PLN_ATTRIBUTE9, PL.PLN_ATTRIBUTE10, PL.PLN_ATTRIBUTE11, PL.PLN_ATTRIBUTE12, PL.PLN_ATTRIBUTE13, PL.PLN_ATTRIBUTE14, PL.PLN_ATTRIBUTE15, PL.PLN_ATTRIBUTE16, PL.PLN_ATTRIBUTE17, PL.PLN_ATTRIBUTE18, PL.PLN_ATTRIBUTE19, PL.PLN_ATTRIBUTE20, PL.PLN_ATTRIBUTE21, PL.PLN_ATTRIBUTE22, PL.PLN_ATTRIBUTE23, PL.PLN_ATTRIBUTE24, PL.PLN_ATTRIBUTE25, PL.PLN_ATTRIBUTE26, PL.PLN_ATTRIBUTE27, PL.PLN_ATTRIBUTE28, PL.PLN_ATTRIBUTE29, PL.PLN_ATTRIBUTE30, PL.LAST_UPDATE_DATE, PL.LAST_UPDATED_BY, PL.LAST_UPDATE_LOGIN, PL.CREATED_BY, PL.CREATION_DATE, PL.OBJECT_VERSION_NUMBER, PL.ENRT_PL_OPT_FLAG, PL.BNFT_OR_OPTION_RSTRCTN_CD, PL.MN_CVG_ALWD_AMT, PL.SUBJ_TO_IMPTD_INCM_CD, PL.SUBJ_TO_IMPTD_INCM_TYP_CD, PL.URL_REF_NAME, PL.UNSSPND_ENRT_CD, PL.IMPTD_INCM_CALC_CD, PL.PLN_MN_CVG_ALWD_AMT, PL.PCP_CD, PL.MX_WTG_PERD_RL, PL.COBRA_PYMT_DUE_DY_NUM, PL.CR_DSTR_BNFT_PRVDR_POOL_ID, PL.NIP_DFLT_FLAG, PL.VRFY_FMLY_MMBR_CD, PL.VRFY_FMLY_MMBR_RL, PL.ALWS_TMPRY_ID_CRD_FLAG, PL.FRFS_DISTR_MTHD_CD, PL.FRFS_DISTR_MTHD_RL, PL.FRFS_CNTR_DET_CD, PL.FRFS_DISTR_DET_CD, PL.COST_ALLOC_KEYFLEX_1_ID, PL.COST_ALLOC_KEYFLEX_2_ID, PL.POST_TO_GL_FLAG, PL.FRFS_VAL_DET_CD, PL.FRFS_MX_CRYFWD_VAL, PL.FRFS_PORTION_DET_CD, PL.BNDRY_PERD_CD, PL.SHORT_CODE, PL.SHORT_NAME, PL.FUNCTION_CODE, PL.MAPPING_TABLE_NAME, PL.MAPPING_TABLE_PK_ID, PL.PL_YR_NOT_APPLCBL_FLAG, PL.LEGISLATION_CODE, PL.LEGISLATION_SUBGROUP, PL.GROUP_PL_ID, PL.USE_CSD_RSD_PRCCNG_CD, PL.SUSP_IF_CTFN_NOT_PRVD_FLAG, PL.SUSP_IF_CTFN_NOT_BNF_FLAG, PL.BNF_CTFN_DETERMINE_CD, PL.GLOBAL_FLAG, PL.CVG_AMT_LMT_RL, PL.CVG_MLT_LMT_RL, PL.MN_CVG_RQD_MLT_NUM, PL.MX_CVG_ALWD_MLT_NUM, PL.UNSSPND_ENRT_RL, PL.UNSSPND_RT_CD, PL.UNSSPND_RT_RL, PL.DSGN_SELF_AS_BNF_FLAG, PL.PLN_ATTRIBUTE_NUMBER1, PL.PLN_ATTRIBUTE_NUMBER2, PL.PLN_ATTRIBUTE_NUMBER3, PL.PLN_ATTRIBUTE_NUMBER4, PL.PLN_ATTRIBUTE_NUMBER5, PL.PLN_ATTRIBUTE_NUMBER6, PL.PLN_ATTRIBUTE_NUMBER7, PL.PLN_ATTRIBUTE_NUMBER8, PL.PLN_ATTRIBUTE_NUMBER9, PL.PLN_ATTRIBUTE_NUMBER10, PL.PLN_ATTRIBUTE_NUMBER11, PL.PLN_ATTRIBUTE_NUMBER12, PL.PLN_ATTRIBUTE_NUMBER13, PL.PLN_ATTRIBUTE_NUMBER14, PL.PLN_ATTRIBUTE_NUMBER15, PL.PLN_ATTRIBUTE_NUMBER16, PL.PLN_ATTRIBUTE_NUMBER17, PL.PLN_ATTRIBUTE_NUMBER18, PL.PLN_ATTRIBUTE_NUMBER19, PL.PLN_ATTRIBUTE_NUMBER20, PL.PLN_ATTRIBUTE_DATE1, PL.PLN_ATTRIBUTE_DATE2, PL.PLN_ATTRIBUTE_DATE3, PL.PLN_ATTRIBUTE_DATE4, PL.PLN_ATTRIBUTE_DATE5, PL.PLN_ATTRIBUTE_DATE6, PL.PLN_ATTRIBUTE_DATE7, PL.PLN_ATTRIBUTE_DATE8, PL.PLN_ATTRIBUTE_DATE9, PL.PLN_ATTRIBUTE_DATE10, PL.PLN_ATTRIBUTE_DATE11, PL.PLN_ATTRIBUTE_DATE12, PL.PLN_ATTRIBUTE_DATE13, PL.PLN_ATTRIBUTE_DATE14, PL.PLN_ATTRIBUTE_DATE15, PL.CARRIER_ID, PL.CARRIER_PL_NAME, PL.CONFIG_ID_1, PL.CONFIG_ID_2, PL.CONFIG_ID_3, PL.CONFIG_ID_4, PL.CONFIG_ID_5, PL.CONFIG_NUM_1, PL.CONFIG_NUM_2, PL.CONFIG_NUM_3, PL.CONFIG_NUM_4, PL.CONFIG_NUM_5, PL.CONFIG_CHAR_1, PL.CONFIG_CHAR_2, PL.CONFIG_CHAR_3, PL.CONFIG_CHAR_4, PL.CONFIG_CHAR_5, PL.CONFIG_DATE_1, PL.CONFIG_DATE_2, PL.CONFIG_DATE_3, PL.CONFIG_DATE_4, PL.CONFIG_DATE_5 FROM BEN_PL_F PL, BEN_PL_F_TL TL WHERE PL.PL_TYP_ID = TL.PL_ID(+) AND PL.EFFECTIVE_START_DATE = TL.EFFECTIVE_START_DATE(+) AND TL.LANGUAGE(+) = USERENV('LANG')