VIEW: BEN.BEN_CWB_PERSON_INFO#

Source

View Text - Preformatted

select GROUP_PER_IN_LER_ID GROUP_PER_IN_LER_ID, ASSIGNMENT_ID ASSIGNMENT_ID, PERSON_ID PERSON_ID, SUPERVISOR_ID SUPERVISOR_ID, EFFECTIVE_DATE EFFECTIVE_DATE, FULL_NAME FULL_NAME, BRIEF_NAME BRIEF_NAME, CUSTOM_NAME CUSTOM_NAME, SUPERVISOR_FULL_NAME SUPERVISOR_FULL_NAME, SUPERVISOR_BRIEF_NAME SUPERVISOR_BRIEF_NAME, SUPERVISOR_CUSTOM_NAME SUPERVISOR_CUSTOM_NAME, LEGISLATION_CODE LEGISLATION_CODE, YEARS_EMPLOYED YEARS_EMPLOYED, YEARS_IN_JOB YEARS_IN_JOB, YEARS_IN_POSITION YEARS_IN_POSITION, YEARS_IN_GRADE YEARS_IN_GRADE, EMPLOYEE_NUMBER EMPLOYEE_NUMBER, START_DATE START_DATE, ORIGINAL_START_DATE ORIGINAL_START_DATE, ADJUSTED_SVC_DATE ADJUSTED_SVC_DATE, BASE_SALARY BASE_SALARY, BASE_SALARY_CHANGE_DATE BASE_SALARY_CHANGE_DATE, PAYROLL_NAME PAYROLL_NAME, PERFORMANCE_RATING PERFORMANCE_RATING, PERFORMANCE_RATING_TYPE PERFORMANCE_RATING_TYPE, PERFORMANCE_RATING_DATE PERFORMANCE_RATING_DATE, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, ORGANIZATION_ID ORGANIZATION_ID, JOB_ID JOB_ID, GRADE_ID GRADE_ID, POSITION_ID POSITION_ID, PEOPLE_GROUP_ID PEOPLE_GROUP_ID, SOFT_CODING_KEYFLEX_ID SOFT_CODING_KEYFLEX_ID, LOCATION_ID LOCATION_ID, PAY_RATE_ID PAY_RATE_ID, ASSIGNMENT_STATUS_TYPE_ID ASSIGNMENT_STATUS_TYPE_ID, FREQUENCY FREQUENCY, GRADE_ANNULIZATION_FACTOR GRADE_ANNULIZATION_FACTOR, PAY_ANNULIZATION_FACTOR PAY_ANNULIZATION_FACTOR, GRD_MIN_VAL GRD_MIN_VAL, GRD_MAX_VAL GRD_MAX_VAL, GRD_MID_POINT GRD_MID_POINT, GRD_QUARTILE GRD_QUARTILE, GRD_COMPARATIO GRD_COMPARATIO, EMP_CATEGORY EMP_CATEGORY, CHANGE_REASON CHANGE_REASON, NORMAL_HOURS NORMAL_HOURS, EMAIL_ADDRESS EMAIL_ADDRESS, BASE_SALARY_FREQUENCY BASE_SALARY_FREQUENCY, NEW_ASSGN_OVN NEW_ASSGN_OVN, NEW_PERF_EVENT_ID NEW_PERF_EVENT_ID, NEW_PERF_REVIEW_ID NEW_PERF_REVIEW_ID, POST_PROCESS_STAT_CD POST_PROCESS_STAT_CD, FEEDBACK_RATING FEEDBACK_RATING, FEEDBACK_COMMENTS FEEDBACK_COMMENTS, FEEDBACK_DATE FEEDBACK_DATE, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, CUSTOM_SEGMENT1 CUSTOM_SEGMENT1, CUSTOM_SEGMENT2 CUSTOM_SEGMENT2, CUSTOM_SEGMENT3 CUSTOM_SEGMENT3, CUSTOM_SEGMENT4 CUSTOM_SEGMENT4, CUSTOM_SEGMENT5 CUSTOM_SEGMENT5, CUSTOM_SEGMENT6 CUSTOM_SEGMENT6, CUSTOM_SEGMENT7 CUSTOM_SEGMENT7, CUSTOM_SEGMENT8 CUSTOM_SEGMENT8, CUSTOM_SEGMENT9 CUSTOM_SEGMENT9, CUSTOM_SEGMENT10 CUSTOM_SEGMENT10, CUSTOM_SEGMENT11 CUSTOM_SEGMENT11, CUSTOM_SEGMENT12 CUSTOM_SEGMENT12, CUSTOM_SEGMENT13 CUSTOM_SEGMENT13, CUSTOM_SEGMENT14 CUSTOM_SEGMENT14, CUSTOM_SEGMENT15 CUSTOM_SEGMENT15, CUSTOM_SEGMENT16 CUSTOM_SEGMENT16, CUSTOM_SEGMENT17 CUSTOM_SEGMENT17, CUSTOM_SEGMENT18 CUSTOM_SEGMENT18, CUSTOM_SEGMENT19 CUSTOM_SEGMENT19, CUSTOM_SEGMENT20 CUSTOM_SEGMENT20, PEOPLE_GROUP_NAME PEOPLE_GROUP_NAME, PEOPLE_GROUP_SEGMENT1 PEOPLE_GROUP_SEGMENT1, PEOPLE_GROUP_SEGMENT2 PEOPLE_GROUP_SEGMENT2, PEOPLE_GROUP_SEGMENT3 PEOPLE_GROUP_SEGMENT3, PEOPLE_GROUP_SEGMENT4 PEOPLE_GROUP_SEGMENT4, PEOPLE_GROUP_SEGMENT5 PEOPLE_GROUP_SEGMENT5, PEOPLE_GROUP_SEGMENT6 PEOPLE_GROUP_SEGMENT6, PEOPLE_GROUP_SEGMENT7 PEOPLE_GROUP_SEGMENT7, PEOPLE_GROUP_SEGMENT8 PEOPLE_GROUP_SEGMENT8, PEOPLE_GROUP_SEGMENT9 PEOPLE_GROUP_SEGMENT9, PEOPLE_GROUP_SEGMENT10 PEOPLE_GROUP_SEGMENT10, PEOPLE_GROUP_SEGMENT11 PEOPLE_GROUP_SEGMENT11, ASS_ATTRIBUTE_CATEGORY ASS_ATTRIBUTE_CATEGORY, ASS_ATTRIBUTE1 ASS_ATTRIBUTE1, ASS_ATTRIBUTE2 ASS_ATTRIBUTE2, ASS_ATTRIBUTE3 ASS_ATTRIBUTE3, ASS_ATTRIBUTE4 ASS_ATTRIBUTE4, ASS_ATTRIBUTE5 ASS_ATTRIBUTE5, ASS_ATTRIBUTE6 ASS_ATTRIBUTE6, ASS_ATTRIBUTE7 ASS_ATTRIBUTE7, ASS_ATTRIBUTE8 ASS_ATTRIBUTE8, ASS_ATTRIBUTE9 ASS_ATTRIBUTE9, ASS_ATTRIBUTE10 ASS_ATTRIBUTE10, ASS_ATTRIBUTE11 ASS_ATTRIBUTE11, ASS_ATTRIBUTE12 ASS_ATTRIBUTE12, ASS_ATTRIBUTE13 ASS_ATTRIBUTE13, ASS_ATTRIBUTE14 ASS_ATTRIBUTE14, ASS_ATTRIBUTE15 ASS_ATTRIBUTE15, ASS_ATTRIBUTE16 ASS_ATTRIBUTE16, ASS_ATTRIBUTE17 ASS_ATTRIBUTE17, ASS_ATTRIBUTE18 ASS_ATTRIBUTE18, ASS_ATTRIBUTE19 ASS_ATTRIBUTE19, ASS_ATTRIBUTE20 ASS_ATTRIBUTE20, ASS_ATTRIBUTE21 ASS_ATTRIBUTE21, ASS_ATTRIBUTE22 ASS_ATTRIBUTE22, ASS_ATTRIBUTE23 ASS_ATTRIBUTE23, ASS_ATTRIBUTE24 ASS_ATTRIBUTE24, ASS_ATTRIBUTE25 ASS_ATTRIBUTE25, ASS_ATTRIBUTE26 ASS_ATTRIBUTE26, ASS_ATTRIBUTE27 ASS_ATTRIBUTE27, ASS_ATTRIBUTE28 ASS_ATTRIBUTE28, ASS_ATTRIBUTE29 ASS_ATTRIBUTE29, ASS_ATTRIBUTE30 ASS_ATTRIBUTE30, WS_COMMENTS WS_COMMENTS, CPI_ATTRIBUTE_CATEGORY CPI_ATTRIBUTE_CATEGORY, CPI_ATTRIBUTE1 CPI_ATTRIBUTE1, CPI_ATTRIBUTE2 CPI_ATTRIBUTE2, CPI_ATTRIBUTE3 CPI_ATTRIBUTE3, CPI_ATTRIBUTE4 CPI_ATTRIBUTE4, CPI_ATTRIBUTE5 CPI_ATTRIBUTE5, CPI_ATTRIBUTE6 CPI_ATTRIBUTE6, CPI_ATTRIBUTE7 CPI_ATTRIBUTE7, CPI_ATTRIBUTE8 CPI_ATTRIBUTE8, CPI_ATTRIBUTE9 CPI_ATTRIBUTE9, CPI_ATTRIBUTE10 CPI_ATTRIBUTE10, CPI_ATTRIBUTE11 CPI_ATTRIBUTE11, CPI_ATTRIBUTE12 CPI_ATTRIBUTE12, CPI_ATTRIBUTE13 CPI_ATTRIBUTE13, CPI_ATTRIBUTE14 CPI_ATTRIBUTE14, CPI_ATTRIBUTE15 CPI_ATTRIBUTE15, CPI_ATTRIBUTE16 CPI_ATTRIBUTE16, CPI_ATTRIBUTE17 CPI_ATTRIBUTE17, CPI_ATTRIBUTE18 CPI_ATTRIBUTE18, CPI_ATTRIBUTE19 CPI_ATTRIBUTE19, CPI_ATTRIBUTE20 CPI_ATTRIBUTE20, CPI_ATTRIBUTE21 CPI_ATTRIBUTE21, CPI_ATTRIBUTE22 CPI_ATTRIBUTE22, CPI_ATTRIBUTE23 CPI_ATTRIBUTE23, CPI_ATTRIBUTE24 CPI_ATTRIBUTE24, CPI_ATTRIBUTE25 CPI_ATTRIBUTE25, CPI_ATTRIBUTE26 CPI_ATTRIBUTE26, CPI_ATTRIBUTE27 CPI_ATTRIBUTE27, CPI_ATTRIBUTE28 CPI_ATTRIBUTE28, CPI_ATTRIBUTE29 CPI_ATTRIBUTE29, CPI_ATTRIBUTE30 CPI_ATTRIBUTE30, 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, GROUP_PL_ID GROUP_PL_ID, LF_EVT_OCRD_DT LF_EVT_OCRD_DT, BASE_SALARY_CURRENCY BASE_SALARY_CURRENCY, FTE_FACTOR FTE_FACTOR, GRD_QUINTILE GRD_QUINTILE, GRD_DECILE GRD_DECILE, GRD_PCT_IN_RANGE GRD_PCT_IN_RANGE, GRADE_RATE_FREQUENCY GRADE_RATE_FREQUENCY, SALARY_1_YEAR_AGO SALARY_1_YEAR_AGO, SALARY_1_YEAR_AGO_FREQUENCY SALARY_1_YEAR_AGO_FREQUENCY, SALARY_1_YEAR_AGO_CURRENCY SALARY_1_YEAR_AGO_CURRENCY, SALARY_1_YEAR_AGO_ANN_FCTR SALARY_1_YEAR_AGO_ANN_FCTR, SALARY_2_YEAR_AGO SALARY_2_YEAR_AGO, SALARY_2_YEAR_AGO_FREQUENCY SALARY_2_YEAR_AGO_FREQUENCY, SALARY_2_YEAR_AGO_CURRENCY SALARY_2_YEAR_AGO_CURRENCY, SALARY_2_YEAR_AGO_ANN_FCTR SALARY_2_YEAR_AGO_ANN_FCTR, SALARY_3_YEAR_AGO SALARY_3_YEAR_AGO, SALARY_3_YEAR_AGO_FREQUENCY SALARY_3_YEAR_AGO_FREQUENCY, SALARY_3_YEAR_AGO_CURRENCY SALARY_3_YEAR_AGO_CURRENCY, SALARY_3_YEAR_AGO_ANN_FCTR SALARY_3_YEAR_AGO_ANN_FCTR, SALARY_4_YEAR_AGO SALARY_4_YEAR_AGO, SALARY_4_YEAR_AGO_FREQUENCY SALARY_4_YEAR_AGO_FREQUENCY, SALARY_4_YEAR_AGO_CURRENCY SALARY_4_YEAR_AGO_CURRENCY, SALARY_4_YEAR_AGO_ANN_FCTR SALARY_4_YEAR_AGO_ANN_FCTR, SALARY_5_YEAR_AGO SALARY_5_YEAR_AGO, SALARY_5_YEAR_AGO_FREQUENCY SALARY_5_YEAR_AGO_FREQUENCY, SALARY_5_YEAR_AGO_CURRENCY SALARY_5_YEAR_AGO_CURRENCY, SALARY_5_YEAR_AGO_ANN_FCTR SALARY_5_YEAR_AGO_ANN_FCTR, PREV_SAL PREV_SAL, PREV_SAL_FREQUENCY PREV_SAL_FREQUENCY, PREV_SAL_CURRENCY PREV_SAL_CURRENCY, PREV_SAL_ANN_FCTR PREV_SAL_ANN_FCTR, PREV_SAL_CHG_DATE PREV_SAL_CHG_DATE, PREV_SAL_CHG_RSN PREV_SAL_CHG_RSN, MKT_CURRENCY MKT_CURRENCY, MKT_FREQUENCY MKT_FREQUENCY, MKT_ANNUALIZATION_FACTOR MKT_ANNUALIZATION_FACTOR, MKT_MIN_SALARY MKT_MIN_SALARY, MKT_25PCT_SALARY MKT_25PCT_SALARY, MKT_MID_SALARY MKT_MID_SALARY, MKT_75PCT_SALARY MKT_75PCT_SALARY, MKT_MAX_SALARY MKT_MAX_SALARY, MKT_EMP_QUARTILE MKT_EMP_QUARTILE, MKT_EMP_PCT_IN_RANGE MKT_EMP_PCT_IN_RANGE, MKT_EMP_COMPARATIO MKT_EMP_COMPARATIO, MKT_SURVEY_ID MKT_SURVEY_ID, CURRENT_PAY_PROPOSAL_ID CURRENT_PAY_PROPOSAL_ID, APPRAISAL_ID APPRAISAL_ID, EMAIL_STATUS EMAIL_STATUS from "BEN"."BEN_CWB_PERSON_INFO"

