Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: PPREXPE Human Resources Reporting View Meta Data Reports
SGHE Banner Operational Data Store Reporting View Source: PPREXPE - NULL

Source Column Source Form Target Type Target Target Column Calculation Formula
PPREXPE_CONTACT_IND PPAEXPR

REPORTING VIEW

EMPLOYMENT_HISTORY

PAST_EMPLOYMENT_SLOT

PAST_EMPLOYMENT_SLOT

PAST_EMPLOYMENT_SLOT

PAST_EMPLOYMENT_SLOT

SUPERVISOR_CONTACT_IND

SUPERVISOR_CONTACT_IND3

SUPERVISOR_CONTACT_IND2

SUPERVISOR_CONTACT_IND4

SUPERVISOR_CONTACT_IND1

NA
PPREXPE_CURR_HOURLY PPAEXPR

REPORTING VIEW

PAST_EMPLOYMENT_SLOT

PAST_EMPLOYMENT_SLOT

PAST_EMPLOYMENT_SLOT

EMPLOYMENT_HISTORY

PAST_EMPLOYMENT_SLOT

CURRENT_HOURLY_RATE1

CURRENT_HOURLY_RATE4

CURRENT_HOURLY_RATE3

CURRENT_HOURLY_RATE

CURRENT_HOURLY_RATE2

NA
PPREXPE_CURR_SALARY PPAEXPR

REPORTING VIEW

PAST_EMPLOYMENT_SLOT

PAST_EMPLOYMENT_SLOT

PAST_EMPLOYMENT_SLOT

PAST_EMPLOYMENT_SLOT

EMPLOYMENT_HISTORY

CURRENT_SALARY1

CURRENT_SALARY2

CURRENT_SALARY4

CURRENT_SALARY3

CURRENT_SALARY

NA
PPREXPE_EMPR_NAME PPAEXPR

REPORTING VIEW

CURRENT_EMPLOYMENT

PAST_EMPLOYMENT_SLOT

PAST_EMPLOYMENT_SLOT

PAST_EMPLOYMENT_SLOT

PAST_EMPLOYMENT_SLOT

EMPLOYER_NAME

EMPLOYER_NAME2

EMPLOYER_NAME1

EMPLOYER_NAME4

EMPLOYER_NAME3

NA
PPREXPE_EMPS_SUPERVISE PPAEXPR

REPORTING VIEW

PAST_EMPLOYMENT_SLOT

PAST_EMPLOYMENT_SLOT

PAST_EMPLOYMENT_SLOT

EMPLOYMENT_HISTORY

PAST_EMPLOYMENT_SLOT

EMPLOYEES_SUPERVISED2

EMPLOYEES_SUPERVISED4

EMPLOYEES_SUPERVISED3

EMPLOYEES_SUPERVISED

EMPLOYEES_SUPERVISED1

NA
PPREXPE_EMTY_CODE PPAEXPR

REPORTING VIEW

CURRENT_EMPLOYMENT

EMPLOYMENT_HISTORY

EMPLOYER_CATEGORY

EMPLOYER_CATEGORY

NA
PPREXPE_END_DATE PPAEXPR

REPORTING VIEW

PAST_EMPLOYMENT_SLOT

PAST_EMPLOYMENT_SLOT

PAST_EMPLOYMENT_SLOT

PAST_EMPLOYMENT_SLOT

EMPLOYMENT_HISTORY

END_DATE1

END_DATE4

END_DATE3

END_DATE2

END_DATE

NA
PPREXPE_NATN_CODE PPAEXPR

REPORTING VIEW

CURRENT_EMPLOYMENT

EMPLOYMENT_HISTORY

NATION

NATION

NA
PPREXPE_PIDM NA

REPORTING VIEW

CURRENT_EMPLOYMENT

EMPLOYMENT_HISTORY

PAST_EMPLOYMENT_SLOT

PERSON_UID

PERSON_UID

PERSON_UID

NA
PPREXPE_POSN_TITLE PPAEXPR

REPORTING VIEW

CURRENT_EMPLOYMENT

