| Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
|---|
| PHRHIST_ADJS_DATE |
PHAADJT |
NO |
REPORTING VIEW |
PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET |
ADJUST_DATE ADJUST_DATE |
NO NO |
NA |
| PHRHIST_ADJS_SEQ_NO |
PHAADJT |
NO |
REPORTING VIEW |
PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION |
ADJUST_SEQUENCE_NUMBER ADJUST_SEQUENCE_NUMBER |
NO NO |
NA |
| PHRHIST_ADJ_BY_DATE |
PHAADJT |
NO |
REPORTING VIEW |
PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION |
ADJUST_BY_DATE ADJUST_BY_DATE |
NO NO |
NA |
| PHRHIST_ADJ_BY_SEQ_NO |
PHAADJT |
NO |
REPORTING VIEW |
PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION |
ADJUST_BY_SEQUENCE_NUMBER ADJUST_BY_SEQUENCE_NUMBER |
NO NO |
NA |
| PHRHIST_ASSOC_SEQ_NO |
PHAADJT |
NO |
REPORTING VIEW |
PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION |
ASSOCIATED_SEQUENCE_NUMBER ASSOCIATED_SEQUENCE_NUMBER |
NO NO |
NA |
| PHRHIST_CALC_IND |
PHILIST |
NO |
REPORTING VIEW |
PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION |
PAYROLL_CALCULATION_TYPE PAYROLL_CALCULATION_TYPE |
NO NO |
|
| PHRHIST_DISP |
PHILIST |
NO |
REPORTING VIEW |
PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET |
DISPOSITION DISPOSITION |
NO NO |
NA |
| PHRHIST_EVENT_DATE |
PHICHEK |
NO |
REPORTING VIEW |
PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET |
DOCUMENT_DATE DOCUMENT_DATE |
NO NO |
NA |
| PHRHIST_GROSS |
PHICHEK |
NO |
REPORTING VIEW |
PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET |
GROSS_AMOUNT GROSS_AMOUNT |
NO NO |
NA |
| PHRHIST_NET |
PHICHEK |
NO |
REPORTING VIEW |
PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET |
NET_AMOUNT NET_AMOUNT |
NO NO |
NA |
| PHRHIST_PAYNO |
PHICHEK |
NO |
REPORTING VIEW |
PAYROLL_EMPLOYEE_POSITION |
PAYROLL_NUMBER |
NO |
NA |
| PHRHIST_PICT_CODE |
PHICHEK |
NO |
REPORTING VIEW |
PAYROLL_EMPLOYEE_POSITION |
PAYROLL_IDENTIFIER |
NO |
NA |
| PHRHIST_PIDM |
PHRCHEK |
NO |
REPORTING VIEW |
PAYROLL_EMPLOYEE_POSITION |
PERSON_UID |
NO |
|
| PHRHIST_POSTING_OVERRIDE_DATE |
PHAADJT |
NO |
REPORTING VIEW |
PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION |
POSTING_OVERRIDE_DATE POSTING_OVERRIDE_DATE |
NO NO |
NA |
| PHRHIST_PRINT_IND |
PHAADJT |
NO |
REPORTING VIEW |
PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET |
DOCUMENT_PRINT_METHOD DOCUMENT_PRINT_METHOD |
NO NO |
|
| PHRHIST_SEQ_NO |
PHICHEK |
NO |
REPORTING VIEW |
PAYROLL_EMPLOYEE_POSITION |
EVENT_SEQUENCE_NUMBER |
NO |
NA |
| PHRHIST_TYPE_DESC |
PHILIST |
NO |
REPORTING VIEW |
PAYROLL_POSITION_TIMESHEET |
PAYROLL_EVENT_TYPE_DESC |
NO |
NA |
| PHRHIST_TYPE_IND |
PHILIST |
NO |
REPORTING VIEW |
PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET |
PAYROLL_EVENT_TYPE PAYROLL_EVENT_TYPE |
NO NO |
NA |
| PHRHIST_UI_EXCEPTION_IND |
PHICHEK |
NO |
REPORTING VIEW |
PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION |
UNEMPLOY_INSURANCE_EXCEPTION UNEMPLOY_INSURANCE_EXCEPTION |
NO NO |
NA |
| PHRHIST_UI_WEEKS |
PHICHEK |
NO |
REPORTING VIEW |
PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET |
UNEMPLOY_INSURANCE_WEEKS UNEMPLOY_INSURANCE_WEEKS |
NO NO |
NA |
| PHRHIST_UPDT_DATE |
NA |
NO |
REPORTING VIEW |
PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION |
SUPPLEMENTAL_PAY_DATE SUPPLEMENTAL_PAY_DATE |
NO NO |
NA |
| PHRHIST_YEAR |
PHICHEK |
NO |
REPORTING VIEW |
PAYROLL_EMPLOYEE_POSITION |
CALENDAR_YEAR |
NO |
NA |