Faculty_Load table

Each record shows information about a particular CRN in regards to the faculty member assigned to it. There are multiple records per Term per Faculty member and possibly per CRN. This table was created for use by the Faculty_Load report, which is based on the Access report “Faculty Load – Version C” in Faculty_contract.mdb.

Oracle source: ReportsNet. FACULTY_LOAD view

Oracle objects: BANINST1.COS_SV_FACULTY_LOAD_NEW (SIRASGN, SSBSECT, SSRMEET, SSRXLST, SPRIDEN,

SPBPERS, SCBCRSE, SCRSCHD, STVTERM, SIRICINT)

Updated: nightly

Oracle Field/Calc	DW Field	Description or Sample
FAC_DEPT	FAC_DEPT
substr(f_get_cntr_desc(fl.fac_dept),1,30)	FAC_DEPT_DESC
fl.SSBSECT_TERM_CODE	TERM
fl.STVTERM_DESC	SEMESTER
fl.SIRASGN_FCNT_CODE	FCNT_CODE
substr(f_get_fcnt_desc(fl.sirasgn_fcnt_code),1,30)	FCNT_DESC
fl.SPRIDEN_LAST_NAME	LAST_NAME
fl.SPRIDEN_FIRST_NAME	FIRST_NAME
fl.SPBPERS_SSN	SSN	(to be removed)
fl.SPRIDEN_ID	FACULTYID
fl.SSBSECT_CRN	CRN
fl.SSBSECT_SUBJ_CODE	SUBJECT
fl.SSBSECT_CRSE_NUMB	COURSENUMBER
fl.SSBSECT_PTRM_CODE	PTRM_CODE
fl.SSBSECT_PTRM_WEEKS	PTRM_WEEKS
nvl(LAB_HOURS, 0)	LAB_HOURS
nvl(LEC_HOURS, 0)	LEC_HOURS
nvl(OTH_HOURS, 0)	OTH_HOURS
(nvl(LEC_HOURS, 0)+(nvl(LAB_HOURS, 0)0.75)+(nvl(OTH_HOURS, 0)0.7))*fl.SIRASGN_PERCENT_RESPONSE/100	CALC_WORK_LOAD
decode(SIRASGN_WORKLOAD_ADJUST, null,(SCRSCHD_WORKLOADSIRASGN_PERCENT_RESPONSE/100), (SIRASGN_WORKLOAD_ADJUSTSIRASGN_PERCENT_RESPONSE/100))	LHE
decode(SIRASGN_WORKLOAD_ADJUST, null,(SCRSCHD_WORKLOADSIRASGN_PERCENT_RESPONSE/100), (SIRASGN_WORKLOAD_ADJUSTSIRASGN_PERCENT_RESPONSE/100))/15	FTE
fl.SSBSECT_ACCT_CODE	ACCT_CODE
fl.SSBSECT_SCHD_CODE	SCHD_CODE_SSBSECT
fl.SIRASGN_PERCENT_RESPONSE	SIRASGN_PERCENT_RESPONSE
SIRASGN_WORKLOAD_ADJUST	SIRASGN_WORKLOAD_ADJUST
fl.SSBSECT_ENRL	ENRL
summ.re_assgn	RE_ASSIGN
case when nvl(SUM_WL, 0)>0 then (sum_wl/15) end	RE_ASSIGN_SUM_FTE
summ.Other_assgn	OTHER_ASSIGN
fl.SSBSECT_INSM_CODE	INSM_CODE_SSBSECT
fl.SSRXLST_XLST_GROUP	XLST_GROUP
fl.CAMPUS	CAMPUS