.. index::
   tbl1_Courses_DateTracker

========================
tbl1_Courses_DateTracker
========================

.. default-role:: doc

:Description:

     This table keeps track of when each semester was last synchronized and when projected enrollments were last refreshed.

:Footnote:

   Now that we automatically do the sync and the projected enrollment refresh in same step, these fields should have the same values.
   Suggestion: consolidate both of these fields into one last updated field



Columns
=======


**ID** ``int(11) NOT NULL AUTO_INCREMENT``

   :Options:

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


**session_term** ``varchar(255) DEFAULT NULL``

   :Description:

      Fall, Spring or Summer

   :Options:

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


**session_year** ``int(11) DEFAULT NULL``

   :Description:

       Semester Year

   :Options:

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


**last_synchronized** ``datetime DEFAULT NULL``

   :Description:

      Timestamp sync with CSS last happened

   :Options:

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


**last_pe_refresh** ``datetime DEFAULT NULL``

   :Description:

      Timestamp projected enrollments were last refreshed

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