Reporting View Source: APREHIS

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

**Banner Operational Data Store**
Source Column	Source Form	Local Source	Target Type	Target	Target Column	Local Target	Calculation Formula
APREHIS_ATYP_CODE	APAEHIS	NO					NA
APREHIS_ATYP_SEQNO	APAEHIS	NO					NA
APREHIS_COMMENT	APAEHIS	NO	REPORTING VIEW	EMPLOYMENT_HISTORY CURRENT_EMPLOYMENT	EMPLOYER_COMMENT EMPLOYER_COMMENT	NO NO	NA
APREHIS_EMPL_POSITION	APAEHIS	NO	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	NO NO NO NO NO NO	NA
APREHIS_EMPR_NAME		NO	REPORTING VIEW	CURRENT_EMPLOYMENT	EMPLOYER_NAME	NO
APREHIS_EMPR_PIDM	NA	NO	REPORTING VIEW	CURRENT_EMPLOYMENT EMPLOYMENT_HISTORY	EMPLOYER_UID EMPLOYER_UID	NO NO	NA
APREHIS_EMPS_CODE		NO	REPORTING VIEW	CURRENT_EMPLOYMENT EMPLOYMENT_HISTORY	EMPLOYMENT_STATUS EMPLOYMENT_STATUS	NO NO
APREHIS_FROM_DATE	APAEHIS	NO	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	NO NO NO NO NO NO	NA
APREHIS_JOBC_CODE	APAEHIS	NO	REPORTING VIEW	EMPLOYMENT_HISTORY CURRENT_EMPLOYMENT	EMPLOYER_CATEGORY EMPLOYER_CATEGORY	NO NO	NA
APREHIS_JOBC_CODE2	APAEHIS	NO	REPORTING VIEW	EMPLOYMENT_HISTORY CURRENT_EMPLOYMENT	EMPLOYER_CATEGORY2 EMPLOYER_CATEGORY2	NO NO	NA
APREHIS_JOBC_CODE3	APAEHIS	NO	REPORTING VIEW	CURRENT_EMPLOYMENT EMPLOYMENT_HISTORY	EMPLOYER_CATEGORY3 EMPLOYER_CATEGORY3	NO NO	NA
APREHIS_JOBC_CODE4	APAEHIS	NO	REPORTING VIEW	CURRENT_EMPLOYMENT EMPLOYMENT_HISTORY	EMPLOYER_CATEGORY4 EMPLOYER_CATEGORY4	NO NO	NA
APREHIS_MG_IND	APAEHIS	NO	REPORTING VIEW	CURRENT_EMPLOYMENT	MATCHING_GIFT_IND	NO	NA
APREHIS_PIDM	NA	NO	REPORTING VIEW	PAST_EMPLOYMENT_SLOT CURRENT_EMPLOYMENT EMPLOYMENT_HISTORY	PERSON_UID PERSON_UID PERSON_UID	NO NO NO	NA
APREHIS_PRIMARY_IND	APAEHIS	NO	REPORTING VIEW	EMPLOYMENT_HISTORY CURRENT_EMPLOYMENT	PRIMARY_EMPLOYMENT_IND PRIMARY_EMPLOYMENT_IND	NO NO	NA
APREHIS_SEQ_NO	APAEHIS	NO	REPORTING VIEW	CURRENT_EMPLOYMENT EMPLOYMENT_HISTORY	EMPLOYMENT_ORDER EMPLOYMENT_ORDER	NO NO	NA
APREHIS_SICC_CODE		NO	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	NO NO NO NO NO NO
APREHIS_TO_DATE	APAEHIS	NO	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	NO NO NO NO NO	NA
APREHIS_WKLY_HOURS		NO	REPORTING VIEW	CURRENT_EMPLOYMENT EMPLOYMENT_HISTORY	WEEKLY_HOURS WEEKLY_HOURS	NO NO

Ver: 9.2