.. index::
   tbl1_Semester_Statuses_Payroll

==============================
tbl1_Semester_Statuses_Payroll
==============================

.. default-role:: doc

:Description:

   Works similar to `tbl1_Semester_Statuses` but for use with the Solutions payroll functions

:Footnote:

   will be obsolete if we remove the payroll functions



Columns
=======


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

   :Options:

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


**the_semester** ``varchar(25) DEFAULT NULL``

   :Description:

      Fall or Spring

   :Options:

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


**the_year** ``smallint(6) DEFAULT NULL``

   :Description:

      Semester Year

   :Options:

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


**the_status** ``smallint(6) DEFAULT NULL``

   :Description:

      Status code of semester with respect to the payroll function

   :Options:

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


**payroll_type** ``smallint(6) DEFAULT NULL``

   :Description:

      1 for graders, 2 for PTYs

   :Options:

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


**created_date** ``datetime DEFAULT NULL``

   :Description:

      date created for semester

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