| Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
|---|
| PERJTOT_EARN_CODE |
PEIJTOT |
NO |
COMPOSITE VIEW |
AP_EARNING_TOTALS_CY AP_EARNING_TOTALS_FY AP_EMPLOYEE_EARNING_FY AP_EMPLOYEE_EARNING_CY |
EARNINGS EARNINGS EARNINGS EARNINGS |
NO NO NO NO |
NA |
| PERJTOT_EMPR_CODE |
PEIJTOT |
NO |
COMPOSITE VIEW |
AP_EARNING_TOTALS_FY AP_EMPLOYEE_EARNING_FY AP_EMPLOYEE_EARNING_CY AP_EARNING_TOTALS_CY |
EMPLOYER EMPLOYER EMPLOYER EMPLOYER |
NO NO NO NO |
NA |
| PERJTOT_GRS |
PEIJTOT |
NO |
COMPOSITE VIEW |
AP_EMPLOYEE_EARNING_CY AP_EMPLOYEE_EARNING_FY |
GROSS GROSS |
NO NO |
NA |
| PERJTOT_HRS |
PEIJTOT |
NO |
COMPOSITE VIEW |
AP_EMPLOYEE_EARNING_CY AP_EMPLOYEE_EARNING_FY |
HOURS HOURS |
NO NO |
NA |
| PERJTOT_MONTH |
PEIJTOT |
NO |
COMPOSITE VIEW |
AP_EMPLOYEE_EARNING_CY AP_EMPLOYEE_EARNING_FY |
MONTH MONTH |
NO NO |
NA |
| PERJTOT_PIDM |
PEIJTOT |
NO |
COMPOSITE VIEW |
AP_EARNING_TOTALS_CY AP_EMPLOYEE_EARNING_CY AP_EARNING_TOTALS_FY AP_EMPLOYEE_EARNING_FY |
PERSON_UID PERSON_UID PERSON_UID PERSON_UID |
NO NO NO NO |
NA |
| PERJTOT_POSN |
PEIJTOT |
NO |
COMPOSITE VIEW |
AP_EMPLOYEE_EARNING_FY AP_EARNING_TOTALS_CY AP_EARNING_TOTALS_FY AP_EMPLOYEE_EARNING_CY |
POSITION POSITION POSITION POSITION |
NO NO NO NO |
NA |
| PERJTOT_SUFF |
PEIJTOT |
NO |
COMPOSITE VIEW |
AP_EMPLOYEE_EARNING_CY AP_EARNING_TOTALS_CY AP_EARNING_TOTALS_FY AP_EMPLOYEE_EARNING_FY |
SUFFIX SUFFIX SUFFIX SUFFIX |
NO NO NO NO |
NA |
| PERJTOT_YEAR |
PEIJTOT |
NO |
COMPOSITE VIEW |
AP_EARNING_TOTALS_CY AP_EMPLOYEE_EARNING_CY |
CALENDAR_YEAR CALENDAR_YEAR |
NO NO |
NA |