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