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**
Source Column	Source Form	Target Type	Target	Target Column	Calculation Formula
APREHIS_ATYP_CODE	APAEHIS				NA
APREHIS_ATYP_SEQNO	APAEHIS				NA
APREHIS_COMMENT	APAEHIS	REPORTING VIEW	EMPLOYMENT_HISTORY CURRENT_EMPLOYMENT	EMPLOYER_COMMENT EMPLOYER_COMMENT	NA
APREHIS_EMPL_POSITION	APAEHIS	REPORTING VIEW	PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT CURRENT_EMPLOYMENT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT EMPLOYMENT_HISTORY	POSITION_TITLE3 POSITION_TITLE4 POSITION_TITLE POSITION_TITLE2 POSITION_TITLE1 POSITION_TITLE	NA
APREHIS_EMPR_NAME		REPORTING VIEW	CURRENT_EMPLOYMENT	EMPLOYER_NAME
APREHIS_EMPR_PIDM	NA	REPORTING VIEW	CURRENT_EMPLOYMENT EMPLOYMENT_HISTORY	EMPLOYER_UID EMPLOYER_UID	NA
APREHIS_EMPS_CODE		REPORTING VIEW	CURRENT_EMPLOYMENT EMPLOYMENT_HISTORY	EMPLOYMENT_STATUS EMPLOYMENT_STATUS
APREHIS_FROM_DATE	APAEHIS	REPORTING VIEW	PAST_EMPLOYMENT_SLOT CURRENT_EMPLOYMENT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT EMPLOYMENT_HISTORY PAST_EMPLOYMENT_SLOT	END_DATE1 START_DATE END_DATE2 END_DATE4 END_DATE END_DATE3	NA
APREHIS_JOBC_CODE	APAEHIS	REPORTING VIEW	EMPLOYMENT_HISTORY CURRENT_EMPLOYMENT	EMPLOYER_CATEGORY EMPLOYER_CATEGORY	NA
APREHIS_JOBC_CODE2	APAEHIS	REPORTING VIEW	EMPLOYMENT_HISTORY CURRENT_EMPLOYMENT	EMPLOYER_CATEGORY2 EMPLOYER_CATEGORY2	NA
APREHIS_JOBC_CODE3	APAEHIS	REPORTING VIEW	CURRENT_EMPLOYMENT EMPLOYMENT_HISTORY	EMPLOYER_CATEGORY3 EMPLOYER_CATEGORY3	NA
APREHIS_JOBC_CODE4	APAEHIS	REPORTING VIEW	CURRENT_EMPLOYMENT EMPLOYMENT_HISTORY	EMPLOYER_CATEGORY4 EMPLOYER_CATEGORY4	NA
APREHIS_MG_IND	APAEHIS	REPORTING VIEW	CURRENT_EMPLOYMENT	MATCHING_GIFT_IND	NA
APREHIS_PIDM	NA	REPORTING VIEW	PAST_EMPLOYMENT_SLOT CURRENT_EMPLOYMENT EMPLOYMENT_HISTORY	PERSON_UID PERSON_UID PERSON_UID	NA
APREHIS_PRIMARY_IND	APAEHIS	REPORTING VIEW	EMPLOYMENT_HISTORY CURRENT_EMPLOYMENT	PRIMARY_EMPLOYMENT_IND PRIMARY_EMPLOYMENT_IND	NA
APREHIS_SEQ_NO	APAEHIS	REPORTING VIEW	CURRENT_EMPLOYMENT EMPLOYMENT_HISTORY	EMPLOYMENT_ORDER EMPLOYMENT_ORDER	NA
APREHIS_SICC_CODE		REPORTING VIEW	CURRENT_EMPLOYMENT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT EMPLOYMENT_HISTORY PAST_EMPLOYMENT_SLOT	EMPLOYER_INDUSTRIAL_TYPE EMPLOYER_TYPE1 EMPLOYER_TYPE4 EMPLOYER_TYPE3 EMPLOYER_INDUSTRIAL_TYPE EMPLOYER_TYPE2
APREHIS_TO_DATE	APAEHIS	REPORTING VIEW	PAST_EMPLOYMENT_SLOT EMPLOYMENT_HISTORY PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT	START_DATE3 START_DATE START_DATE2 START_DATE4 START_DATE1	NA
APREHIS_WKLY_HOURS		REPORTING VIEW	CURRENT_EMPLOYMENT EMPLOYMENT_HISTORY	WEEKLY_HOURS WEEKLY_HOURS

Ver: 8.5