SID Instructional Activity

Owned by Michael Harvey (Deactivated)
Last updated: Sept 20, 2018
1 min read

 

This page documents the SID_Instructional_Activity table which is a composite of data representing instructional-related activities from data in the Data Warehouse and Production Banner databases.

 

TableNameCOLUMN_NAMEdata_typeMaxLengthSource_SystemSource_TableSource_Column_NameNotes_LogicMeta Mart Description
dbo.SID_Instructional_ActivityTERMIDvarchar8DWHOUSEINSTRUCTIONAL_ACTIVITY_VW REPT_TIME_FRAME Academic term (YYYYMM) to which the reported data applies
dbo.SID_Instructional_ActivityBENCHvarchar1Run-time parameterN/A@BENCH' (B, F, D, E)Entered / passed through at run-time in ETL
dbo.SID_Instructional_ActivitySESSION_IDvarchar1DWHOUSEINSTRUCTIONAL_ACTIVITY_VW SESSION_ID 01405 - Session Flag
dbo.SID_Instructional_ActivityCRS_PREFIXvarchar3DWHOUSEINSTRUCTIONAL_ACTIVITY_VW CRS_PREFIX 01195 - Common Course Prefix
dbo.SID_Instructional_ActivityCRS_NBRvarchar4DWHOUSEINSTRUCTIONAL_ACTIVITY_VW CRS_NBR 01196 - Common Course Number
dbo.SID_Instructional_ActivityCRS_INDvarchar1DWHOUSEINSTRUCTIONAL_ACTIVITY_VW CRS_IND 01003 - Common Course Outside Indicator
dbo.SID_Instructional_ActivityCRS_SECTN_NBRvarchar6DWHOUSEINSTRUCTIONAL_ACTIVITY_VW CRS_SECTN_NBR 01096 - Course Section Number
dbo.SID_Instructional_ActivityREF_NUMvarchar5DWHOUSEHUB_INSTRUCT_ACT_CURR_V  COURSE_CRN_NUMBER Course reference number.
dbo.SID_Instructional_ActivityCAMPUS_Fvarchar4DWHOUSEHUB_INSTRUCT_ACT_CURR_V  OPERATING_UNITCalculated: 0001,0003,0004,0012 - Operating Unit, either override or default.
dbo.SID_Instructional_ActivityCRS_SECTN_TYP_PRIvarchar1DWHOUSEINSTRUCTIONAL_ACTIVITY_VW CRS_SECTN_TYP_PRI 01289 - Primary Course Section Type
dbo.SID_Instructional_ActivityVAR_CRED_FLGvarchar1DWHOUSEINSTRUCTIONAL_ACTIVITY_VW VAR_CRED_FLG 01114 - Variable Credit Flag
dbo.SID_Instructional_ActivityCIP_CRSvarchar6DWHOUSEINSTRUCTIONAL_ACTIVITY_VW CIP_CRS 01098 - Course Program Category
dbo.SID_Instructional_ActivityBE_CD_CRSvarchar1DWHOUSEINSTRUCTIONAL_ACTIVITY_VW BE_CD_CRS 01100 - Course Budget Entity Code
dbo.SID_Instructional_ActivityDEPT_ID_CRSvarchar9DWHOUSEINSTRUCTIONAL_ACTIVITY_VW DEPT_ID_CRS 01198 - Account/Department Number - Course
dbo.SID_Instructional_ActivitySECTN_ENROLL_CREDnumeric DWHOUSEINSTRUCTIONAL_ACTIVITY_VW SECTN_ENROLL_CRED 01124 - Section Enrollment for Credit
dbo.SID_Instructional_ActivityCRS_CRED_HRSnumeric DWHOUSEINSTRUCTIONAL_ACTIVITY_VW CRS_CRED_HRS 01128 - Course Credit Hours
dbo.SID_Instructional_ActivityACT_SECTN_INSTR_HRSnumeric DWHOUSEINSTRUCTIONAL_ACTIVITY_VW ACT_SECTN_INSTR_HRS 01113 - Actual Section Instruction Hours
dbo.SID_Instructional_ActivityDELIVERY_INDvarchar1DWHOUSEINSTRUCTIONAL_ACTIVITY_VW DELIVERY_IND 01417 - Instructional Delivery Indicator
dbo.SID_Instructional_ActivityTECH_IND_PRIMARYvarchar1DWHOUSEINSTRUCTIONAL_ACTIVITY_VW TECH_IND_PRIMARY 01418 - Technology Delivery Indicator
dbo.SID_Instructional_ActivityTECH_IND_SECONDARYvarchar1DWHOUSEINSTRUCTIONAL_ACTIVITY_VW TECH_IND_SECONDARY 01418 - Technology Delivery Indicator
dbo.SID_Instructional_ActivityTECH_IND_TERTIARYvarchar1DWHOUSEINSTRUCTIONAL_ACTIVITY_VW TECH_IND_TERTIARY 01418 - Technology Delivery Indicator
dbo.SID_Instructional_ActivityCOUNTRY_CDvarchar5DWHOUSEINSTRUCTIONAL_ACTIVITY_VW COUNTRY_CD 011703 - Country Code
dbo.SID_Instructional_ActivitySECTN_HEADCNT_ENROLnumeric DWHOUSEHUB_INSTRUCT_ACT_CURR_V  ENRL_COUNTCalculated from count of Courses Taken
dbo.SID_Instructional_ActivityTOTAL_CRS_CRED_HRSnumeric DWHOUSE COURSES_TAKEN_VWSTU_SECTN_FUND_CD01103 - Student Section Funding Flag
dbo.SID_Instructional_ActivityFNDBL_CRS_CRED_HRSnumeric DWHOUSEHUB_CRSE_TAKEN_CURR_VST_FUND_CRED_HRSCalculated from 01286 - State Fundable Credit Hours
dbo.SID_Instructional_ActivityFNDBL_GRAD_DOC_HRSnumeric DWHOUSEHUB_CRSE_TAKEN_CURR_VST_FUND_CRED_HRSCalculated from 01286 - State Fundable Credit Hours
dbo.SID_Instructional_ActivityDOC_STU_GRAD_HRSnumeric DWHOUSE COURSES_TAKEN_VWSTU_SECTN_CRED 01097 - Student Section Credit
dbo.SID_Instructional_ActivityREPT_INSTvarchar4DWHOUSEINSTRUCTIONAL_ACTIVITY_VW REPT_INST 01045 - Reporting Institution
dbo.SID_Instructional_ActivityXLST_GROUPvarchar2DWHOUSEHUB_INSTRUCT_ACT_CURR_V  XLST_GROUP Cross list group identifier number.
dbo.SID_Instructional_ActivityOPERATING_UNITvarchar8DWHOUSEHUB_INSTRUCT_ACT_CURR_V  OPERATING_UNIT Operating Unit, either override or default.
dbo.SID_Instructional_ActivityFUND_CODEvarchar5DWHOUSEHUB_INSTRUCT_ACT_CURR_V  FUND_CODE Fund Code, either override or default.
dbo.SID_Instructional_ActivityDEPTIDvarchar10DWHOUSEHUB_INSTRUCT_ACT_CURR_V  DEPTID Department, either override or default.
dbo.SID_Instructional_ActivityPRODUCTvarchar6DWHOUSEHUB_INSTRUCT_ACT_CURR_V  PRODUCT Product, either from override or default.
dbo.SID_Instructional_ActivityCHARTFIELD1varchar10DWHOUSEHUB_INSTRUCT_ACT_CURR_V  CHARTFIELD1 Initiative, either from override or default.
dbo.SID_Instructional_ActivityPROJECT_IDvarchar15DWHOUSEHUB_INSTRUCT_ACT_CURR_V  PROJECT_ID Project, either from override or default.
dbo.SID_Instructional_ActivitySRNvarchar20DWHOUSEINSTRUCTIONAL_ACTIVITY_VWDEPT_ID_CRS 01198 - Account/Department Number - Course
dbo.SID_Instructional_ActivityCourse_Titlevarchar500DWHOUSEHUB_INSTRUCT_ACT_CURR_V  COURSE_TITLE_NAME Course Title
dbo.SID_Instructional_ActivityEff_Sectiondecimal DWHOUSE COURSE_MEETINGS_VWCalculated: 1.0 / Count of course meetings?Indirectly from SID_Course_Meetings via SPROC PROC_DataLoad_GenerateEffCourseSections
dbo.SID_Instructional_ActivityTimestampdatetime SQL DatabaseTimestamp  
dbo.SID_Instructional_ActivityDelivery_Methd_Indnvarchar2DWHOUSEINSTRUCTIONAL_ACTIVITY_VW Delivery_Methd_Ind Instructional Delivery Method
dbo.SID_Instructional_ActivityFlag_Online_Coursevarchar1DWHOUSEINSTRUCTIONAL_ACTIVITY_VW Calculated: Y or NDerived from TECH_IND_PRIMARY, TECH_IND_SECONDARY, TECH_IND_TERTIARY
dbo.SID_Instructional_ActivityFlag_FKL_Coursevarchar1PROD_ROSSRATTRCalculated: Y or NDerived from ATTR_CODE – This field defines the attribute code of the section.
dbo.SID_Instructional_ActivityUSF_Identifiersvarchar50PROD_ROSSRATTRCalculated: USF_Identifiers + 'W'Derived from ATTR_CODE - This field defines the attribute code of the section.
dbo.SID_Instructional_ActivityFNDBL_CRS_CRED_HRS_AARnumeric DWHOUSE COURSES_TAKEN_VWSTU_SECTN_CREDCalculated from Courses Taken