| Table Name |
Type |
Description |
| dim_course | Core Entity Tables | Course catalog details |
| dim_course_section | Core Entity Tables | Individual course sections per term |
| dim_department | Core Entity Tables | Academic departments such as Engineering or Arts |
| dim_faculty | Core Entity Tables | Faculty and instructor master data |
| dim_major | Core Entity Tables | Academic majors available under programs |
| dim_person | Core Entity Tables | Student and person identity master data |
| dim_program | Core Entity Tables | Degree programs (e.g., B.S. Computer Science) |
| dim_term | Core Entity Tables | Academic terms/semesters (e.g., Fall 2025) |
| dim_user_account | Core Entity Tables | User accounts for system access |
| dim_address_type | Lookup | Address types such as Home, Mailing, Permanent |
| dim_contact_type | Lookup | Types of contact information (Phone, Email, Emergency Contact) |
| dim_course_level_type | Lookup | Course levels (Undergraduate, Graduate, etc.) |
| dim_enrollment_status_type | Lookup | Status of enrollment (Enrolled, Withdrawn, Completed) |
| dim_ethnicity_type | Lookup | Ethnicity classifications |
| dim_gender_type | Lookup | Gender classifications |
| dim_grade_type | Lookup | Grade values (A, B, Pass/Fail, etc.) |
| dim_race_type | Lookup | Race classifications |
| dim_role_type | Lookup | Role types for accounts (Admin, Student, Instructor) |
| dim_address | Relationship/XREF | Normalized student and faculty addresses |
| dim_country | Relationship/XREF | ISO country codes and names |
| dim_course_prerequisite | Relationship/XREF | Defines prerequisite relationships between courses |
| dim_email | Relationship/XREF | Email addresses associated with persons |
| dim_enrollment | Relationship/XREF | Student course enrollment records |
| dim_faculty_assignment | Relationship/XREF | Faculty assigned to courses/sections |
| dim_major | Relationship/XREF | Student majors assignment (xref) |
| dim_phone | Relationship/XREF | Phone numbers associated with persons |
| dim_state_province | Relationship/XREF | US states, Canadian provinces, etc. |