Tbl1_EnrollmentHistory

Description

This table contains a snapshot of the total enrollment per course offering for a semester and a date. Every time the Solutions synchronize procedure is run, this table is filled in with a snapshot of current enrollments. Department Chairs and Advisors can use this information to track enrollment trends over time

Footnote

Occassionally we are asked for this information for a particular section. I did not build this into the system because the nature of this table already makes it quite large, and if we captured information on a per-section basis, it would grow even more. But this is something to think about and consider.

Columns

ID int(11) NOT NULL

Options

display="true", null="true", search="false", type=""

semester_year int(11) DEFAULT NULL

Description

Semester Year

Options

display="true", null="true", search="false", type=""

semester_session varchar(10) DEFAULT NULL

Description

Fall, Spring or Summer

Options

display="true", null="true", search="false", type=""

course_number varchar(255) DEFAULT NULL

Options

display="true", null="true", search="false", type=""

as_of_date datetime DEFAULT NULL

Description

8-digit course number, for example 01640012

Options

display="true", null="true", search="false", type=""

num_enrolled smallint(6) DEFAULT NULL

Description

Total students enrolled for course offering when data was captured (sum of all sections)

Options

display="true", null="true", search="false", type=""

last_change timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()

Options

display="true", null="true", search="false", type=""