EIS Student CUBE Documentation - Courses Taken.
- Michael Harvey (Deactivated)
Owned by Michael Harvey (Deactivated)
Mar 13, 2019
Loading data...
Dimensions.
| Cube Name | Dimension Unique Name | Description |
|---|---|---|
| Course Taken | Course Org Department Hierarchy | |
| Course Taken | Course Org Unit College Hierarchy | |
| Course Taken | Flag Org Unit Academic | Identifies if the course unit is academic or not. |
| Course Taken | Org Unit Campus | Unique campus name, for cross system use |
| Course Taken | Org Unit College | Unique College Code, similar to banner for College by campus |
| Course Taken | Org Unit College Group | Grouping to identify Health vs Non-Health colleges |
| Course Taken | Org Unit Department | Unique College Department Code |
| Course Taken | Course CIP | Course CIP Code. Classification associated with the major emphasis of the course program category or other activity. The codes are based on the Classification of Instructional Programs (CIP) compiled by the National Center for Educational Statistics (NCES). |
| Course Taken | Course CIP Group | Course CIP group identified by using the leading two characters of the entire program CIP. |
| Course Taken | Course CIP Hierarchy | |
| Course Taken | Course CIP Title | Course CIP Title. Classification associated with the major emphasis of the course program category or other activity. The codes are based on the Classification of Instructional Programs (CIP) compiled by the National Center for Educational Statistics (NCES). |
| Course Taken | Course Days In Week Meeting | Course Days In Week Meeting |
| Course Taken | Course Delivery Method | A classification of a course based on the delivery of direct instruction. Full Distance Learning Course. Full Distance Learning Course - 100% of the direct instruction of the course is delivered using some form of technology when the student and instructor are separated by time, space, or both. All special course components (exams, internships, practica, clinicals, labs, etc) that cannot be completed online can be completed off-campus.Primarily Classroom Course - Primarily Classroom Course - Less than 50% of the direct instruction of the course is delivered using some form of technology when the student and instructor are separated by time, space or both. This designation can include activities that do not occur in a classroom (ie, labs, internships, practica, clinicals, labs, etc).Hybrid Course - 50-79% of the direct instruction of the course is delivered using some form of technology when the student and instructor are separated by time, space or both.Primarily Distance Learning Course - 80-99% of the direc |
| Course Taken | Course Detail | Complete course identifier in the format of Course Prefix - Course Number - Course Section Course sectiontype (course reference number) |
| Course Taken | Course ID | Synthetic key designed to identify unique courses at the section level |
| Course Taken | Course Identifier | Course identifier in the format CoursePrefix CourseNumber CourseSection |
| Course Taken | Course Level Group | Course level identified as undegraduate or graduate level. Undergraduate course have a course number <= 4999. Graduate courses have a course number >= 5000 |
| Course Taken | Course Number | A code which includes the level of a course and which is assigned to identify the course in a systematic manner |
| Course Taken | Course Prefix | The alpha abbreviation which is assigned to a course, by Common Course Numbering. |
| Course Taken | Course Prefix Number Title | Course identifier in the format of CoursePrefix - Course number Course Title |
| Course Taken | Course Ref Number | Unique identifier to distinguish courses down to its lowermost granularity. |
| Course Taken | Course Section | A unique identifier assigned by the institution for each section of a course offered during the term reported. |
| Course Taken | Course Section Type | The means by which instruction is predominantly delivered for this course section as reported on the Student Data Course File. |
| Course Taken | Course Session ID | An indicator used by the universities to uniquely identify a session of less than 10 weeks within a summer term OR less than full term for fall and spring terms. |
| Course Taken | Course Site | The official number or other identifier that serves to uniquely identify the site within the university. |
| Course Taken | Course Site Address | Address of the site where the course if offered. |
| Course Taken | Course Site County | County of the site where the course is being offered. |
| Course Taken | Course Title | Course Title |
| Course Taken | Flag Education Abroad | Identifies courses that are education abroad. Specifically courses which have a Session_Code = 1 in SSBSECT table in Banner |
| Course Taken | Flag FKL | Identifies general education courses. Also called foundation of knowledge and learning courses. |
| Course Taken | Flag Maymester | Identifies courses offered in the special maymester time frame |
| Course Taken | Flag Winter Session | Identifies courses offered in the special winter session time frame |
| Course Taken | Funding Source | A code to indicate the budget entity of the department offering the course section. |
| Course Taken | Instructor Primary Name | Name of the primary instructor associated with the course |
| Course Taken | Instructor Primary PID | ID of the primary instructor associated with the course. |
| Course Taken | Measures | |
| Course Taken | Flag Fall | Identifies fall terms. |
| Course Taken | Flag Fall Spring | Identfies fall and spring terms. |
| Course Taken | Flag Summer Fall | Identifies summer and fall terms. |
| Course Taken | Term | Term of record. |
| Course Taken | Term Academic Year Hierarchy | Term Academic Year Hierarchy |
| Course Taken | Term Calendar Year Hierarchy | Term Calendar Year Hierarchy |
| Course Taken | Term Title | Term Title of record. |
| Course Taken | Year Academic | Academic year as identified by Summer + Fall + Spring. |
| Course Taken | Year Calendar | Calendar year as identified by Spring + Summer + Fall. |
| Course Taken | Year Stu Fin Aid | Financial Aid year as identified by Fall + Spring + Summer. |
| Course Taken | Latest Benchmark | This field provides the latest benchmark for which data has been loaded by term |
FACTS/MEASURES.
| Cube Name | Measure Name | Measure Description | EXPRESSION |
|---|---|---|---|
| Course Taken | % Count of Total for Col | Case when isempty([Course Count]) then null else iif(isempty(Axis(0).Item(0).Item(0).Dimension.CurrentMember.Parent),1,[Course Count]/(Axis(0).Item(0).Item(0).Dimension.CurrentMember.Parent,Measures.[Course Count])) End | |
| Course Taken | % Count of Total for Row | Case when isempty([Course Count]) then null else iif(isempty(Axis(1).Item(0).Item(0).Dimension.CurrentMember.Parent),1,[Course Count]/(Axis(1).Item(0).Item(0).Dimension.CurrentMember.Parent,Measures.[Course Count])) End | |
| Course Taken | Course Count | Course Count | |
| Course Taken | Course Credit Hours | Course Credit Hours | |
| Course Taken | Course Headcount | Students enrolled in courses | |
| Course Taken | Credit Hours Doctoral Fundable | Credit Hours Doctoral Fundable | |
| Course Taken | Credit Hours Doctoral Gross | Credit Hours Doctoral Gross | |
| Course Taken | Credit Hours Fundable | The number of State Fundable Hours based on Student Section Funding Flag, type of Course Section and/or Fee Waiver Kind | |
| Course Taken | Credit Hours Fundable AAR | The number of State Fundable Hours based on Student Section Funding Flag, type of Course Section and/or Fee Waiver Kind as per BOG Accountability methodology | |
| Course Taken | Credit Hours Gross | A quantitative measurement, stated in semester hours, which is the number of hours for which a student may be enrolled for credit for this course section |