tbl1_PTLPayRates

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