CurrentCourseEnroll table, vCurrentCourseEnroll view
- Jordan Lamb
This table has a record for the enrollment in a CRN for every day. This is updated nightly. Two 2 most recent terms available for registration are selected each night – that is, the table will have enrollment counts for each CRN in a term beginning on the first day of registration for that term.
Note: If you want to compare these counts on a census date to the census count in BANNER, know that the BANNER census count (from SSBSECT) can contain students who added the class AFTER census but were “back-dated” and so will be counted in Banner’s census count (these would not show up in this CurrentCourse Enroll table). Also, the nightly job that loads this table runs at 9:00 PM whereas the BANNER census number is run earlier in the morning – there may be students who add or drop during the day.
Source: Data Warehouse Course table
Updated: nightly
DW Field | Description or Sample |
Term |
|
Date | The date the record was added to this table |
CRN |
|
Actual_Enroll | The enrollment in the course at the time of Date |
Wait_Capacity | The max number of slots in the wait list |
Wait_Count | The number of students on the wait list |
Wait_Avail | The number of slots available in the wait list |
There is a view called vCurrentCourseEnroll that shows all of these columns as well as the Term’s start date and the number of days before or after the start date that the record was added to the table.