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