Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 3 Current »

 

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_Link
dbo.SID_Instructional_ActivityTERMIDvarchar8DWHOUSEINSTRUCTIONAL_ACTIVITY_VW REPT_TIME_FRAME  
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  
dbo.SID_Instructional_ActivityCRS_PREFIXvarchar3DWHOUSEINSTRUCTIONAL_ACTIVITY_VW CRS_PREFIX  
dbo.SID_Instructional_ActivityCRS_NBRvarchar4DWHOUSEINSTRUCTIONAL_ACTIVITY_VW CRS_NBR  
dbo.SID_Instructional_ActivityCRS_INDvarchar1DWHOUSEINSTRUCTIONAL_ACTIVITY_VW CRS_IND  
dbo.SID_Instructional_ActivityCRS_SECTN_NBRvarchar6DWHOUSEINSTRUCTIONAL_ACTIVITY_VW CRS_SECTN_NBR  
dbo.SID_Instructional_ActivityREF_NUMvarchar5DWHOUSEHUB_INSTRUCT_ACT_CURR_V  COURSE_CRN_NUMBER  
dbo.SID_Instructional_ActivityCAMPUS_Fvarchar4DWHOUSEHUB_INSTRUCT_ACT_CURR_V  OPERATING_UNITCalculated: 0001,0003,0004,0012
dbo.SID_Instructional_ActivityCRS_SECTN_TYP_PRIvarchar1DWHOUSEINSTRUCTIONAL_ACTIVITY_VW CRS_SECTN_TYP_PRI  
dbo.SID_Instructional_ActivityVAR_CRED_FLGvarchar1DWHOUSEINSTRUCTIONAL_ACTIVITY_VW VAR_CRED_FLG  
dbo.SID_Instructional_ActivityCIP_CRSvarchar6DWHOUSEINSTRUCTIONAL_ACTIVITY_VW CIP_CRS  
dbo.SID_Instructional_ActivityBE_CD_CRSvarchar1DWHOUSEINSTRUCTIONAL_ACTIVITY_VW BE_CD_CRS  
dbo.SID_Instructional_ActivityDEPT_ID_CRSvarchar9DWHOUSEINSTRUCTIONAL_ACTIVITY_VW DEPT_ID_CRS  
dbo.SID_Instructional_ActivitySECTN_ENROLL_CREDnumeric DWHOUSEINSTRUCTIONAL_ACTIVITY_VW SECTN_ENROLL_CRED  
dbo.SID_Instructional_ActivityCRS_CRED_HRSnumeric DWHOUSEINSTRUCTIONAL_ACTIVITY_VW CRS_CRED_HRS  
dbo.SID_Instructional_ActivityACT_SECTN_INSTR_HRSnumeric DWHOUSEINSTRUCTIONAL_ACTIVITY_VW ACT_SECTN_INSTR_HRS  
dbo.SID_Instructional_ActivityDELIVERY_INDvarchar1DWHOUSEINSTRUCTIONAL_ACTIVITY_VW DELIVERY_IND  
dbo.SID_Instructional_ActivityTECH_IND_PRIMARYvarchar1DWHOUSEINSTRUCTIONAL_ACTIVITY_VW TECH_IND_PRIMARY  
dbo.SID_Instructional_ActivityTECH_IND_SECONDARYvarchar1DWHOUSEINSTRUCTIONAL_ACTIVITY_VW TECH_IND_SECONDARY  
dbo.SID_Instructional_ActivityTECH_IND_TERTIARYvarchar1DWHOUSEINSTRUCTIONAL_ACTIVITY_VW TECH_IND_TERTIARY  
dbo.SID_Instructional_ActivityCOUNTRY_CDvarchar5DWHOUSEINSTRUCTIONAL_ACTIVITY_VW COUNTRY_CD  
dbo.SID_Instructional_ActivitySECTN_HEADCNT_ENROLnumeric DWHOUSEHUB_INSTRUCT_ACT_CURR_V  ENRL_COUNTCalculated from Courses Taken
dbo.SID_Instructional_ActivityTOTAL_CRS_CRED_HRSnumeric DWHOUSE COURSES_TAKEN_VWSTU_SECTN_FUND_CDCalculated from Courses Taken
dbo.SID_Instructional_ActivityFNDBL_CRS_CRED_HRSnumeric DWHOUSEHUB_CRSE_TAKEN_CURR_VST_FUND_CRED_HRSCalculated from Courses Taken
dbo.SID_Instructional_ActivityFNDBL_GRAD_DOC_HRSnumeric DWHOUSEHUB_CRSE_TAKEN_CURR_VST_FUND_CRED_HRSCalculated from Courses Taken
dbo.SID_Instructional_ActivityDOC_STU_GRAD_HRSnumeric DWHOUSE COURSES_TAKEN_VWSTU_SECTN_CRED  
dbo.SID_Instructional_ActivityREPT_INSTvarchar4DWHOUSEINSTRUCTIONAL_ACTIVITY_VW REPT_INST  
dbo.SID_Instructional_ActivityXLST_GROUPvarchar2DWHOUSEHUB_INSTRUCT_ACT_CURR_V  XLST_GROUP  
dbo.SID_Instructional_ActivityOPERATING_UNITvarchar8DWHOUSEHUB_INSTRUCT_ACT_CURR_V  OPERATING_UNIT  
dbo.SID_Instructional_ActivityFUND_CODEvarchar5DWHOUSEHUB_INSTRUCT_ACT_CURR_V  FUND_CODE  
dbo.SID_Instructional_ActivityDEPTIDvarchar10DWHOUSEHUB_INSTRUCT_ACT_CURR_V  DEPTID  
dbo.SID_Instructional_ActivityPRODUCTvarchar6DWHOUSEHUB_INSTRUCT_ACT_CURR_V  PRODUCT  
dbo.SID_Instructional_ActivityCHARTFIELD1varchar10DWHOUSEHUB_INSTRUCT_ACT_CURR_V  CHARTFIELD1  
dbo.SID_Instructional_ActivityPROJECT_IDvarchar15DWHOUSEHUB_INSTRUCT_ACT_CURR_V  PROJECT_ID  
dbo.SID_Instructional_ActivitySRNvarchar20DWHOUSEHUB_CRSE_TAKEN_CURR_VDEPT_ID_CRS  
dbo.SID_Instructional_ActivityCourse_Titlevarchar500DWHOUSEHUB_INSTRUCT_ACT_CURR_V  COURSE_TITLE_NAME  
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  
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

 

 

  • No labels