VIEW: BEN.BEN_CWB_PERSON_RATES#

Source

View Text - Preformatted

select PERSON_RATE_ID PERSON_RATE_ID, GROUP_PER_IN_LER_ID GROUP_PER_IN_LER_ID, PL_ID PL_ID, OIPL_ID OIPL_ID, GROUP_PL_ID GROUP_PL_ID, GROUP_OIPL_ID GROUP_OIPL_ID, LF_EVT_OCRD_DT LF_EVT_OCRD_DT, PERSON_ID PERSON_ID, ASSIGNMENT_ID ASSIGNMENT_ID, ELIG_FLAG ELIG_FLAG, WS_VAL WS_VAL, WS_MN_VAL WS_MN_VAL, WS_MX_VAL WS_MX_VAL, WS_INCR_VAL WS_INCR_VAL, ELIG_SAL_VAL ELIG_SAL_VAL, STAT_SAL_VAL STAT_SAL_VAL, OTH_COMP_VAL OTH_COMP_VAL, TOT_COMP_VAL TOT_COMP_VAL, MISC1_VAL MISC1_VAL, MISC2_VAL MISC2_VAL, MISC3_VAL MISC3_VAL, REC_VAL REC_VAL, REC_MN_VAL REC_MN_VAL, REC_MX_VAL REC_MX_VAL, REC_INCR_VAL REC_INCR_VAL, WS_VAL_LAST_UPD_DATE WS_VAL_LAST_UPD_DATE, WS_VAL_LAST_UPD_BY WS_VAL_LAST_UPD_BY, PAY_PROPOSAL_ID PAY_PROPOSAL_ID, ELEMENT_ENTRY_VALUE_ID ELEMENT_ENTRY_VALUE_ID, INELIG_RSN_CD INELIG_RSN_CD, ELIG_OVRID_DT ELIG_OVRID_DT, ELIG_OVRID_PERSON_ID ELIG_OVRID_PERSON_ID, COPY_DIST_BDGT_VAL COPY_DIST_BDGT_VAL, COPY_WS_BDGT_VAL COPY_WS_BDGT_VAL, COPY_RSRV_VAL COPY_RSRV_VAL, COPY_DIST_BDGT_MN_VAL COPY_DIST_BDGT_MN_VAL, COPY_DIST_BDGT_MX_VAL COPY_DIST_BDGT_MX_VAL, COPY_DIST_BDGT_INCR_VAL COPY_DIST_BDGT_INCR_VAL, COPY_WS_BDGT_MN_VAL COPY_WS_BDGT_MN_VAL, COPY_WS_BDGT_MX_VAL COPY_WS_BDGT_MX_VAL, COPY_WS_BDGT_INCR_VAL COPY_WS_BDGT_INCR_VAL, COPY_RSRV_MN_VAL COPY_RSRV_MN_VAL, COPY_RSRV_MX_VAL COPY_RSRV_MX_VAL, COPY_RSRV_INCR_VAL COPY_RSRV_INCR_VAL, COPY_DIST_BDGT_ISS_VAL COPY_DIST_BDGT_ISS_VAL, COPY_WS_BDGT_ISS_VAL COPY_WS_BDGT_ISS_VAL, COPY_DIST_BDGT_ISS_DATE COPY_DIST_BDGT_ISS_DATE, COPY_WS_BDGT_ISS_DATE COPY_WS_BDGT_ISS_DATE, COMP_POSTING_DATE COMP_POSTING_DATE, WS_RT_START_DATE WS_RT_START_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, 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, CURRENCY CURRENCY from "BEN"."BEN_CWB_PERSON_RATES"

View Text - HTML Formatted

SELECT PERSON_RATE_ID PERSON_RATE_ID
, GROUP_PER_IN_LER_ID GROUP_PER_IN_LER_ID
, PL_ID PL_ID
, OIPL_ID OIPL_ID
, GROUP_PL_ID GROUP_PL_ID
, GROUP_OIPL_ID GROUP_OIPL_ID
, LF_EVT_OCRD_DT LF_EVT_OCRD_DT
, PERSON_ID PERSON_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, ELIG_FLAG ELIG_FLAG
, WS_VAL WS_VAL
, WS_MN_VAL WS_MN_VAL
, WS_MX_VAL WS_MX_VAL
, WS_INCR_VAL WS_INCR_VAL
, ELIG_SAL_VAL ELIG_SAL_VAL
, STAT_SAL_VAL STAT_SAL_VAL
, OTH_COMP_VAL OTH_COMP_VAL
, TOT_COMP_VAL TOT_COMP_VAL
, MISC1_VAL MISC1_VAL
, MISC2_VAL MISC2_VAL
, MISC3_VAL MISC3_VAL
, REC_VAL REC_VAL
, REC_MN_VAL REC_MN_VAL
, REC_MX_VAL REC_MX_VAL
, REC_INCR_VAL REC_INCR_VAL
, WS_VAL_LAST_UPD_DATE WS_VAL_LAST_UPD_DATE
, WS_VAL_LAST_UPD_BY WS_VAL_LAST_UPD_BY
, PAY_PROPOSAL_ID PAY_PROPOSAL_ID
, ELEMENT_ENTRY_VALUE_ID ELEMENT_ENTRY_VALUE_ID
, INELIG_RSN_CD INELIG_RSN_CD
, ELIG_OVRID_DT ELIG_OVRID_DT
, ELIG_OVRID_PERSON_ID ELIG_OVRID_PERSON_ID
, COPY_DIST_BDGT_VAL COPY_DIST_BDGT_VAL
, COPY_WS_BDGT_VAL COPY_WS_BDGT_VAL
, COPY_RSRV_VAL COPY_RSRV_VAL
, COPY_DIST_BDGT_MN_VAL COPY_DIST_BDGT_MN_VAL
, COPY_DIST_BDGT_MX_VAL COPY_DIST_BDGT_MX_VAL
, COPY_DIST_BDGT_INCR_VAL COPY_DIST_BDGT_INCR_VAL
, COPY_WS_BDGT_MN_VAL COPY_WS_BDGT_MN_VAL
, COPY_WS_BDGT_MX_VAL COPY_WS_BDGT_MX_VAL
, COPY_WS_BDGT_INCR_VAL COPY_WS_BDGT_INCR_VAL
, COPY_RSRV_MN_VAL COPY_RSRV_MN_VAL
, COPY_RSRV_MX_VAL COPY_RSRV_MX_VAL
, COPY_RSRV_INCR_VAL COPY_RSRV_INCR_VAL
, COPY_DIST_BDGT_ISS_VAL COPY_DIST_BDGT_ISS_VAL
, COPY_WS_BDGT_ISS_VAL COPY_WS_BDGT_ISS_VAL
, COPY_DIST_BDGT_ISS_DATE COPY_DIST_BDGT_ISS_DATE
, COPY_WS_BDGT_ISS_DATE COPY_WS_BDGT_ISS_DATE
, COMP_POSTING_DATE COMP_POSTING_DATE
, WS_RT_START_DATE WS_RT_START_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, 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
, CURRENCY CURRENCY
FROM "BEN"."BEN_CWB_PERSON_RATES"