WDT_ACADEMIC_TIME - Academic Time Dimension
| Academic Time dimension provides information about the academic period, year and aid year. | | |
WDT_COURSE - Course Dimension
| Course Dimension table provides information for the course or subject offering scheduled. This information includes course identification (ex. ENG 110), Course title long and short, Program classification or government reporting code, subject area and the organization within the institution responsible for providing the instructional content. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_COURSE_REFERENCE_NUMBER - Course Reference Number Dimension
| Course Reference Number Dimension table provides the valid course reference numbers that have been used in combination with an academic period to identify a section or unique course offering. | | |
WDT_COURSE_SECTION - Course Section Dimension
| Course Section Dimension Table provides information specific to the section instruction and if the section is graded. | | |
WDT_DEMOGRAPHIC - Demographic Dimension
| Demographic Dimension table provides information for the person that is consistent whether this is an employee, inquirer, applicant, student or graduate at the institution. This information includes gender, ethnicity, age range and family income range. It uses the cleansing rules in the EDW for the short and long descriptions as well as the definition of the ranges in this dimension. | | |
WDT_GRADE_CHANGE - Grade Change Dimension
| Grade Change Dimension table provides a history of any grade changes for the student course. Data includes the grade change reason and comment on why change was made. | | |
WDT_INSTRUCTOR - Instructor Dimension
| Instructor Dimension table provides information about the primary instructor for the student course. Data includes instructor name, home college and department.. | | |
WDT_MULTI_SOURCE - Multi Source Dimension
| Multi-source Dimension table provides information on the source(s) of information. This information is the multi-source code and its descriptions along with the process group and administrative group. | | |
WDT_PERSON - Person Dimension
| Person Dimension table provides information on an individual. | | |
WDT_REGISTRATION - Registration Dimension
| Registration Dimension table provides information for the person that includes the time frame registration status for a schedule offering. This information includes final grade if assigned, type of grading (regular, Pass/Fail, Audit, etc.) and section registration status. It uses the cleansing rules in the EDW for the short and long descriptions. | | |
WDT_SUB_ACADEMIC_PERIOD - Sub Academic Period Dimension
| Sub Academic Time Dimension table provides information about the a part of academic period. | | |
WFT_STUDENT_COURSE - Student Course Fact Table
| Student Course Fact table provides detail data for student courses recorded in the system. Courses taken by the student may be in progress (registration), graded (history), and transferred (transfer) courses. Indicators permit the report user to identify groupings of courses for selected reporting needs. | | |