| Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
|---|
| PHRHOUR_ACTIVITY_DATE |
PHAHOUR |
NO |
REPORTING VIEW |
PAYROLL_POSITION_TIMESHEET PAYROLL_TIMESHEET |
TIMESHEET_ACTIVITY_DATE ACTIVITY_DATE |
NO NO |
|
| PHRHOUR_AMT |
PHAHOUR |
NO |
REPORTING VIEW |
PAYROLL_POSITION_TIMESHEET PAYROLL_TIMESHEET |
GROSS_EARNINGS GROSS_EARNINGS |
NO NO |
|
| PHRHOUR_BEGIN_DATE |
NA |
NO |
REPORTING VIEW |
PAYROLL_TIMESHEET PAYROLL_POSITION_TIMESHEET |
TIME_ENTRY_PERIOD_BEGIN_DATE TIME_ENTRY_PERIOD_BEGIN_DATE |
NO NO |
|
| PHRHOUR_EARN_CODE |
PHAHOUR |
NO |
REPORTING VIEW |
PAYROLL_TIMESHEET PAYROLL_POSITION_TIMESHEET |
EARNINGS EARNINGS |
NO NO |
|
| PHRHOUR_EFFECTIVE_DATE |
PHAHOUR |
NO |
REPORTING VIEW |
PAYROLL_TIMESHEET PAYROLL_POSITION_TIMESHEET |
EFFECTIVE_DATE EFFECTIVE_DATE |
NO NO |
|
| PHRHOUR_END_DATE |
NA |
NO |
REPORTING VIEW |
PAYROLL_TIMESHEET PAYROLL_POSITION_TIMESHEET |
TIME_ENTRY_PERIOD_END_DATE TIME_ENTRY_PERIOD_END_DATE |
NO NO |
|
| PHRHOUR_GEN_IND |
PHAHOUR |
NO |
REPORTING VIEW |
PAYROLL_TIMESHEET PAYROLL_POSITION_TIMESHEET |
SYSTEM_GENERATED_IND SYSTEM_GENERATED_IND |
NO NO |
|
| PHRHOUR_HRS |
PHAHOUR |
NO |
REPORTING VIEW |
PAYROLL_TIMESHEET PAYROLL_POSITION_TIMESHEET |
HOURS_WORKED HOURS_WORKED |
NO NO |
|
| PHRHOUR_PAYNO |
PHAHOUR |
NO |
REPORTING VIEW |
PAYROLL_TIMESHEET PAYROLL_POSITION_TIMESHEET |
PAYROLL_NUMBER PAYROLL_NUMBER |
NO NO |
|
| PHRHOUR_PICT_CODE |
PHAHOUR |
NO |
REPORTING VIEW |
PAYROLL_TIMESHEET PAYROLL_POSITION_TIMESHEET |
PAYROLL_IDENTIFIER PAYROLL_IDENTIFIER |
NO NO |
|
| PHRHOUR_PIDM |
PHAHOUR |
NO |
REPORTING VIEW |
PAYROLL_POSITION_TIMESHEET PAYROLL_TIMESHEET |
PERSON_UID PERSON_UID |
NO NO |
|
| PHRHOUR_POSN |
PHAHOUR |
NO |
REPORTING VIEW |
PAYROLL_TIMESHEET PAYROLL_POSITION_TIMESHEET |
POSITION POSITION |
NO NO |
|
| PHRHOUR_SEQ_NO |
PHAHOUR |
NO |
REPORTING VIEW |
PAYROLL_POSITION_TIMESHEET PAYROLL_TIMESHEET |
EVENT_SEQUENCE_NUMBER EVENT_SEQUENCE_NUMBER |
NO NO |
|
| PHRHOUR_SHIFT |
PHAHOUR |
NO |
REPORTING VIEW |
PAYROLL_TIMESHEET |
SHIFT_NUMBER |
NO |
|
| PHRHOUR_SUFF |
PHAHOUR |
NO |
REPORTING VIEW |
PAYROLL_POSITION_TIMESHEET PAYROLL_TIMESHEET |
JOB_SUFFIX JOB_SUFFIX |
NO NO |
|
| PHRHOUR_YEAR |
PHAHOUR |
NO |
REPORTING VIEW |
PAYROLL_POSITION_TIMESHEET PAYROLL_TIMESHEET |
CALENDAR_YEAR CALENDAR_YEAR |
NO NO |
|