VIEW: BEN.BEN_CWB_PERSON_INFO_EFC#

Source

View Text - Preformatted

select GROUP_PER_IN_LER_ID GROUP_PER_IN_LER_ID, EFC_ACTION_ID EFC_ACTION_ID, PERSON_ID PERSON_ID, GRD_MIN_VAL GRD_MIN_VAL, GRD_MAX_VAL GRD_MAX_VAL, GRD_MID_POINT GRD_MID_POINT, BASE_SALARY BASE_SALARY, CURRENCY_CODE CURRENCY_CODE, BASE_SALARY_CURRENCY BASE_SALARY_CURRENCY, PREV_SAL_CURRENCY PREV_SAL_CURRENCY, SALARY_1_YEAR_AGO SALARY_1_YEAR_AGO, SALARY_1_YEAR_AGO_CURRENCY SALARY_1_YEAR_AGO_CURRENCY, SALARY_2_YEAR_AGO SALARY_2_YEAR_AGO, SALARY_2_YEAR_AGO_CURRENCY SALARY_2_YEAR_AGO_CURRENCY, SALARY_3_YEAR_AGO SALARY_3_YEAR_AGO, SALARY_3_YEAR_AGO_CURRENCY SALARY_3_YEAR_AGO_CURRENCY, SALARY_4_YEAR_AGO SALARY_4_YEAR_AGO, SALARY_4_YEAR_AGO_CURRENCY SALARY_4_YEAR_AGO_CURRENCY, SALARY_5_YEAR_AGO SALARY_5_YEAR_AGO, SALARY_5_YEAR_AGO_CURRENCY SALARY_5_YEAR_AGO_CURRENCY, PREV_SAL PREV_SAL, MKT_CURRENCY MKT_CURRENCY, MKT_MIN_SALARY MKT_MIN_SALARY, MKT_MID_SALARY MKT_MID_SALARY, MKT_MAX_SALARY MKT_MAX_SALARY from "BEN"."BEN_CWB_PERSON_INFO_EFC"

View Text - HTML Formatted

SELECT GROUP_PER_IN_LER_ID GROUP_PER_IN_LER_ID
, EFC_ACTION_ID EFC_ACTION_ID
, PERSON_ID PERSON_ID
, GRD_MIN_VAL GRD_MIN_VAL
, GRD_MAX_VAL GRD_MAX_VAL
, GRD_MID_POINT GRD_MID_POINT
, BASE_SALARY BASE_SALARY
, CURRENCY_CODE CURRENCY_CODE
, BASE_SALARY_CURRENCY BASE_SALARY_CURRENCY
, PREV_SAL_CURRENCY PREV_SAL_CURRENCY
, SALARY_1_YEAR_AGO SALARY_1_YEAR_AGO
, SALARY_1_YEAR_AGO_CURRENCY SALARY_1_YEAR_AGO_CURRENCY
, SALARY_2_YEAR_AGO SALARY_2_YEAR_AGO
, SALARY_2_YEAR_AGO_CURRENCY SALARY_2_YEAR_AGO_CURRENCY
, SALARY_3_YEAR_AGO SALARY_3_YEAR_AGO
, SALARY_3_YEAR_AGO_CURRENCY SALARY_3_YEAR_AGO_CURRENCY
, SALARY_4_YEAR_AGO SALARY_4_YEAR_AGO
, SALARY_4_YEAR_AGO_CURRENCY SALARY_4_YEAR_AGO_CURRENCY
, SALARY_5_YEAR_AGO SALARY_5_YEAR_AGO
, SALARY_5_YEAR_AGO_CURRENCY SALARY_5_YEAR_AGO_CURRENCY
, PREV_SAL PREV_SAL
, MKT_CURRENCY MKT_CURRENCY
, MKT_MIN_SALARY MKT_MIN_SALARY
, MKT_MID_SALARY MKT_MID_SALARY
, MKT_MAX_SALARY MKT_MAX_SALARY
FROM "BEN"."BEN_CWB_PERSON_INFO_EFC"