.. index::
   tbl1_PTLPayRates

================
tbl1_PTLPayRates
================

.. default-role:: doc

:Description:

   This table keeps track of the current PTL pay rates for a semester

:Footnote:

   While the PTL Payroll function works in Solutions, I don't think it is being used by anyone at this time



Columns
=======


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

   :Options:

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


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

   :Description:

      Fall or Spring

   :Options:

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


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

   :Description:

      Semester Year

   :Options:

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


**base_rate** ``double DEFAULT NULL``

   :Description:

      PTL Base Pay Rate

   :Options:

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


**increment_rate** ``double DEFAULT NULL``

   :Description:

      Increment Rate

   :Footnote:

      This may be obsolete, we may now only use an increment percent. Contact Mayka for more info

   :Options:

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


**increment_rate_phd** ``double DEFAULT NULL``

   :Description:

      Increment Rate for PTLs with Phds

   :Options:

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


**increment_percent** ``float DEFAULT NULL``

   :Description:

      Increment Percent for new semesters

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