VIEW: BEN.BEN_PL_F#

Source

View Text - Preformatted

select PL_ID PL_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, NAME NAME, DRVBL_DPNT_ELIG_FLAG DRVBL_DPNT_ELIG_FLAG, DRVBL_FCTR_PRTN_ELIG_FLAG DRVBL_FCTR_PRTN_ELIG_FLAG, DPNT_NO_CTFN_RQD_FLAG DPNT_NO_CTFN_RQD_FLAG, MAY_ENRL_PL_N_OIPL_FLAG MAY_ENRL_PL_N_OIPL_FLAG, DPNT_CVD_BY_OTHR_APLS_FLAG DPNT_CVD_BY_OTHR_APLS_FLAG, DPNT_ADRS_RQD_FLAG DPNT_ADRS_RQD_FLAG, DPNT_LEG_ID_RQD_FLAG DPNT_LEG_ID_RQD_FLAG, DPNT_DOB_RQD_FLAG DPNT_DOB_RQD_FLAG, DRVBL_FCTR_APLS_RTS_FLAG DRVBL_FCTR_APLS_RTS_FLAG, ELIG_APLS_FLAG ELIG_APLS_FLAG, NO_MX_OPTS_NUM_APLS_FLAG NO_MX_OPTS_NUM_APLS_FLAG, ALWS_QDRO_FLAG ALWS_QDRO_FLAG, ALWS_QMCSO_FLAG ALWS_QMCSO_FLAG, HGHLY_CMPD_RL_APLS_FLAG HGHLY_CMPD_RL_APLS_FLAG, ENRT_PL_OPT_FLAG ENRT_PL_OPT_FLAG, FRFS_APLY_FLAG FRFS_APLY_FLAG, SVGS_PL_FLAG SVGS_PL_FLAG, TRK_INELIG_PER_FLAG TRK_INELIG_PER_FLAG, USE_ALL_ASNTS_ELIG_FLAG USE_ALL_ASNTS_ELIG_FLAG, USE_ALL_ASNTS_FOR_RT_FLAG USE_ALL_ASNTS_FOR_RT_FLAG, VSTG_APLS_FLAG VSTG_APLS_FLAG, PRTN_ELIG_OVRID_ALWD_FLAG PRTN_ELIG_OVRID_ALWD_FLAG, HC_PL_SUBJ_HCFA_APRVL_FLAG HC_PL_SUBJ_HCFA_APRVL_FLAG, WVBL_FLAG WVBL_FLAG, INVK_FLX_CR_PL_FLAG INVK_FLX_CR_PL_FLAG, INVK_DCLN_PRTN_PL_FLAG INVK_DCLN_PRTN_PL_FLAG, ALWS_REIMBMTS_FLAG ALWS_REIMBMTS_FLAG, ALWS_UNRSTRCTD_ENRT_FLAG ALWS_UNRSTRCTD_ENRT_FLAG, BNF_ADDL_INSTN_TXT_ALWD_FLAG BNF_ADDL_INSTN_TXT_ALWD_FLAG, BNF_ADRS_RQD_FLAG BNF_ADRS_RQD_FLAG, BNF_CTFN_RQD_FLAG BNF_CTFN_RQD_FLAG, BNF_CNTNGT_BNFS_ALWD_FLAG BNF_CNTNGT_BNFS_ALWD_FLAG, BNF_LEGV_ID_RQD_FLAG BNF_LEGV_ID_RQD_FLAG, BNF_MAY_DSGT_ORG_FLAG BNF_MAY_DSGT_ORG_FLAG, BNF_QDRO_RL_APLS_FLAG BNF_QDRO_RL_APLS_FLAG, BNF_DSGE_MNR_TTEE_RQD_FLAG BNF_DSGE_MNR_TTEE_RQD_FLAG, NO_MN_CVG_AMT_APLS_FLAG NO_MN_CVG_AMT_APLS_FLAG, NO_MX_CVG_AMT_APLS_FLAG NO_MX_CVG_AMT_APLS_FLAG, NO_MN_CVG_INCR_APLS_FLAG NO_MN_CVG_INCR_APLS_FLAG, NO_MX_CVG_INCR_APLS_FLAG NO_MX_CVG_INCR_APLS_FLAG, NO_MN_OPTS_NUM_APLS_FLAG NO_MN_OPTS_NUM_APLS_FLAG, BNF_DOB_RQD_FLAG BNF_DOB_RQD_FLAG, PL_CD PL_CD, PL_TYP_ID PL_TYP_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ORDR_NUM ORDR_NUM, CVG_INCR_R_DECR_ONLY_CD CVG_INCR_R_DECR_ONLY_CD, MX_CVG_WCFN_AMT MX_CVG_WCFN_AMT, MX_CVG_WCFN_MLT_NUM MX_CVG_WCFN_MLT_NUM, MN_CVG_ALWD_AMT MN_CVG_ALWD_AMT, PRORT_PRTL_YR_CVG_RSTRN_RL PRORT_PRTL_YR_CVG_RSTRN_RL, MN_OPTS_RQD_NUM MN_OPTS_RQD_NUM, MX_OPTS_ALWD_NUM MX_OPTS_ALWD_NUM, MX_WTG_PERD_PRTE_VAL MX_WTG_PERD_PRTE_VAL, MX_CVG_INCR_ALWD_AMT MX_CVG_INCR_ALWD_AMT, MX_CVG_MLT_INCR_NUM MX_CVG_MLT_INCR_NUM, DFLT_TO_ASN_PNDG_CTFN_RL DFLT_TO_ASN_PNDG_CTFN_RL, MX_CVG_INCR_WCF_ALWD_AMT MX_CVG_INCR_WCF_ALWD_AMT, MX_CVG_MLT_INCR_WCF_NUM MX_CVG_MLT_INCR_WCF_NUM, MX_CVG_ALWD_AMT MX_CVG_ALWD_AMT, MN_CVG_RQD_AMT MN_CVG_RQD_AMT, ENRT_RL ENRT_RL, MX_WTG_DT_TO_USE_RL MX_WTG_DT_TO_USE_RL, RQD_PERD_ENRT_NENRT_UOM RQD_PERD_ENRT_NENRT_UOM, RQD_PERD_ENRT_NENRT_VAL RQD_PERD_ENRT_NENRT_VAL, RQD_PERD_ENRT_NENRT_RL RQD_PERD_ENRT_NENRT_RL, SUBJ_TO_IMPTD_INCM_CD SUBJ_TO_IMPTD_INCM_CD, SUBJ_TO_IMPTD_INCM_TYP_CD SUBJ_TO_IMPTD_INCM_TYP_CD, URL_REF_NAME URL_REF_NAME, UNSSPND_ENRT_CD UNSSPND_ENRT_CD, INCPTN_DT INCPTN_DT, IMPTD_INCM_CALC_CD IMPTD_INCM_CALC_CD, BNF_INCRMT_AMT BNF_INCRMT_AMT, BNF_MN_DSGNTBL_AMT BNF_MN_DSGNTBL_AMT, BNF_MN_DSGNTBL_PCT_VAL BNF_MN_DSGNTBL_PCT_VAL, BNF_PCT_INCRMT_VAL BNF_PCT_INCRMT_VAL, IVR_IDENT IVR_IDENT, RT_END_DT_CD RT_END_DT_CD, RT_END_DT_RL RT_END_DT_RL, RT_STRT_DT_CD RT_STRT_DT_CD, RT_STRT_DT_RL RT_STRT_DT_RL, POSTELCN_EDIT_RL POSTELCN_EDIT_RL, PER_CVRD_CD PER_CVRD_CD, BNFT_OR_OPTION_RSTRCTN_CD BNFT_OR_OPTION_RSTRCTN_CD, PLN_MN_CVG_ALWD_AMT PLN_MN_CVG_ALWD_AMT, PCP_CD PCP_CD, AUTO_ENRT_MTHD_RL AUTO_ENRT_MTHD_RL, MX_WTG_PERD_RL MX_WTG_PERD_RL, MN_CVG_RL MN_CVG_RL, MX_CVG_RL MX_CVG_RL, MX_WTG_PERD_PRTE_UOM MX_WTG_PERD_PRTE_UOM, MX_WTG_DT_TO_USE_CD MX_WTG_DT_TO_USE_CD, NIP_PL_UOM NIP_PL_UOM, BNF_DFLT_BNF_CD BNF_DFLT_BNF_CD, BNF_PCT_AMT_ALWD_CD BNF_PCT_AMT_ALWD_CD, CMPR_CLMS_TO_CVG_OR_BAL_CD CMPR_CLMS_TO_CVG_OR_BAL_CD, COBRA_PYMT_DUE_DY_NUM COBRA_PYMT_DUE_DY_NUM, DPNT_CVG_END_DT_CD DPNT_CVG_END_DT_CD, DPNT_CVG_STRT_DT_CD DPNT_CVG_STRT_DT_CD, NIP_DFLT_ENRT_DET_RL NIP_DFLT_ENRT_DET_RL, DPNT_DSGN_CD DPNT_DSGN_CD, NIP_DFLT_ENRT_CD NIP_DFLT_ENRT_CD, BNF_DSGN_CD BNF_DSGN_CD, PRMRY_FNDG_MTHD_CD PRMRY_FNDG_MTHD_CD, DFLT_TO_ASN_PNDG_CTFN_CD DFLT_TO_ASN_PNDG_CTFN_CD, ENRT_MTHD_CD ENRT_MTHD_CD, HC_SVC_TYP_CD HC_SVC_TYP_CD, DPNT_CVG_END_DT_RL DPNT_CVG_END_DT_RL, NIP_ACTY_REF_PERD_CD NIP_ACTY_REF_PERD_CD, ENRT_CD ENRT_CD, PRORT_PRTL_YR_CVG_RSTRN_CD PRORT_PRTL_YR_CVG_RSTRN_CD, PL_STAT_CD PL_STAT_CD, ENRT_CVG_STRT_DT_CD ENRT_CVG_STRT_DT_CD, ENRT_CVG_END_DT_CD ENRT_CVG_END_DT_CD, NIP_ENRT_INFO_RT_FREQ_CD NIP_ENRT_INFO_RT_FREQ_CD, DPNT_CVG_STRT_DT_RL DPNT_CVG_STRT_DT_RL, ENRT_CVG_END_DT_RL ENRT_CVG_END_DT_RL, ENRT_CVG_STRT_DT_RL ENRT_CVG_STRT_DT_RL, ACTL_PREM_ID ACTL_PREM_ID, BNFT_PRVDR_POOL_ID BNFT_PRVDR_POOL_ID, CR_DSTR_BNFT_PRVDR_POOL_ID CR_DSTR_BNFT_PRVDR_POOL_ID, PLN_ATTRIBUTE_CATEGORY PLN_ATTRIBUTE_CATEGORY, PLN_ATTRIBUTE1 PLN_ATTRIBUTE1, PLN_ATTRIBUTE2 PLN_ATTRIBUTE2, PLN_ATTRIBUTE3 PLN_ATTRIBUTE3, PLN_ATTRIBUTE4 PLN_ATTRIBUTE4, PLN_ATTRIBUTE5 PLN_ATTRIBUTE5, PLN_ATTRIBUTE6 PLN_ATTRIBUTE6, PLN_ATTRIBUTE7 PLN_ATTRIBUTE7, PLN_ATTRIBUTE8 PLN_ATTRIBUTE8, PLN_ATTRIBUTE9 PLN_ATTRIBUTE9, PLN_ATTRIBUTE10 PLN_ATTRIBUTE10, PLN_ATTRIBUTE11 PLN_ATTRIBUTE11, PLN_ATTRIBUTE12 PLN_ATTRIBUTE12, PLN_ATTRIBUTE13 PLN_ATTRIBUTE13, PLN_ATTRIBUTE14 PLN_ATTRIBUTE14, PLN_ATTRIBUTE15 PLN_ATTRIBUTE15, PLN_ATTRIBUTE16 PLN_ATTRIBUTE16, PLN_ATTRIBUTE17 PLN_ATTRIBUTE17, PLN_ATTRIBUTE18 PLN_ATTRIBUTE18, PLN_ATTRIBUTE19 PLN_ATTRIBUTE19, PLN_ATTRIBUTE20 PLN_ATTRIBUTE20, PLN_ATTRIBUTE21 PLN_ATTRIBUTE21, PLN_ATTRIBUTE22 PLN_ATTRIBUTE22, PLN_ATTRIBUTE23 PLN_ATTRIBUTE23, PLN_ATTRIBUTE24 PLN_ATTRIBUTE24, PLN_ATTRIBUTE25 PLN_ATTRIBUTE25, PLN_ATTRIBUTE26 PLN_ATTRIBUTE26, PLN_ATTRIBUTE27 PLN_ATTRIBUTE27, PLN_ATTRIBUTE28 PLN_ATTRIBUTE28, PLN_ATTRIBUTE29 PLN_ATTRIBUTE29, PLN_ATTRIBUTE30 PLN_ATTRIBUTE30, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, VRFY_FMLY_MMBR_CD VRFY_FMLY_MMBR_CD, VRFY_FMLY_MMBR_RL VRFY_FMLY_MMBR_RL, ALWS_TMPRY_ID_CRD_FLAG ALWS_TMPRY_ID_CRD_FLAG, NIP_DFLT_FLAG NIP_DFLT_FLAG, FRFS_DISTR_MTHD_CD FRFS_DISTR_MTHD_CD, FRFS_DISTR_MTHD_RL FRFS_DISTR_MTHD_RL, FRFS_CNTR_DET_CD FRFS_CNTR_DET_CD, FRFS_DISTR_DET_CD FRFS_DISTR_DET_CD, COST_ALLOC_KEYFLEX_1_ID COST_ALLOC_KEYFLEX_1_ID, COST_ALLOC_KEYFLEX_2_ID COST_ALLOC_KEYFLEX_2_ID, POST_TO_GL_FLAG POST_TO_GL_FLAG, FRFS_VAL_DET_CD FRFS_VAL_DET_CD, FRFS_MX_CRYFWD_VAL FRFS_MX_CRYFWD_VAL, FRFS_PORTION_DET_CD FRFS_PORTION_DET_CD, BNDRY_PERD_CD BNDRY_PERD_CD, SHORT_CODE SHORT_CODE, SHORT_NAME SHORT_NAME, FUNCTION_CODE FUNCTION_CODE, MAPPING_TABLE_NAME MAPPING_TABLE_NAME, MAPPING_TABLE_PK_ID MAPPING_TABLE_PK_ID, PL_YR_NOT_APPLCBL_FLAG PL_YR_NOT_APPLCBL_FLAG, LEGISLATION_CODE LEGISLATION_CODE, LEGISLATION_SUBGROUP LEGISLATION_SUBGROUP, GROUP_PL_ID GROUP_PL_ID, USE_CSD_RSD_PRCCNG_CD USE_CSD_RSD_PRCCNG_CD, SUSP_IF_CTFN_NOT_PRVD_FLAG SUSP_IF_CTFN_NOT_PRVD_FLAG, CTFN_DETERMINE_CD CTFN_DETERMINE_CD, SUSP_IF_DPNT_SSN_NT_PRV_CD SUSP_IF_DPNT_SSN_NT_PRV_CD, SUSP_IF_DPNT_DOB_NT_PRV_CD SUSP_IF_DPNT_DOB_NT_PRV_CD, SUSP_IF_DPNT_ADR_NT_PRV_CD SUSP_IF_DPNT_ADR_NT_PRV_CD, SUSP_IF_CTFN_NOT_DPNT_FLAG SUSP_IF_CTFN_NOT_DPNT_FLAG, SUSP_IF_BNF_SSN_NT_PRV_CD SUSP_IF_BNF_SSN_NT_PRV_CD, SUSP_IF_BNF_DOB_NT_PRV_CD SUSP_IF_BNF_DOB_NT_PRV_CD, SUSP_IF_BNF_ADR_NT_PRV_CD SUSP_IF_BNF_ADR_NT_PRV_CD, SUSP_IF_CTFN_NOT_BNF_FLAG SUSP_IF_CTFN_NOT_BNF_FLAG, DPNT_CTFN_DETERMINE_CD DPNT_CTFN_DETERMINE_CD, BNF_CTFN_DETERMINE_CD BNF_CTFN_DETERMINE_CD, ALL_INELIG ALL_INELIG, ZD_EDITION_NAME ZD_EDITION_NAME, BNF_EXL_PARTICIPANT_FLAG BNF_EXL_PARTICIPANT_FLAG from "BEN"."BEN_PL_F"

