Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
NORTERN_ACTIVITY_DATE |
NOAEPAF |
NO |
COMPOSITE VIEW |
AN_PERSONNEL_ACTION_EARNING |
PAF_EARNING_ACTIVITY_DATE |
NO |
|
NORTERN_APPLY_STATUS_IND |
NOAEPAF |
NO |
COMPOSITE VIEW |
AN_PERSONNEL_ACTION_EARNING |
PAF_APPLY_STATUS |
NO |
|
NORTERN_APTY_CODE |
NOAEPAF |
NO |
COMPOSITE VIEW |
AN_PERSONNEL_ACTION_EARNING |
PAF_APPROVAL_TYPE |
NO |
|
NORTERN_CANCEL_DATE |
NOAEPAF |
NO |
COMPOSITE VIEW |
AN_PERSONNEL_ACTION_EARNING |
EARNINGS_END_DATE |
NO |
|
NORTERN_DEEMED_HRS |
NOAEPAF |
NO |
COMPOSITE VIEW |
AN_PERSONNEL_ACTION_EARNING |
FEDERAL_EMPLOYMENT_HOURS |
NO |
|
NORTERN_EARN_CODE |
NOAEPAF |
NO |
COMPOSITE VIEW |
AN_PERSONNEL_ACTION_EARNING |
EARNINGS |
NO |
|
NORTERN_EFFECTIVE_DATE |
NOAEPAF |
NO |
COMPOSITE VIEW |
AN_PERSONNEL_ACTION_EARNING |
PAF_EFFECTIVE_DATE |
NO |
|
NORTERN_HRS |
TBD |
NO |
|
|
|
|
|
NORTERN_POSN |
NOAEPAF |
NO |
COMPOSITE VIEW |
AN_PERSONNEL_ACTION_EARNING |
POSITION |
NO |
|
NORTERN_SHIFT |
NOAEPAF |
NO |
COMPOSITE VIEW |
AN_PERSONNEL_ACTION_EARNING |
SHIFT_NUMBER |
NO |
|
NORTERN_SPECIAL_RATE |
NOAEPAF |
NO |
COMPOSITE VIEW |
AN_PERSONNEL_ACTION_EARNING |
SPECIAL_RATE |
NO |
|
NORTERN_SUFF |
NOAEPAF |
NO |
COMPOSITE VIEW |
AN_PERSONNEL_ACTION_EARNING |
JOB_SUFFIX |
NO |
|
NORTERN_TRANSACTION_NO |
NOAEPAF |
NO |
COMPOSITE VIEW |
AN_PERSONNEL_ACTION_EARNING |
PAF_TRANSACTION_NUMBER |
NO |
|