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 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	NA
APREHIS_EMPR_NAME	APAEHIS	REPORTING VIEW	CURRENT_EMPLOYMENT	EMPLOYER_NAME	NA
APREHIS_EMPR_PIDM	NA	REPORTING VIEW	EMPLOYMENT_HISTORY CURRENT_EMPLOYMENT	EMPLOYER_UID EMPLOYER_UID	NA
APREHIS_EMPS_CODE	APAEHIS	REPORTING VIEW	EMPLOYMENT_HISTORY CURRENT_EMPLOYMENT	EMPLOYMENT_STATUS EMPLOYMENT_STATUS	NA
APREHIS_FROM_DATE	APAEHIS	REPORTING VIEW	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	NA
APREHIS_JOBC_CODE	APAEHIS	REPORTING VIEW	EMPLOYMENT_HISTORY CURRENT_EMPLOYMENT	EMPLOYER_CATEGORY EMPLOYER_CATEGORY	NA
APREHIS_JOBC_CODE2	APAEHIS	REPORTING VIEW	CURRENT_EMPLOYMENT EMPLOYMENT_HISTORY	EMPLOYER_CATEGORY2 EMPLOYER_CATEGORY2	NA
APREHIS_JOBC_CODE3	APAEHIS	REPORTING VIEW	EMPLOYMENT_HISTORY CURRENT_EMPLOYMENT	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	CURRENT_EMPLOYMENT EMPLOYMENT_HISTORY	PRIMARY_EMPLOYMENT_IND PRIMARY_EMPLOYMENT_IND	NA
APREHIS_SEQ_NO	APAEHIS	REPORTING VIEW	EMPLOYMENT_HISTORY CURRENT_EMPLOYMENT	EMPLOYMENT_ORDER EMPLOYMENT_ORDER	NA
APREHIS_SICC_CODE	APAEHIS	REPORTING VIEW	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	NA
APREHIS_TO_DATE	APAEHIS	REPORTING VIEW	EMPLOYMENT_HISTORY PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT	START_DATE START_DATE4 START_DATE1 START_DATE2 START_DATE3	NA
APREHIS_WKLY_HOURS	APAEHIS	REPORTING VIEW	EMPLOYMENT_HISTORY CURRENT_EMPLOYMENT	WEEKLY_HOURS WEEKLY_HOURS	NA

Ver: 9.0