View Text - HTML Formatted

SELECT PL_ID PL_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, NAME NAME
, DRVBL_DPNT_ELIG_FLAG DRVBL_DPNT_ELIG_FLAG
, DRVBL_FCTR_PRTN_ELIG_FLAG DRVBL_FCTR_PRTN_ELIG_FLAG
, DPNT_NO_CTFN_RQD_FLAG DPNT_NO_CTFN_RQD_FLAG
, MAY_ENRL_PL_N_OIPL_FLAG MAY_ENRL_PL_N_OIPL_FLAG
, DPNT_CVD_BY_OTHR_APLS_FLAG DPNT_CVD_BY_OTHR_APLS_FLAG
, DPNT_ADRS_RQD_FLAG DPNT_ADRS_RQD_FLAG
, DPNT_LEG_ID_RQD_FLAG DPNT_LEG_ID_RQD_FLAG
, DPNT_DOB_RQD_FLAG DPNT_DOB_RQD_FLAG
, DRVBL_FCTR_APLS_RTS_FLAG DRVBL_FCTR_APLS_RTS_FLAG
, ELIG_APLS_FLAG ELIG_APLS_FLAG
, NO_MX_OPTS_NUM_APLS_FLAG NO_MX_OPTS_NUM_APLS_FLAG
, ALWS_QDRO_FLAG ALWS_QDRO_FLAG
, ALWS_QMCSO_FLAG ALWS_QMCSO_FLAG
, HGHLY_CMPD_RL_APLS_FLAG HGHLY_CMPD_RL_APLS_FLAG
, ENRT_PL_OPT_FLAG ENRT_PL_OPT_FLAG
, FRFS_APLY_FLAG FRFS_APLY_FLAG
, SVGS_PL_FLAG SVGS_PL_FLAG
, TRK_INELIG_PER_FLAG TRK_INELIG_PER_FLAG
, USE_ALL_ASNTS_ELIG_FLAG USE_ALL_ASNTS_ELIG_FLAG
, USE_ALL_ASNTS_FOR_RT_FLAG USE_ALL_ASNTS_FOR_RT_FLAG
, VSTG_APLS_FLAG VSTG_APLS_FLAG
, PRTN_ELIG_OVRID_ALWD_FLAG PRTN_ELIG_OVRID_ALWD_FLAG
, HC_PL_SUBJ_HCFA_APRVL_FLAG HC_PL_SUBJ_HCFA_APRVL_FLAG
, WVBL_FLAG WVBL_FLAG
, INVK_FLX_CR_PL_FLAG INVK_FLX_CR_PL_FLAG
, INVK_DCLN_PRTN_PL_FLAG INVK_DCLN_PRTN_PL_FLAG
, ALWS_REIMBMTS_FLAG ALWS_REIMBMTS_FLAG
, ALWS_UNRSTRCTD_ENRT_FLAG ALWS_UNRSTRCTD_ENRT_FLAG
, BNF_ADDL_INSTN_TXT_ALWD_FLAG BNF_ADDL_INSTN_TXT_ALWD_FLAG
, BNF_ADRS_RQD_FLAG BNF_ADRS_RQD_FLAG
, BNF_CTFN_RQD_FLAG BNF_CTFN_RQD_FLAG
, BNF_CNTNGT_BNFS_ALWD_FLAG BNF_CNTNGT_BNFS_ALWD_FLAG
, BNF_LEGV_ID_RQD_FLAG BNF_LEGV_ID_RQD_FLAG
, BNF_MAY_DSGT_ORG_FLAG BNF_MAY_DSGT_ORG_FLAG
, BNF_QDRO_RL_APLS_FLAG BNF_QDRO_RL_APLS_FLAG
, BNF_DSGE_MNR_TTEE_RQD_FLAG BNF_DSGE_MNR_TTEE_RQD_FLAG
, NO_MN_CVG_AMT_APLS_FLAG NO_MN_CVG_AMT_APLS_FLAG
, NO_MX_CVG_AMT_APLS_FLAG NO_MX_CVG_AMT_APLS_FLAG
, NO_MN_CVG_INCR_APLS_FLAG NO_MN_CVG_INCR_APLS_FLAG
, NO_MX_CVG_INCR_APLS_FLAG NO_MX_CVG_INCR_APLS_FLAG
, NO_MN_OPTS_NUM_APLS_FLAG NO_MN_OPTS_NUM_APLS_FLAG
, BNF_DOB_RQD_FLAG BNF_DOB_RQD_FLAG
, PL_CD PL_CD
, PL_TYP_ID PL_TYP_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ORDR_NUM ORDR_NUM
, CVG_INCR_R_DECR_ONLY_CD CVG_INCR_R_DECR_ONLY_CD
, MX_CVG_WCFN_AMT MX_CVG_WCFN_AMT
, MX_CVG_WCFN_MLT_NUM MX_CVG_WCFN_MLT_NUM
, MN_CVG_ALWD_AMT MN_CVG_ALWD_AMT
, PRORT_PRTL_YR_CVG_RSTRN_RL PRORT_PRTL_YR_CVG_RSTRN_RL
, MN_OPTS_RQD_NUM MN_OPTS_RQD_NUM
, MX_OPTS_ALWD_NUM MX_OPTS_ALWD_NUM
, MX_WTG_PERD_PRTE_VAL MX_WTG_PERD_PRTE_VAL
, MX_CVG_INCR_ALWD_AMT MX_CVG_INCR_ALWD_AMT
, MX_CVG_MLT_INCR_NUM MX_CVG_MLT_INCR_NUM
, DFLT_TO_ASN_PNDG_CTFN_RL DFLT_TO_ASN_PNDG_CTFN_RL
, MX_CVG_INCR_WCF_ALWD_AMT MX_CVG_INCR_WCF_ALWD_AMT
, MX_CVG_MLT_INCR_WCF_NUM MX_CVG_MLT_INCR_WCF_NUM
, MX_CVG_ALWD_AMT MX_CVG_ALWD_AMT
, MN_CVG_RQD_AMT MN_CVG_RQD_AMT
, ENRT_RL ENRT_RL
, MX_WTG_DT_TO_USE_RL MX_WTG_DT_TO_USE_RL
, RQD_PERD_ENRT_NENRT_UOM RQD_PERD_ENRT_NENRT_UOM
, RQD_PERD_ENRT_NENRT_VAL RQD_PERD_ENRT_NENRT_VAL
, RQD_PERD_ENRT_NENRT_RL RQD_PERD_ENRT_NENRT_RL
, SUBJ_TO_IMPTD_INCM_CD SUBJ_TO_IMPTD_INCM_CD
, SUBJ_TO_IMPTD_INCM_TYP_CD SUBJ_TO_IMPTD_INCM_TYP_CD
, URL_REF_NAME URL_REF_NAME
, UNSSPND_ENRT_CD UNSSPND_ENRT_CD
, INCPTN_DT INCPTN_DT
, IMPTD_INCM_CALC_CD IMPTD_INCM_CALC_CD
, BNF_INCRMT_AMT BNF_INCRMT_AMT
, BNF_MN_DSGNTBL_AMT BNF_MN_DSGNTBL_AMT
, BNF_MN_DSGNTBL_PCT_VAL BNF_MN_DSGNTBL_PCT_VAL
, BNF_PCT_INCRMT_VAL BNF_PCT_INCRMT_VAL
, IVR_IDENT IVR_IDENT
, RT_END_DT_CD RT_END_DT_CD
, RT_END_DT_RL RT_END_DT_RL
, RT_STRT_DT_CD RT_STRT_DT_CD
, RT_STRT_DT_RL RT_STRT_DT_RL
, POSTELCN_EDIT_RL POSTELCN_EDIT_RL
, PER_CVRD_CD PER_CVRD_CD
, BNFT_OR_OPTION_RSTRCTN_CD BNFT_OR_OPTION_RSTRCTN_CD
, PLN_MN_CVG_ALWD_AMT PLN_MN_CVG_ALWD_AMT
, PCP_CD PCP_CD
, AUTO_ENRT_MTHD_RL AUTO_ENRT_MTHD_RL
, MX_WTG_PERD_RL MX_WTG_PERD_RL
, MN_CVG_RL MN_CVG_RL
, MX_CVG_RL MX_CVG_RL
, MX_WTG_PERD_PRTE_UOM MX_WTG_PERD_PRTE_UOM
, MX_WTG_DT_TO_USE_CD MX_WTG_DT_TO_USE_CD
, NIP_PL_UOM NIP_PL_UOM
, BNF_DFLT_BNF_CD BNF_DFLT_BNF_CD
, BNF_PCT_AMT_ALWD_CD BNF_PCT_AMT_ALWD_CD
, CMPR_CLMS_TO_CVG_OR_BAL_CD CMPR_CLMS_TO_CVG_OR_BAL_CD
, COBRA_PYMT_DUE_DY_NUM COBRA_PYMT_DUE_DY_NUM
, DPNT_CVG_END_DT_CD DPNT_CVG_END_DT_CD
, DPNT_CVG_STRT_DT_CD DPNT_CVG_STRT_DT_CD
, NIP_DFLT_ENRT_DET_RL NIP_DFLT_ENRT_DET_RL
, DPNT_DSGN_CD DPNT_DSGN_CD
, NIP_DFLT_ENRT_CD NIP_DFLT_ENRT_CD
, BNF_DSGN_CD BNF_DSGN_CD
, PRMRY_FNDG_MTHD_CD PRMRY_FNDG_MTHD_CD
, DFLT_TO_ASN_PNDG_CTFN_CD DFLT_TO_ASN_PNDG_CTFN_CD
, ENRT_MTHD_CD ENRT_MTHD_CD
, HC_SVC_TYP_CD HC_SVC_TYP_CD
, DPNT_CVG_END_DT_RL DPNT_CVG_END_DT_RL
, NIP_ACTY_REF_PERD_CD NIP_ACTY_REF_PERD_CD
, ENRT_CD ENRT_CD
, PRORT_PRTL_YR_CVG_RSTRN_CD PRORT_PRTL_YR_CVG_RSTRN_CD
, PL_STAT_CD PL_STAT_CD
, ENRT_CVG_STRT_DT_CD ENRT_CVG_STRT_DT_CD
, ENRT_CVG_END_DT_CD ENRT_CVG_END_DT_CD
, NIP_ENRT_INFO_RT_FREQ_CD NIP_ENRT_INFO_RT_FREQ_CD
, DPNT_CVG_STRT_DT_RL DPNT_CVG_STRT_DT_RL
, ENRT_CVG_END_DT_RL ENRT_CVG_END_DT_RL
, ENRT_CVG_STRT_DT_RL ENRT_CVG_STRT_DT_RL
, ACTL_PREM_ID ACTL_PREM_ID
, BNFT_PRVDR_POOL_ID BNFT_PRVDR_POOL_ID
, CR_DSTR_BNFT_PRVDR_POOL_ID CR_DSTR_BNFT_PRVDR_POOL_ID
, PLN_ATTRIBUTE_CATEGORY PLN_ATTRIBUTE_CATEGORY
, PLN_ATTRIBUTE1 PLN_ATTRIBUTE1
, PLN_ATTRIBUTE2 PLN_ATTRIBUTE2
, PLN_ATTRIBUTE3 PLN_ATTRIBUTE3
, PLN_ATTRIBUTE4 PLN_ATTRIBUTE4
, PLN_ATTRIBUTE5 PLN_ATTRIBUTE5
, PLN_ATTRIBUTE6 PLN_ATTRIBUTE6
, PLN_ATTRIBUTE7 PLN_ATTRIBUTE7
, PLN_ATTRIBUTE8 PLN_ATTRIBUTE8
, PLN_ATTRIBUTE9 PLN_ATTRIBUTE9
, PLN_ATTRIBUTE10 PLN_ATTRIBUTE10
, PLN_ATTRIBUTE11 PLN_ATTRIBUTE11
, PLN_ATTRIBUTE12 PLN_ATTRIBUTE12
, PLN_ATTRIBUTE13 PLN_ATTRIBUTE13
, PLN_ATTRIBUTE14 PLN_ATTRIBUTE14
, PLN_ATTRIBUTE15 PLN_ATTRIBUTE15
, PLN_ATTRIBUTE16 PLN_ATTRIBUTE16
, PLN_ATTRIBUTE17 PLN_ATTRIBUTE17
, PLN_ATTRIBUTE18 PLN_ATTRIBUTE18
, PLN_ATTRIBUTE19 PLN_ATTRIBUTE19
, PLN_ATTRIBUTE20 PLN_ATTRIBUTE20
, PLN_ATTRIBUTE21 PLN_ATTRIBUTE21
, PLN_ATTRIBUTE22 PLN_ATTRIBUTE22
, PLN_ATTRIBUTE23 PLN_ATTRIBUTE23
, PLN_ATTRIBUTE24 PLN_ATTRIBUTE24
, PLN_ATTRIBUTE25 PLN_ATTRIBUTE25
, PLN_ATTRIBUTE26 PLN_ATTRIBUTE26
, PLN_ATTRIBUTE27 PLN_ATTRIBUTE27
, PLN_ATTRIBUTE28 PLN_ATTRIBUTE28
, PLN_ATTRIBUTE29 PLN_ATTRIBUTE29
, PLN_ATTRIBUTE30 PLN_ATTRIBUTE30
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, VRFY_FMLY_MMBR_CD VRFY_FMLY_MMBR_CD
, VRFY_FMLY_MMBR_RL VRFY_FMLY_MMBR_RL
, ALWS_TMPRY_ID_CRD_FLAG ALWS_TMPRY_ID_CRD_FLAG
, NIP_DFLT_FLAG NIP_DFLT_FLAG
, FRFS_DISTR_MTHD_CD FRFS_DISTR_MTHD_CD
, FRFS_DISTR_MTHD_RL FRFS_DISTR_MTHD_RL
, FRFS_CNTR_DET_CD FRFS_CNTR_DET_CD
, FRFS_DISTR_DET_CD FRFS_DISTR_DET_CD
, COST_ALLOC_KEYFLEX_1_ID COST_ALLOC_KEYFLEX_1_ID
, COST_ALLOC_KEYFLEX_2_ID COST_ALLOC_KEYFLEX_2_ID
, POST_TO_GL_FLAG POST_TO_GL_FLAG
, FRFS_VAL_DET_CD FRFS_VAL_DET_CD
, FRFS_MX_CRYFWD_VAL FRFS_MX_CRYFWD_VAL
, FRFS_PORTION_DET_CD FRFS_PORTION_DET_CD
, BNDRY_PERD_CD BNDRY_PERD_CD
, SHORT_CODE SHORT_CODE
, SHORT_NAME SHORT_NAME
, FUNCTION_CODE FUNCTION_CODE
, MAPPING_TABLE_NAME MAPPING_TABLE_NAME
, MAPPING_TABLE_PK_ID MAPPING_TABLE_PK_ID
, PL_YR_NOT_APPLCBL_FLAG PL_YR_NOT_APPLCBL_FLAG
, LEGISLATION_CODE LEGISLATION_CODE
, LEGISLATION_SUBGROUP LEGISLATION_SUBGROUP
, GROUP_PL_ID GROUP_PL_ID
, USE_CSD_RSD_PRCCNG_CD USE_CSD_RSD_PRCCNG_CD
, SUSP_IF_CTFN_NOT_PRVD_FLAG SUSP_IF_CTFN_NOT_PRVD_FLAG
, CTFN_DETERMINE_CD CTFN_DETERMINE_CD
, SUSP_IF_DPNT_SSN_NT_PRV_CD SUSP_IF_DPNT_SSN_NT_PRV_CD
, SUSP_IF_DPNT_DOB_NT_PRV_CD SUSP_IF_DPNT_DOB_NT_PRV_CD
, SUSP_IF_DPNT_ADR_NT_PRV_CD SUSP_IF_DPNT_ADR_NT_PRV_CD
, SUSP_IF_CTFN_NOT_DPNT_FLAG SUSP_IF_CTFN_NOT_DPNT_FLAG
, SUSP_IF_BNF_SSN_NT_PRV_CD SUSP_IF_BNF_SSN_NT_PRV_CD
, SUSP_IF_BNF_DOB_NT_PRV_CD SUSP_IF_BNF_DOB_NT_PRV_CD
, SUSP_IF_BNF_ADR_NT_PRV_CD SUSP_IF_BNF_ADR_NT_PRV_CD
, SUSP_IF_CTFN_NOT_BNF_FLAG SUSP_IF_CTFN_NOT_BNF_FLAG
, DPNT_CTFN_DETERMINE_CD DPNT_CTFN_DETERMINE_CD
, BNF_CTFN_DETERMINE_CD BNF_CTFN_DETERMINE_CD
, ALL_INELIG ALL_INELIG
, ZD_EDITION_NAME ZD_EDITION_NAME
, BNF_EXL_PARTICIPANT_FLAG BNF_EXL_PARTICIPANT_FLAG
FROM "BEN"."BEN_PL_F"