VIEW: BEN.BEN_PLIP_F#

Source

View Text - Preformatted

select PLIP_ID PLIP_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, DFLT_FLAG DFLT_FLAG, PLIP_STAT_CD PLIP_STAT_CD, ALWS_UNRSTRCTD_ENRT_FLAG ALWS_UNRSTRCTD_ENRT_FLAG, PGM_ID PGM_ID, PL_ID PL_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, DRVBL_FCTR_APLS_RTS_FLAG DRVBL_FCTR_APLS_RTS_FLAG, DRVBL_FCTR_PRTN_ELIG_FLAG DRVBL_FCTR_PRTN_ELIG_FLAG, ELIG_APLS_FLAG ELIG_APLS_FLAG, PRTN_ELIG_OVRID_ALWD_FLAG PRTN_ELIG_OVRID_ALWD_FLAG, TRK_INELIG_PER_FLAG TRK_INELIG_PER_FLAG, POSTELCN_EDIT_RL POSTELCN_EDIT_RL, CPP_ATTRIBUTE_CATEGORY CPP_ATTRIBUTE_CATEGORY, CPP_ATTRIBUTE1 CPP_ATTRIBUTE1, CPP_ATTRIBUTE2 CPP_ATTRIBUTE2, CPP_ATTRIBUTE3 CPP_ATTRIBUTE3, CPP_ATTRIBUTE4 CPP_ATTRIBUTE4, CPP_ATTRIBUTE5 CPP_ATTRIBUTE5, CPP_ATTRIBUTE6 CPP_ATTRIBUTE6, CPP_ATTRIBUTE7 CPP_ATTRIBUTE7, CPP_ATTRIBUTE8 CPP_ATTRIBUTE8, CPP_ATTRIBUTE9 CPP_ATTRIBUTE9, CPP_ATTRIBUTE10 CPP_ATTRIBUTE10, CPP_ATTRIBUTE11 CPP_ATTRIBUTE11, CPP_ATTRIBUTE12 CPP_ATTRIBUTE12, CPP_ATTRIBUTE13 CPP_ATTRIBUTE13, CPP_ATTRIBUTE14 CPP_ATTRIBUTE14, CPP_ATTRIBUTE15 CPP_ATTRIBUTE15, CPP_ATTRIBUTE16 CPP_ATTRIBUTE16, CPP_ATTRIBUTE17 CPP_ATTRIBUTE17, CPP_ATTRIBUTE18 CPP_ATTRIBUTE18, CPP_ATTRIBUTE19 CPP_ATTRIBUTE19, CPP_ATTRIBUTE20 CPP_ATTRIBUTE20, CPP_ATTRIBUTE21 CPP_ATTRIBUTE21, CPP_ATTRIBUTE22 CPP_ATTRIBUTE22, CPP_ATTRIBUTE23 CPP_ATTRIBUTE23, CPP_ATTRIBUTE24 CPP_ATTRIBUTE24, CPP_ATTRIBUTE25 CPP_ATTRIBUTE25, CPP_ATTRIBUTE26 CPP_ATTRIBUTE26, CPP_ATTRIBUTE27 CPP_ATTRIBUTE27, CPP_ATTRIBUTE28 CPP_ATTRIBUTE28, CPP_ATTRIBUTE29 CPP_ATTRIBUTE29, CPP_ATTRIBUTE30 CPP_ATTRIBUTE30, 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, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, DFLT_ENRT_CD DFLT_ENRT_CD, ORDR_NUM ORDR_NUM, IVR_IDENT IVR_IDENT, ENRT_CD ENRT_CD, ENRT_MTHD_CD ENRT_MTHD_CD, DFLT_ENRT_DET_RL DFLT_ENRT_DET_RL, AUTO_ENRT_MTHD_RL AUTO_ENRT_MTHD_RL, ENRT_RL ENRT_RL, ENRT_CVG_STRT_DT_CD ENRT_CVG_STRT_DT_CD, ENRT_CVG_STRT_DT_RL ENRT_CVG_STRT_DT_RL, ENRT_CVG_END_DT_CD ENRT_CVG_END_DT_CD, ENRT_CVG_END_DT_RL ENRT_CVG_END_DT_RL, RT_STRT_DT_CD RT_STRT_DT_CD, RT_STRT_DT_RL RT_STRT_DT_RL, RT_END_DT_CD RT_END_DT_CD, RT_END_DT_RL RT_END_DT_RL, URL_REF_NAME URL_REF_NAME, CVG_INCR_R_DECR_ONLY_CD CVG_INCR_R_DECR_ONLY_CD, DFLT_TO_ASN_PNDG_CTFN_CD DFLT_TO_ASN_PNDG_CTFN_CD, DFLT_TO_ASN_PNDG_CTFN_RL DFLT_TO_ASN_PNDG_CTFN_RL, MN_CVG_AMT MN_CVG_AMT, MN_CVG_RL MN_CVG_RL, MX_CVG_ALWD_AMT MX_CVG_ALWD_AMT, MX_CVG_INCR_ALWD_AMT MX_CVG_INCR_ALWD_AMT, MX_CVG_INCR_WCF_ALWD_AMT MX_CVG_INCR_WCF_ALWD_AMT, MX_CVG_MLT_INCR_NUM MX_CVG_MLT_INCR_NUM, MX_CVG_MLT_INCR_WCF_NUM MX_CVG_MLT_INCR_WCF_NUM, MX_CVG_RL MX_CVG_RL, MX_CVG_WCFN_AMT MX_CVG_WCFN_AMT, MX_CVG_WCFN_MLT_NUM MX_CVG_WCFN_MLT_NUM, NO_MN_CVG_AMT_APLS_FLAG NO_MN_CVG_AMT_APLS_FLAG, NO_MN_CVG_INCR_APLS_FLAG NO_MN_CVG_INCR_APLS_FLAG, NO_MX_CVG_AMT_APLS_FLAG NO_MX_CVG_AMT_APLS_FLAG, NO_MX_CVG_INCR_APLS_FLAG NO_MX_CVG_INCR_APLS_FLAG, UNSSPND_ENRT_CD UNSSPND_ENRT_CD, PRORT_PRTL_YR_CVG_RSTRN_CD PRORT_PRTL_YR_CVG_RSTRN_CD, PRORT_PRTL_YR_CVG_RSTRN_RL PRORT_PRTL_YR_CVG_RSTRN_RL, CMBN_PLIP_ID CMBN_PLIP_ID, BNFT_OR_OPTION_RSTRCTN_CD BNFT_OR_OPTION_RSTRCTN_CD, VRFY_FMLY_MMBR_CD VRFY_FMLY_MMBR_CD, VRFY_FMLY_MMBR_RL VRFY_FMLY_MMBR_RL, PER_CVRD_CD PER_CVRD_CD, SHORT_CODE SHORT_CODE, SHORT_NAME SHORT_NAME, LEGISLATION_CODE LEGISLATION_CODE, LEGISLATION_SUBGROUP LEGISLATION_SUBGROUP, USE_CSD_RSD_PRCCNG_CD USE_CSD_RSD_PRCCNG_CD, ALL_INELIG ALL_INELIG from "BEN"."BEN_PLIP_F"

