Go To View:  RETURN TO REPORTING VIEW REPORTS LIST
Composite View Source: APREHIS Advancement Reporting View Meta Data Reports
Banner Operational Data Store Reporting View Source: APREHIS - NULL

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