Reporting View Source: APREHIS

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Composite View Source: APREHIS Advancement Reporting View Meta Data Reports

**SGHE Banner Operational Data Store**
Banner Source Column	Source Form	ODS Target	ODS Target Column
APREHIS_ATYP_CODE	APAEHIS
APREHIS_ATYP_SEQNO	APAEHIS
APREHIS_COMMENT	APAEHIS	EMPLOYMENT_HISTORY CURRENT_EMPLOYMENT	EMPLOYER_COMMENT EMPLOYER_COMMENT
APREHIS_EMPL_POSITION	APAEHIS	PAST_EMPLOYMENT_SLOT CURRENT_EMPLOYMENT EMPLOYMENT_HISTORY PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT	POSITION_TITLE1 POSITION_TITLE POSITION_TITLE POSITION_TITLE4 POSITION_TITLE2 POSITION_TITLE3
APREHIS_EMPR_NAME	APAEHIS	CURRENT_EMPLOYMENT	EMPLOYER_NAME
APREHIS_EMPR_PIDM	NA	EMPLOYMENT_HISTORY CURRENT_EMPLOYMENT	EMPLOYER_UID EMPLOYER_UID
APREHIS_EMPS_CODE	APAEHIS	EMPLOYMENT_HISTORY CURRENT_EMPLOYMENT	EMPLOYMENT_STATUS EMPLOYMENT_STATUS
APREHIS_FROM_DATE	APAEHIS	PAST_EMPLOYMENT_SLOT EMPLOYMENT_HISTORY PAST_EMPLOYMENT_SLOT CURRENT_EMPLOYMENT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT	END_DATE1 END_DATE END_DATE4 START_DATE END_DATE3 END_DATE2
APREHIS_JOBC_CODE	APAEHIS	EMPLOYMENT_HISTORY CURRENT_EMPLOYMENT	EMPLOYER_CATEGORY EMPLOYER_CATEGORY
APREHIS_JOBC_CODE2	APAEHIS	CURRENT_EMPLOYMENT EMPLOYMENT_HISTORY	EMPLOYER_CATEGORY2 EMPLOYER_CATEGORY2
APREHIS_JOBC_CODE3	APAEHIS	EMPLOYMENT_HISTORY CURRENT_EMPLOYMENT	EMPLOYER_CATEGORY3 EMPLOYER_CATEGORY3
APREHIS_JOBC_CODE4	APAEHIS	CURRENT_EMPLOYMENT EMPLOYMENT_HISTORY	EMPLOYER_CATEGORY4 EMPLOYER_CATEGORY4
APREHIS_MG_IND	APAEHIS	CURRENT_EMPLOYMENT	MATCHING_GIFT_IND
APREHIS_PIDM	NA	PAST_EMPLOYMENT_SLOT CURRENT_EMPLOYMENT EMPLOYMENT_HISTORY	PERSON_UID PERSON_UID PERSON_UID
APREHIS_PRIMARY_IND	APAEHIS	CURRENT_EMPLOYMENT EMPLOYMENT_HISTORY	PRIMARY_EMPLOYMENT_IND PRIMARY_EMPLOYMENT_IND
APREHIS_SEQ_NO	APAEHIS	EMPLOYMENT_HISTORY CURRENT_EMPLOYMENT	EMPLOYMENT_ORDER EMPLOYMENT_ORDER
APREHIS_SICC_CODE	APAEHIS	CURRENT_EMPLOYMENT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT EMPLOYMENT_HISTORY PAST_EMPLOYMENT_SLOT	EMPLOYER_INDUSTRIAL_TYPE EMPLOYER_TYPE2 EMPLOYER_TYPE4 EMPLOYER_TYPE1 EMPLOYER_INDUSTRIAL_TYPE EMPLOYER_TYPE3
APREHIS_TO_DATE	APAEHIS	EMPLOYMENT_HISTORY PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT	START_DATE START_DATE4 START_DATE1 START_DATE2 START_DATE3
APREHIS_WKLY_HOURS	APAEHIS	EMPLOYMENT_HISTORY CURRENT_EMPLOYMENT	WEEKLY_HOURS WEEKLY_HOURS

Ver: 8.3