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_COMP_DETAILS#

Source

View Text - Preformatted


select GROUP_PER_IN_LER_ID GROUP_PER_IN_LER_ID, GROUP_PL_ID GROUP_PL_ID, LF_EVT_OCRD_DT LF_EVT_OCRD_DT, PERSON_ID PERSON_ID, PLOIPLID PLOIPLID, OIP1PLID OIP1PLID, OIP2PLID OIP2PLID, OIP3PLID OIP3PLID, OIP4PLID OIP4PLID, OIPL1ID OIPL1ID, OIPL2ID OIPL2ID, OIPL3ID OIPL3ID, OIPL4ID OIPL4ID, OPT1OIPLORDRNUM OPT1OIPLORDRNUM, OPT2OIPLORDRNUM OPT2OIPLORDRNUM, OPT3OIPLORDRNUM OPT3OIPLORDRNUM, OPT4OIPLORDRNUM OPT4OIPLORDRNUM, OIP1GRPOIPLID OIP1GRPOIPLID, OIP2GRPOIPLID OIP2GRPOIPLID, OIP3GRPOIPLID OIP3GRPOIPLID, OIP4GRPOIPLID OIP4GRPOIPLID, ELIG_FLAG ELIG_FLAG, OPT1_ELIG_FLAG OPT1_ELIG_FLAG, OPT2_ELIG_FLAG OPT2_ELIG_FLAG, OPT3_ELIG_FLAG OPT3_ELIG_FLAG, OPT4_ELIG_FLAG OPT4_ELIG_FLAG, PLANUFACTOR PLANUFACTOR, GRPUFACTOR GRPUFACTOR, PER_IN_LER_STAT_CD PER_IN_LER_STAT_CD, PROCD_DT PROCD_DT, BG_ID BG_ID, ORG_ID ORG_ID, LOC_ID LOC_ID, GRADE_RANGE GRADE_RANGE, GRADE_MID_POINT GRADE_MID_POINT, PRIOR_FTE_SALARY PRIOR_FTE_SALARY, NEW_FTE_SALARY NEW_FTE_SALARY, NEW_QUARTILE NEW_QUARTILE, NEW_QUINTILE NEW_QUINTILE, NEW_DECILE NEW_DECILE, NEW_PERCENTILE NEW_PERCENTILE, NEW_COMPARATIO NEW_COMPARATIO, PROPOSED_PERFORMANCE_RATING PROPOSED_PERFORMANCE_RATING, JOB_ID JOB_ID, JOB_FLEX1 JOB_FLEX1, JOB_FLEX2 JOB_FLEX2, JOB_FLEX3 JOB_FLEX3, JOB_FLEX4 JOB_FLEX4, JOB_FLEX5 JOB_FLEX5, PROPOSED_JOB_ID PROPOSED_JOB_ID, POSITION_ID POSITION_ID, PROPOSED_POSITION_ID PROPOSED_POSITION_ID, GRADE_ID GRADE_ID, PROPOSED_GRADE_ID PROPOSED_GRADE_ID, PEOPLE_GROUP PEOPLE_GROUP, PROPOSED_GROUP PROPOSED_GROUP, ASSIGNMENT_STATUS_ID ASSIGNMENT_STATUS_ID, CORP_BASE_SALARY CORP_BASE_SALARY, PL_NAME PL_NAME, OPT1_NAME OPT1_NAME, OPT2_NAME OPT2_NAME, OPT3_NAME OPT3_NAME, OPT4_NAME OPT4_NAME, PL_UOM PL_UOM, OPT1_UOM OPT1_UOM, OPT2_UOM OPT2_UOM, OPT3_UOM OPT3_UOM, OPT4_UOM OPT4_UOM, PL_CURRENCY PL_CURRENCY, OPT1_CURRENCY OPT1_CURRENCY, OPT2_CURRENCY OPT2_CURRENCY, OPT3_CURRENCY OPT3_CURRENCY, OPT4_CURRENCY OPT4_CURRENCY, PL_ELIG_SAL_VAL PL_ELIG_SAL_VAL, PL_WS_VAL PL_WS_VAL, PL_PCT_OF_ELIG_SAL PL_PCT_OF_ELIG_SAL, PL_WS_MIN_VAL PL_WS_MIN_VAL, PL_WS_MAX_VAL PL_WS_MAX_VAL, PL_WS_INCR_VAL PL_WS_INCR_VAL, PL_NEW_SALARY PL_NEW_SALARY, PL_WS_VAL_LIMIT PL_WS_VAL_LIMIT, PL_REC_VAL PL_REC_VAL, PL_REC_MN_VAL PL_REC_MN_VAL, PL_REC_MX_VAL PL_REC_MX_VAL, PL_REC_VAL_LIMIT PL_REC_VAL_LIMIT, PL_REC_VAL_PCT PL_REC_VAL_PCT, PL_REC_VAL_PCT_LIMIT PL_REC_VAL_PCT_LIMIT, PL_MISC1_VAL PL_MISC1_VAL, PL_MISC2_VAL PL_MISC2_VAL, PL_MISC3_VAL PL_MISC3_VAL, PL_STAT_SAL_VAL PL_STAT_SAL_VAL, PL_TOT_COMP_VAL PL_TOT_COMP_VAL, PL_OTH_COMP_VAL PL_OTH_COMP_VAL, PL_XCHG_RATE PL_XCHG_RATE, PL_CORP_ELIG_SAL_VAL PL_CORP_ELIG_SAL_VAL, PL_CORP_WS_VAL PL_CORP_WS_VAL, PL_CORP_NEW_SALARY PL_CORP_NEW_SALARY, PL_SALARY_COMP PL_SALARY_COMP, OPT1_ELIG_SAL_VAL OPT1_ELIG_SAL_VAL, OPT1_WS_VAL OPT1_WS_VAL, OPT1_PCT_OF_ELIG_SAL OPT1_PCT_OF_ELIG_SAL, OPT1_WS_MIN_VAL OPT1_WS_MIN_VAL, OPT1_WS_MAX_VAL OPT1_WS_MAX_VAL, OPT1_WS_INCR_VAL OPT1_WS_INCR_VAL, OPT1_NEW_SALARY OPT1_NEW_SALARY, OPT1_WS_VAL_LIMIT OPT1_WS_VAL_LIMIT, OPT1_REC_VAL OPT1_REC_VAL, OPT1_REC_MN_VAL OPT1_REC_MN_VAL, OPT1_REC_MX_VAL OPT1_REC_MX_VAL, OPT1_REC_VAL_LIMIT OPT1_REC_VAL_LIMIT, OPT1_REC_VAL_PCT OPT1_REC_VAL_PCT, OPT1_REC_VAL_PCT_LIMIT OPT1_REC_VAL_PCT_LIMIT, OPT1_MISC1_VAL OPT1_MISC1_VAL, OPT1_MISC2_VAL OPT1_MISC2_VAL, OPT1_MISC3_VAL OPT1_MISC3_VAL, OPT1_STAT_SAL_VAL OPT1_STAT_SAL_VAL, OPT1_TOT_COMP_VAL OPT1_TOT_COMP_VAL, OPT1_OTH_COMP_VAL OPT1_OTH_COMP_VAL, OPT1_XCHG_RATE OPT1_XCHG_RATE, OPT1_CORP_ELIG_SAL_VAL OPT1_CORP_ELIG_SAL_VAL, OPT1_CORP_WS_VAL OPT1_CORP_WS_VAL, OPT1_CORP_NEW_SALARY OPT1_CORP_NEW_SALARY, OPT1_SALARY_COMP OPT1_SALARY_COMP, OPT2_ELIG_SAL_VAL OPT2_ELIG_SAL_VAL, OPT2_WS_VAL OPT2_WS_VAL, OPT2_PCT_OF_ELIG_SAL OPT2_PCT_OF_ELIG_SAL, OPT2_WS_MIN_VAL OPT2_WS_MIN_VAL, OPT2_WS_MAX_VAL OPT2_WS_MAX_VAL, OPT2_WS_INCR_VAL OPT2_WS_INCR_VAL, OPT2_NEW_SALARY OPT2_NEW_SALARY, OPT2_WS_VAL_LIMIT OPT2_WS_VAL_LIMIT, OPT2_REC_VAL OPT2_REC_VAL, OPT2_REC_MN_VAL OPT2_REC_MN_VAL, OPT2_REC_MX_VAL OPT2_REC_MX_VAL, OPT2_REC_VAL_LIMIT OPT2_REC_VAL_LIMIT, OPT2_REC_VAL_PCT OPT2_REC_VAL_PCT, OPT2_REC_VAL_PCT_LIMIT OPT2_REC_VAL_PCT_LIMIT, OPT2_MISC1_VAL OPT2_MISC1_VAL, OPT2_MISC2_VAL OPT2_MISC2_VAL, OPT2_MISC3_VAL OPT2_MISC3_VAL, OPT2_STAT_SAL_VAL OPT2_STAT_SAL_VAL, OPT2_TOT_COMP_VAL OPT2_TOT_COMP_VAL, OPT2_OTH_COMP_VAL OPT2_OTH_COMP_VAL, OPT2_XCHG_RATE OPT2_XCHG_RATE, OPT2_CORP_ELIG_SAL_VAL OPT2_CORP_ELIG_SAL_VAL, OPT2_CORP_WS_VAL OPT2_CORP_WS_VAL, OPT2_CORP_NEW_SALARY OPT2_CORP_NEW_SALARY, OPT2_SALARY_COMP OPT2_SALARY_COMP, OPT3_ELIG_SAL_VAL OPT3_ELIG_SAL_VAL, OPT3_WS_VAL OPT3_WS_VAL, OPT3_PCT_OF_ELIG_SAL OPT3_PCT_OF_ELIG_SAL, OPT3_WS_MIN_VAL OPT3_WS_MIN_VAL, OPT3_WS_MAX_VAL OPT3_WS_MAX_VAL, OPT3_WS_INCR_VAL OPT3_WS_INCR_VAL, OPT3_NEW_SALARY OPT3_NEW_SALARY, OPT3_WS_VAL_LIMIT OPT3_WS_VAL_LIMIT, OPT3_REC_VAL OPT3_REC_VAL, OPT3_REC_MN_VAL OPT3_REC_MN_VAL, OPT3_REC_MX_VAL OPT3_REC_MX_VAL, OPT3_REC_VAL_LIMIT OPT3_REC_VAL_LIMIT, OPT3_REC_VAL_PCT OPT3_REC_VAL_PCT, OPT3_REC_VAL_PCT_LIMIT OPT3_REC_VAL_PCT_LIMIT, OPT3_MISC1_VAL OPT3_MISC1_VAL, OPT3_MISC2_VAL OPT3_MISC2_VAL, OPT3_MISC3_VAL OPT3_MISC3_VAL, OPT3_STAT_SAL_VAL OPT3_STAT_SAL_VAL, OPT3_TOT_COMP_VAL OPT3_TOT_COMP_VAL, OPT3_OTH_COMP_VAL OPT3_OTH_COMP_VAL, OPT3_XCHG_RATE OPT3_XCHG_RATE, OPT3_CORP_ELIG_SAL_VAL OPT3_CORP_ELIG_SAL_VAL, OPT3_CORP_WS_VAL OPT3_CORP_WS_VAL, OPT3_CORP_NEW_SALARY OPT3_CORP_NEW_SALARY, OPT3_SALARY_COMP OPT3_SALARY_COMP, OPT4_ELIG_SAL_VAL OPT4_ELIG_SAL_VAL, OPT4_WS_VAL OPT4_WS_VAL, OPT4_PCT_OF_ELIG_SAL OPT4_PCT_OF_ELIG_SAL, OPT4_WS_MIN_VAL OPT4_WS_MIN_VAL, OPT4_WS_MAX_VAL OPT4_WS_MAX_VAL, OPT4_WS_INCR_VAL OPT4_WS_INCR_VAL, OPT4_NEW_SALARY OPT4_NEW_SALARY, OPT4_WS_VAL_LIMIT OPT4_WS_VAL_LIMIT, OPT4_REC_VAL OPT4_REC_VAL, OPT4_REC_MN_VAL OPT4_REC_MN_VAL, OPT4_REC_MX_VAL OPT4_REC_MX_VAL, OPT4_REC_VAL_LIMIT OPT4_REC_VAL_LIMIT, OPT4_REC_VAL_PCT OPT4_REC_VAL_PCT, OPT4_REC_VAL_PCT_LIMIT OPT4_REC_VAL_PCT_LIMIT, OPT4_MISC1_VAL OPT4_MISC1_VAL, OPT4_MISC2_VAL OPT4_MISC2_VAL, OPT4_MISC3_VAL OPT4_MISC3_VAL, OPT4_STAT_SAL_VAL OPT4_STAT_SAL_VAL, OPT4_TOT_COMP_VAL OPT4_TOT_COMP_VAL, OPT4_OTH_COMP_VAL OPT4_OTH_COMP_VAL, OPT4_XCHG_RATE OPT4_XCHG_RATE, OPT4_CORP_ELIG_SAL_VAL OPT4_CORP_ELIG_SAL_VAL, OPT4_CORP_WS_VAL OPT4_CORP_WS_VAL, OPT4_CORP_NEW_SALARY OPT4_CORP_NEW_SALARY, OPT4_SALARY_COMP OPT4_SALARY_COMP, CHANGE_REASON CHANGE_REASON, LEVEL1MGR LEVEL1MGR, LEVEL2MGR LEVEL2MGR, LEVEL3MGR LEVEL3MGR, LEVEL4MGR LEVEL4MGR, LEVEL5MGR LEVEL5MGR, LEVEL6MGR LEVEL6MGR, LEVEL7MGR LEVEL7MGR, LEVEL8MGR LEVEL8MGR, SAL_STAT_CURRENCY SAL_STAT_CURRENCY, WRK_MGR_NAME WRK_MGR_NAME, CORP_CURRENCY CORP_CURRENCY, CONC_REQUEST_ID CONC_REQUEST_ID, START_DATE START_DATE, END_DATE END_DATE from "BEN"."BEN_CWB_COMP_DETAILS"

