VIEW: BEN.BEN_ENRT_RT#

Source

View Text - Preformatted

select ENRT_RT_ID ENRT_RT_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ACTY_TYP_CD ACTY_TYP_CD, TX_TYP_CD TX_TYP_CD, CTFN_RQD_FLAG CTFN_RQD_FLAG, DFLT_FLAG DFLT_FLAG, DFLT_PNDG_CTFN_FLAG DFLT_PNDG_CTFN_FLAG, DSPLY_ON_ENRT_FLAG DSPLY_ON_ENRT_FLAG, USE_TO_CALC_NET_FLX_CR_FLAG USE_TO_CALC_NET_FLX_CR_FLAG, ENTR_VAL_AT_ENRT_FLAG ENTR_VAL_AT_ENRT_FLAG, ASN_ON_ENRT_FLAG ASN_ON_ENRT_FLAG, RL_CRS_ONLY_FLAG RL_CRS_ONLY_FLAG, ACTY_BASE_RT_ID ACTY_BASE_RT_ID, ENTR_ANN_VAL_FLAG ENTR_ANN_VAL_FLAG, RT_STRT_DT RT_STRT_DT, RT_STRT_DT_CD RT_STRT_DT_CD, RT_STRT_DT_RL RT_STRT_DT_RL, RT_TYP_CD RT_TYP_CD, ELIG_PER_ELCTBL_CHC_ID ELIG_PER_ELCTBL_CHC_ID, SPCL_RT_ENRT_RT_ID SPCL_RT_ENRT_RT_ID, ENRT_BNFT_ID ENRT_BNFT_ID, CVG_AMT_CALC_MTHD_ID CVG_AMT_CALC_MTHD_ID, ACTL_PREM_ID ACTL_PREM_ID, COMP_LVL_FCTR_ID COMP_LVL_FCTR_ID, PTD_COMP_LVL_FCTR_ID PTD_COMP_LVL_FCTR_ID, CLM_COMP_LVL_FCTR_ID CLM_COMP_LVL_FCTR_ID, ECR_ATTRIBUTE_CATEGORY ECR_ATTRIBUTE_CATEGORY, ECR_ATTRIBUTE1 ECR_ATTRIBUTE1, ECR_ATTRIBUTE2 ECR_ATTRIBUTE2, ECR_ATTRIBUTE3 ECR_ATTRIBUTE3, ECR_ATTRIBUTE4 ECR_ATTRIBUTE4, ECR_ATTRIBUTE5 ECR_ATTRIBUTE5, ECR_ATTRIBUTE6 ECR_ATTRIBUTE6, ECR_ATTRIBUTE7 ECR_ATTRIBUTE7, ECR_ATTRIBUTE8 ECR_ATTRIBUTE8, ECR_ATTRIBUTE9 ECR_ATTRIBUTE9, ECR_ATTRIBUTE10 ECR_ATTRIBUTE10, ECR_ATTRIBUTE11 ECR_ATTRIBUTE11, ECR_ATTRIBUTE12 ECR_ATTRIBUTE12, ECR_ATTRIBUTE13 ECR_ATTRIBUTE13, ECR_ATTRIBUTE14 ECR_ATTRIBUTE14, ECR_ATTRIBUTE15 ECR_ATTRIBUTE15, ECR_ATTRIBUTE16 ECR_ATTRIBUTE16, ECR_ATTRIBUTE17 ECR_ATTRIBUTE17, ECR_ATTRIBUTE18 ECR_ATTRIBUTE18, ECR_ATTRIBUTE19 ECR_ATTRIBUTE19, ECR_ATTRIBUTE20 ECR_ATTRIBUTE20, ECR_ATTRIBUTE21 ECR_ATTRIBUTE21, ECR_ATTRIBUTE22 ECR_ATTRIBUTE22, ECR_ATTRIBUTE23 ECR_ATTRIBUTE23, ECR_ATTRIBUTE24 ECR_ATTRIBUTE24, ECR_ATTRIBUTE25 ECR_ATTRIBUTE25, ECR_ATTRIBUTE26 ECR_ATTRIBUTE26, ECR_ATTRIBUTE27 ECR_ATTRIBUTE27, ECR_ATTRIBUTE28 ECR_ATTRIBUTE28, ECR_ATTRIBUTE29 ECR_ATTRIBUTE29, ECR_ATTRIBUTE30 ECR_ATTRIBUTE30, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_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, DFLT_VAL DFLT_VAL, DECR_BNFT_PRVDR_POOL_ID DECR_BNFT_PRVDR_POOL_ID, ANN_VAL ANN_VAL, ANN_MN_ELCN_VAL ANN_MN_ELCN_VAL, ANN_MX_ELCN_VAL ANN_MX_ELCN_VAL, VAL VAL, PRTT_RT_VAL_ID PRTT_RT_VAL_ID, NNMNTRY_UOM NNMNTRY_UOM, MX_ELCN_VAL MX_ELCN_VAL, MN_ELCN_VAL MN_ELCN_VAL, INCRMT_ELCN_VAL INCRMT_ELCN_VAL, CMCD_ACTY_REF_PERD_CD CMCD_ACTY_REF_PERD_CD, CMCD_MN_ELCN_VAL CMCD_MN_ELCN_VAL, CMCD_MX_ELCN_VAL CMCD_MX_ELCN_VAL, CMCD_VAL CMCD_VAL, CMCD_DFLT_VAL CMCD_DFLT_VAL, RT_USG_CD RT_USG_CD, ANN_DFLT_VAL ANN_DFLT_VAL, BNFT_RT_TYP_CD BNFT_RT_TYP_CD, RT_MLT_CD RT_MLT_CD, DSPLY_MN_ELCN_VAL DSPLY_MN_ELCN_VAL, DSPLY_MX_ELCN_VAL DSPLY_MX_ELCN_VAL, ISS_VAL ISS_VAL, VAL_LAST_UPD_DATE VAL_LAST_UPD_DATE, VAL_LAST_UPD_PERSON_ID VAL_LAST_UPD_PERSON_ID, PP_IN_YR_USED_NUM PP_IN_YR_USED_NUM, ORDR_NUM ORDR_NUM from "BEN"."BEN_ENRT_RT"

