VIEW: BEN.BEN_ENRT_BNFT_RBV#

Source

View Text - Preformatted

select ENRT_BNFT_ID ENRT_BNFT_ID, DFLT_FLAG DFLT_FLAG, VAL_HAS_BN_PRORTD_FLAG VAL_HAS_BN_PRORTD_FLAG, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, CTFN_RQD_FLAG CTFN_RQD_FLAG, CRNTLY_ENRLD_FLAG CRNTLY_ENRLD_FLAG, ELIG_PER_ELCTBL_CHC_ID ELIG_PER_ELCTBL_CHC_ID, COMP_LVL_FCTR_ID COMP_LVL_FCTR_ID, ENB_ATTRIBUTE_CATEGORY ENB_ATTRIBUTE_CATEGORY, ENB_ATTRIBUTE1 ENB_ATTRIBUTE1, ENB_ATTRIBUTE2 ENB_ATTRIBUTE2, ENB_ATTRIBUTE3 ENB_ATTRIBUTE3, ENB_ATTRIBUTE4 ENB_ATTRIBUTE4, ENB_ATTRIBUTE5 ENB_ATTRIBUTE5, ENB_ATTRIBUTE6 ENB_ATTRIBUTE6, ENB_ATTRIBUTE7 ENB_ATTRIBUTE7, ENB_ATTRIBUTE8 ENB_ATTRIBUTE8, ENB_ATTRIBUTE9 ENB_ATTRIBUTE9, ENB_ATTRIBUTE10 ENB_ATTRIBUTE10, ENB_ATTRIBUTE11 ENB_ATTRIBUTE11, ENB_ATTRIBUTE12 ENB_ATTRIBUTE12, ENB_ATTRIBUTE13 ENB_ATTRIBUTE13, ENB_ATTRIBUTE14 ENB_ATTRIBUTE14, ENB_ATTRIBUTE15 ENB_ATTRIBUTE15, ENB_ATTRIBUTE16 ENB_ATTRIBUTE16, ENB_ATTRIBUTE17 ENB_ATTRIBUTE17, ENB_ATTRIBUTE18 ENB_ATTRIBUTE18, ENB_ATTRIBUTE19 ENB_ATTRIBUTE19, ENB_ATTRIBUTE20 ENB_ATTRIBUTE20, ENB_ATTRIBUTE21 ENB_ATTRIBUTE21, ENB_ATTRIBUTE22 ENB_ATTRIBUTE22, ENB_ATTRIBUTE23 ENB_ATTRIBUTE23, ENB_ATTRIBUTE24 ENB_ATTRIBUTE24, ENB_ATTRIBUTE25 ENB_ATTRIBUTE25, ENB_ATTRIBUTE26 ENB_ATTRIBUTE26, ENB_ATTRIBUTE27 ENB_ATTRIBUTE27, ENB_ATTRIBUTE28 ENB_ATTRIBUTE28, ENB_ATTRIBUTE29 ENB_ATTRIBUTE29, ENB_ATTRIBUTE30 ENB_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, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, BNDRY_PERD_CD BNDRY_PERD_CD, VAL VAL, NNMNTRY_UOM NNMNTRY_UOM, BNFT_TYP_CD BNFT_TYP_CD, ENTR_VAL_AT_ENRT_FLAG ENTR_VAL_AT_ENRT_FLAG, MN_VAL MN_VAL, MX_VAL MX_VAL, PRTT_ENRT_RSLT_ID PRTT_ENRT_RSLT_ID, INCRMT_VAL INCRMT_VAL, RT_TYP_CD RT_TYP_CD, CVG_MLT_CD CVG_MLT_CD, ORDR_NUM ORDR_NUM, DFLT_VAL DFLT_VAL, MX_WOUT_CTFN_VAL MX_WOUT_CTFN_VAL, MX_WO_CTFN_FLAG MX_WO_CTFN_FLAG, BENEFIT_ACTION_ID BENEFIT_ACTION_ID, PERSON_ACTION_ID PERSON_ACTION_ID from "BEN"."BEN_ENRT_BNFT_RBV"

View Text - HTML Formatted

