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