PAST_EMPLOYMENT_SLOT

PAST_EMPLOYMENT_SLOT

EMPLOYMENT_HISTORY

PAST_EMPLOYMENT_SLOT

PAST_EMPLOYMENT_SLOT

POSITION_TITLE

POSITION_TITLE4

POSITION_TITLE2

POSITION_TITLE

POSITION_TITLE1

POSITION_TITLE3

NA
PPREXPE_REASON_LEFT PPAEXPR

REPORTING VIEW

PAST_EMPLOYMENT_SLOT

PAST_EMPLOYMENT_SLOT

EMPLOYMENT_HISTORY

PAST_EMPLOYMENT_SLOT

CURRENT_EMPLOYMENT

PAST_EMPLOYMENT_SLOT

REASON_LEFT1

REASON_LEFT2

REASON_LEFT

REASON_LEFT3

REASON_LEFT

REASON_LEFT4

NA
PPREXPE_START_DATE PPAEXPR

REPORTING VIEW

PAST_EMPLOYMENT_SLOT

CURRENT_EMPLOYMENT

PAST_EMPLOYMENT_SLOT

EMPLOYMENT_HISTORY

PAST_EMPLOYMENT_SLOT

PAST_EMPLOYMENT_SLOT

START_DATE2

START_DATE

START_DATE4

START_DATE

START_DATE1

START_DATE3

NA
PPREXPE_STAT_CODE PPAEXPR

REPORTING VIEW

EMPLOYMENT_HISTORY

CURRENT_EMPLOYMENT

PROVINCE_STATE

STATE_PROVINCE

NA
PPREXPE_SUPER_COMMENT PPAEXPR

REPORTING VIEW

EMPLOYMENT_HISTORY

SUPERVISOR_COMMENT

NA
PPREXPE_SUPER_NAME PPAEXPR

REPORTING VIEW

PAST_EMPLOYMENT_SLOT

PAST_EMPLOYMENT_SLOT

PAST_EMPLOYMENT_SLOT

EMPLOYMENT_HISTORY

PAST_EMPLOYMENT_SLOT

SUPERVISOR_NAME3

SUPERVISOR_NAME1

SUPERVISOR_NAME2

SUPERVISOR_NAME

SUPERVISOR_NAME4

NA
PPREXPE_SUPER_PHONE_AREA PPAEXPR

REPORTING VIEW

PAST_EMPLOYMENT_SLOT

PAST_EMPLOYMENT_SLOT

PAST_EMPLOYMENT_SLOT

PAST_EMPLOYMENT_SLOT

EMPLOYMENT_HISTORY

SUPERVISOR_PHONE_AREA1

SUPERVISOR_PHONE_AREA2

SUPERVISOR_PHONE_AREA3

SUPERVISOR_PHONE_AREA4

SUPERVISOR_PHONE_AREA

NA
PPREXPE_SUPER_PHONE_EXT PPAEXPR

REPORTING VIEW

PAST_EMPLOYMENT_SLOT

EMPLOYMENT_HISTORY

PAST_EMPLOYMENT_SLOT

PAST_EMPLOYMENT_SLOT

PAST_EMPLOYMENT_SLOT

SUPERVISOR_PHONE_EXTENSION4

SUPERVISOR_PHONE_EXTENSION

SUPERVISOR_PHONE_EXTENSION1

SUPERVISOR_PHONE_EXTENSION2

SUPERVISOR_PHONE_EXTENSION3

NA
PPREXPE_SUPER_PHONE_NUMBER PPAEXPR

REPORTING VIEW

PAST_EMPLOYMENT_SLOT

PAST_EMPLOYMENT_SLOT

PAST_EMPLOYMENT_SLOT

EMPLOYMENT_HISTORY

PAST_EMPLOYMENT_SLOT

SUPERVISOR_PHONE_NUMBER2

SUPERVISOR_PHONE_NUMBER1

SUPERVISOR_PHONE_NUMBER4

SUPERVISOR_PHONE_NUMBER

SUPERVISOR_PHONE_NUMBER3

NA


Ver: 8.0