tbl1_honors_response_log¶
- Description
This is a logfile of students who submit responses to honors course invites via the RSVP chronoform. Data is pulled when the getforms2.py program is run. This log data is viewable via the Honors Responses tab in the Solutions Control Center. Honors invites are sent via the Solutions Honors Candidates Utility program
Columns¶
id int(8) NOT NULL
- Options
display="true", null="true", search="false", type=""
uniq_id varchar(256) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
the_semester varchar(45) DEFAULT NULL
- Description
Fall or Spring
- Footnote
the honors process is almost exclusively done in Fall but might also be done in Spring
- Options
display="true", null="true", search="false", type=""
the_year int(8) DEFAULT NULL
- Description
Year
- Options
display="true", null="true", search="false", type=""
course_number int(8) DEFAULT NULL
- Description
Honors course student is responding about
- Footnote
could be 152H, 291, 251H, 191, 192, 152H
- Options
display="true", null="true", search="false", type=""
response_notes varchar(255) DEFAULT NULL
- Description
notes
- 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=""
student_name varchar(255) DEFAULT '0'
- Options
display="true", null="true", search="false", type=""
student_ruid int(8) DEFAULT 0
- Options
display="true", null="true", search="false", type=""
response_timestamp datetime DEFAULT NULL
- Options
display="true", null="true", search="false", type=""