fct_survey_questions


Description

Surveys are structured with a series of questions that the respondent answers.

Every Survey Question has a Question Type, which is one of:

  1. multiple_choice - The respondent chooses one or more options from a list of choices.
  2. text - The respondent writes a response in a text field.
  3. scale-based questions - The respondent chooses an option from a minimum/maximum value range.
  4. number - The respondent enters a number with an optional minimum/maximum value range.
  5. date - The respondent chooses a date.

Survey Questions Model

fct_survey_questions is designed to answer the following questions:

  1. What questions are in a survey?
  2. What are the details of a specific question? (E.g.: question_name, question_type, question_instructions, etc.)
  3. What is the minimum and maximum scale of the question, (if a scale-based question)? (question_scale_minimum, question_scale_maximum, etc.)
  4. What are the options available for the question? (question_option_labels)

Columns

Column Type Children Parents Comments
survey_question_id int8
fct_survey_question_responses.survey_question_id Implied Constraint R

The ID of the survey question containing this response, E.g.: 1.
survey_id int8
fct_surveys.survey_id Implied Constraint R

The ID of the survey containing this question, E.g.: 123.
question_name varchar

The name or title of the question, E.g.: How satisfied are you with the service?.
question_type varchar

The type of question, One of: multiple_choice, text, analog_scale, date or number.
question_key varchar

A stable identifier of the question, used in the data export and post-processing. E.g.: doctor-visits-monthly
question_required bool

Whether a response to the survey question is required, E.g.: true or false
question_position int8

The position of the question within the survey, E.g.: 42.
question_scale_minimum int8

The minimum value for scale questions, E.g.: 1.
question_scale_maximum int8

The maximum value for scale questions, E.g.: 100.
question_scale_minimum_label varchar

Label for the minimum scale value, E.g.: Not satisfied.
question_scale_maximum_label varchar

Label for the maximum scale value, E.g.: Very satisfied.
question_scale_lower_threshold int8

The minimum value that will trigger an observation. Note that a null value will disable observation triggers for this question. E.g.: 3, 10, NULL, etc.
question_option_labels varchar

Concatenated labels of the options for the question, with the Option Name and Option Position. E.g.: Always (1), Most of the time (2), Some of the time (3), Never (4).
question_instructions varchar

Instructions for answering the question, E.g.: Please write your response..
company_id int8
dim_companies.company_id Implied Constraint R

The company ID, E.g.: 345.
question_accepts_multiple_answers bool

Whether a multiple choice question can accept multiple answers. E.g.: true or false

Indexes

Constraint Name Type Sort Column(s)
fct_survey_questions_pkey Primary key Asc survey_question_id
fct_survey_questions_company_id_idx Performance Asc company_id
fct_survey_questions_survey_id_idx Performance Asc survey_id

Relationships

Close relationships within degrees of separation