Go To View:  RETURN TO COMPOSITE VIEW REPORTS LIST
Reporting View Source: NBRJOBS Human Resources
SGHE Banner Operational Data Store Composite View Source: NBRJOBS - NULL

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: