.. index::
   tbl1_honors_response_log

========================
tbl1_honors_response_log
========================

.. default-role:: doc

: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=""``