VIEW: BEN.BEN_LER_BNFT_RSTRN_F#

Source

View Text - Preformatted

select LER_BNFT_RSTRN_ID LER_BNFT_RSTRN_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, 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, LER_ID LER_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, LBR_ATTRIBUTE_CATEGORY LBR_ATTRIBUTE_CATEGORY, LBR_ATTRIBUTE1 LBR_ATTRIBUTE1, LBR_ATTRIBUTE2 LBR_ATTRIBUTE2, LBR_ATTRIBUTE3 LBR_ATTRIBUTE3, LBR_ATTRIBUTE4 LBR_ATTRIBUTE4, LBR_ATTRIBUTE5 LBR_ATTRIBUTE5, LBR_ATTRIBUTE6 LBR_ATTRIBUTE6, LBR_ATTRIBUTE7 LBR_ATTRIBUTE7, LBR_ATTRIBUTE8 LBR_ATTRIBUTE8, LBR_ATTRIBUTE9 LBR_ATTRIBUTE9, LBR_ATTRIBUTE10 LBR_ATTRIBUTE10, LBR_ATTRIBUTE11 LBR_ATTRIBUTE11, LBR_ATTRIBUTE12 LBR_ATTRIBUTE12, LBR_ATTRIBUTE13 LBR_ATTRIBUTE13, LBR_ATTRIBUTE14 LBR_ATTRIBUTE14, LBR_ATTRIBUTE15 LBR_ATTRIBUTE15, LBR_ATTRIBUTE16 LBR_ATTRIBUTE16, LBR_ATTRIBUTE17 LBR_ATTRIBUTE17, LBR_ATTRIBUTE18 LBR_ATTRIBUTE18, LBR_ATTRIBUTE19 LBR_ATTRIBUTE19, LBR_ATTRIBUTE20 LBR_ATTRIBUTE20, LBR_ATTRIBUTE21 LBR_ATTRIBUTE21, LBR_ATTRIBUTE22 LBR_ATTRIBUTE22, LBR_ATTRIBUTE23 LBR_ATTRIBUTE23, LBR_ATTRIBUTE24 LBR_ATTRIBUTE24, LBR_ATTRIBUTE25 LBR_ATTRIBUTE25, LBR_ATTRIBUTE26 LBR_ATTRIBUTE26, LBR_ATTRIBUTE27 LBR_ATTRIBUTE27, LBR_ATTRIBUTE28 LBR_ATTRIBUTE28, LBR_ATTRIBUTE29 LBR_ATTRIBUTE29, LBR_ATTRIBUTE30 LBR_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_TO_ASN_PNDG_CTFN_CD DFLT_TO_ASN_PNDG_CTFN_CD, 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_INCR_ALWD_AMT MX_CVG_INCR_ALWD_AMT, MX_CVG_ALWD_AMT MX_CVG_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, MN_CVG_AMT MN_CVG_AMT, MN_CVG_RL MN_CVG_RL, CVG_INCR_R_DECR_ONLY_CD CVG_INCR_R_DECR_ONLY_CD, UNSSPND_ENRT_CD UNSSPND_ENRT_CD, PL_ID PL_ID, PLIP_ID PLIP_ID, SUSP_IF_CTFN_NOT_PRVD_FLAG SUSP_IF_CTFN_NOT_PRVD_FLAG, CTFN_DETERMINE_CD CTFN_DETERMINE_CD from "BEN"."BEN_LER_BNFT_RSTRN_F"

View Text - HTML Formatted

SELECT LER_BNFT_RSTRN_ID LER_BNFT_RSTRN_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, 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
, LER_ID LER_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, LBR_ATTRIBUTE_CATEGORY LBR_ATTRIBUTE_CATEGORY
, LBR_ATTRIBUTE1 LBR_ATTRIBUTE1
, LBR_ATTRIBUTE2 LBR_ATTRIBUTE2
, LBR_ATTRIBUTE3 LBR_ATTRIBUTE3
, LBR_ATTRIBUTE4 LBR_ATTRIBUTE4
, LBR_ATTRIBUTE5 LBR_ATTRIBUTE5
, LBR_ATTRIBUTE6 LBR_ATTRIBUTE6
, LBR_ATTRIBUTE7 LBR_ATTRIBUTE7
, LBR_ATTRIBUTE8 LBR_ATTRIBUTE8
, LBR_ATTRIBUTE9 LBR_ATTRIBUTE9
, LBR_ATTRIBUTE10 LBR_ATTRIBUTE10
, LBR_ATTRIBUTE11 LBR_ATTRIBUTE11
, LBR_ATTRIBUTE12 LBR_ATTRIBUTE12
, LBR_ATTRIBUTE13 LBR_ATTRIBUTE13
, LBR_ATTRIBUTE14 LBR_ATTRIBUTE14
, LBR_ATTRIBUTE15 LBR_ATTRIBUTE15
, LBR_ATTRIBUTE16 LBR_ATTRIBUTE16
, LBR_ATTRIBUTE17 LBR_ATTRIBUTE17
, LBR_ATTRIBUTE18 LBR_ATTRIBUTE18
, LBR_ATTRIBUTE19 LBR_ATTRIBUTE19
, LBR_ATTRIBUTE20 LBR_ATTRIBUTE20
, LBR_ATTRIBUTE21 LBR_ATTRIBUTE21
, LBR_ATTRIBUTE22 LBR_ATTRIBUTE22
, LBR_ATTRIBUTE23 LBR_ATTRIBUTE23
, LBR_ATTRIBUTE24 LBR_ATTRIBUTE24
, LBR_ATTRIBUTE25 LBR_ATTRIBUTE25
, LBR_ATTRIBUTE26 LBR_ATTRIBUTE26
, LBR_ATTRIBUTE27 LBR_ATTRIBUTE27
, LBR_ATTRIBUTE28 LBR_ATTRIBUTE28
, LBR_ATTRIBUTE29 LBR_ATTRIBUTE29
, LBR_ATTRIBUTE30 LBR_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_TO_ASN_PNDG_CTFN_CD DFLT_TO_ASN_PNDG_CTFN_CD
, 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_INCR_ALWD_AMT MX_CVG_INCR_ALWD_AMT
, MX_CVG_ALWD_AMT MX_CVG_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
, MN_CVG_AMT MN_CVG_AMT
, MN_CVG_RL MN_CVG_RL
, CVG_INCR_R_DECR_ONLY_CD CVG_INCR_R_DECR_ONLY_CD
, UNSSPND_ENRT_CD UNSSPND_ENRT_CD
, PL_ID PL_ID
, PLIP_ID PLIP_ID
, SUSP_IF_CTFN_NOT_PRVD_FLAG SUSP_IF_CTFN_NOT_PRVD_FLAG
, CTFN_DETERMINE_CD CTFN_DETERMINE_CD
FROM "BEN"."BEN_LER_BNFT_RSTRN_F"