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