Composite View Source: APREHIS

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Reporting View Source: APREHIS Advancement

**SGHE Banner Operational Data Store**
Banner Source Name	Banner Source Column	Banner Business Name	Source Form	Banner Business Definition	Banner Business Acronym	ODS Target	ODS Target Column
	APREHIS_ATYP_CODE		APAEHIS			AA_PREVIOUS_EMPLOYMENT	EMPLOYEE_ADDRESS_TYPE
	APREHIS_ATYP_SEQNO		APAEHIS			AA_PREVIOUS_EMPLOYMENT	EMPLOYEE_ADDRESS_SEQ_NUMBER
	APREHIS_COMMENT		APAEHIS
	APREHIS_EMPL_POSITION		APAEHIS			AA_PREVIOUS_EMPLOYMENT	POSITION_TITLE
	APREHIS_EMPR_NAME		APAEHIS			AA_PREVIOUS_EMPLOYMENT	EMPLOYER_NAME
	APREHIS_EMPR_PIDM		NA			AA_PREVIOUS_EMPLOYMENT	EMPLOYER_UID
	APREHIS_EMPS_CODE		APAEHIS			AA_PREVIOUS_EMPLOYMENT	EMPLOYMENT_STATUS
	APREHIS_FROM_DATE		APAEHIS			AA_PREVIOUS_EMPLOYMENT	START_DATE
	APREHIS_JOBC_CODE		APAEHIS			AA_PREVIOUS_EMPLOYMENT	EMPLOYER_CATEGORY
	APREHIS_JOBC_CODE2		APAEHIS			AA_PREVIOUS_EMPLOYMENT	EMPLOYER_CATEGORY2
	APREHIS_JOBC_CODE3		APAEHIS			AA_PREVIOUS_EMPLOYMENT	EMPLOYER_CATEGORY3
	APREHIS_JOBC_CODE4		APAEHIS			AA_PREVIOUS_EMPLOYMENT	EMPLOYER_CATEGORY4
	APREHIS_MG_IND		APAEHIS			AA_PREVIOUS_EMPLOYMENT	MATCHING_GIFT_IND
	APREHIS_PIDM		NA			AA_PREVIOUS_EMPLOYMENT	PERSON_UID
	APREHIS_PRIMARY_IND		APAEHIS
	APREHIS_SEQ_NO		APAEHIS			AA_PREVIOUS_EMPLOYMENT	EMPLOYMENT_ORDER
	APREHIS_SICC_CODE		APAEHIS			AA_PREVIOUS_EMPLOYMENT	EMPLOYER_INDUSTRIAL_TYPE
	APREHIS_TO_DATE		APAEHIS			AA_PREVIOUS_EMPLOYMENT	END_DATE
	APREHIS_WKLY_HOURS		APAEHIS			AA_PREVIOUS_EMPLOYMENT	WEEKLY_HOURS

Ver: 8.3