.. index:: tblx_Graders_Data ================= tblx_Graders_Data ================= .. default-role:: doc :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=""``