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