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

Source Column Source Form Target Type Target Target Column Calculation Formula
APREHIS_ATYP_CODE APAEHIS COMPOSITE VIEW

AA_PREVIOUS_EMPLOYMENT

EMPLOYEE_ADDRESS_TYPE

NA
APREHIS_ATYP_SEQNO APAEHIS COMPOSITE VIEW

AA_PREVIOUS_EMPLOYMENT

EMPLOYEE_ADDRESS_SEQ_NUMBER

NA
APREHIS_COMMENT APAEHIS       NA
APREHIS_EMPL_POSITION APAEHIS COMPOSITE VIEW

AA_PREVIOUS_EMPLOYMENT

POSITION_TITLE

NA
APREHIS_EMPR_NAME COMPOSITE VIEW

AA_PREVIOUS_EMPLOYMENT

EMPLOYER_NAME

 
APREHIS_EMPR_PIDM NA COMPOSITE VIEW

AA_PREVIOUS_EMPLOYMENT

EMPLOYER_UID

NA
APREHIS_EMPS_CODE COMPOSITE VIEW

AA_PREVIOUS_EMPLOYMENT

EMPLOYMENT_STATUS

 
APREHIS_FROM_DATE APAEHIS COMPOSITE VIEW

AA_PREVIOUS_EMPLOYMENT

START_DATE

NA
APREHIS_JOBC_CODE APAEHIS COMPOSITE VIEW

AA_PREVIOUS_EMPLOYMENT

EMPLOYER_CATEGORY

NA
APREHIS_JOBC_CODE2 APAEHIS COMPOSITE VIEW

AA_PREVIOUS_EMPLOYMENT

EMPLOYER_CATEGORY2

NA
APREHIS_JOBC_CODE3 APAEHIS COMPOSITE VIEW

AA_PREVIOUS_EMPLOYMENT

EMPLOYER_CATEGORY3

NA
APREHIS_JOBC_CODE4 APAEHIS COMPOSITE VIEW

AA_PREVIOUS_EMPLOYMENT

EMPLOYER_CATEGORY4

NA
APREHIS_MG_IND APAEHIS COMPOSITE VIEW

AA_PREVIOUS_EMPLOYMENT

MATCHING_GIFT_IND

NA
APREHIS_PIDM NA COMPOSITE VIEW

AA_PREVIOUS_EMPLOYMENT

PERSON_UID

NA
APREHIS_PRIMARY_IND APAEHIS       NA
APREHIS_SEQ_NO APAEHIS COMPOSITE VIEW

AA_PREVIOUS_EMPLOYMENT

EMPLOYMENT_ORDER

NA
APREHIS_SICC_CODE COMPOSITE VIEW

AA_PREVIOUS_EMPLOYMENT

EMPLOYER_INDUSTRIAL_TYPE

 
APREHIS_TO_DATE APAEHIS COMPOSITE VIEW

AA_PREVIOUS_EMPLOYMENT

END_DATE

NA
APREHIS_WKLY_HOURS COMPOSITE VIEW

AA_PREVIOUS_EMPLOYMENT

WEEKLY_HOURS

 


Ver: