.. index:: tbl1_Evaluators =============== tbl1_Evaluators =============== .. default-role:: doc :Description: List of Request Evaluators used by Request Portal program :Relation: many-to-one relation with `tbl1_Requests` table where tbl1_Requests.EvaluatorID = tbl1_Evaluators.ID :Footnote: Future recommendation: since each evaluator should be a person in `tbl1_People` table, it would make sense to link these two tables, perhaps adding a personID field to this table. Then we would be able to remove many of these fields from this table since the information is shared with tbl1_People (last name, first name, phone, etc) Columns ======= **EvaluatorID** ``int(11) NOT NULL`` :Description: unique identifier for each evaluator :Options: ``display="true", null="true", search="false", type=""`` **evaluator_firstname** ``varchar(255) DEFAULT NULL`` :Description: evaluator firstname :Options: ``display="true", null="true", search="false", type=""`` **evaluator_lastname** ``varchar(255) DEFAULT NULL`` :Description: evaluator last name :Options: ``display="true", null="true", search="false", type=""`` **evaluator_email** ``varchar(255) DEFAULT NULL`` :Description: evaluator email :Options: ``display="true", null="true", search="false", type=""`` **evaluator_office** ``varchar(255) DEFAULT NULL`` :Description: evaluator office number :Options: ``display="true", null="true", search="false", type=""`` **evaluator_phone** ``varchar(255) DEFAULT NULL`` :Description: evalutor phone :Options: ``display="true", null="true", search="false", type=""`` **evaluator_notes** ``mediumtext DEFAULT NULL`` :Description: evalutor notes :Options: ``display="true", null="true", search="false", type=""`` **EvaluatesSPHonors** ``bit(1) DEFAULT NULL`` :Description: True if this person evaluates special permission honors requests :Options: ``display="true", null="true", search="false", type=""`` **EvaluatesPrereqs** ``bit(1) DEFAULT NULL`` :Description: True if this person evaluates prerquisite override requests :Options: ``display="true", null="true", search="false", type=""`` **EvaluatesXfers** ``bit(1) DEFAULT NULL`` :Description: True if this person evaluates transfer credit requests :Options: ``display="true", null="true", search="false", type=""`` **EvaluatesSPNonMatric** ``bit(1) DEFAULT NULL`` :Description: True if this person evaluates special permission for non-matriculated student requests :Options: ``display="true", null="true", search="false", type=""`` **EvaluatesSPMF** ``bit(1) DEFAULT NULL`` :Description: True if this person evaluates special permission multiple fail requests :Options: ``display="true", null="true", search="false", type=""`` **sph_course_start_number** ``smallint(6) DEFAULT NULL`` :Description: When assigning requests to appropriate evaluator, there is a need to indicate which course numbers should be directed to which evaluators. This field is the starting 3-digit number of the range of special permission honors requests that should be assigned to this evaluator. :Options: ``display="true", null="true", search="false", type=""`` **sph_course_end_number** ``int(11) DEFAULT NULL`` :Description: When assigning requests to appropriate evaluator, there is a need to indicate which course numbers should be directed to which evaluators. This field is the ending 3-digit number of the range of special permission honors requests that should be assigned to this evaluator. :Options: ``display="true", null="true", search="false", type=""`` **Inactive** ``bit(1) DEFAULT NULL`` :Description: This should be set to TRUE when the person is no longer acting as an evaluator :Options: ``display="true", null="true", search="false", type=""`` **send_from_identity_number** ``int(11) DEFAULT NULL`` :Description: Email identity number :Footnote: This field was added to try to address the scenario when an advisor does not want his personal email to show up in the 'from' line of emails being sent. For example, we have a special email account for transfer advisor, transfer@math.rutgers.edu. When emails are composed from this program, we would want the 'from' line of the email to say 'from transfer advisor' and not the advisor's personal email. After doing some research, I learned that Thunderbird email accounts have corresponding 'identity numbers' for each account a person has access to in their email client. So this field can be set to a number (1, 2, 3, etc) that represents which account should come up by default. I'm not completely sure how to determine which identity corresponds to which number, but this can easily be learned through trial and error and seeing which identity comes up after changing this setting. :Options: ``display="true", null="true", search="false", type=""`` **HonorsCandidatesAdvisor** ``bit(1) DEFAULT NULL`` :Description: For the Solutions Honors Candidates utility, the program needs to know which evaluator is the primary person evaluating honors candidates. This should be set to TRUE for that person. :Options: ``display="true", null="true", search="false", type=""`` **spnm_course_start_number** ``smallint(6) DEFAULT NULL`` :Description: When assigning requests to appropriate evaluator, there is a need to indicate which course numbers should be directed to which evaluators. This field is the starting 3-digit number of the range of special permission for non matric students that should be assigned to this evaluator. :Options: ``display="true", null="true", search="false", type=""`` **spnm_course_end_number** ``int(11) DEFAULT NULL`` :Description: When assigning requests to appropriate evaluator, there is a need to indicate which course numbers should be directed to which evaluators. This field is the ending 3-digit number of the range of special permission for non matric students that should be assigned to this evaluator. :Options: ``display="true", null="true", search="false", type=""`` **spmf_course_start_number** ``smallint(6) DEFAULT NULL`` :Description: When assigning requests to appropriate evaluator, there is a need to indicate which course numbers should be directed to which evaluators. This field is the starting 3-digit number of the range of special permission for multiple fail requests that should be assigned to this evaluator. :Options: ``display="true", null="true", search="false", type=""`` **spmf_course_end_number** ``int(11) DEFAULT NULL`` :Description: When assigning requests to appropriate evaluator, there is a need to indicate which course numbers should be directed to which evaluators. This field is the ending 3-digit number of the range of special permission for multiple fail requests that should be assigned to this evaluator. :Options: ``display="true", null="true", search="false", type=""`` **prereq_course_start_number** ``smallint(6) DEFAULT NULL`` :Description: When assigning requests to appropriate evaluator, there is a need to indicate which course numbers should be directed to which evaluators. This field is the starting 3-digit number of the range of prerequisite override requests that should be assigned to this evaluator. :Options: ``display="true", null="true", search="false", type=""`` **prereq_course_end_number** ``int(11) DEFAULT NULL`` :Description: When assigning requests to appropriate evaluator, there is a need to indicate which course numbers should be directed to which evaluators. This field is the ending 3-digit number of the range of prerequisite override requests that should be assigned to this evaluator. :Options: ``display="true", null="true", search="false", type=""`` **xfer_course_start_number** ``smallint(6) DEFAULT NULL`` :Description: When assigning requests to appropriate evaluator, there is a need to indicate which course numbers should be directed to which evaluators. This field is the starting 3-digit number of the range of transfer credit requests that should be assigned to this evaluator. :Options: ``display="true", null="true", search="false", type=""`` **xfer_course_end_number** ``int(11) DEFAULT NULL`` :Description: When assigning requests to appropriate evaluator, there is a need to indicate which course numbers should be directed to which evaluators. This field is the ending 3-digit number of the range of transfer credit requests that should be assigned to this evaluator. :Options: ``display="true", null="true", search="false", type=""`` **spnm_exception_courses** ``varchar(255) DEFAULT NULL`` :Description: If this evaluator is also responsible for other special permission non-matric requests for course #'s outside of range indicated in other fields, they should be entered here in this form: "*151*152*001* :Options: ``display="true", null="true", search="false", type=""`` **spmf_exception_courses** ``varchar(255) DEFAULT NULL`` :Description: If this evaluator is also responsible for other special permission multiple fail requests for course #'s outside of range indicated in other fields, they should be entered here in this form: "*151*152*001* :Options: ``display="true", null="true", search="false", type=""`` **prereq_exception_courses** ``varchar(255) DEFAULT NULL`` :Description: If this evaluator is also responsible for other prerequisite override requests for course #'s outside of range indicated in other fields, they should be entered here in this form: "*151*152*001* :Options: ``display="true", null="true", search="false", type=""`` **xfer_exception_courses** ``varchar(255) DEFAULT NULL`` :Description: If this evaluator is also responsible for other transfer credit requests for course #'s outside of range indicated in other fields, they should be entered here in this form: "*151*152*001* :Options: ``display="true", null="true", search="false", type=""`` **sph_exception_courses** ``varchar(255) DEFAULT NULL`` :Description: If this evaluator is also responsible for other special permission honors requests for course #'s outside of range indicated in other fields, they should be entered here in this form: "*151*152*001* :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=""`` **default_evaluator** ``bit(1) DEFAULT b'0'`` :Description: Set to TRUE for the default evaluator. If an evaluator for a request cannot be determined based on the other fields in this table, the default evaluator will be assigned. :Options: ``display="true", null="true", search="false", type=""``