.. index::
   tblx_PTLs_Data

==============
tblx_PTLs_Data
==============

.. default-role:: doc

:Description:

   	This table is used to hold the PTL data for the PTL payroll function.



Columns
=======


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

   :Footnote:

       While this function still exists in Solutions database interface, I don't think anyone is using this function so we should decide whether this might be obsoleted

   :Options:

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


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

   :Options:

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


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

   :Options:

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


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

   :Options:

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


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

   :Options:

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


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

   :Options:

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


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

   :Options:

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


**PreviousRate** ``double DEFAULT NULL``

   :Options:

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


**NewRate** ``double DEFAULT NULL``

   :Options:

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


**TotalPay** ``double DEFAULT NULL``

   :Options:

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


**last_updated** ``datetime DEFAULT NULL``

   :Options:

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


**NewPTL** ``bit(1) DEFAULT NULL``

   :Options:

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


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

   :Options:

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


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

   :Options:

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


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

   :Options:

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


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

   :Options:

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


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

   :Options:

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


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

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