VIEW: BEN.BEN_BATCH_RATE_INFO#

Source

View Text - Preformatted

select BATCH_RT_ID BATCH_RT_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, BENEFIT_ACTION_ID BENEFIT_ACTION_ID, ENRT_CVG_STRT_DT ENRT_CVG_STRT_DT, ENRT_CVG_THRU_DT ENRT_CVG_THRU_DT, ACTN_CD ACTN_CD, CLOSE_ACTN_ITM_DT CLOSE_ACTN_ITM_DT, PERSON_ID PERSON_ID, PGM_ID PGM_ID, PL_ID PL_ID, OIPL_ID OIPL_ID, BNFT_RT_TYP_CD BNFT_RT_TYP_CD, DFLT_FLAG DFLT_FLAG, VAL VAL, TX_TYP_CD TX_TYP_CD, ACTY_TYP_CD ACTY_TYP_CD, MN_ELCN_VAL MN_ELCN_VAL, MX_ELCN_VAL MX_ELCN_VAL, INCRMT_ELCN_VAL INCRMT_ELCN_VAL, DFLT_VAL DFLT_VAL, RT_STRT_DT RT_STRT_DT, 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, OLD_VAL OLD_VAL from "BEN"."BEN_BATCH_RATE_INFO"

View Text - HTML Formatted

SELECT BATCH_RT_ID BATCH_RT_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, BENEFIT_ACTION_ID BENEFIT_ACTION_ID
, ENRT_CVG_STRT_DT ENRT_CVG_STRT_DT
, ENRT_CVG_THRU_DT ENRT_CVG_THRU_DT
, ACTN_CD ACTN_CD
, CLOSE_ACTN_ITM_DT CLOSE_ACTN_ITM_DT
, PERSON_ID PERSON_ID
, PGM_ID PGM_ID
, PL_ID PL_ID
, OIPL_ID OIPL_ID
, BNFT_RT_TYP_CD BNFT_RT_TYP_CD
, DFLT_FLAG DFLT_FLAG
, VAL VAL
, TX_TYP_CD TX_TYP_CD
, ACTY_TYP_CD ACTY_TYP_CD
, MN_ELCN_VAL MN_ELCN_VAL
, MX_ELCN_VAL MX_ELCN_VAL
, INCRMT_ELCN_VAL INCRMT_ELCN_VAL
, DFLT_VAL DFLT_VAL
, RT_STRT_DT RT_STRT_DT
, 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
, OLD_VAL OLD_VAL
FROM "BEN"."BEN_BATCH_RATE_INFO"