Reporting View Source: NBRJOBS

Go To View:	RETURN TO REPORTING VIEW REPORTS LIST
	Composite View Source: NBRJOBS Human Resources Reporting View Meta Data Reports

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

Ver: 8.5