View Text - HTML Formatted

SELECT GROUP_PER_IN_LER_ID GROUP_PER_IN_LER_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, PERSON_ID PERSON_ID
, SUPERVISOR_ID SUPERVISOR_ID
, EFFECTIVE_DATE EFFECTIVE_DATE
, FULL_NAME FULL_NAME
, BRIEF_NAME BRIEF_NAME
, CUSTOM_NAME CUSTOM_NAME
, SUPERVISOR_FULL_NAME SUPERVISOR_FULL_NAME
, SUPERVISOR_BRIEF_NAME SUPERVISOR_BRIEF_NAME
, SUPERVISOR_CUSTOM_NAME SUPERVISOR_CUSTOM_NAME
, LEGISLATION_CODE LEGISLATION_CODE
, YEARS_EMPLOYED YEARS_EMPLOYED
, YEARS_IN_JOB YEARS_IN_JOB
, YEARS_IN_POSITION YEARS_IN_POSITION
, YEARS_IN_GRADE YEARS_IN_GRADE
, EMPLOYEE_NUMBER EMPLOYEE_NUMBER
, START_DATE START_DATE
, ORIGINAL_START_DATE ORIGINAL_START_DATE
, ADJUSTED_SVC_DATE ADJUSTED_SVC_DATE
, BASE_SALARY BASE_SALARY
, BASE_SALARY_CHANGE_DATE BASE_SALARY_CHANGE_DATE
, PAYROLL_NAME PAYROLL_NAME
, PERFORMANCE_RATING PERFORMANCE_RATING
, PERFORMANCE_RATING_TYPE PERFORMANCE_RATING_TYPE
, PERFORMANCE_RATING_DATE PERFORMANCE_RATING_DATE
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, ORGANIZATION_ID ORGANIZATION_ID
, JOB_ID JOB_ID
, GRADE_ID GRADE_ID
, POSITION_ID POSITION_ID
, PEOPLE_GROUP_ID PEOPLE_GROUP_ID
, SOFT_CODING_KEYFLEX_ID SOFT_CODING_KEYFLEX_ID
, LOCATION_ID LOCATION_ID
, PAY_RATE_ID PAY_RATE_ID
, ASSIGNMENT_STATUS_TYPE_ID ASSIGNMENT_STATUS_TYPE_ID
, FREQUENCY FREQUENCY
, GRADE_ANNULIZATION_FACTOR GRADE_ANNULIZATION_FACTOR
, PAY_ANNULIZATION_FACTOR PAY_ANNULIZATION_FACTOR
, GRD_MIN_VAL GRD_MIN_VAL
, GRD_MAX_VAL GRD_MAX_VAL
, GRD_MID_POINT GRD_MID_POINT
, GRD_QUARTILE GRD_QUARTILE
, GRD_COMPARATIO GRD_COMPARATIO
, EMP_CATEGORY EMP_CATEGORY
, CHANGE_REASON CHANGE_REASON
, NORMAL_HOURS NORMAL_HOURS
, EMAIL_ADDRESS EMAIL_ADDRESS
, BASE_SALARY_FREQUENCY BASE_SALARY_FREQUENCY
, NEW_ASSGN_OVN NEW_ASSGN_OVN
, NEW_PERF_EVENT_ID NEW_PERF_EVENT_ID
, NEW_PERF_REVIEW_ID NEW_PERF_REVIEW_ID
, POST_PROCESS_STAT_CD POST_PROCESS_STAT_CD
, FEEDBACK_RATING FEEDBACK_RATING
, FEEDBACK_COMMENTS FEEDBACK_COMMENTS
, FEEDBACK_DATE FEEDBACK_DATE
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CUSTOM_SEGMENT1 CUSTOM_SEGMENT1
, CUSTOM_SEGMENT2 CUSTOM_SEGMENT2
, CUSTOM_SEGMENT3 CUSTOM_SEGMENT3
, CUSTOM_SEGMENT4 CUSTOM_SEGMENT4
, CUSTOM_SEGMENT5 CUSTOM_SEGMENT5
, CUSTOM_SEGMENT6 CUSTOM_SEGMENT6
, CUSTOM_SEGMENT7 CUSTOM_SEGMENT7
, CUSTOM_SEGMENT8 CUSTOM_SEGMENT8
, CUSTOM_SEGMENT9 CUSTOM_SEGMENT9
, CUSTOM_SEGMENT10 CUSTOM_SEGMENT10
, CUSTOM_SEGMENT11 CUSTOM_SEGMENT11
, CUSTOM_SEGMENT12 CUSTOM_SEGMENT12
, CUSTOM_SEGMENT13 CUSTOM_SEGMENT13
, CUSTOM_SEGMENT14 CUSTOM_SEGMENT14
, CUSTOM_SEGMENT15 CUSTOM_SEGMENT15
, CUSTOM_SEGMENT16 CUSTOM_SEGMENT16
, CUSTOM_SEGMENT17 CUSTOM_SEGMENT17
, CUSTOM_SEGMENT18 CUSTOM_SEGMENT18
, CUSTOM_SEGMENT19 CUSTOM_SEGMENT19
, CUSTOM_SEGMENT20 CUSTOM_SEGMENT20
, PEOPLE_GROUP_NAME PEOPLE_GROUP_NAME
, PEOPLE_GROUP_SEGMENT1 PEOPLE_GROUP_SEGMENT1
, PEOPLE_GROUP_SEGMENT2 PEOPLE_GROUP_SEGMENT2
, PEOPLE_GROUP_SEGMENT3 PEOPLE_GROUP_SEGMENT3
, PEOPLE_GROUP_SEGMENT4 PEOPLE_GROUP_SEGMENT4
, PEOPLE_GROUP_SEGMENT5 PEOPLE_GROUP_SEGMENT5
, PEOPLE_GROUP_SEGMENT6 PEOPLE_GROUP_SEGMENT6
, PEOPLE_GROUP_SEGMENT7 PEOPLE_GROUP_SEGMENT7
, PEOPLE_GROUP_SEGMENT8 PEOPLE_GROUP_SEGMENT8
, PEOPLE_GROUP_SEGMENT9 PEOPLE_GROUP_SEGMENT9
, PEOPLE_GROUP_SEGMENT10 PEOPLE_GROUP_SEGMENT10
, PEOPLE_GROUP_SEGMENT11 PEOPLE_GROUP_SEGMENT11
, ASS_ATTRIBUTE_CATEGORY ASS_ATTRIBUTE_CATEGORY
, ASS_ATTRIBUTE1 ASS_ATTRIBUTE1
, ASS_ATTRIBUTE2 ASS_ATTRIBUTE2
, ASS_ATTRIBUTE3 ASS_ATTRIBUTE3
, ASS_ATTRIBUTE4 ASS_ATTRIBUTE4
, ASS_ATTRIBUTE5 ASS_ATTRIBUTE5
, ASS_ATTRIBUTE6 ASS_ATTRIBUTE6
, ASS_ATTRIBUTE7 ASS_ATTRIBUTE7
, ASS_ATTRIBUTE8 ASS_ATTRIBUTE8
, ASS_ATTRIBUTE9 ASS_ATTRIBUTE9
, ASS_ATTRIBUTE10 ASS_ATTRIBUTE10
, ASS_ATTRIBUTE11 ASS_ATTRIBUTE11
, ASS_ATTRIBUTE12 ASS_ATTRIBUTE12
, ASS_ATTRIBUTE13 ASS_ATTRIBUTE13
, ASS_ATTRIBUTE14 ASS_ATTRIBUTE14
, ASS_ATTRIBUTE15 ASS_ATTRIBUTE15
, ASS_ATTRIBUTE16 ASS_ATTRIBUTE16
, ASS_ATTRIBUTE17 ASS_ATTRIBUTE17
, ASS_ATTRIBUTE18 ASS_ATTRIBUTE18
, ASS_ATTRIBUTE19 ASS_ATTRIBUTE19
, ASS_ATTRIBUTE20 ASS_ATTRIBUTE20
, ASS_ATTRIBUTE21 ASS_ATTRIBUTE21
, ASS_ATTRIBUTE22 ASS_ATTRIBUTE22
, ASS_ATTRIBUTE23 ASS_ATTRIBUTE23
, ASS_ATTRIBUTE24 ASS_ATTRIBUTE24
, ASS_ATTRIBUTE25 ASS_ATTRIBUTE25
, ASS_ATTRIBUTE26 ASS_ATTRIBUTE26
, ASS_ATTRIBUTE27 ASS_ATTRIBUTE27
, ASS_ATTRIBUTE28 ASS_ATTRIBUTE28
, ASS_ATTRIBUTE29 ASS_ATTRIBUTE29
, ASS_ATTRIBUTE30 ASS_ATTRIBUTE30
, WS_COMMENTS WS_COMMENTS
, CPI_ATTRIBUTE_CATEGORY CPI_ATTRIBUTE_CATEGORY
, CPI_ATTRIBUTE1 CPI_ATTRIBUTE1
, CPI_ATTRIBUTE2 CPI_ATTRIBUTE2
, CPI_ATTRIBUTE3 CPI_ATTRIBUTE3
, CPI_ATTRIBUTE4 CPI_ATTRIBUTE4
, CPI_ATTRIBUTE5 CPI_ATTRIBUTE5
, CPI_ATTRIBUTE6 CPI_ATTRIBUTE6
, CPI_ATTRIBUTE7 CPI_ATTRIBUTE7
, CPI_ATTRIBUTE8 CPI_ATTRIBUTE8
, CPI_ATTRIBUTE9 CPI_ATTRIBUTE9
, CPI_ATTRIBUTE10 CPI_ATTRIBUTE10
, CPI_ATTRIBUTE11 CPI_ATTRIBUTE11
, CPI_ATTRIBUTE12 CPI_ATTRIBUTE12
, CPI_ATTRIBUTE13 CPI_ATTRIBUTE13
, CPI_ATTRIBUTE14 CPI_ATTRIBUTE14
, CPI_ATTRIBUTE15 CPI_ATTRIBUTE15
, CPI_ATTRIBUTE16 CPI_ATTRIBUTE16
, CPI_ATTRIBUTE17 CPI_ATTRIBUTE17
, CPI_ATTRIBUTE18 CPI_ATTRIBUTE18
, CPI_ATTRIBUTE19 CPI_ATTRIBUTE19
, CPI_ATTRIBUTE20 CPI_ATTRIBUTE20
, CPI_ATTRIBUTE21 CPI_ATTRIBUTE21
, CPI_ATTRIBUTE22 CPI_ATTRIBUTE22
, CPI_ATTRIBUTE23 CPI_ATTRIBUTE23
, CPI_ATTRIBUTE24 CPI_ATTRIBUTE24
, CPI_ATTRIBUTE25 CPI_ATTRIBUTE25
, CPI_ATTRIBUTE26 CPI_ATTRIBUTE26
, CPI_ATTRIBUTE27 CPI_ATTRIBUTE27
, CPI_ATTRIBUTE28 CPI_ATTRIBUTE28
, CPI_ATTRIBUTE29 CPI_ATTRIBUTE29
, CPI_ATTRIBUTE30 CPI_ATTRIBUTE30
, 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
, GROUP_PL_ID GROUP_PL_ID
, LF_EVT_OCRD_DT LF_EVT_OCRD_DT
, BASE_SALARY_CURRENCY BASE_SALARY_CURRENCY
, FTE_FACTOR FTE_FACTOR
, GRD_QUINTILE GRD_QUINTILE
, GRD_DECILE GRD_DECILE
, GRD_PCT_IN_RANGE GRD_PCT_IN_RANGE
, GRADE_RATE_FREQUENCY GRADE_RATE_FREQUENCY
, SALARY_1_YEAR_AGO SALARY_1_YEAR_AGO
, SALARY_1_YEAR_AGO_FREQUENCY SALARY_1_YEAR_AGO_FREQUENCY
, SALARY_1_YEAR_AGO_CURRENCY SALARY_1_YEAR_AGO_CURRENCY
, SALARY_1_YEAR_AGO_ANN_FCTR SALARY_1_YEAR_AGO_ANN_FCTR
, SALARY_2_YEAR_AGO SALARY_2_YEAR_AGO
, SALARY_2_YEAR_AGO_FREQUENCY SALARY_2_YEAR_AGO_FREQUENCY
, SALARY_2_YEAR_AGO_CURRENCY SALARY_2_YEAR_AGO_CURRENCY
, SALARY_2_YEAR_AGO_ANN_FCTR SALARY_2_YEAR_AGO_ANN_FCTR
, SALARY_3_YEAR_AGO SALARY_3_YEAR_AGO
, SALARY_3_YEAR_AGO_FREQUENCY SALARY_3_YEAR_AGO_FREQUENCY
, SALARY_3_YEAR_AGO_CURRENCY SALARY_3_YEAR_AGO_CURRENCY
, SALARY_3_YEAR_AGO_ANN_FCTR SALARY_3_YEAR_AGO_ANN_FCTR
, SALARY_4_YEAR_AGO SALARY_4_YEAR_AGO
, SALARY_4_YEAR_AGO_FREQUENCY SALARY_4_YEAR_AGO_FREQUENCY
, SALARY_4_YEAR_AGO_CURRENCY SALARY_4_YEAR_AGO_CURRENCY
, SALARY_4_YEAR_AGO_ANN_FCTR SALARY_4_YEAR_AGO_ANN_FCTR
, SALARY_5_YEAR_AGO SALARY_5_YEAR_AGO
, SALARY_5_YEAR_AGO_FREQUENCY SALARY_5_YEAR_AGO_FREQUENCY
, SALARY_5_YEAR_AGO_CURRENCY SALARY_5_YEAR_AGO_CURRENCY
, SALARY_5_YEAR_AGO_ANN_FCTR SALARY_5_YEAR_AGO_ANN_FCTR
, PREV_SAL PREV_SAL
, PREV_SAL_FREQUENCY PREV_SAL_FREQUENCY
, PREV_SAL_CURRENCY PREV_SAL_CURRENCY
, PREV_SAL_ANN_FCTR PREV_SAL_ANN_FCTR
, PREV_SAL_CHG_DATE PREV_SAL_CHG_DATE
, PREV_SAL_CHG_RSN PREV_SAL_CHG_RSN
, MKT_CURRENCY MKT_CURRENCY
, MKT_FREQUENCY MKT_FREQUENCY
, MKT_ANNUALIZATION_FACTOR MKT_ANNUALIZATION_FACTOR
, MKT_MIN_SALARY MKT_MIN_SALARY
, MKT_25PCT_SALARY MKT_25PCT_SALARY
, MKT_MID_SALARY MKT_MID_SALARY
, MKT_75PCT_SALARY MKT_75PCT_SALARY
, MKT_MAX_SALARY MKT_MAX_SALARY
, MKT_EMP_QUARTILE MKT_EMP_QUARTILE
, MKT_EMP_PCT_IN_RANGE MKT_EMP_PCT_IN_RANGE
, MKT_EMP_COMPARATIO MKT_EMP_COMPARATIO
, MKT_SURVEY_ID MKT_SURVEY_ID
, CURRENT_PAY_PROPOSAL_ID CURRENT_PAY_PROPOSAL_ID
, APPRAISAL_ID APPRAISAL_ID
, EMAIL_STATUS EMAIL_STATUS
FROM "BEN"."BEN_CWB_PERSON_INFO"