View Text - HTML Formatted

SELECT ENRT_RT_ID ENRT_RT_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ACTY_TYP_CD ACTY_TYP_CD
, TX_TYP_CD TX_TYP_CD
, CTFN_RQD_FLAG CTFN_RQD_FLAG
, DFLT_FLAG DFLT_FLAG
, DFLT_PNDG_CTFN_FLAG DFLT_PNDG_CTFN_FLAG
, DSPLY_ON_ENRT_FLAG DSPLY_ON_ENRT_FLAG
, USE_TO_CALC_NET_FLX_CR_FLAG USE_TO_CALC_NET_FLX_CR_FLAG
, ENTR_VAL_AT_ENRT_FLAG ENTR_VAL_AT_ENRT_FLAG
, ASN_ON_ENRT_FLAG ASN_ON_ENRT_FLAG
, RL_CRS_ONLY_FLAG RL_CRS_ONLY_FLAG
, ACTY_BASE_RT_ID ACTY_BASE_RT_ID
, ENTR_ANN_VAL_FLAG ENTR_ANN_VAL_FLAG
, RT_STRT_DT RT_STRT_DT
, RT_STRT_DT_CD RT_STRT_DT_CD
, RT_STRT_DT_RL RT_STRT_DT_RL
, RT_TYP_CD RT_TYP_CD
, ELIG_PER_ELCTBL_CHC_ID ELIG_PER_ELCTBL_CHC_ID
, SPCL_RT_ENRT_RT_ID SPCL_RT_ENRT_RT_ID
, ENRT_BNFT_ID ENRT_BNFT_ID
, CVG_AMT_CALC_MTHD_ID CVG_AMT_CALC_MTHD_ID
, ACTL_PREM_ID ACTL_PREM_ID
, COMP_LVL_FCTR_ID COMP_LVL_FCTR_ID
, PTD_COMP_LVL_FCTR_ID PTD_COMP_LVL_FCTR_ID
, CLM_COMP_LVL_FCTR_ID CLM_COMP_LVL_FCTR_ID
, ECR_ATTRIBUTE_CATEGORY ECR_ATTRIBUTE_CATEGORY
, ECR_ATTRIBUTE1 ECR_ATTRIBUTE1
, ECR_ATTRIBUTE2 ECR_ATTRIBUTE2
, ECR_ATTRIBUTE3 ECR_ATTRIBUTE3
, ECR_ATTRIBUTE4 ECR_ATTRIBUTE4
, ECR_ATTRIBUTE5 ECR_ATTRIBUTE5
, ECR_ATTRIBUTE6 ECR_ATTRIBUTE6
, ECR_ATTRIBUTE7 ECR_ATTRIBUTE7
, ECR_ATTRIBUTE8 ECR_ATTRIBUTE8
, ECR_ATTRIBUTE9 ECR_ATTRIBUTE9
, ECR_ATTRIBUTE10 ECR_ATTRIBUTE10
, ECR_ATTRIBUTE11 ECR_ATTRIBUTE11
, ECR_ATTRIBUTE12 ECR_ATTRIBUTE12
, ECR_ATTRIBUTE13 ECR_ATTRIBUTE13
, ECR_ATTRIBUTE14 ECR_ATTRIBUTE14
, ECR_ATTRIBUTE15 ECR_ATTRIBUTE15
, ECR_ATTRIBUTE16 ECR_ATTRIBUTE16
, ECR_ATTRIBUTE17 ECR_ATTRIBUTE17
, ECR_ATTRIBUTE18 ECR_ATTRIBUTE18
, ECR_ATTRIBUTE19 ECR_ATTRIBUTE19
, ECR_ATTRIBUTE20 ECR_ATTRIBUTE20
, ECR_ATTRIBUTE21 ECR_ATTRIBUTE21
, ECR_ATTRIBUTE22 ECR_ATTRIBUTE22
, ECR_ATTRIBUTE23 ECR_ATTRIBUTE23
, ECR_ATTRIBUTE24 ECR_ATTRIBUTE24
, ECR_ATTRIBUTE25 ECR_ATTRIBUTE25
, ECR_ATTRIBUTE26 ECR_ATTRIBUTE26
, ECR_ATTRIBUTE27 ECR_ATTRIBUTE27
, ECR_ATTRIBUTE28 ECR_ATTRIBUTE28
, ECR_ATTRIBUTE29 ECR_ATTRIBUTE29
, ECR_ATTRIBUTE30 ECR_ATTRIBUTE30
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_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
, DFLT_VAL DFLT_VAL
, DECR_BNFT_PRVDR_POOL_ID DECR_BNFT_PRVDR_POOL_ID
, ANN_VAL ANN_VAL
, ANN_MN_ELCN_VAL ANN_MN_ELCN_VAL
, ANN_MX_ELCN_VAL ANN_MX_ELCN_VAL
, VAL VAL
, PRTT_RT_VAL_ID PRTT_RT_VAL_ID
, NNMNTRY_UOM NNMNTRY_UOM
, MX_ELCN_VAL MX_ELCN_VAL
, MN_ELCN_VAL MN_ELCN_VAL
, INCRMT_ELCN_VAL INCRMT_ELCN_VAL
, CMCD_ACTY_REF_PERD_CD CMCD_ACTY_REF_PERD_CD
, CMCD_MN_ELCN_VAL CMCD_MN_ELCN_VAL
, CMCD_MX_ELCN_VAL CMCD_MX_ELCN_VAL
, CMCD_VAL CMCD_VAL
, CMCD_DFLT_VAL CMCD_DFLT_VAL
, RT_USG_CD RT_USG_CD
, ANN_DFLT_VAL ANN_DFLT_VAL
, BNFT_RT_TYP_CD BNFT_RT_TYP_CD
, RT_MLT_CD RT_MLT_CD
, DSPLY_MN_ELCN_VAL DSPLY_MN_ELCN_VAL
, DSPLY_MX_ELCN_VAL DSPLY_MX_ELCN_VAL
, ISS_VAL ISS_VAL
, VAL_LAST_UPD_DATE VAL_LAST_UPD_DATE
, VAL_LAST_UPD_PERSON_ID VAL_LAST_UPD_PERSON_ID
, PP_IN_YR_USED_NUM PP_IN_YR_USED_NUM
, ORDR_NUM ORDR_NUM
FROM "BEN"."BEN_ENRT_RT"