SID Courses Taken

Owned by Michael Harvey (Deactivated)
Last updated: Sept 21, 2018
2 min read

 

This page documents the SID_Courses_Taken table which represents a composite of data from the Warehouse and Production Banner systems. 

 

TableNameCOLUMN_NAMEdata_typeMaxLengthSource_SystemSource_TableSource_Column_NameNotes_LogicMeta Mart Description
dbo.SID_Courses_TakenTERMIDvarchar8DWHOUSE COURSES_TAKEN_VWDEMO_TIME_FRAME Academic term (YYYYMM) in which the demographic data is reported.
dbo.SID_Courses_TakenBENCHvarchar1Run-time parameterN/A@BENCH' (B, F, D, E)

Entered / passed at run-time

in ETL

dbo.SID_Courses_TakenUIDvarchar9DWHOUSE COURSES_TAKEN_VWUSF_ID This field holds the OASIS U-ID.
dbo.SID_Courses_TakenFEE_CLASS_KINDvarchar1DWHOUSE COURSES_TAKEN_VWFEE_CLASS_KIND 01107 - Fee Classification - Kind.
dbo.SID_Courses_TakenSEGMENT_SEQnumeric DWHOUSE COURSES_TAKEN_VW SEGMENT_SEQ Segment Counter
dbo.SID_Courses_TakenCRS_PREFIXvarchar3DWHOUSE COURSES_TAKEN_VW CRS_PREFIX 01195 - Common Course Prefix
dbo.SID_Courses_TakenCRS_NBRvarchar4DWHOUSE COURSES_TAKEN_VW CRS_NBR 01196 - Common Course Number
dbo.SID_Courses_TakenCRS_INDvarchar1DWHOUSE COURSES_TAKEN_VW CRS_IND 01003 - Common Course Outside Indicator
dbo.SID_Courses_TakenCRS_SECTN_NBRvarchar6DWHOUSE COURSES_TAKEN_VW CRS_SECTN_NBR 01096 - Course Section Number
dbo.SID_Courses_TakenSTU_SECTN_CREDnumeric DWHOUSE COURSES_TAKEN_VW STU_SECTN_CRED 01097 - Student Section Credit
dbo.SID_Courses_TakenREF_NUMvarchar5DWHOUSE COURSES_TAKEN_VW U_RESV_1

5 characters starting

in position 15

dbo.SID_Courses_TakenSESSION_IDvarchar1DWHOUSEHUB_CRSE_TAKEN_CURR_V  SESSION_ID Session ID (used internally in the hub and not sent to BOG)
dbo.SID_Courses_TakenCIP_CRSvarchar6DWHOUSE COURSES_TAKEN_VW CIP_CRS 01098 - Course Program Category
dbo.SID_Courses_TakenCAMPUS_Fvarchar4DWHOUSE COURSES_TAKEN_VW U_RESV_2

Set to '0001' if = '0038'

(Health Science Funded)

