...
| TableName | COLUMN_NAME | data_type | MaxLength | Source_System | Source_Table | Source_Column_Name | MetaMart_Description | Notes_Logic | Meta _ Mart _LinkDescription | |
| dbo.SID_Instructional_Activity | TERMID | varchar | 8 | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | REPT_TIME_FRAME | Academic term (YYYYMM) to which the reported data applies | |||
| 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 | 01405 - Session Flag | |||
| dbo.SID_Instructional_Activity | CRS_PREFIX | varchar | 3 | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | CRS_PREFIX | 01195 - Common Course Prefix | |||
| dbo.SID_Instructional_Activity | CRS_NBR | varchar | 4 | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | CRS_NBR | 01196 - Common Course Number | |||
| dbo.SID_Instructional_Activity | CRS_IND | varchar | 1 | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | CRS_IND | 01003 - Common Course Outside Indicator | |||
| dbo.SID_Instructional_Activity | CRS_SECTN_NBR | varchar | 6 | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | CRS_SECTN_NBR | 01096 - Course Section Number | |||
| dbo.SID_Instructional_Activity | REF_NUM | varchar | 5 | DWHOUSE | HUB_INSTRUCT_ACT_CURR_V | COURSE_CRN_NUMBER | Course reference number. | |||
| dbo.SID_Instructional_Activity | CAMPUS_F | varchar | 4 | DWHOUSE | HUB_INSTRUCT_ACT_CURR_V | OPERATING_UNIT | Calculated: 0001,0003,0004,0012 - Operating Unit, either override or default. | |||
| dbo.SID_Instructional_Activity | CRS_SECTN_TYP_PRI | varchar | 1 | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | CRS_SECTN_TYP_PRI | 01289 - Primary Course Section Type | |||
| dbo.SID_Instructional_Activity | VAR_CRED_FLG | varchar | 1 | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | VAR_CRED_FLG | 01114 - Variable Credit Flag | |||
| dbo.SID_Instructional_Activity | CIP_CRS | varchar | 6 | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | CIP_CRS | 01098 - Course Program Category | |||
| dbo.SID_Instructional_Activity | BE_CD_CRS | varchar | 1 | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | BE_CD_CRS | 01100 - Course Budget Entity Code | |||
| dbo.SID_Instructional_Activity | DEPT_ID_CRS | varchar | 9 | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW VW | DEPT_ID_CRS | 01198 - Account/Department Number - Course | |||
| dbo.SID_Instructional_Activity | SECTN_ENROLL_CRED | numeric | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | SECTN_ENROLL_CRED | 01124 - Section Enrollment for Credit | ||||
| dbo.SID_Instructional_Activity | CRS_CRED_HRS | numeric | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | CRS_CRED_HRS | 01128 - Course Credit Hours | ||||
| dbo.SID_Instructional_Activity | ACT_SECTN_INSTR_HRS | numeric | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | ACT_SECTN_INSTR_HRS | 01113 - Actual Section Instruction Hours | ||||
| dbo.SID_Instructional_Activity | DELIVERY_IND | varchar | 1 | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | DELIVERY_IND | 01417 - Instructional Delivery Indicator | |||
| dbo.SID_Instructional_Activity | TECH_IND_PRIMARY | varchar | 1 | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | TECH_IND_PRIMARY | 01418 - Technology Delivery Indicator | |||
| dbo.SID_Instructional_Activity | TECH_IND_SECONDARY | varchar | 1 | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | TECH_IND_SECONDARY | 01418 - Technology Delivery Indicator | |||
| dbo.SID_Instructional_Activity | TECH_IND_TERTIARY | varchar | 1 | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | TECH_IND_TERTIARY | 01418 - Technology Delivery Indicator | |||
| dbo.SID_Instructional_Activity | COUNTRY_CD | varchar | 5 | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | COUNTRY_CD | 011703 - Country Code | |||
| dbo.SID_Instructional_Activity | SECTN_HEADCNT_ENROL | numeric | DWHOUSE | HUB_INSTRUCT_ACT_CURR_V | ENRL_COUNT | Calculated from count of Courses Taken | ||||
| dbo.SID_Instructional_Activity | TOTAL_CRS_CRED_HRS | numeric | DWHOUSE | COURSES COURSES_TAKEN_VW | STU_SECTN_FUND_CD | Calculated from Courses Taken01103 - Student Section Funding Flag | ||||
| dbo.SID_Instructional_Activity | FNDBL_CRS_CRED_HRS | numeric | DWHOUSE | HUB_CRSE_TAKEN_CURR_V | ST_FUND_CRED_HRS | Calculated from Courses Taken01286 - State Fundable Credit Hours | ||||
| dbo.SID_Instructional_Activity | FNDBL_GRAD_DOC_HRS | numeric | DWHOUSE | HUB_CRSE_TAKEN_CURR_V | ST_FUND_CRED_HRS | Calculated from Courses Taken01286 - State Fundable Credit Hours | ||||
| dbo.SID_Instructional_Activity | DOC_STU_GRAD_HRS | numeric | DWHOUSE | COURSES COURSES_TAKEN_VW | STU_SECTN_CRED | 01097 - Student Section Credit | ||||
| dbo.SID_Instructional_Activity | REPT_INST | varchar | 4 | DWHOUSE | INSTRUCTIONAL_ACTIVITY_VW | REPT_INST | 01045 - Reporting Institution | |||
| dbo.SID_Instructional_Activity | XLST_GROUP | varchar | 2 | DWHOUSE | HUB_INSTRUCT_ACT_CURR_V V | XLST_GROUP | Cross list group identifier number. | |||
| dbo.SID_Instructional_Activity | OPERATING_UNIT | varchar | 8 | DWHOUSE | HUB_INSTRUCT_ACT_CURR_V | OPERATING_UNIT | Operating Unit, either override or default. | |||
| dbo.SID_Instructional_Activity | FUND_CODE | varchar | 5 | DWHOUSE | HUB_INSTRUCT_ACT_CURR_V | FUND_CODE | Fund Code, either override or default. | |||
| dbo.SID_Instructional_Activity | DEPTID | varchar | 10 | DWHOUSE | HUB_INSTRUCT_ACT_CURR_V | DEPTID | Department, either override or default. | |||
| dbo.SID_Instructional_Activity | PRODUCT | varchar | 6 | DWHOUSE | HUB_INSTRUCT_ACT_CURR_V | PRODUCT | Product, either from override or default. | |||
| dbo.SID_Instructional_Activity | CHARTFIELD1 | varchar | 10 | DWHOUSE | HUB_INSTRUCT_ACT_CURR_V | CHARTFIELD1 | Initiative, either from override or default. | |||
| dbo.SID_Instructional_Activity | PROJECT_ID | varchar | 15 | DWHOUSE | HUB_INSTRUCT_ACT_CURR_V | PROJECT_ID | Project, either from override or default. | |||
| dbo.SID_Instructional_Activity | SRN | varchar | 20 | DWHOUSE | HUBINSTRUCTIONAL_CRSE_TAKEN_CURR_VACTIVITY_VW | DEPT_ID_CRS | 01198 - Account/Department Number - Course | |||
| dbo.SID_Instructional_Activity | Course_Title | varchar | 500 | DWHOUSE | HUB_INSTRUCT_ACT_CURR_V | COURSE_TITLE_NAME | Course Title | |||
| dbo.SID_Instructional_Activity | Eff_Section | decimal | DWHOUSE | COURSE 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 | Instructional Delivery Method | |||
| 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 – This field defines the attribute code of the section. | |||
| dbo.SID_Instructional_Activity | USF_Identifiers | varchar | 50 | PROD_RO | SSRATTR | Calculated: USF_Identifiers + 'W' | Derived from ATTR_CODE - This field defines the attribute code of the section. | |||
| dbo.SID_Instructional_Activity | FNDBL_CRS_CRED_HRS_AAR | numeric | DWHOUSE | COURSES COURSES_TAKEN_VW | STU_SECTN_CRED | Calculated from Courses Taken | ||||