View Text - HTML Formatted

SELECT PLIP_ID PLIP_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, DFLT_FLAG DFLT_FLAG
, PLIP_STAT_CD PLIP_STAT_CD
, ALWS_UNRSTRCTD_ENRT_FLAG ALWS_UNRSTRCTD_ENRT_FLAG
, PGM_ID PGM_ID
, PL_ID PL_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, DRVBL_FCTR_APLS_RTS_FLAG DRVBL_FCTR_APLS_RTS_FLAG
, DRVBL_FCTR_PRTN_ELIG_FLAG DRVBL_FCTR_PRTN_ELIG_FLAG
, ELIG_APLS_FLAG ELIG_APLS_FLAG
, PRTN_ELIG_OVRID_ALWD_FLAG PRTN_ELIG_OVRID_ALWD_FLAG
, TRK_INELIG_PER_FLAG TRK_INELIG_PER_FLAG
, POSTELCN_EDIT_RL POSTELCN_EDIT_RL
, CPP_ATTRIBUTE_CATEGORY CPP_ATTRIBUTE_CATEGORY
, CPP_ATTRIBUTE1 CPP_ATTRIBUTE1
, CPP_ATTRIBUTE2 CPP_ATTRIBUTE2
, CPP_ATTRIBUTE3 CPP_ATTRIBUTE3
, CPP_ATTRIBUTE4 CPP_ATTRIBUTE4
, CPP_ATTRIBUTE5 CPP_ATTRIBUTE5
, CPP_ATTRIBUTE6 CPP_ATTRIBUTE6
, CPP_ATTRIBUTE7 CPP_ATTRIBUTE7
, CPP_ATTRIBUTE8 CPP_ATTRIBUTE8
, CPP_ATTRIBUTE9 CPP_ATTRIBUTE9
, CPP_ATTRIBUTE10 CPP_ATTRIBUTE10
, CPP_ATTRIBUTE11 CPP_ATTRIBUTE11
, CPP_ATTRIBUTE12 CPP_ATTRIBUTE12
, CPP_ATTRIBUTE13 CPP_ATTRIBUTE13
, CPP_ATTRIBUTE14 CPP_ATTRIBUTE14
, CPP_ATTRIBUTE15 CPP_ATTRIBUTE15
, CPP_ATTRIBUTE16 CPP_ATTRIBUTE16
, CPP_ATTRIBUTE17 CPP_ATTRIBUTE17
, CPP_ATTRIBUTE18 CPP_ATTRIBUTE18
, CPP_ATTRIBUTE19 CPP_ATTRIBUTE19
, CPP_ATTRIBUTE20 CPP_ATTRIBUTE20
, CPP_ATTRIBUTE21 CPP_ATTRIBUTE21
, CPP_ATTRIBUTE22 CPP_ATTRIBUTE22
, CPP_ATTRIBUTE23 CPP_ATTRIBUTE23
, CPP_ATTRIBUTE24 CPP_ATTRIBUTE24
, CPP_ATTRIBUTE25 CPP_ATTRIBUTE25
, CPP_ATTRIBUTE26 CPP_ATTRIBUTE26
, CPP_ATTRIBUTE27 CPP_ATTRIBUTE27
, CPP_ATTRIBUTE28 CPP_ATTRIBUTE28
, CPP_ATTRIBUTE29 CPP_ATTRIBUTE29
, CPP_ATTRIBUTE30 CPP_ATTRIBUTE30
, 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
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, DFLT_ENRT_CD DFLT_ENRT_CD
, ORDR_NUM ORDR_NUM
, IVR_IDENT IVR_IDENT
, ENRT_CD ENRT_CD
, ENRT_MTHD_CD ENRT_MTHD_CD
, DFLT_ENRT_DET_RL DFLT_ENRT_DET_RL
, AUTO_ENRT_MTHD_RL AUTO_ENRT_MTHD_RL
, ENRT_RL ENRT_RL
, ENRT_CVG_STRT_DT_CD ENRT_CVG_STRT_DT_CD
, ENRT_CVG_STRT_DT_RL ENRT_CVG_STRT_DT_RL
, ENRT_CVG_END_DT_CD ENRT_CVG_END_DT_CD
, ENRT_CVG_END_DT_RL ENRT_CVG_END_DT_RL
, RT_STRT_DT_CD RT_STRT_DT_CD
, RT_STRT_DT_RL RT_STRT_DT_RL
, RT_END_DT_CD RT_END_DT_CD
, RT_END_DT_RL RT_END_DT_RL
, URL_REF_NAME URL_REF_NAME
, CVG_INCR_R_DECR_ONLY_CD CVG_INCR_R_DECR_ONLY_CD
, DFLT_TO_ASN_PNDG_CTFN_CD DFLT_TO_ASN_PNDG_CTFN_CD
, DFLT_TO_ASN_PNDG_CTFN_RL DFLT_TO_ASN_PNDG_CTFN_RL
, MN_CVG_AMT MN_CVG_AMT
, MN_CVG_RL MN_CVG_RL
, MX_CVG_ALWD_AMT MX_CVG_ALWD_AMT
, MX_CVG_INCR_ALWD_AMT MX_CVG_INCR_ALWD_AMT
, MX_CVG_INCR_WCF_ALWD_AMT MX_CVG_INCR_WCF_ALWD_AMT
, MX_CVG_MLT_INCR_NUM MX_CVG_MLT_INCR_NUM
, MX_CVG_MLT_INCR_WCF_NUM MX_CVG_MLT_INCR_WCF_NUM
, MX_CVG_RL MX_CVG_RL
, MX_CVG_WCFN_AMT MX_CVG_WCFN_AMT
, MX_CVG_WCFN_MLT_NUM MX_CVG_WCFN_MLT_NUM
, NO_MN_CVG_AMT_APLS_FLAG NO_MN_CVG_AMT_APLS_FLAG
, NO_MN_CVG_INCR_APLS_FLAG NO_MN_CVG_INCR_APLS_FLAG
, NO_MX_CVG_AMT_APLS_FLAG NO_MX_CVG_AMT_APLS_FLAG
, NO_MX_CVG_INCR_APLS_FLAG NO_MX_CVG_INCR_APLS_FLAG
, UNSSPND_ENRT_CD UNSSPND_ENRT_CD
, PRORT_PRTL_YR_CVG_RSTRN_CD PRORT_PRTL_YR_CVG_RSTRN_CD
, PRORT_PRTL_YR_CVG_RSTRN_RL PRORT_PRTL_YR_CVG_RSTRN_RL
, CMBN_PLIP_ID CMBN_PLIP_ID
, BNFT_OR_OPTION_RSTRCTN_CD BNFT_OR_OPTION_RSTRCTN_CD
, VRFY_FMLY_MMBR_CD VRFY_FMLY_MMBR_CD
, VRFY_FMLY_MMBR_RL VRFY_FMLY_MMBR_RL
, PER_CVRD_CD PER_CVRD_CD
, SHORT_CODE SHORT_CODE
, SHORT_NAME SHORT_NAME
, LEGISLATION_CODE LEGISLATION_CODE
, LEGISLATION_SUBGROUP LEGISLATION_SUBGROUP
, USE_CSD_RSD_PRCCNG_CD USE_CSD_RSD_PRCCNG_CD
, ALL_INELIG ALL_INELIG
FROM "BEN"."BEN_PLIP_F"