eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: BEN.BEN_CWB_SUMMARY#

Source

View Text - Preformatted


select SUMMARY_ID SUMMARY_ID, GROUP_PER_IN_LER_ID GROUP_PER_IN_LER_ID, GROUP_PL_ID GROUP_PL_ID, GROUP_OIPL_ID GROUP_OIPL_ID, PERSON_ID PERSON_ID, LF_EVT_OCRD_DT LF_EVT_OCRD_DT, STATUS STATUS, ELIG_COUNT_DIRECT ELIG_COUNT_DIRECT, ELIG_COUNT_ALL ELIG_COUNT_ALL, EMP_RECV_COUNT_DIRECT EMP_RECV_COUNT_DIRECT, EMP_RECV_COUNT_ALL EMP_RECV_COUNT_ALL, ELIG_SAL_VAL_DIRECT ELIG_SAL_VAL_DIRECT, ELIG_SAL_VAL_ALL ELIG_SAL_VAL_ALL, WS_VAL_DIRECT WS_VAL_DIRECT, WS_VAL_ALL WS_VAL_ALL, WS_BDGT_VAL_DIRECT WS_BDGT_VAL_DIRECT, WS_BDGT_VAL_ALL WS_BDGT_VAL_ALL, WS_BDGT_ISS_VAL_DIRECT WS_BDGT_ISS_VAL_DIRECT, WS_BDGT_ISS_VAL_ALL WS_BDGT_ISS_VAL_ALL, BDGT_VAL_DIRECT BDGT_VAL_DIRECT, BDGT_ISS_VAL_DIRECT BDGT_ISS_VAL_DIRECT, STAT_SAL_VAL_DIRECT STAT_SAL_VAL_DIRECT, STAT_SAL_VAL_ALL STAT_SAL_VAL_ALL, OTH_COMP_VAL_DIRECT OTH_COMP_VAL_DIRECT, OTH_COMP_VAL_ALL OTH_COMP_VAL_ALL, TOT_COMP_VAL_DIRECT TOT_COMP_VAL_DIRECT, TOT_COMP_VAL_ALL TOT_COMP_VAL_ALL, REC_VAL_DIRECT REC_VAL_DIRECT, REC_VAL_ALL REC_VAL_ALL, REC_MN_VAL_DIRECT REC_MN_VAL_DIRECT, REC_MN_VAL_ALL REC_MN_VAL_ALL, REC_MX_VAL_DIRECT REC_MX_VAL_DIRECT, REC_MX_VAL_ALL REC_MX_VAL_ALL, MISC1_VAL_DIRECT MISC1_VAL_DIRECT, MISC1_VAL_ALL MISC1_VAL_ALL, MISC2_VAL_DIRECT MISC2_VAL_DIRECT, MISC2_VAL_ALL MISC2_VAL_ALL, MISC3_VAL_DIRECT MISC3_VAL_DIRECT, MISC3_VAL_ALL MISC3_VAL_ALL, 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 from "BEN"."BEN_CWB_SUMMARY"

View Text - HTML Formatted

SELECT SUMMARY_ID SUMMARY_ID
, GROUP_PER_IN_LER_ID GROUP_PER_IN_LER_ID
, GROUP_PL_ID GROUP_PL_ID
, GROUP_OIPL_ID GROUP_OIPL_ID
, PERSON_ID PERSON_ID
, LF_EVT_OCRD_DT LF_EVT_OCRD_DT
, STATUS STATUS
, ELIG_COUNT_DIRECT ELIG_COUNT_DIRECT
, ELIG_COUNT_ALL ELIG_COUNT_ALL
, EMP_RECV_COUNT_DIRECT EMP_RECV_COUNT_DIRECT
, EMP_RECV_COUNT_ALL EMP_RECV_COUNT_ALL
, ELIG_SAL_VAL_DIRECT ELIG_SAL_VAL_DIRECT
, ELIG_SAL_VAL_ALL ELIG_SAL_VAL_ALL
, WS_VAL_DIRECT WS_VAL_DIRECT
, WS_VAL_ALL WS_VAL_ALL
, WS_BDGT_VAL_DIRECT WS_BDGT_VAL_DIRECT
, WS_BDGT_VAL_ALL WS_BDGT_VAL_ALL
, WS_BDGT_ISS_VAL_DIRECT WS_BDGT_ISS_VAL_DIRECT
, WS_BDGT_ISS_VAL_ALL WS_BDGT_ISS_VAL_ALL
, BDGT_VAL_DIRECT BDGT_VAL_DIRECT
, BDGT_ISS_VAL_DIRECT BDGT_ISS_VAL_DIRECT
, STAT_SAL_VAL_DIRECT STAT_SAL_VAL_DIRECT
, STAT_SAL_VAL_ALL STAT_SAL_VAL_ALL
, OTH_COMP_VAL_DIRECT OTH_COMP_VAL_DIRECT
, OTH_COMP_VAL_ALL OTH_COMP_VAL_ALL
, TOT_COMP_VAL_DIRECT TOT_COMP_VAL_DIRECT
, TOT_COMP_VAL_ALL TOT_COMP_VAL_ALL
, REC_VAL_DIRECT REC_VAL_DIRECT
, REC_VAL_ALL REC_VAL_ALL
, REC_MN_VAL_DIRECT REC_MN_VAL_DIRECT
, REC_MN_VAL_ALL REC_MN_VAL_ALL
, REC_MX_VAL_DIRECT REC_MX_VAL_DIRECT
, REC_MX_VAL_ALL REC_MX_VAL_ALL
, MISC1_VAL_DIRECT MISC1_VAL_DIRECT
, MISC1_VAL_ALL MISC1_VAL_ALL
, MISC2_VAL_DIRECT MISC2_VAL_DIRECT
, MISC2_VAL_ALL MISC2_VAL_ALL
, MISC3_VAL_DIRECT MISC3_VAL_DIRECT
, MISC3_VAL_ALL MISC3_VAL_ALL
, 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
FROM "BEN"."BEN_CWB_SUMMARY"