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.
TableName | COLUMN_NAME | data_type | MaxLength | Source_System | Source_Table | Source_Column_Name | MetaMart_Description | Notes_Logic | Meta_Mart_Link |
dbo.SID_Instructional_Activity | TERMID | varchar | 8 | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | REPT_TIME_FRAME | |||
dbo.SID_Instructional_Activity | BENCH | varchar | 1 | Run-time parameter | N/A | @BENCH' (B, F, D, E) | N/A | Entered / passed through at run-time in ETL | |
dbo.SID_Instructional_Activity | SESSION_ID | varchar | 1 | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | SESSION_ID | |||
dbo.SID_Instructional_Activity | CRS_PREFIX | varchar | 3 | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | CRS_PREFIX | |||
dbo.SID_Instructional_Activity | CRS_NBR | varchar | 4 | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | CRS_NBR | |||
dbo.SID_Instructional_Activity | CRS_IND | varchar | 1 | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | CRS_IND | |||
dbo.SID_Instructional_Activity | CRS_SECTN_NBR | varchar | 6 | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | CRS_SECTN_NBR | |||
dbo.SID_Instructional_Activity | REF_NUM | varchar | 5 | DWHOUSE | HUB_INSTRUCT_ACT_CURR_V | COURSE_CRN_NUMBER | |||
dbo.SID_Instructional_Activity | CAMPUS_F | varchar | 4 | DWHOUSE | HUB_INSTRUCT_ACT_CURR_V | OPERATING_UNIT | Calculated: 0001,0003,0004,0012 | ||
dbo.SID_Instructional_Activity | CRS_SECTN_TYP_PRI | varchar | 1 | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | CRS_SECTN_TYP_PRI | |||
dbo.SID_Instructional_Activity | VAR_CRED_FLG | varchar | 1 | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | VAR_CRED_FLG | |||
dbo.SID_Instructional_Activity | CIP_CRS | varchar | 6 | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | CIP_CRS | |||
dbo.SID_Instructional_Activity | BE_CD_CRS | varchar | 1 | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | BE_CD_CRS | |||
dbo.SID_Instructional_Activity | DEPT_ID_CRS | varchar | 9 | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | DEPT_ID_CRS | |||
dbo.SID_Instructional_Activity | SECTN_ENROLL_CRED | numeric | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | SECTN_ENROLL_CRED | ||||
dbo.SID_Instructional_Activity | CRS_CRED_HRS | numeric | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | CRS_CRED_HRS | ||||
dbo.SID_Instructional_Activity | ACT_SECTN_INSTR_HRS | numeric | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | ACT_SECTN_INSTR_HRS | ||||
dbo.SID_Instructional_Activity | DELIVERY_IND | varchar | 1 | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | DELIVERY_IND | |||
dbo.SID_Instructional_Activity | TECH_IND_PRIMARY | varchar | 1 | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | TECH_IND_PRIMARY | |||
dbo.SID_Instructional_Activity | TECH_IND_SECONDARY | varchar | 1 | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | TECH_IND_SECONDARY | |||
dbo.SID_Instructional_Activity | TECH_IND_TERTIARY | varchar | 1 | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | TECH_IND_TERTIARY | |||
dbo.SID_Instructional_Activity | COUNTRY_CD | varchar | 5 | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | COUNTRY_CD | |||
dbo.SID_Instructional_Activity | SECTN_HEADCNT_ENROL | numeric | DWHOUSE | HUB_INSTRUCT_ACT_CURR_V | ENRL_COUNT | Calculated from Courses Taken | |||
dbo.SID_Instructional_Activity | TOTAL_CRS_CRED_HRS | numeric | DWHOUSE | COURSES_TAKEN_VW | STU_SECTN_FUND_CD | Calculated from Courses Taken | |||
dbo.SID_Instructional_Activity | FNDBL_CRS_CRED_HRS | numeric | DWHOUSE | HUB_CRSE_TAKEN_CURR_V | ST_FUND_CRED_HRS | Calculated from Courses Taken | |||
dbo.SID_Instructional_Activity | FNDBL_GRAD_DOC_HRS | numeric | DWHOUSE | HUB_CRSE_TAKEN_CURR_V | ST_FUND_CRED_HRS | Calculated from Courses Taken | |||
dbo.SID_Instructional_Activity | DOC_STU_GRAD_HRS | numeric | DWHOUSE | COURSES_TAKEN_VW | STU_SECTN_CRED | ||||
dbo.SID_Instructional_Activity | REPT_INST | varchar | 4 | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | REPT_INST | |||
dbo.SID_Instructional_Activity | XLST_GROUP | varchar | 2 | DWHOUSE | HUB_INSTRUCT_ACT_CURR_V | XLST_GROUP | |||
dbo.SID_Instructional_Activity | OPERATING_UNIT | varchar | 8 | DWHOUSE | HUB_INSTRUCT_ACT_CURR_V | OPERATING_UNIT | |||
dbo.SID_Instructional_Activity | FUND_CODE | varchar | 5 | DWHOUSE | HUB_INSTRUCT_ACT_CURR_V | FUND_CODE | |||
dbo.SID_Instructional_Activity | DEPTID | varchar | 10 | DWHOUSE | HUB_INSTRUCT_ACT_CURR_V | DEPTID | |||
dbo.SID_Instructional_Activity | PRODUCT | varchar | 6 | DWHOUSE | HUB_INSTRUCT_ACT_CURR_V | PRODUCT | |||
dbo.SID_Instructional_Activity | CHARTFIELD1 | varchar | 10 | DWHOUSE | HUB_INSTRUCT_ACT_CURR_V | CHARTFIELD1 | |||
dbo.SID_Instructional_Activity | PROJECT_ID | varchar | 15 | DWHOUSE | HUB_INSTRUCT_ACT_CURR_V | PROJECT_ID | |||
dbo.SID_Instructional_Activity | SRN | varchar | 20 | DWHOUSE | HUB_CRSE_TAKEN_CURR_V | DEPT_ID_CRS | |||
dbo.SID_Instructional_Activity | Course_Title | varchar | 500 | DWHOUSE | HUB_INSTRUCT_ACT_CURR_V | COURSE_TITLE_NAME | |||
dbo.SID_Instructional_Activity | Eff_Section | decimal | DWHOUSE | COURSE_MEETINGS_VW | Calculated: 1.0 / Count of course meetings? | Indirectly from SID_Course_Meetings via SPROC PROC_DataLoad_GenerateEffCourseSections | |||
dbo.SID_Instructional_Activity | Timestamp | datetime | SQL | Database | Timestamp | ||||
dbo.SID_Instructional_Activity | Delivery_Methd_Ind | nvarchar | 2 | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | Delivery_Methd_Ind | |||
dbo.SID_Instructional_Activity | Flag_Online_Course | varchar | 1 | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | Calculated: Y or N | Derived from TECH_IND_PRIMARY, TECH_IND_SECONDARY, TECH_IND_TERTIARY | ||
dbo.SID_Instructional_Activity | Flag_FKL_Course | varchar | 1 | PROD_RO | SSRATTR | Calculated: Y or N | Derived from ATTR_CODE | ||
dbo.SID_Instructional_Activity | USF_Identifiers | varchar | 50 | PROD_RO | SSRATTR | Calculated: USF_Identifiers + 'W' | Derived from ATTR_CODE | ||
dbo.SID_Instructional_Activity | FNDBL_CRS_CRED_HRS_AAR | numeric | DWHOUSE | COURSES_TAKEN_VW | STU_SECTN_CRED | Calculated from Courses Taken |