| Source Column |
Source Form |
Local Source |
Target Type |
Target |
Target Column |
Local Target |
Calculation Formula |
|---|
| NBRJOBS_ACTIVITY_DATE |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
ACTIVITY_DATE |
NO |
|
| NBRJOBS_ANN_SALARY |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
ANNUAL_SALARY |
NO |
NA |
| NBRJOBS_APPT_PCT |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
APPOINTMENT_PCT |
NO |
NA |
| NBRJOBS_ASSGN_SALARY |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
POSITION_ASSIGNMENT_PAY |
NO |
NA |
| NBRJOBS_COAS_CODE_TS |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION AN_EMPLOYEE_POSITION |
TIMESHEET_CHART_OF_ACCOUNTS CHART_OF_ACCOUNTS |
NO NO |
NA |
| NBRJOBS_CONTRACT_NO |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
CONTRACT_NUMBER |
NO |
NA |
| NBRJOBS_DESC |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_SUPERVISOR AN_EMPLOYEE_POSITION AP_FACULTY_SABBATICAL_HISTORY |
POSITION_TITLE POSITION_TITLE POSITION_TITLE |
NO NO NO |
NA |
| NBRJOBS_DFPR_CODE |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
POSITION_DEFERRED_PAY |
NO |
NA |
| NBRJOBS_ECLS_CODE |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
POSITION_EMPLOYEE_CLASS |
NO |
NA |
| NBRJOBS_EFFECTIVE_DATE |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION AN_SUPERVISOR AN_EMPLOYEE_POSITION |
EFFECTIVE_START_DATE EFFECTIVE_DATE EFFECTIVE_DATE |
NO NO NO |
NA |
| NBRJOBS_EMPR_CODE |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
EMPLOYER_CODE |
NO |
NA |
| NBRJOBS_ENCUMBRANCE_HRS |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
ENCUMBRANCE_HOURS |
NO |
NA |
| NBRJOBS_FACTOR |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
ASSIGNMENT_FACTOR |
NO |
NA |
| NBRJOBS_FTE |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
FULL_TIME_EQUIVALENCY_PCT |
NO |
NA |
| NBRJOBS_HRS_DAY |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
HOURS_PER_DAY |
NO |
NA |
| NBRJOBS_HRS_PAY |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
HOURS_PER_PAY |
NO |
NA |
| NBRJOBS_JBLN_CODE |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
POSITION_LOCATION |
NO |
NA |
| NBRJOBS_JCRE_CODE |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
POSITION_CHANGE_REASON |
NO |
NA |
| NBRJOBS_LCAT_CODE |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
JOB_LEAVE_CATEGORY |
NO |
NA |
| NBRJOBS_LEAV_REPT_METHOD |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
LEAVE_REPORT_ENTRY_METHOD |
NO |
|
| NBRJOBS_LGCD_CODE |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
LONGEVITY_ELIGIBILITY |
NO |
|
| NBRJOBS_ORGN_CODE_TS |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
TIMESHEET_ORGANIZATION |
NO |
NA |
| NBRJOBS_PAYS |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
NUMBER_OF_PAYS |
NO |
NA |
| NBRJOBS_PCAT_CODE |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
PREMIUM_PAY_CATEGORY |
NO |
NA |
| NBRJOBS_PERS_CHG_DATE |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
POSITION_PERSONNEL_DATE |
NO |
NA |
| NBRJOBS_PERS_PAY_CODE |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
PUBLIC_RETIREMENT_PAY_RATE |
NO |
NA |
| NBRJOBS_PER_PAY_DEFER_AMT |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
DEFERRED_PAY_AMOUNT |
NO |
NA |
| NBRJOBS_PER_PAY_SALARY |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
PER_PAY_SALARY |
NO |
NA |
| NBRJOBS_PICT_CODE |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION AN_EMPLOYEE_POSITION |
ASSIGNMENT_PAY_ID PAY_CODE |
NO NO |
NA |
| NBRJOBS_PICT_CODE_LEAV_REPT |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
LEAVE_REPORT_PAYROLL_ID |
NO |
|
| NBRJOBS_POSN |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
POSITION |
NO |
NA |
| NBRJOBS_REG_RATE |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
HOURLY_RATE |
NO |
NA |
| NBRJOBS_SAL_GRADE |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
ASSIGNMENT_GRADE |
NO |
NA |
| NBRJOBS_SAL_STEP |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
ASSIGNMENT_STEP |
NO |
NA |
| NBRJOBS_SAL_TABLE |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
ASSIGNMENT_TABLE |
NO |
NA |
| NBRJOBS_SGRP_CODE |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
ASSIGNMENT_SALARY_GROUP |
NO |
NA |
| NBRJOBS_SHIFT |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
SHIFT |
NO |
NA |
| NBRJOBS_STATUS |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION AN_SUPERVISOR |
POSITION_STATUS POSITION_STATUS |
NO NO |
NA |
| NBRJOBS_STRS_ASSN_CODE |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
STATE_RETIREMENT_ASSIGNMENT |
NO |
NA |
| NBRJOBS_STRS_PAY_CODE |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
STATE_RETIREMENT_PAY_RATE |
NO |
NA |
| NBRJOBS_SUFF |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
JOB_SUFFIX |
NO |
NA |
| NBRJOBS_SUPERVISOR_PIDM |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
SUPERVISOR_UID |
NO |
NA |
| NBRJOBS_SUPERVISOR_POSN |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
SUPERVISOR_POSITION |
NO |
NA |
| NBRJOBS_SUPERVISOR_SUFF |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
SUPERVISOR_JOB_SUFFIX |
NO |
NA |
| NBRJOBS_TIME_ENTRY_METHOD |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
TIME_ENTRY_METHOD |
NO |
|
| NBRJOBS_TIME_ENTRY_TYPE |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
TIME_ENTRY_TYPE |
NO |
|
| NBRJOBS_TIME_IN_OUT_IND |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
TIME_IN_OUT_IND |
NO |
|
| NBRJOBS_USER_ID |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
USER_ID |
NO |
|
| NBRJOBS_WKCP_CODE |
NBAJOBS |
NO |
COMPOSITE VIEW |
AN_EMPLOYEE_POSITION |
WORKER_COMPENSATION_CLASS |
NO |
NA |