| Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
|---|
| PHRJOBS_ACTIVITY_DATE |
PHIJOBS |
NO |
REPORTING VIEW |
PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET |
PAYROLL_POSITION_ACTIVITY_DATE PAYROLL_POSITION_ACTIVITY_DATE |
NO NO |
|
| PHRJOBS_APPT_PCT |
NA |
NO |
REPORTING VIEW |
PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET |
APPOINTMENT_PCT APPOINTMENT_PCT |
NO NO |
NA |
| PHRJOBS_BASE_SAL_HRS |
NA |
NO |
REPORTING VIEW |
PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET |
BASE_SALARY_HOURS BASE_SALARY_HOURS |
NO NO |
NA |
| PHRJOBS_COAS_CODE_TS |
PHIJOBS |
NO |
REPORTING VIEW |
PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET |
TIMESHEET_CHART_OF_ACCOUNTS TIMESHEET_CHART_OF_ACCOUNTS |
NO NO |
NA |
| PHRJOBS_CONTRACT_TYPE |
NA |
NO |
REPORTING VIEW |
PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET |
POSITION_CONTRACT_TYPE POSITION_CONTRACT_TYPE |
NO NO |
NA |
| PHRJOBS_DEFER_AMT |
NA |
NO |
REPORTING VIEW |
PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET |
DEFERRED_PAY_AMOUNT DEFERRED_PAY_AMOUNT |
NO NO |
NA |
| PHRJOBS_ECLS_CODE |
PHIJOBS |
NO |
REPORTING VIEW |
PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION |
POSITION_EMPLOYEE_CLASS POSITION_EMPLOYEE_CLASS |
NO NO |
NA |
| PHRJOBS_EFFECTIVE_DATE |
PHIJOBS |
NO |
REPORTING VIEW |
PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION |
POSITION_BEGIN_DATE POSITION_BEGIN_DATE |
NO NO |
NA |
| PHRJOBS_EFFECTIVE_UNTIL_DATE |
NA |
NO |
REPORTING VIEW |
PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION |
POSITION_END_DATE POSITION_END_DATE |
NO NO |
NA |
| PHRJOBS_EMPR_CODE |
NA |
NO |
REPORTING VIEW |
PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET |
EMPLOYER EMPLOYER |
NO NO |
NA |
| PHRJOBS_FIRST_NAME_SEQ |
PHIJOBS |
NO |
REPORTING VIEW |
PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET |
FIRST_NAME_HISTORY FIRST_NAME_HISTORY |
NO NO |
NA |
| PHRJOBS_FTE |
NA |
NO |
REPORTING VIEW |
PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION |
FULL_TIME_EQUIVALENCY FULL_TIME_EQUIVALENCY |
NO NO |
NA |
| PHRJOBS_FULL_ASSGN_SALARY |
NA |
NO |
REPORTING VIEW |
PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET |
FULL_ASSIGNMENT_SALARY FULL_ASSIGNMENT_SALARY |
NO NO |
NA |
| PHRJOBS_HRS_DAY |
NA |
NO |
REPORTING VIEW |
PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION |
HOURS_PER_DAY HOURS_PER_DAY |
NO NO |
NA |
| PHRJOBS_ID_SEQ |
PHIJOBS |
NO |
REPORTING VIEW |
PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET |
ID_HISTORY ID_HISTORY |
NO NO |
NA |
| PHRJOBS_LAST_NAME_SEQ |
PHIJOBS |
NO |
REPORTING VIEW |
PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET |
LAST_NAME_HISTORY LAST_NAME_HISTORY |
NO NO |
NA |
| PHRJOBS_LCAT_CODE |
NA |
NO |
REPORTING VIEW |
PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION |
LEAVE_CATEGORY LEAVE_CATEGORY |
NO NO |
NA |
| PHRJOBS_LGCD_CODE |
NA |
NO |
REPORTING VIEW |
PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET |
LONGEVITY_ELIGIBILITY LONGEVITY_ELIGIBILITY |
NO NO |
NA |
| PHRJOBS_ORGN_CODE_TS |
PHIJOBS |
NO |
REPORTING VIEW |
PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION |
TIMESHEET_ORGANIZATION TIMESHEET_ORGANIZATION |
NO NO |
NA |
| PHRJOBS_PAY_CNT |
NA |
NO |
REPORTING VIEW |
PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET |
PAYROLL_IDENTIFIER_COUNT PAYROLL_IDENTIFIER_COUNT |
NO NO |
NA |
| PHRJOBS_PCAT_CODE |
NA |
NO |
REPORTING VIEW |
PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET |
PREMIUM_PAY_CATEGORY PREMIUM_PAY_CATEGORY |
NO NO |
NA |
| PHRJOBS_PERS_CONT_CODE |
NA |
NO |
REPORTING VIEW |
PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION |
PUBLIC_RETIREMENT_CONTRIBUTION PUBLIC_RETIREMENT_CONTRIBUTION |
NO NO |
NA |
| PHRJOBS_PERS_PAY_CODE |
NA |
NO |
REPORTING VIEW |
PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET |
PUBLIC_RETIREMENT_PAY_RATE PUBLIC_RETIREMENT_PAY_RATE |
NO NO |
NA |
| PHRJOBS_PER_PAY_SALARY |
NA |
NO |
REPORTING VIEW |
PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET |
PER_PAY_SALARY PER_PAY_SALARY |
NO NO |
NA |
| PHRJOBS_POSN |
PHIJOBS |
NO |
REPORTING VIEW |
PAYROLL_EMPLOYEE_POSITION |
POSITION |
NO |
NA |
| PHRJOBS_PREV_FISCAL_YEAR_IND |
NA |
NO |
REPORTING VIEW |
PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET |
PREVIOUS_FISCAL_YEAR_IND PREVIOUS_FISCAL_YEAR_IND |
NO NO |
NA |
| PHRJOBS_SALARY_RATE |
NA |
NO |
REPORTING VIEW |
PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION |
HOURLY_RATE HOURLY_RATE |
NO NO |
NA |
| PHRJOBS_SHIFT |
NA |
NO |
REPORTING VIEW |
PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET |
SHIFT_NUMBER SHIFT_NUMBER |
NO NO |
NA |
| PHRJOBS_STATUS |
PHIJOBS |
NO |
REPORTING VIEW |
PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION |
POSITION_STATUS POSITION_STATUS |
NO NO |
NA |
| PHRJOBS_STRS_ASSN_CODE |
NA |
NO |
REPORTING VIEW |
PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION |
STATE_RETIREMENT_ASSIGNMENT STATE_RETIREMENT_ASSIGNMENT |
NO NO |
NA |
| PHRJOBS_STRS_CONT_CODE |
NA |
NO |
REPORTING VIEW |
PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION |
STATE_RETIREMENT_CONTRIBUTION STATE_RETIREMENT_CONTRIBUTION |
NO NO |
NA |
| PHRJOBS_STRS_PAY_CODE |
NA |
NO |
REPORTING VIEW |
PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET |
STATE_RETIREMENT_PAY_RATE STATE_RETIREMENT_PAY_RATE |
NO NO |
NA |
| PHRJOBS_SUFF |
PHIJOBS |
NO |
REPORTING VIEW |
PAYROLL_EMPLOYEE_POSITION |
JOB_SUFFIX |
NO |
NA |
| PHRJOBS_TIME_ENTRY_IND |
NA |
NO |
REPORTING VIEW |
PAYROLL_EMPLOYEE_POSITION PAYROLL_POSITION_TIMESHEET |
TIME_ENTRY_TYPE TIME_ENTRY_TYPE |
NO NO |
NA |
| PHRJOBS_TS_ROSTER_IND |
PHIJOBS |
NO |
REPORTING VIEW |
PAYROLL_POSITION_TIMESHEET PAYROLL_EMPLOYEE_POSITION |
TIMESHEET_METHOD TIMESHEET_METHOD |
NO NO |
NA |