This page documents the SID_Courses_Taken table which represents a composite of data from the Warehouse and Production Banner systems.
TableName | COLUMN_NAME | data_type | MaxLength | Source_System | Source_Table | Source_Column_Name | Notes_Logic | Meta_Mart_Link |
dbo.SID_Courses_Taken | TERMID | varchar | 8 | DWHOUSE | COURSES_TAKEN_VW | DEMO_TIME_FRAME | ||
dbo.SID_Courses_Taken | BENCH | varchar | 1 | Run-time parameter | N/A | @BENCH' (B, F, D, E) | Entered / passed at run-time in ETL | |
dbo.SID_Courses_Taken | UID | varchar | 9 | DWHOUSE | COURSES_TAKEN_VW | USF_ID | ||
dbo.SID_Courses_Taken | FEE_CLASS_KIND | varchar | 1 | DWHOUSE | COURSES_TAKEN_VW | FEE_CLASS_KIND | ||
dbo.SID_Courses_Taken | SEGMENT_SEQ | numeric | DWHOUSE | COURSES_TAKEN_VW | SEGMENT_SEQ | |||
dbo.SID_Courses_Taken | CRS_PREFIX | varchar | 3 | DWHOUSE | COURSES_TAKEN_VW | CRS_PREFIX | ||
dbo.SID_Courses_Taken | CRS_NBR | varchar | 4 | DWHOUSE | COURSES_TAKEN_VW | CRS_NBR | ||
dbo.SID_Courses_Taken | CRS_IND | varchar | 1 | DWHOUSE | COURSES_TAKEN_VW | CRS_IND | ||
dbo.SID_Courses_Taken | CRS_SECTN_NBR | varchar | 6 | DWHOUSE | COURSES_TAKEN_VW | CRS_SECTN_NBR | ||
dbo.SID_Courses_Taken | STU_SECTN_CRED | numeric | DWHOUSE | COURSES_TAKEN_VW | STU_SECTN_CRED | |||
dbo.SID_Courses_Taken | REF_NUM | varchar | 5 | DWHOUSE | COURSES_TAKEN_VW | U_RESV_1 | 5 characters starting in position 15 | |
dbo.SID_Courses_Taken | SESSION_ID | varchar | 1 | DWHOUSE | HUB_CRSE_TAKEN_CURR_V | SESSION_ID | ||
dbo.SID_Courses_Taken | CIP_CRS | varchar | 6 | DWHOUSE | COURSES_TAKEN_VW | CIP_CRS | ||
dbo.SID_Courses_Taken | CAMPUS_F | varchar | 4 | DWHOUSE | COURSES_TAKEN_VW | U_RESV_2 | Set to '0001' if = '0038' (Health Science Funded) | |
dbo.SID_Courses_Taken | CAMPUS_CD | varchar | 4 | DWHOUSE | COURSES_TAKEN_VW | CAMPUS_CD | ||
dbo.SID_Courses_Taken | SITE_NBR | varchar | 4 | DWHOUSE | COURSES_TAKEN_VW | SITE_NBR | ||
dbo.SID_Courses_Taken | CRS_SECTN_LOC_CNTY | varchar | 4 | DWHOUSE | COURSES_TAKEN_VW | CRS_SECTN_LOC_CNTY | ||
dbo.SID_Courses_Taken | BE_CD | varchar | 1 | DWHOUSE | COURSES_TAKEN_VW | BE_CD | ||
dbo.SID_Courses_Taken | CONT_COOP_ED_IND | varchar | 1 | DWHOUSE | COURSES_TAKEN_VW | CONT_COOP_ED_IND | ||
dbo.SID_Courses_Taken | GRADE_AWARDED | varchar | 2 | DWHOUSE | COURSES_TAKEN_VW | GRADE_AWARDED | ||
dbo.SID_Courses_Taken | STU_SECTN_FUND_CD | varchar | 1 | DWHOUSE | COURSES_TAKEN_VW | STU_SECTN_FUND_CD | ||
dbo.SID_Courses_Taken | COLLEGE | varchar | 2 | DWHOUSE | COURSES_TAKEN_VW | COLLEGE | ||
dbo.SID_Courses_Taken | CRS_SECTN_TYP_PRI | varchar | 1 | DWHOUSE | COURSES_TAKEN_VW | CRS_SECTN_TYP_PRI | ||
dbo.SID_Courses_Taken | PRELIM_FILE_FLG | varchar | 1 | DWHOUSE | COURSES_TAKEN_VW | PRELIM_FILE_FLG | ||
dbo.SID_Courses_Taken | INST_OUTSIDE_IND | varchar | 2 | DWHOUSE | COURSES_TAKEN_VW | INST_OUTSIDE_IND | ||
dbo.SID_Courses_Taken | DEPT_ID_CRS | varchar | 9 | DWHOUSE | COURSES_TAKEN_VW | DEPT_ID_CRS | ||
dbo.SID_Courses_Taken | HRS_SURCHARGE | numeric | DWHOUSE | HUB_CRSE_TAKEN_CURR_V | HRS_SURCHARGE | |||
dbo.SID_Courses_Taken | DIFF_TUITION_FLG | varchar | 1 | DWHOUSE | COURSES_TAKEN_VW | DIFF_TUITION_FLG | ||
dbo.SID_Courses_Taken | CRS_LEVEL_CLASS | varchar | 2 | DWHOUSE | HUB_CRSE_TAKEN_CURR_V | Calculated: 1,2,3,L,R,U | Derived from CRS_NBR | |
dbo.SID_Courses_Taken | ST_FUND_CRED_HRS | numeric | DWHOUSE | HUB_CRSE_TAKEN_CURR_V | ST_FUND_CRED_HRS | |||
dbo.SID_Courses_Taken | REPT_INST | varchar | 4 | Literal | Via Query | USF | Stored Procedure - Proc-DataLoad_SID | |
dbo.SID_Courses_Taken | CRSE_DEPT_CODE | varchar | 4 | DWHOUSE | HUB_CRSE_TAKEN_CURR_V | CRSE_DEPT_CODE | ||
dbo.SID_Courses_Taken | OVRR_DEPT_CODE | varchar | 4 | DWHOUSE | HUB_CRSE_TAKEN_CURR_V | OVRR_DEPT_CODE | ||
dbo.SID_Courses_Taken | OPERATING_UNIT | varchar | 8 | DWHOUSE | HUB_CRSE_TAKEN_CURR_V | OPERATING_UNIT | ||
dbo.SID_Courses_Taken | FUND_CODE | varchar | 5 | DWHOUSE | HUB_CRSE_TAKEN_CURR_V | FUND_CODE | ||
dbo.SID_Courses_Taken | DEPTID | varchar | 10 | DWHOUSE | HUB_CRSE_TAKEN_CURR_V | DEPTID | ||
dbo.SID_Courses_Taken | PRODUCT | varchar | 6 | DWHOUSE | HUB_CRSE_TAKEN_CURR_V | PRODUCT | ||
dbo.SID_Courses_Taken | CHARTFIELD1 | varchar | 50 | DWHOUSE | HUB_CRSE_TAKEN_CURR_V | CHARTFIELD1 | ||
dbo.SID_Courses_Taken | PROJECT_ID | varchar | 15 | DWHOUSE | HUB_CRSE_TAKEN_CURR_V | PROJECT_ID | ||
dbo.SID_Courses_Taken | STAFF_WAIVED_HRS | numeric | DWHOUSE | HUB_CRSE_TAKEN_CURR_V | STAFF_WAIVED_HRS | |||
dbo.SID_Courses_Taken | OASIS_PIDM | float | DWHOUSE | HUB_CRSE_TAKEN_CURR_V | OASIS_PIDM | |||
dbo.SID_Courses_Taken | SRN | varchar | 20 | DWHOUSE | HUB_CRSE_TAKEN_CURR_V | DEPT_ID_CRS | ||
dbo.SID_Courses_Taken | Fee_Class_Res | varchar | 1 | DWHOUSE | ENROLLMENTS_VW | Fee_Class_Res | Load indirectly from SID_Enrollments | |
dbo.SID_Courses_Taken | Bldg_Code_Org | nvarchar | 50 | DWHOUSE | HUB_CRSE_TAKEN_CURR_V | Bldg_Code_Org |