View Text - HTML Formatted

SELECT GROUP_PER_IN_LER_ID GROUP_PER_IN_LER_ID
, GROUP_PL_ID GROUP_PL_ID
, LF_EVT_OCRD_DT LF_EVT_OCRD_DT
, PERSON_ID PERSON_ID
, PLOIPLID PLOIPLID
, OIP1PLID OIP1PLID
, OIP2PLID OIP2PLID
, OIP3PLID OIP3PLID
, OIP4PLID OIP4PLID
, OIPL1ID OIPL1ID
, OIPL2ID OIPL2ID
, OIPL3ID OIPL3ID
, OIPL4ID OIPL4ID
, OPT1OIPLORDRNUM OPT1OIPLORDRNUM
, OPT2OIPLORDRNUM OPT2OIPLORDRNUM
, OPT3OIPLORDRNUM OPT3OIPLORDRNUM
, OPT4OIPLORDRNUM OPT4OIPLORDRNUM
, OIP1GRPOIPLID OIP1GRPOIPLID
, OIP2GRPOIPLID OIP2GRPOIPLID
, OIP3GRPOIPLID OIP3GRPOIPLID
, OIP4GRPOIPLID OIP4GRPOIPLID
, ELIG_FLAG ELIG_FLAG
, OPT1_ELIG_FLAG OPT1_ELIG_FLAG
, OPT2_ELIG_FLAG OPT2_ELIG_FLAG
, OPT3_ELIG_FLAG OPT3_ELIG_FLAG
, OPT4_ELIG_FLAG OPT4_ELIG_FLAG
, PLANUFACTOR PLANUFACTOR
, GRPUFACTOR GRPUFACTOR
, PER_IN_LER_STAT_CD PER_IN_LER_STAT_CD
, PROCD_DT PROCD_DT
, BG_ID BG_ID
, ORG_ID ORG_ID
, LOC_ID LOC_ID
, GRADE_RANGE GRADE_RANGE
, GRADE_MID_POINT GRADE_MID_POINT
, PRIOR_FTE_SALARY PRIOR_FTE_SALARY
, NEW_FTE_SALARY NEW_FTE_SALARY
, NEW_QUARTILE NEW_QUARTILE
, NEW_QUINTILE NEW_QUINTILE
, NEW_DECILE NEW_DECILE
, NEW_PERCENTILE NEW_PERCENTILE
, NEW_COMPARATIO NEW_COMPARATIO
, PROPOSED_PERFORMANCE_RATING PROPOSED_PERFORMANCE_RATING
, JOB_ID JOB_ID
, JOB_FLEX1 JOB_FLEX1
, JOB_FLEX2 JOB_FLEX2
, JOB_FLEX3 JOB_FLEX3
, JOB_FLEX4 JOB_FLEX4
, JOB_FLEX5 JOB_FLEX5
, PROPOSED_JOB_ID PROPOSED_JOB_ID
, POSITION_ID POSITION_ID
, PROPOSED_POSITION_ID PROPOSED_POSITION_ID
, GRADE_ID GRADE_ID
, PROPOSED_GRADE_ID PROPOSED_GRADE_ID
, PEOPLE_GROUP PEOPLE_GROUP
, PROPOSED_GROUP PROPOSED_GROUP
, ASSIGNMENT_STATUS_ID ASSIGNMENT_STATUS_ID
, CORP_BASE_SALARY CORP_BASE_SALARY
, PL_NAME PL_NAME
, OPT1_NAME OPT1_NAME
, OPT2_NAME OPT2_NAME
, OPT3_NAME OPT3_NAME
, OPT4_NAME OPT4_NAME
, PL_UOM PL_UOM
, OPT1_UOM OPT1_UOM
, OPT2_UOM OPT2_UOM
, OPT3_UOM OPT3_UOM
, OPT4_UOM OPT4_UOM
, PL_CURRENCY PL_CURRENCY
, OPT1_CURRENCY OPT1_CURRENCY
, OPT2_CURRENCY OPT2_CURRENCY
, OPT3_CURRENCY OPT3_CURRENCY
, OPT4_CURRENCY OPT4_CURRENCY
, PL_ELIG_SAL_VAL PL_ELIG_SAL_VAL
, PL_WS_VAL PL_WS_VAL
, PL_PCT_OF_ELIG_SAL PL_PCT_OF_ELIG_SAL
, PL_WS_MIN_VAL PL_WS_MIN_VAL
, PL_WS_MAX_VAL PL_WS_MAX_VAL
, PL_WS_INCR_VAL PL_WS_INCR_VAL
, PL_NEW_SALARY PL_NEW_SALARY
, PL_WS_VAL_LIMIT PL_WS_VAL_LIMIT
, PL_REC_VAL PL_REC_VAL
, PL_REC_MN_VAL PL_REC_MN_VAL
, PL_REC_MX_VAL PL_REC_MX_VAL
, PL_REC_VAL_LIMIT PL_REC_VAL_LIMIT
, PL_REC_VAL_PCT PL_REC_VAL_PCT
, PL_REC_VAL_PCT_LIMIT PL_REC_VAL_PCT_LIMIT
, PL_MISC1_VAL PL_MISC1_VAL
, PL_MISC2_VAL PL_MISC2_VAL
, PL_MISC3_VAL PL_MISC3_VAL
, PL_STAT_SAL_VAL PL_STAT_SAL_VAL
, PL_TOT_COMP_VAL PL_TOT_COMP_VAL
, PL_OTH_COMP_VAL PL_OTH_COMP_VAL
, PL_XCHG_RATE PL_XCHG_RATE
, PL_CORP_ELIG_SAL_VAL PL_CORP_ELIG_SAL_VAL
, PL_CORP_WS_VAL PL_CORP_WS_VAL
, PL_CORP_NEW_SALARY PL_CORP_NEW_SALARY
, PL_SALARY_COMP PL_SALARY_COMP
, OPT1_ELIG_SAL_VAL OPT1_ELIG_SAL_VAL
, OPT1_WS_VAL OPT1_WS_VAL
, OPT1_PCT_OF_ELIG_SAL OPT1_PCT_OF_ELIG_SAL
, OPT1_WS_MIN_VAL OPT1_WS_MIN_VAL
, OPT1_WS_MAX_VAL OPT1_WS_MAX_VAL
, OPT1_WS_INCR_VAL OPT1_WS_INCR_VAL
, OPT1_NEW_SALARY OPT1_NEW_SALARY
, OPT1_WS_VAL_LIMIT OPT1_WS_VAL_LIMIT
, OPT1_REC_VAL OPT1_REC_VAL
, OPT1_REC_MN_VAL OPT1_REC_MN_VAL
, OPT1_REC_MX_VAL OPT1_REC_MX_VAL
, OPT1_REC_VAL_LIMIT OPT1_REC_VAL_LIMIT
, OPT1_REC_VAL_PCT OPT1_REC_VAL_PCT
, OPT1_REC_VAL_PCT_LIMIT OPT1_REC_VAL_PCT_LIMIT
, OPT1_MISC1_VAL OPT1_MISC1_VAL
, OPT1_MISC2_VAL OPT1_MISC2_VAL
, OPT1_MISC3_VAL OPT1_MISC3_VAL
, OPT1_STAT_SAL_VAL OPT1_STAT_SAL_VAL
, OPT1_TOT_COMP_VAL OPT1_TOT_COMP_VAL
, OPT1_OTH_COMP_VAL OPT1_OTH_COMP_VAL
, OPT1_XCHG_RATE OPT1_XCHG_RATE
, OPT1_CORP_ELIG_SAL_VAL OPT1_CORP_ELIG_SAL_VAL
, OPT1_CORP_WS_VAL OPT1_CORP_WS_VAL
, OPT1_CORP_NEW_SALARY OPT1_CORP_NEW_SALARY
, OPT1_SALARY_COMP OPT1_SALARY_COMP
, OPT2_ELIG_SAL_VAL OPT2_ELIG_SAL_VAL
, OPT2_WS_VAL OPT2_WS_VAL
, OPT2_PCT_OF_ELIG_SAL OPT2_PCT_OF_ELIG_SAL
, OPT2_WS_MIN_VAL OPT2_WS_MIN_VAL
, OPT2_WS_MAX_VAL OPT2_WS_MAX_VAL
, OPT2_WS_INCR_VAL OPT2_WS_INCR_VAL
, OPT2_NEW_SALARY OPT2_NEW_SALARY
, OPT2_WS_VAL_LIMIT OPT2_WS_VAL_LIMIT
, OPT2_REC_VAL OPT2_REC_VAL
, OPT2_REC_MN_VAL OPT2_REC_MN_VAL
, OPT2_REC_MX_VAL OPT2_REC_MX_VAL
, OPT2_REC_VAL_LIMIT OPT2_REC_VAL_LIMIT
, OPT2_REC_VAL_PCT OPT2_REC_VAL_PCT
, OPT2_REC_VAL_PCT_LIMIT OPT2_REC_VAL_PCT_LIMIT
, OPT2_MISC1_VAL OPT2_MISC1_VAL
, OPT2_MISC2_VAL OPT2_MISC2_VAL
, OPT2_MISC3_VAL OPT2_MISC3_VAL
, OPT2_STAT_SAL_VAL OPT2_STAT_SAL_VAL
, OPT2_TOT_COMP_VAL OPT2_TOT_COMP_VAL
, OPT2_OTH_COMP_VAL OPT2_OTH_COMP_VAL
, OPT2_XCHG_RATE OPT2_XCHG_RATE
, OPT2_CORP_ELIG_SAL_VAL OPT2_CORP_ELIG_SAL_VAL
, OPT2_CORP_WS_VAL OPT2_CORP_WS_VAL
, OPT2_CORP_NEW_SALARY OPT2_CORP_NEW_SALARY
, OPT2_SALARY_COMP OPT2_SALARY_COMP
, OPT3_ELIG_SAL_VAL OPT3_ELIG_SAL_VAL
, OPT3_WS_VAL OPT3_WS_VAL
, OPT3_PCT_OF_ELIG_SAL OPT3_PCT_OF_ELIG_SAL
, OPT3_WS_MIN_VAL OPT3_WS_MIN_VAL
, OPT3_WS_MAX_VAL OPT3_WS_MAX_VAL
, OPT3_WS_INCR_VAL OPT3_WS_INCR_VAL
, OPT3_NEW_SALARY OPT3_NEW_SALARY
, OPT3_WS_VAL_LIMIT OPT3_WS_VAL_LIMIT
, OPT3_REC_VAL OPT3_REC_VAL
, OPT3_REC_MN_VAL OPT3_REC_MN_VAL
, OPT3_REC_MX_VAL OPT3_REC_MX_VAL
, OPT3_REC_VAL_LIMIT OPT3_REC_VAL_LIMIT
, OPT3_REC_VAL_PCT OPT3_REC_VAL_PCT
, OPT3_REC_VAL_PCT_LIMIT OPT3_REC_VAL_PCT_LIMIT
, OPT3_MISC1_VAL OPT3_MISC1_VAL
, OPT3_MISC2_VAL OPT3_MISC2_VAL
, OPT3_MISC3_VAL OPT3_MISC3_VAL
, OPT3_STAT_SAL_VAL OPT3_STAT_SAL_VAL
, OPT3_TOT_COMP_VAL OPT3_TOT_COMP_VAL
, OPT3_OTH_COMP_VAL OPT3_OTH_COMP_VAL
, OPT3_XCHG_RATE OPT3_XCHG_RATE
, OPT3_CORP_ELIG_SAL_VAL OPT3_CORP_ELIG_SAL_VAL
, OPT3_CORP_WS_VAL OPT3_CORP_WS_VAL
, OPT3_CORP_NEW_SALARY OPT3_CORP_NEW_SALARY
, OPT3_SALARY_COMP OPT3_SALARY_COMP
, OPT4_ELIG_SAL_VAL OPT4_ELIG_SAL_VAL
, OPT4_WS_VAL OPT4_WS_VAL
, OPT4_PCT_OF_ELIG_SAL OPT4_PCT_OF_ELIG_SAL
, OPT4_WS_MIN_VAL OPT4_WS_MIN_VAL
, OPT4_WS_MAX_VAL OPT4_WS_MAX_VAL
, OPT4_WS_INCR_VAL OPT4_WS_INCR_VAL
, OPT4_NEW_SALARY OPT4_NEW_SALARY
, OPT4_WS_VAL_LIMIT OPT4_WS_VAL_LIMIT
, OPT4_REC_VAL OPT4_REC_VAL
, OPT4_REC_MN_VAL OPT4_REC_MN_VAL
, OPT4_REC_MX_VAL OPT4_REC_MX_VAL
, OPT4_REC_VAL_LIMIT OPT4_REC_VAL_LIMIT
, OPT4_REC_VAL_PCT OPT4_REC_VAL_PCT
, OPT4_REC_VAL_PCT_LIMIT OPT4_REC_VAL_PCT_LIMIT
, OPT4_MISC1_VAL OPT4_MISC1_VAL
, OPT4_MISC2_VAL OPT4_MISC2_VAL
, OPT4_MISC3_VAL OPT4_MISC3_VAL
, OPT4_STAT_SAL_VAL OPT4_STAT_SAL_VAL
, OPT4_TOT_COMP_VAL OPT4_TOT_COMP_VAL
, OPT4_OTH_COMP_VAL OPT4_OTH_COMP_VAL
, OPT4_XCHG_RATE OPT4_XCHG_RATE
, OPT4_CORP_ELIG_SAL_VAL OPT4_CORP_ELIG_SAL_VAL
, OPT4_CORP_WS_VAL OPT4_CORP_WS_VAL
, OPT4_CORP_NEW_SALARY OPT4_CORP_NEW_SALARY
, OPT4_SALARY_COMP OPT4_SALARY_COMP
, CHANGE_REASON CHANGE_REASON
, LEVEL1MGR LEVEL1MGR
, LEVEL2MGR LEVEL2MGR
, LEVEL3MGR LEVEL3MGR
, LEVEL4MGR LEVEL4MGR
, LEVEL5MGR LEVEL5MGR
, LEVEL6MGR LEVEL6MGR
, LEVEL7MGR LEVEL7MGR
, LEVEL8MGR LEVEL8MGR
, SAL_STAT_CURRENCY SAL_STAT_CURRENCY
, WRK_MGR_NAME WRK_MGR_NAME
, CORP_CURRENCY CORP_CURRENCY
, CONC_REQUEST_ID CONC_REQUEST_ID
, START_DATE START_DATE
, END_DATE END_DATE
FROM "BEN"."BEN_CWB_COMP_DETAILS"