VIEW: BEN.BEN_BNFT_PRVDR_POOL_F#

Source

View Text - Preformatted

select BNFT_PRVDR_POOL_ID BNFT_PRVDR_POOL_ID, EFFECTIVE_START_DATE EFFECTIVE_START_DATE, EFFECTIVE_END_DATE EFFECTIVE_END_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, NAME NAME, PGM_POOL_FLAG PGM_POOL_FLAG, EXCS_ALWYS_FFTD_FLAG EXCS_ALWYS_FFTD_FLAG, USE_FOR_PGM_POOL_FLAG USE_FOR_PGM_POOL_FLAG, NO_MN_DSTRBL_PCT_FLAG NO_MN_DSTRBL_PCT_FLAG, NO_MN_DSTRBL_VAL_FLAG NO_MN_DSTRBL_VAL_FLAG, NO_MX_DSTRBL_PCT_FLAG NO_MX_DSTRBL_PCT_FLAG, NO_MX_DSTRBL_VAL_FLAG NO_MX_DSTRBL_VAL_FLAG, AUTO_ALCT_EXCS_FLAG AUTO_ALCT_EXCS_FLAG, PGM_ID PGM_ID, CMBN_PTIP_ID CMBN_PTIP_ID, CMBN_PTIP_OPT_ID CMBN_PTIP_OPT_ID, PCT_RNDG_RL PCT_RNDG_RL, VAL_RNDG_RL VAL_RNDG_RL, OIPLIP_ID OIPLIP_ID, BPP_ATTRIBUTE_CATEGORY BPP_ATTRIBUTE_CATEGORY, BPP_ATTRIBUTE1 BPP_ATTRIBUTE1, BPP_ATTRIBUTE2 BPP_ATTRIBUTE2, BPP_ATTRIBUTE3 BPP_ATTRIBUTE3, BPP_ATTRIBUTE4 BPP_ATTRIBUTE4, BPP_ATTRIBUTE5 BPP_ATTRIBUTE5, BPP_ATTRIBUTE6 BPP_ATTRIBUTE6, BPP_ATTRIBUTE7 BPP_ATTRIBUTE7, BPP_ATTRIBUTE8 BPP_ATTRIBUTE8, BPP_ATTRIBUTE9 BPP_ATTRIBUTE9, BPP_ATTRIBUTE10 BPP_ATTRIBUTE10, BPP_ATTRIBUTE11 BPP_ATTRIBUTE11, BPP_ATTRIBUTE12 BPP_ATTRIBUTE12, BPP_ATTRIBUTE13 BPP_ATTRIBUTE13, BPP_ATTRIBUTE14 BPP_ATTRIBUTE14, BPP_ATTRIBUTE15 BPP_ATTRIBUTE15, BPP_ATTRIBUTE16 BPP_ATTRIBUTE16, BPP_ATTRIBUTE17 BPP_ATTRIBUTE17, BPP_ATTRIBUTE18 BPP_ATTRIBUTE18, BPP_ATTRIBUTE19 BPP_ATTRIBUTE19, BPP_ATTRIBUTE20 BPP_ATTRIBUTE20, BPP_ATTRIBUTE21 BPP_ATTRIBUTE21, BPP_ATTRIBUTE22 BPP_ATTRIBUTE22, BPP_ATTRIBUTE23 BPP_ATTRIBUTE23, BPP_ATTRIBUTE24 BPP_ATTRIBUTE24, BPP_ATTRIBUTE25 BPP_ATTRIBUTE25, BPP_ATTRIBUTE26 BPP_ATTRIBUTE26, BPP_ATTRIBUTE27 BPP_ATTRIBUTE27, BPP_ATTRIBUTE28 BPP_ATTRIBUTE28, BPP_ATTRIBUTE29 BPP_ATTRIBUTE29, BPP_ATTRIBUTE30 BPP_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, PCT_RNDG_CD PCT_RNDG_CD, VAL_RNDG_CD VAL_RNDG_CD, CMBN_PLIP_ID CMBN_PLIP_ID, PLIP_ID PLIP_ID, PTIP_ID PTIP_ID, DFLT_EXCS_TRTMT_CD DFLT_EXCS_TRTMT_CD, DFLT_EXCS_TRTMT_RL DFLT_EXCS_TRTMT_RL, RLOVR_RSTRCN_CD RLOVR_RSTRCN_CD, MN_DSTRBL_PCT_NUM MN_DSTRBL_PCT_NUM, MN_DSTRBL_VAL MN_DSTRBL_VAL, MX_DSTRBL_PCT_NUM MX_DSTRBL_PCT_NUM, MX_DSTRBL_VAL MX_DSTRBL_VAL, EXCS_TRTMT_CD EXCS_TRTMT_CD, ALWS_NGTV_CRS_FLAG ALWS_NGTV_CRS_FLAG, USES_NET_CRS_MTHD_FLAG USES_NET_CRS_MTHD_FLAG, MX_DFCIT_PCT_POOL_CRS_NUM MX_DFCIT_PCT_POOL_CRS_NUM, MX_DFCIT_PCT_COMP_NUM MX_DFCIT_PCT_COMP_NUM, COMP_LVL_FCTR_ID COMP_LVL_FCTR_ID from "BEN"."BEN_BNFT_PRVDR_POOL_F"

View Text - HTML Formatted

