CurrentStudentCount table
- Jordan Lamb
Owned by Jordan Lamb
This table stores counts of students and units who are registered for at least one class on each day of a term. Units are stored as well.
Source: Data Warehouse Student table
Updated: nightly
DW Field | Description or Sample |
Term | Â |
Date | The date the record was added to this table |
Stu_PT | A: Count of students with term_hours (units) < 12 |
Stu_PT_TotalUnits | B: Sum of term_hours < 12 |
Stu_PT_FLE_Equiv | C: Stu_PT_TotalUnits / 15 |
Stu_FT | D: Count of students with term_hours (units) >=12 |
Stu_FT_TotalUnits | E: Sum of term_hours >= 12 |
Stu_FT_FLE_Total | D + C |
Stu_Total_Count | A + D |
Stu_Total_Count_Units | B + E |
Stu_Total_Class_Enroll | Sum of registered_classes column in the Student table |