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