SELECT BNFT_PRVDR_POOL_ID BNFT_PRVDR_POOL_ID
, EFFECTIVE_START_DATE EFFECTIVE_START_DATE
, EFFECTIVE_END_DATE EFFECTIVE_END_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, NAME NAME
, PGM_POOL_FLAG PGM_POOL_FLAG
, EXCS_ALWYS_FFTD_FLAG EXCS_ALWYS_FFTD_FLAG
, USE_FOR_PGM_POOL_FLAG USE_FOR_PGM_POOL_FLAG
, NO_MN_DSTRBL_PCT_FLAG NO_MN_DSTRBL_PCT_FLAG
, NO_MN_DSTRBL_VAL_FLAG NO_MN_DSTRBL_VAL_FLAG
, NO_MX_DSTRBL_PCT_FLAG NO_MX_DSTRBL_PCT_FLAG
, NO_MX_DSTRBL_VAL_FLAG NO_MX_DSTRBL_VAL_FLAG
, AUTO_ALCT_EXCS_FLAG AUTO_ALCT_EXCS_FLAG
, PGM_ID PGM_ID
, CMBN_PTIP_ID CMBN_PTIP_ID
, CMBN_PTIP_OPT_ID CMBN_PTIP_OPT_ID
, PCT_RNDG_RL PCT_RNDG_RL
, VAL_RNDG_RL VAL_RNDG_RL
, OIPLIP_ID OIPLIP_ID
, BPP_ATTRIBUTE_CATEGORY BPP_ATTRIBUTE_CATEGORY
, BPP_ATTRIBUTE1 BPP_ATTRIBUTE1
, BPP_ATTRIBUTE2 BPP_ATTRIBUTE2
, BPP_ATTRIBUTE3 BPP_ATTRIBUTE3
, BPP_ATTRIBUTE4 BPP_ATTRIBUTE4
, BPP_ATTRIBUTE5 BPP_ATTRIBUTE5
, BPP_ATTRIBUTE6 BPP_ATTRIBUTE6
, BPP_ATTRIBUTE7 BPP_ATTRIBUTE7
, BPP_ATTRIBUTE8 BPP_ATTRIBUTE8
, BPP_ATTRIBUTE9 BPP_ATTRIBUTE9
, BPP_ATTRIBUTE10 BPP_ATTRIBUTE10
, BPP_ATTRIBUTE11 BPP_ATTRIBUTE11
, BPP_ATTRIBUTE12 BPP_ATTRIBUTE12
, BPP_ATTRIBUTE13 BPP_ATTRIBUTE13
, BPP_ATTRIBUTE14 BPP_ATTRIBUTE14
, BPP_ATTRIBUTE15 BPP_ATTRIBUTE15
, BPP_ATTRIBUTE16 BPP_ATTRIBUTE16
, BPP_ATTRIBUTE17 BPP_ATTRIBUTE17
, BPP_ATTRIBUTE18 BPP_ATTRIBUTE18
, BPP_ATTRIBUTE19 BPP_ATTRIBUTE19
, BPP_ATTRIBUTE20 BPP_ATTRIBUTE20
, BPP_ATTRIBUTE21 BPP_ATTRIBUTE21
, BPP_ATTRIBUTE22 BPP_ATTRIBUTE22
, BPP_ATTRIBUTE23 BPP_ATTRIBUTE23
, BPP_ATTRIBUTE24 BPP_ATTRIBUTE24
, BPP_ATTRIBUTE25 BPP_ATTRIBUTE25
, BPP_ATTRIBUTE26 BPP_ATTRIBUTE26
, BPP_ATTRIBUTE27 BPP_ATTRIBUTE27
, BPP_ATTRIBUTE28 BPP_ATTRIBUTE28
, BPP_ATTRIBUTE29 BPP_ATTRIBUTE29
, BPP_ATTRIBUTE30 BPP_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
, PCT_RNDG_CD PCT_RNDG_CD
, VAL_RNDG_CD VAL_RNDG_CD
, CMBN_PLIP_ID CMBN_PLIP_ID
, PLIP_ID PLIP_ID
, PTIP_ID PTIP_ID
, DFLT_EXCS_TRTMT_CD DFLT_EXCS_TRTMT_CD
, DFLT_EXCS_TRTMT_RL DFLT_EXCS_TRTMT_RL
, RLOVR_RSTRCN_CD RLOVR_RSTRCN_CD
, MN_DSTRBL_PCT_NUM MN_DSTRBL_PCT_NUM
, MN_DSTRBL_VAL MN_DSTRBL_VAL
, MX_DSTRBL_PCT_NUM MX_DSTRBL_PCT_NUM
, MX_DSTRBL_VAL MX_DSTRBL_VAL
, EXCS_TRTMT_CD EXCS_TRTMT_CD
, ALWS_NGTV_CRS_FLAG ALWS_NGTV_CRS_FLAG
, USES_NET_CRS_MTHD_FLAG USES_NET_CRS_MTHD_FLAG
, MX_DFCIT_PCT_POOL_CRS_NUM MX_DFCIT_PCT_POOL_CRS_NUM
, MX_DFCIT_PCT_COMP_NUM MX_DFCIT_PCT_COMP_NUM
, COMP_LVL_FCTR_ID COMP_LVL_FCTR_ID
FROM "BEN"."BEN_BNFT_PRVDR_POOL_F"