Survey data set
The survey dataset is included for running PowerReports on surveys and scorecards.
The survey dataset is refreshed on a daily basis overnight and includes all responses to
surveys that have at least one question answered. If a respondent has not completed any answers, the
response for that location is not included in the dataset.
Note: A survey is not represented in the
dataset under these conditions:
- No responses are provided yet for a survey.
- The location associated with the survey is not part of a classification group.
The group, location, and region data that is included in the dataset are the same as the
data that is included in the monthly dataset. For more information about the monthly data set, see
the monthly dataset topic. The
data set includes pre-calculated scores, comparison to previous period answers and scores,
comparison to maximum or target scores, and comparison to average scores of respondents.
Note: The
scoring includes the calculation of average scores from all respondents. When you ask participants
to respond to scorecards from third party organizations, inform them that by responding to the
survey, their answers are included in the calculation of average scores, which may be shared with
other respondents to give feedback on how they have scored compared to the average of all
respondents.
The following tables describe the fields in the data set.
Column | Field type | Description |
---|---|---|
Survey Name |
Text | Name of the survey on the user interface. |
Survey Tag |
Text | The survey tag is set when a survey is created or copied. It is used to link similar surveys.
These surveys have the same sections and questions but have different survey names and different
effective from and effective to dates. Link a survey to the same survey in the previous period to calculate previous period values. |
Survey Type |
Text | Options are:
|
Date From |
Date | Effective from date. |
Date To |
Date | Effective to date. |
Survey Response Name |
Text | The name that is assigned to the survey response. The naming convention is normally surveyname-locationname. |
Survey Response Status |
Text | Options are:
Reflects the status of the issue that is linked to the survey response. |
Number of Mandatory Questions |
Numeric | Each question is a survey is set to Mandatory yes or no. Mandatory questions are the
questions that every respondent is expected to answer. Child or dependent questions are set to
No as showing them are based on the answer to the parent question. The number
of mandatory questions does not necessarily equal the total number of questions in a
survey. Note: For users who only complete their survey responses through the survey portal, they can
only submit their survey response once they have answered all mandatory questions so this setting
does need to be carefully considered for those types of surveys.
|
Number of Mandatory Questions Answered |
Numeric | The number of mandatory questions answered indicates how complete a survey response is. It indicates how many of the mandatory questions, which every respondent is expected to answer, are complete. |
Percent Mandatory Questions Answered |
Numeric |
Number of Mandatory Questions Answered / Number of
Mandatory Questions expressed as a percentage. |
Section Name |
Text | Name of the section. |
Question |
Text | Name of the question. |
Question Label | Text | The label attached to the question for categorization and aggregated reporting
purposes. The field is not visible to survey respondents in UI, but visible in Survey reports and Survey dataset. |
Question Type |
Text | Options are:
Note: The actual attachment is not included in the data set.
|
Answer |
Text | The answer entered to the question. If the question type is Attachment and an attachment was uploaded in response to the question then the answer is file attached. If no file is attached then the answer is blank. The file itself cannot be accessed from the data set. |
Answer Numeric |
Numeric | If the answer is numeric, then this field is populated so that you can use math functions, such as sum or avg. |
Answer Previous Period |
Text | Answer to the same question in the same survey in the previous period based on the Tag and Effective dates. |
Answer Numeric Previous Period |
Numeric | For the previous period, if the answer is numeric, then this field is populated so that you can use math functions, such as sum or avg. |
Sub folder | Column | Field type | Description |
---|---|---|---|
N/A | Survey Score |
Numeric | Sum of all Section Weighted Scores |
Compare to Max | Survey Max Score |
Numeric | Sum of all Section Weighted Max Scores |
Compare to Max | Survey Score Variance to Max |
Numeric |
Survey Max Score - Survey Score |
Compare to Max | Survey Score Variance to Max % |
Numeric |
Survey Score Variance to Max / Survey Max
Score |
Compare to Previous | Survey Score Previous Period |
Numeric | Survey Score from the survey in the period previous to the current survey
period. |
Compare to Previous | Survey Variance to Previous |
Numeric |
Survey Score - Survey Score Previous
Period |
Compare to Previous | Survey Variance % to Previous |
Numeric |
Survey Variance to Previous / Survey
Score |
Compare to Previous | Survey Variance to Max Previous Period |
Numeric |
Survey Max Score - Survey Score Previous
Period |
Compare to Previous | Survey Variance to Max % Previous Period |
Numeric |
Survey Variance to Max Previous Period / Survey Max
Score |
Compare to Average | Survey Score Respondents Avg |
Numeric | Average of the Survey Score from all respondents to the survey |
Compare to Average | Survey Variance to Respondents Avg |
Numeric |
Survey Score Respondents Avg - Survey
Score |
Compare to Average | Survey Variance % to Respondents Avg |
Numeric |
Survey Variance to Respondents Avg / Survey Score
Respondents Avg |
Compare to Average | Survey Score Respondents Avg Previous Period |
Numeric | Average of the Survey Score from all respondents to the survey in the period
previous to the current survey period |
Compare to Average | Survey Variance to Respondents Avg Previous Period |
Numeric |
Survey Score Respondents Avg Previous Period - Survey Score
Previous Period |
Compare to Average |
|
Numeric |
Survey Variance to Respondents Average Previous Period /
Survey Score Respondents Avg Previous Period |
Sub folder | Column | Field type | Description |
---|---|---|---|
N/A | Section Weighting |
Numeric | If no weighting is used in the survey configuration then a weighting of 1 is applied. |
N/A | Section Score |
Numeric | Sum of all child Question Weighted Scores |
N/A | Section Weighted Score |
Numeric |
Section Score x Section Weighting |
Compare to Max | Section Max Score |
Numeric | Sum of all Question Weighted Max Scores |
Compare to Max | Section Weighted Max Score |
Numeric |
Section Max Score x Section
Weighting |
Compare to Max | Section Score Variance to Max |
Numeric |
Section Weighted Max Score - Section Weighted
Score |
Compare to Max | Section Score Variance to Max % |
Numeric |
Section Score Variance to Max / Section Weighted Max
Score |
Compare to Previous | Section Score Previous Period |
Numeric | Section Weighted Score from the survey response in the period previous to
the current survey response period. |
Compare to Previous | Section Variance to Previous |
Numeric |
Section Weighted Score - Section Score Previous
Period |
Compare to Previous | Section Variance % to Previou s |
Numeric |
Section Variance to Previous / Section Weighted
Score |
Compare to Previous | Section Variance to Max Previous Period |
Numeric |
Section Weighted Max Score - Section Score Previous
Period |
Compare to Previous | Section Variance to Max % Previous Period |
Numeric |
Survey Variance to Max Previous Period / Section Weighted
Max Score |
Compare to Average | Section Score Respondents Avg |
Numeric | Average of the Section Weighted Score from all respondents to the
section |
Compare to Average | Section Variance to Respondents Avg |
Numeric |
Section Score Respondents Avg - Section Weighted
Score |
Compare to Average | Section Variance % to Respondents Avg |
Numeric |
Section Variance to Respondents Avg / Section Score
Respondents Avg |
Compare to Average | Section Score Respondents Avg Previous Period |
Numeric | Average of the Section Score from all respondents to the survey in the
period previous to the current survey period. |
Compare to Average | Section Variance to Respondents Avg Previous Period |
Numeric |
Section Score Respondents Avg Previous Period - Section
Score Previous Period |
Compare to Average | Section Variance % to Respondents Avg Previous Period |
Numeric |
Section Variance to Respondents Avg Previous Period /
Section Score Respondents Avg Previous Period |
Sub folder | Column | Field type | Description |
---|---|---|---|
N/A | Answer Value | Numeric | The value of the picklist answer. This is configured in the picklist question to support the required scoring calculations. For example, Yes might be set to 1 and No might be set to 0. |
N/A | Question Possible Score |
Numeric | The score set in the question configuration for a non pick-list type question, which if any answer is filled in then the configured score is applied for responding to that question. If no answer is provided then the possible score is always 0. |
N/A | Question Weighting |
Numeric | This is the weighting configured for the question. If no weighting is set, then this value is 1. |
N/A | Question Score |
Numeric | The answer value with any decimals removed if this is a picklist question or it is the possible score if not a picklist question. |
N/A | Question Weighted Score |
Numeric |
Question Score x Question
Weighting |
Compare to Max | Question Max Score |
Numeric |
Question Weighted Max Score - Question Weighted Score
|
Compare to Max | Question Weighted Max Score |
Numeric |
Question Score Variance to Max / Question Weighted Max
Score |
Compare to Max | Question Score Variance to Max |
Numeric |
Question Weighted Max Score - Question Score Previous
Period |
Compare to Max | Question Score Variance to Max % |
Numeric |
Question Variance to Max Previous Period / Question
Weighted Max Score |
Compare to Previous | Question Score Previous Period |
Numeric | Question Weighted Score from the survey response in the period previous to
the current survey response period. |
Compare to Previous | Question Variance to Previous |
Numeric |
Question Weighted Score - Question Score Previous
Period |
Compare to Previous | Question Variance % to Previous |
Numeric |
Question Variance to Previous / Question Weighted
Score |
Compare to Previous | Question Variance to Max Previous Period |
Numeric |
Question Weighted Max Score - Question Score Previous
Period |
Compare to Previous | Question Variance to Max % Previous Period |
Numeric |
Question Variance to Max Previous Period / Question
Weighted Max Score |
Compare to Average | Question Score Respondents Avg |
Numeric | Average of the Question Weighted Score from all respondents to the
question |
Compare to Average | Question Variance to Respondents Avg |
Numeric |
Question Score Respondents Avg - Question Weighted
Score |
Compare to Average | Question Variance % to Respondents Avg |
Numeric |
Question variance to Respondents Avg / Question Score Respondents
Avg |
Compare to Average | Question Score Respondents Avg Previous Period |
Numeric | Average of the Question Weighted Score from all respondents to the question
in the period previous to the current survey period |
Compare to Average | Question Variance to Respondents Avg Previous Period |
Numeric |
Question Score Respondents Avg Previous Period - Question
Score Previous Period |
Compare to Average | Question Variance % to Respondents Avg Previous Period |
Numeric |
Question Variance to Respondents Avg Previous Period /
Question Score Respondents Avg Previous Period |