.. index::
   Tbl1_EnrollmentHistory

======================
Tbl1_EnrollmentHistory
======================

.. default-role:: doc

: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=""``