dbo.SID_Courses_TakenCAMPUS_CDvarchar4DWHOUSE COURSES_TAKEN_VW CAMPUS_CD 01099 - Course Section Location - Campus
dbo.SID_Courses_TakenSITE_NBRvarchar4DWHOUSE COURSES_TAKEN_VW SITE_NBR The official number that serves to uniquely identify the site within the university
dbo.SID_Courses_TakenCRS_SECTN_LOC_CNTYvarchar4DWHOUSE COURSES_TAKEN_VW CRS_SECTN_LOC_CNTY 01127 - Course Section Location - County
dbo.SID_Courses_TakenBE_CDvarchar1DWHOUSE COURSES_TAKEN_VW BE_CD 01100 - Course Budget Entity Code
dbo.SID_Courses_TakenCONT_COOP_ED_INDvarchar1DWHOUSE COURSES_TAKEN_VW CONT_COOP_ED_IND 01101 - Continuing and Cooperative Education Flag
dbo.SID_Courses_TakenGRADE_AWARDEDvarchar2DWHOUSE COURSES_TAKEN_VW GRADE_AWARDED 01102 - Grade Awarded
dbo.SID_Courses_TakenSTU_SECTN_FUND_CDvarchar1DWHOUSE COURSES_TAKEN_VW STU_SECTN_FUND_CD 01103 - Student Section Funding Flag
dbo.SID_Courses_TakenCOLLEGEvarchar2DWHOUSE COURSES_TAKEN_VW COLLEGE 01507 - College (Subcomponent)
dbo.SID_Courses_TakenCRS_SECTN_TYP_PRIvarchar1DWHOUSE COURSES_TAKEN_VW CRS_SECTN_TYP_PRI 01289 - Primary Course Section Type
dbo.SID_Courses_TakenPRELIM_FILE_FLGvarchar1DWHOUSE COURSES_TAKEN_VW PRELIM_FILE_FLG 01105 - Preliminary File Flag
dbo.SID_Courses_TakenINST_OUTSIDE_INDvarchar2DWHOUSE COURSES_TAKEN_VW INST_OUTSIDE_IND 01010 - Institutional Outside Indicator
dbo.SID_Courses_TakenDEPT_ID_CRSvarchar9DWHOUSE COURSES_TAKEN_VW DEPT_ID_CRS 01198 - Account/Department Number - Course
dbo.SID_Courses_TakenHRS_SURCHARGEnumeric *Unknown*Unknown*Unknown All values are NULL in data - currently not populated.
dbo.SID_Courses_TakenDIFF_TUITION_FLGvarchar1DWHOUSE COURSES_TAKEN_VW DIFF_TUITION_FLG 01359 - Differential Tuition Flag
dbo.SID_Courses_TakenCRS_LEVEL_CLASSvarchar2DWHOUSEHUB_CRSE_TAKEN_CURR_VCalculated: 1,2,3,L,R,UDerived from CRS_NBRCommon Course Number
dbo.SID_Courses_TakenST_FUND_CRED_HRSnumeric DWHOUSEHUB_CRSE_TAKEN_CURR_VST_FUND_CRED_HRS_BOG State Fundable credit hours
dbo.SID_Courses_TakenREPT_INSTvarchar4LiteralVia QueryUSF 

Stored Procedure -

Proc-DataLoad_SID

dbo.SID_Courses_TakenCRSE_DEPT_CODEvarchar4DWHOUSEHUB_CRSE_TAKEN_CURR_VCRSE_DEPT_CODE Department offering the course
dbo.SID_Courses_TakenOVRR_DEPT_CODEvarchar4DWHOUSEHUB_CRSE_TAKEN_CURR_VOVRR_DEPT_CODE Schedule Override department code
dbo.SID_Courses_TakenOPERATING_UNITvarchar8DWHOUSEHUB_CRSE_TAKEN_CURR_V  OPERATING_UNIT Operating Unit, either override or default.
dbo.SID_Courses_TakenFUND_CODEvarchar5DWHOUSEHUB_CRSE_TAKEN_CURR_V  FUND_CODE Fund Code, either override or default.
dbo.SID_Courses_TakenDEPTIDvarchar10DWHOUSEHUB_CRSE_TAKEN_CURR_V  DEPTID  Department, either override or default.
dbo.SID_Courses_TakenPRODUCTvarchar6DWHOUSEHUB_CRSE_TAKEN_CURR_V  PRODUCT Product, either from override or default.
dbo.SID_Courses_TakenCHARTFIELD1varchar50DWHOUSEHUB_CRSE_TAKEN_CURR_V  CHARTFIELD1 Initiative, either from override or default.
dbo.SID_Courses_TakenPROJECT_IDvarchar15DWHOUSEHUB_CRSE_TAKEN_CURR_V  PROJECT_ID Project, either from override or default
dbo.SID_Courses_TakenSTAFF_WAIVED_HRSnumeric DWHOUSEHUB_CRSE_TAKEN_CURR_V  STAFF_WAIVED_HRS Number of credit hours waived
dbo.SID_Courses_TakenOASIS_PIDMfloat DWHOUSEHUB_CRSE_TAKEN_CURR_V  OASIS_PIDM This field holds the oasis internal identification number.
dbo.SID_Courses_TakenSRNvarchar20DWHOUSECOURSES_TAKEN_VW DEPT_ID_CRS 01198 - Account/Department Number - Course
dbo.SID_Courses_TakenFee_Class_Resvarchar1DWHOUSEENROLLMENTS_VW Fee_Class_Res

Load indirectly from 01106 - Fee Classification - Residency

SID_Enrollments

dbo.SID_Courses_TakenBldg_Code_Orgnvarchar50DWHOUSEHUB_CRSE_TAKEN_CURR_V  Bldg_Code_Org Building code where course is offered