| Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
|---|
| PPREXPE_CONTACT_IND |
PPAEXPR |
NO |
REPORTING VIEW |
EMPLOYMENT_HISTORY PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT |
SUPERVISOR_CONTACT_IND SUPERVISOR_CONTACT_IND2 SUPERVISOR_CONTACT_IND3 SUPERVISOR_CONTACT_IND4 SUPERVISOR_CONTACT_IND1 |
NO NO NO NO NO |
NA |
| PPREXPE_CURR_HOURLY |
PPAEXPR |
NO |
REPORTING VIEW |
PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT EMPLOYMENT_HISTORY PAST_EMPLOYMENT_SLOT |
CURRENT_HOURLY_RATE1 CURRENT_HOURLY_RATE2 CURRENT_HOURLY_RATE3 CURRENT_HOURLY_RATE CURRENT_HOURLY_RATE4 |
NO NO NO NO NO |
NA |
| PPREXPE_CURR_SALARY |
PPAEXPR |
NO |
REPORTING VIEW |
EMPLOYMENT_HISTORY PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT |
CURRENT_SALARY CURRENT_SALARY4 CURRENT_SALARY2 CURRENT_SALARY1 CURRENT_SALARY3 |
NO NO NO NO NO |
NA |
| PPREXPE_EMPR_NAME |
PPAEXPR |
NO |
REPORTING VIEW |
PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT CURRENT_EMPLOYMENT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT |
EMPLOYER_NAME4 EMPLOYER_NAME3 EMPLOYER_NAME EMPLOYER_NAME1 EMPLOYER_NAME2 |
NO NO NO NO NO |
NA |
| PPREXPE_EMPS_SUPERVISE |
PPAEXPR |
NO |
REPORTING VIEW |
PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT EMPLOYMENT_HISTORY PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT |
EMPLOYEES_SUPERVISED4 EMPLOYEES_SUPERVISED1 EMPLOYEES_SUPERVISED EMPLOYEES_SUPERVISED2 EMPLOYEES_SUPERVISED3 |
NO NO NO NO NO |
NA |
| PPREXPE_EMTY_CODE |
PPAEXPR |
NO |
REPORTING VIEW |
EMPLOYMENT_HISTORY CURRENT_EMPLOYMENT |
EMPLOYER_CATEGORY EMPLOYER_CATEGORY |
NO NO |
NA |
| PPREXPE_END_DATE |
PPAEXPR |
NO |
REPORTING VIEW |
PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT EMPLOYMENT_HISTORY PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT |
END_DATE2 END_DATE3 END_DATE END_DATE1 END_DATE4 |
NO NO NO NO NO |
NA |
| PPREXPE_NATN_CODE |
PPAEXPR |
NO |
REPORTING VIEW |
EMPLOYMENT_HISTORY CURRENT_EMPLOYMENT |
NATION NATION |
NO NO |
NA |
| PPREXPE_PIDM |
NA |
NO |
REPORTING VIEW |
CURRENT_EMPLOYMENT PAST_EMPLOYMENT_SLOT EMPLOYMENT_HISTORY |
PERSON_UID PERSON_UID PERSON_UID |
NO NO NO |
NA |
| PPREXPE_POSN_TITLE |
PPAEXPR |
NO |
REPORTING VIEW |
CURRENT_EMPLOYMENT EMPLOYMENT_HISTORY PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT |
POSITION_TITLE POSITION_TITLE POSITION_TITLE2 POSITION_TITLE4 POSITION_TITLE3 POSITION_TITLE1 |
NO NO NO NO NO NO |
NA |
| PPREXPE_REASON_LEFT |
PPAEXPR |
NO |
REPORTING VIEW |
CURRENT_EMPLOYMENT EMPLOYMENT_HISTORY PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT |
REASON_LEFT REASON_LEFT REASON_LEFT1 REASON_LEFT3 REASON_LEFT2 REASON_LEFT4 |
NO NO NO NO NO NO |
NA |
| PPREXPE_START_DATE |
PPAEXPR |
NO |
REPORTING VIEW |
CURRENT_EMPLOYMENT PAST_EMPLOYMENT_SLOT EMPLOYMENT_HISTORY PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT |
START_DATE START_DATE2 START_DATE START_DATE1 START_DATE4 START_DATE3 |
NO NO NO NO NO NO |
NA |
| PPREXPE_STAT_CODE |
PPAEXPR |
NO |
REPORTING VIEW |
EMPLOYMENT_HISTORY CURRENT_EMPLOYMENT |
PROVINCE_STATE STATE_PROVINCE |
NO NO |
NA |
| PPREXPE_SUPER_COMMENT |
PPAEXPR |
NO |
REPORTING VIEW |
EMPLOYMENT_HISTORY |
SUPERVISOR_COMMENT |
NO |
NA |
| PPREXPE_SUPER_NAME |
PPAEXPR |
NO |
REPORTING VIEW |
EMPLOYMENT_HISTORY PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT |
SUPERVISOR_NAME SUPERVISOR_NAME3 SUPERVISOR_NAME1 SUPERVISOR_NAME2 SUPERVISOR_NAME4 |
NO NO NO NO NO |
NA |
| PPREXPE_SUPER_PHONE_AREA |
PPAEXPR |
NO |
REPORTING VIEW |
PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT EMPLOYMENT_HISTORY PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT |
SUPERVISOR_PHONE_AREA2 SUPERVISOR_PHONE_AREA4 SUPERVISOR_PHONE_AREA SUPERVISOR_PHONE_AREA3 SUPERVISOR_PHONE_AREA1 |
NO NO NO NO NO |
NA |
| PPREXPE_SUPER_PHONE_EXT |
PPAEXPR |
NO |
REPORTING VIEW |
PAST_EMPLOYMENT_SLOT EMPLOYMENT_HISTORY PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT |
SUPERVISOR_PHONE_EXTENSION3 SUPERVISOR_PHONE_EXTENSION SUPERVISOR_PHONE_EXTENSION2 SUPERVISOR_PHONE_EXTENSION4 SUPERVISOR_PHONE_EXTENSION1 |
NO NO NO NO NO |
NA |
| PPREXPE_SUPER_PHONE_NUMBER |
PPAEXPR |
NO |
REPORTING VIEW |
PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT EMPLOYMENT_HISTORY PAST_EMPLOYMENT_SLOT PAST_EMPLOYMENT_SLOT |
SUPERVISOR_PHONE_NUMBER2 SUPERVISOR_PHONE_NUMBER1 SUPERVISOR_PHONE_NUMBER SUPERVISOR_PHONE_NUMBER3 SUPERVISOR_PHONE_NUMBER4 |
NO NO NO NO NO |
NA |