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**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
PPREXPE_CONTACT_IND	PPAEXPR	REPORTING VIEW	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	NA
PPREXPE_CURR_HOURLY	PPAEXPR	REPORTING VIEW	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	NA
PPREXPE_CURR_SALARY	PPAEXPR	REPORTING VIEW	EMPLOYMENT_HISTORY PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT	CURRENT_SALARY CURRENT_SALARY1 CURRENT_SALARY4 CURRENT_SALARY2 CURRENT_SALARY3	NA
PPREXPE_EMPR_NAME	PPAEXPR	REPORTING VIEW	PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT CURRENT_EMPLOYMENT PAST_EMPLOYMENT_SLOT	EMPLOYER_NAME4 EMPLOYER_NAME2 EMPLOYER_NAME3 EMPLOYER_NAME EMPLOYER_NAME1	NA
PPREXPE_EMPS_SUPERVISE	PPAEXPR	REPORTING VIEW	EMPLOYMENT_HISTORY PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT	EMPLOYEES_SUPERVISED EMPLOYEES_SUPERVISED1 EMPLOYEES_SUPERVISED4 EMPLOYEES_SUPERVISED2 EMPLOYEES_SUPERVISED3	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_DATE3 END_DATE4 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 PAST_EMPLOYMENT_SLOT EMPLOYMENT_HISTORY	PERSON_UID PERSON_UID PERSON_UID	NA
PPREXPE_POSN_TITLE	PPAEXPR	REPORTING VIEW	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	NA
PPREXPE_REASON_LEFT	PPAEXPR	REPORTING VIEW	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	NA
PPREXPE_START_DATE	PPAEXPR	REPORTING VIEW	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	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	EMPLOYMENT_HISTORY PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT	SUPERVISOR_NAME SUPERVISOR_NAME4 SUPERVISOR_NAME1 SUPERVISOR_NAME3 SUPERVISOR_NAME2	NA
PPREXPE_SUPER_PHONE_AREA	PPAEXPR	REPORTING VIEW	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	NA
PPREXPE_SUPER_PHONE_EXT	PPAEXPR	REPORTING VIEW	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	NA
PPREXPE_SUPER_PHONE_NUMBER	PPAEXPR	REPORTING VIEW	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	NA

Ver: 9.0