fct_surveys


Description

A Survey in Lookout is a structured set of questions designed to gather information from respondents.

They are used to assess aspects such as health, mobility, and mental state, and can be accessed through the Lookout App.

Surveys can be customised to fit the specific needs of the organisation and are an integral part of the feedback loop within Lookout.

For a broader understanding of Surveys, please refer to the Lookout Manuals’ Survey Management article, which goes into detail about how Surveys work.

The responses to these Surveys help organisations understand the needs and experiences of their Members, allowing for better service delivery and support.

Purpose

This model is designed to answer the following questions:

  1. What surveys are available for a company?
  2. What are the details of a specific survey? (E.g.: survey_name, created_at, etc.)
  3. How many questions are in a survey? (total_questions)
  4. How often does the Survey recur? (recurrence_limit, recurrence_interval, recurrence_frequency)
  5. How many Survey Requests have been sent out? (total_survey_requests)
  6. How many Survey Requests have been completed? (total_survey_request_respondents)

Recurrence

Surveys can be set with recurring schedules, allowing them to be sent out at regular intervals. This setup includes:

  • Recurrence Limit (recurrent_limit): The total number of times the survey is set to recur.
  • Recurrence Interval (recurrence_interval): Defines the interval time period of recurrence.
  • Recurrence Frequency (recurrence_frequency): Could be days, weeks, months, or years.

Questions

For a list of Survey Questions, see fct_survey_questions.

Survey Questions Responses

For a list of responses to Survey Questions, see fct_survey_question_responses.

The responses to these surveys help organisations understand the needs and experiences of their Members, allowing for better service delivery and support.

Columns

Column Type Children Parents Comments
survey_id int8
fct_survey_question_responses.survey_id Implied Constraint R
fct_survey_questions.survey_id Implied Constraint R

The unique ID of the survey, E.g.: 123.
survey_name varchar

The name of the survey. E.g.: Client Experience Survey.
created_at timestamp

The date and time the survey was created (in UTC), E.g.: 2021-03-17 22:59:01.116801.
updated_at timestamp

The date and time the survey was last updated (in UTC), E.g.: 2021-03-17 22:59:01.116801.
archived_at timestamp

The date and time the survey was archived (in UTC), E.g.: 2021-03-17 22:59:01.116801.
recurrence_limit int4

The recurrence limit for the survey, from 0 to 2000.
recurrence_interval int4

The recurrence interval for the survey, from 1 to 999.
recurrence_frequency varchar

The recurrence frequency for the survey, One of: days, weeks, months or years.
total_questions int8

The total number of questions in the survey, E.g.: 10.
total_survey_requests int8

The total number of survey requests that were sent, E.g.: 100.
total_survey_request_respondents int8

The total number of respondents to the survey, E.g.: 50.
company_id int8
dim_companies.company_id Implied Constraint R

The company ID, E.g.: 345.

Indexes

Constraint Name Type Sort Column(s)
fct_surveys_pkey Primary key Asc survey_id
fct_surveys_company_id_idx Performance Asc company_id

Relationships

Close relationships within degrees of separation