| 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 |
|