SELECT ENRT_BNFT_ID ENRT_BNFT_ID
, DFLT_FLAG DFLT_FLAG
, VAL_HAS_BN_PRORTD_FLAG VAL_HAS_BN_PRORTD_FLAG
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, CTFN_RQD_FLAG CTFN_RQD_FLAG
, CRNTLY_ENRLD_FLAG CRNTLY_ENRLD_FLAG
, ELIG_PER_ELCTBL_CHC_ID ELIG_PER_ELCTBL_CHC_ID
, COMP_LVL_FCTR_ID COMP_LVL_FCTR_ID
, ENB_ATTRIBUTE_CATEGORY ENB_ATTRIBUTE_CATEGORY
, ENB_ATTRIBUTE1 ENB_ATTRIBUTE1
, ENB_ATTRIBUTE2 ENB_ATTRIBUTE2
, ENB_ATTRIBUTE3 ENB_ATTRIBUTE3
, ENB_ATTRIBUTE4 ENB_ATTRIBUTE4
, ENB_ATTRIBUTE5 ENB_ATTRIBUTE5
, ENB_ATTRIBUTE6 ENB_ATTRIBUTE6
, ENB_ATTRIBUTE7 ENB_ATTRIBUTE7
, ENB_ATTRIBUTE8 ENB_ATTRIBUTE8
, ENB_ATTRIBUTE9 ENB_ATTRIBUTE9
, ENB_ATTRIBUTE10 ENB_ATTRIBUTE10
, ENB_ATTRIBUTE11 ENB_ATTRIBUTE11
, ENB_ATTRIBUTE12 ENB_ATTRIBUTE12
, ENB_ATTRIBUTE13 ENB_ATTRIBUTE13
, ENB_ATTRIBUTE14 ENB_ATTRIBUTE14
, ENB_ATTRIBUTE15 ENB_ATTRIBUTE15
, ENB_ATTRIBUTE16 ENB_ATTRIBUTE16
, ENB_ATTRIBUTE17 ENB_ATTRIBUTE17
, ENB_ATTRIBUTE18 ENB_ATTRIBUTE18
, ENB_ATTRIBUTE19 ENB_ATTRIBUTE19
, ENB_ATTRIBUTE20 ENB_ATTRIBUTE20
, ENB_ATTRIBUTE21 ENB_ATTRIBUTE21
, ENB_ATTRIBUTE22 ENB_ATTRIBUTE22
, ENB_ATTRIBUTE23 ENB_ATTRIBUTE23
, ENB_ATTRIBUTE24 ENB_ATTRIBUTE24
, ENB_ATTRIBUTE25 ENB_ATTRIBUTE25
, ENB_ATTRIBUTE26 ENB_ATTRIBUTE26
, ENB_ATTRIBUTE27 ENB_ATTRIBUTE27
, ENB_ATTRIBUTE28 ENB_ATTRIBUTE28
, ENB_ATTRIBUTE29 ENB_ATTRIBUTE29
, ENB_ATTRIBUTE30 ENB_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
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, BNDRY_PERD_CD BNDRY_PERD_CD
, VAL VAL
, NNMNTRY_UOM NNMNTRY_UOM
, BNFT_TYP_CD BNFT_TYP_CD
, ENTR_VAL_AT_ENRT_FLAG ENTR_VAL_AT_ENRT_FLAG
, MN_VAL MN_VAL
, MX_VAL MX_VAL
, PRTT_ENRT_RSLT_ID PRTT_ENRT_RSLT_ID
, INCRMT_VAL INCRMT_VAL
, RT_TYP_CD RT_TYP_CD
, CVG_MLT_CD CVG_MLT_CD
, ORDR_NUM ORDR_NUM
, DFLT_VAL DFLT_VAL
, MX_WOUT_CTFN_VAL MX_WOUT_CTFN_VAL
, MX_WO_CTFN_FLAG MX_WO_CTFN_FLAG
, BENEFIT_ACTION_ID BENEFIT_ACTION_ID
, PERSON_ACTION_ID PERSON_ACTION_ID
FROM "BEN"."BEN_ENRT_BNFT_RBV"