Reporting View Source: PPREXPE

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**
Banner Source Column	Source Form	ODS Target	ODS Target Column
PPREXPE_CONTACT_IND	PPAEXPR	PAST_EMPLOYMENT_SLOT EMPLOYMENT_HISTORY PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT	SUPERVISOR_CONTACT_IND1 SUPERVISOR_CONTACT_IND SUPERVISOR_CONTACT_IND2 SUPERVISOR_CONTACT_IND3 SUPERVISOR_CONTACT_IND4
PPREXPE_CURR_HOURLY	PPAEXPR	EMPLOYMENT_HISTORY PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT	CURRENT_HOURLY_RATE CURRENT_HOURLY_RATE1 CURRENT_HOURLY_RATE2 CURRENT_HOURLY_RATE4 CURRENT_HOURLY_RATE3
PPREXPE_CURR_SALARY	PPAEXPR	EMPLOYMENT_HISTORY PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT	CURRENT_SALARY CURRENT_SALARY1 CURRENT_SALARY4 CURRENT_SALARY2 CURRENT_SALARY3
PPREXPE_EMPR_NAME	PPAEXPR	PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT CURRENT_EMPLOYMENT PAST_EMPLOYMENT_SLOT	EMPLOYER_NAME4 EMPLOYER_NAME2 EMPLOYER_NAME3 EMPLOYER_NAME EMPLOYER_NAME1
PPREXPE_EMPS_SUPERVISE	PPAEXPR	EMPLOYMENT_HISTORY PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT	EMPLOYEES_SUPERVISED EMPLOYEES_SUPERVISED1 EMPLOYEES_SUPERVISED4 EMPLOYEES_SUPERVISED2 EMPLOYEES_SUPERVISED3
PPREXPE_EMTY_CODE	PPAEXPR	CURRENT_EMPLOYMENT EMPLOYMENT_HISTORY	EMPLOYER_CATEGORY EMPLOYER_CATEGORY
PPREXPE_END_DATE	PPAEXPR	PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT EMPLOYMENT_HISTORY	END_DATE1 END_DATE3 END_DATE4 END_DATE2 END_DATE
PPREXPE_NATN_CODE	PPAEXPR	CURRENT_EMPLOYMENT EMPLOYMENT_HISTORY	NATION NATION
PPREXPE_PIDM	NA	CURRENT_EMPLOYMENT PAST_EMPLOYMENT_SLOT EMPLOYMENT_HISTORY	PERSON_UID PERSON_UID PERSON_UID
PPREXPE_POSN_TITLE	PPAEXPR	PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT CURRENT_EMPLOYMENT EMPLOYMENT_HISTORY	POSITION_TITLE1 POSITION_TITLE2 POSITION_TITLE4 POSITION_TITLE3 POSITION_TITLE POSITION_TITLE
PPREXPE_REASON_LEFT	PPAEXPR	EMPLOYMENT_HISTORY CURRENT_EMPLOYMENT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT	REASON_LEFT REASON_LEFT REASON_LEFT3 REASON_LEFT2 REASON_LEFT4 REASON_LEFT1
PPREXPE_START_DATE	PPAEXPR	PAST_EMPLOYMENT_SLOT EMPLOYMENT_HISTORY PAST_EMPLOYMENT_SLOT CURRENT_EMPLOYMENT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT	START_DATE4 START_DATE START_DATE3 START_DATE START_DATE1 START_DATE2
PPREXPE_STAT_CODE	PPAEXPR	EMPLOYMENT_HISTORY CURRENT_EMPLOYMENT	PROVINCE_STATE STATE_PROVINCE
PPREXPE_SUPER_COMMENT	PPAEXPR	EMPLOYMENT_HISTORY	SUPERVISOR_COMMENT
PPREXPE_SUPER_NAME	PPAEXPR	EMPLOYMENT_HISTORY PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT	SUPERVISOR_NAME SUPERVISOR_NAME4 SUPERVISOR_NAME1 SUPERVISOR_NAME3 SUPERVISOR_NAME2
PPREXPE_SUPER_PHONE_AREA	PPAEXPR	PAST_EMPLOYMENT_SLOT EMPLOYMENT_HISTORY PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT	SUPERVISOR_PHONE_AREA3 SUPERVISOR_PHONE_AREA SUPERVISOR_PHONE_AREA1 SUPERVISOR_PHONE_AREA4 SUPERVISOR_PHONE_AREA2
PPREXPE_SUPER_PHONE_EXT	PPAEXPR	EMPLOYMENT_HISTORY PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT	SUPERVISOR_PHONE_EXTENSION SUPERVISOR_PHONE_EXTENSION3 SUPERVISOR_PHONE_EXTENSION1 SUPERVISOR_PHONE_EXTENSION4 SUPERVISOR_PHONE_EXTENSION2
PPREXPE_SUPER_PHONE_NUMBER	PPAEXPR	PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT EMPLOYMENT_HISTORY	SUPERVISOR_PHONE_NUMBER3 SUPERVISOR_PHONE_NUMBER4 SUPERVISOR_PHONE_NUMBER2 SUPERVISOR_PHONE_NUMBER1 SUPERVISOR_PHONE_NUMBER

Ver: 8.3