Composite View Source: NBRJOBS

Go To View:	RETURN TO COMPOSITE VIEW REPORTS LIST
	Reporting View Source: NBRJOBS Human Resources

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

Ver: