.. index::
   tbl1_survey_field_usage

=======================
tbl1_survey_field_usage
=======================

.. default-role:: doc

:Description:

   This is an internal table used by the Instructor Survey program. In the process of importing
   survey results, Solutions looks at the inbound fields, and creates an entry in this table to list the fields that were used in the
   particular survey, and which instructor types were presented with the question. This will later be used for other functions in the instructor survey program.



Columns
=======


**id** ``int(11) NOT NULL``

   :Options:

      ``display="true", null="true", search="false", type=""``


**the_semester** ``varchar(45) DEFAULT NULL``

   :Description:

      Fall, Spring or Summer

   :Options:

      ``display="true", null="true", search="false", type=""``


**the_year** ``int(11) DEFAULT NULL``

   :Description:

      Semester Year

   :Options:

      ``display="true", null="true", search="false", type=""``


**the_survey_field** ``varchar(45) DEFAULT NULL``

   :Description:

      Name of survey field as defined in Qualtrics

   :Source:

      Name of survey field

   :Footnote:

      In Qualtrics I think these names either correspond with the question field name.  Or, in the case
      of grid fields (like when we list logs of courses), this would be the "question export tag" viewable when one clicks "recode values" for that question

   :Options:

      ``display="true", null="true", search="false", type=""``


**used_for_faculty** ``tinyint(1) DEFAULT 0``

   :Description:

      TRUE if this question appeared on survey-flow when a person with category Faculty answers the survey

   :Options:

      ``display="true", null="true", search="false", type=""``


**used_for_annuals** ``tinyint(1) DEFAULT 0``

   :Description:

      TRUE if this question appeared on survey-flow when a person with category Annual answers the survey

   :Options:

      ``display="true", null="true", search="false", type=""``


**used_for_ptls** ``tinyint(1) DEFAULT 0``

   :Description:

      TRUE if this question appeared on survey-flow when a person with category PTL answers the survey

   :Options:

      ``display="true", null="true", search="false", type=""``


**used_for_graduate_students** ``tinyint(1) DEFAULT 0``

   :Description:

      TRUE if this question appeared on survey-flow when a person with category Graduate Student answers the survey

   :Options:

      ``display="true", null="true", search="false", type=""``