tblx_Graders_Data¶
- Description
This table is used to hold the grader data for the grader payroll function.
- 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
Columns¶
ID int(11) NOT NULL
- Options
display="true", null="true", search="false", type=""
the_semester varchar(255) 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=""
PersonName tinytext DEFAULT NULL
- Description
Grader’s name
- Options
display="true", null="true", search="false", type=""
CourseCrse varchar(255) DEFAULT NULL
- Description
3-digit course code
- Options
display="true", null="true", search="false", type=""
CourseNumber varchar(255) DEFAULT NULL
- Description
Course number in a format like 01:640:250:01
- Options
display="true", null="true", search="false", type=""
CourseSection varchar(255) DEFAULT NULL
- Description
Section Number (or list of sections grader is responsible for, comma-separated)
- Options
display="true", null="true", search="false", type=""
CourseIndex varchar(255) DEFAULT NULL
- Description
Coures index number
- Options
display="true", null="true", search="false", type=""
CourseName tinytext DEFAULT NULL
- Description
Course Name
- Options
display="true", null="true", search="false", type=""
Day tinytext DEFAULT NULL
- Description
Period or Period Pair of cousre
- Options
display="true", null="true", search="false", type=""
Time tinytext DEFAULT NULL
- Description
Time of course
- Options
display="true", null="true", search="false", type=""
Room tinytext DEFAULT NULL
- Description
Course Classroom in format like SEC-220
- Options
display="true", null="true", search="false", type=""
Campus tinytext DEFAULT NULL
- Description
Campus code
- Options
display="true", null="true", search="false", type=""
First Name tinytext DEFAULT NULL
- Description
Grader first name
- Options
display="true", null="true", search="false", type=""
Last Name tinytext DEFAULT NULL
- Description
Grader last name
- Options
display="true", null="true", search="false", type=""
Experienced? bit(1) DEFAULT NULL
- Description
TRUE to indicate person has experience as a grader
- Options
display="true", null="true", search="false", type=""
Email tinytext DEFAULT NULL
- Description
Grader’s email
- Options
display="true", null="true", search="false", type=""
PersonID int(11) DEFAULT NULL
- Description
person id
- Relation
relates to PersonID in tbl1_People table
- Options
display="true", null="true", search="false", type=""
last_updated datetime DEFAULT NULL
- Description
timestamp record was last updated
- Options
display="true", null="true", search="false", type=""
PayrollID varchar(20) DEFAULT NULL
- Description
8-digit payroll id (sometimes called employee id)
- Options
display="true", null="true", search="false", type=""
Hrs/Wk tinytext DEFAULT NULL
- Description
This and all other fields in this table are used when performing the grader payroll function
- Options
display="true", null="true", search="false", type=""
Rate double DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period1_name tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period1_amount smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period2_name tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period2_amount smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period3_name tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period3_amount smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period4_name tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period4_amount smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period5_name tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period5_amount smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period6_name tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period6_amount smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period7_name tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period7_amount smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period8_name tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period8_amount smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period9_name tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period9_amount smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period10_name tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period10_amount smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period11_name tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period11_amount smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period12_name tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period12_amount smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period13_name tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period13_amount smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period14_name tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period14_amount smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period15_name tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period15_amount smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period16_name tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period16_amount smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period17_name tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period17_amount smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period18_name tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period18_amount smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period19_name tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period19_amount smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period20_name tinytext DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
period20_amount smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
total_hours smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
total_pay double 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=""