Brightspace Data Sets for Surveys have a dependency on Surveys. If you turn this tool on and off during the data set query period, there may be unexpected or missing content in your data sets.
Are you looking for further information about Quiz and Survey Questions? Refer to this helpful blog post on Enhancements to Quiz and Survey Data in Brightspace.
Entity Relationship Diagram
The following diagram shows the relationships between entities used to create Brightspace Data Sets for Surveys. To enlarge the diagram, right-click on the image and select Open image in a new tab.
Related Data Sets
As the Entity Relationship Diagram illustrates, the Brightspace Data Sets for Surveys have relationships with other data sets that are not described on this page. These related data sets include:
Quiz Survey Sections
The Quiz Survey Sections Brightspace Data Set returns information about all the sections and question pools that have been created in quizzes in the organization.
Returned Fields
Version History |
Field |
Description |
Type |
Column Size |
Key |
---|---|---|---|---|---|
4.7 / 5.1 - Updated description |
CollectionId | Unique question collection identifier. | bigint | 8 | FK |
3.4 | SectionId | Unique section identifier. | bigint | 8 | PK |
5.7 / 6.0 - Changed Column Size | Name |
Name of the quiz section. Field can be null. |
nvarchar | 256 | |
3.4 | NameIsDisplayed | Indicates if the section name is hidden or shown. | bit | 1 | |
3.4 | IsQuestionPool | Indicates if the question pool is a random section. | bit | 1 | |
3.4 | SectionText | Field can be null. | nvarchar | 1000 | |
3.4 | SectionTextIsHTML | Indicates if the section text is HTML or plain text. | bit | 1 | |
3.4 | IsSectionTextHidden |
Indicates if the section text is hidden or shown. Values are 0 for hidden and 1 for shown. Field can be null. |
bit | 1 | |
4.8 / 5.2 - Updated column size |
QuestionPoints |
Indicates the number of points allotted to the question. Field can be null. |
decimal | 19, 9 | |
3.4 | NumQuestions | Indicates the number of questions in the quiz section. | int | 4 | |
3.4 | NumChoices | Indicates the number of choices in the question pool from which the quiz can be created. | int | 4 | |
3.4 | Shuffle | Indicates that the quiz questions in the pool are shuffled. | bit | 1 | |
3.4 | CreationDate | Date the quiz was created (UTC). | datetime2 | 8 | |
3.4 | CreatedBy |
Id of the user who created the quiz. Field can be null. |
bigint | 8 | |
3.4 | LastModified | Date when the quiz was last modified (UTC). | datetime2 | 8 | |
3.4 | LastModifiedBy |
Id of the user who last modified the quiz. Field can be null. |
bigint | 8 | |
3.4 | IsDeleted |
Indicates that the quiz question is deleted. Field can be null. |
bit | 1 | |
3.6 / 4.0 | Version |
Indicates the version of the question. This column supports the Question Pools information in the Assessment Quality Dashboard. Field can be null. |
bigint |
8 |
Survey Attempts
The Survey Attempts Brightspace Data Set returns details for each user survey attempt for all your org units. This data set includes completed survey attempts and in-progress survey attempts.
Returned Fields
Version History |
Field |
Description |
Type |
Column Size |
Key |
---|---|---|---|---|---|
1.0 |
AttemptId |
Unique attempt identifier |
bigint |
8 |
PK |
7.17 / 8.3 - Removed nullability and added FK |
SurveyId |
Unique survey identifier. |
bigint |
8 |
FK |
1.0 |
UserId |
Unique user identifier. |
int |
4 |
FK |
1.0 |
OrgUnitId |
Unique org unit identifier. |
int |
4 |
FK |
1.0 |
AttemptNumber |
Attempt number for the survey. |
int |
4 |
|
1.0 |
TimeStarted |
Survey attempt start time (UTC). |
datetime2 |
8 |
|
1.0 |
TimeCompleted |
Survey attempt complete time (UTC). Field can be null. |
datetime2 |
8 |
|
1.1 |
AttemptedFromOrgUnitId |
Org unit identifier where the survey was attempted from. Field can be null. |
int | 4 | FK |
1.10 | OldAttemptNumber |
Number of previous times a learner has attempted the survey. Field can be null. |
int | 4 | |
1.10 | IsDeleted |
Indicates that the survey attempt is deleted. Field can be null. |
bit | 1 | |
5.7 / 6.0 | Version | Indicates the version of the row. This information is used to determine which table row occurred first, similar to the way time stamps function in other data sets. | bigint | 8 |
Survey Objects
The Survey Objects Brightspace Data Set describes all the surveys in the organization.
Returned Fields
Version History |
Field |
Description |
Type |
Column Size |
Key |
---|---|---|---|---|---|
5.6 |
SurveyId | Unique survey identifier. | bigint | 8 | PK |
5.6 | SurveyName | Name of the survey. | nvarchar | 1000 | |
5.6 | CategoryId |
Category Id for the survey. Field can be null. |
bigint | 8 | |
5.6 | OrgUnitId | Unique org unit identifier. | int | 4 | FK |
5.6 | Description |
Description of the survey. Field can be null. |
nvarchar | 1000 | |
5.6 | DescriptionEnabled | Indicates if the survey description is enabled. | bit | 1 | |
5.6 | HasInstantFeedback | Indicates if the survey provides instant feedback. | bit | 1 | |
5.6 | IsAnonymous | Indicates if the survey results are anonymous. | bit | 1 | |
5.6 |
IsVisible | Indicates if the survey is visible or hidden from users. | bit | 1 | |
5.6 | SubmissionMessage |
Message provided when user submits survey. Field can be null. |
nvarchar | 1000 | |
5.6 | Footer |
Footer of the survey. Field can be null. |
nvarchar | 1000 | |
5.6 | FooterIsDisplayed | Indicates if the footer is displayed. | bit | 1 | |
5.6 | StartDate |
Start date and time of the survey (UTC). Field can be null. |
datetime2 | 8 | |
5.6 | EndDate |
End date and time of the survey (UTC). Field can be null. |
datetime2 | 8 | |
5.6 | DisplayInCalendar | Indicates if the survey is displayed in the calendar. | bit | 1 | |
5.6 | ResultId |
Unique release condition result identifier. Field can be null. |
bigint | 8 | |
6.16 / 7.4 - Updated description | AttemptsAllowed |
Indicates the number of attempts of the survey that a user is allowed to take. Field can be null. |
int | 4 | |
5.6 | SortOrder | Order in which surveys appear in the interface. | int | 4 | |
5.6 | CreatedBy | Id of the user who created the survey. | int | 4 | FK |
5.6 | IsDeleted | Indicates if the survey is deleted (1) or not (0). | bit | 1 | |
5.6 | LastModified | Date when the survey was last modified (UTC). | datetime2 | 8 | |
5.6 | LastModifiedBy | Id of the user who last modified the survey. | int | 4 | FK |
5.6 | Version | Indicates the version of the row. This information is used to determine which table row occurred first, similar to the way time stamps function in other data sets. | bigint | 8 | |
5.10 / 6.3 | CategoryName |
Name of the category in which the survey belongs. Field can be null. |
nvarchar | 256 |
Survey Question Answer Options
The Survey Question Answer Options Brightspace Data Set returns possible answers for a given survey question. Only includes answer options for these question types: Short Answer, Fill in the Blanks, and Multi-Short Answer. Rows in the data set are filtered out if they are associated with deleted survey questions.
Returned Fields
Version History |
Field |
Description |
Type |
Column Size |
Key |
---|---|---|---|---|---|
1.0 |
AnswerId |
Unique answer identifier |
bigint |
8 |
PK, FK |
1.0 |
AnswerText |
Answer the user entered. Field can be null. |
nvarchar |
1000 |
|
4.8 / 5.2 - Updated column size |
Weight |
Weight associated with the answer. |
decimal |
19, 9 |
|
1.0 |
QuestionId |
Unique question identifier. |
bigint |
8 |
PK, FK |
1.0 |
QuestionVersionId |
Unique question version identifier. |
bigint |
8 |
PK, FK |
2.5 / 3.0 - Added keys | SurveyObjectId | Unique survey object identifier. | bigint | 8 | PK, FK |
1.2 | AnswerOptionId | Unique survey answer identifier. | bigint | 8 | PK |
Survey Question Answers
The Survey Question Answers Brightspace Data Set returns possible answers for a given survey. Rows in the data set are filtered out if they are associated with deleted survey questions.
Returned Fields
Version History |
Field |
Description |
Type |
Column Size |
Key |
---|---|---|---|---|---|
1.0 |
AnswerId |
Unique answer identifier |
bigint |
8 |
PK |
1.0 |
QuestionId |
Unique question identifier |
bigint |
8 |
PK, FK |
1.0 |
QuestionVersionId |
Unique question version identifier |
bigint |
8 |
PK, FK |
1.0 |
SortOrder |
Order in which the survey answers are displayed or correct answer order for ordering questions |
int |
4 |
|
1.0 |
IsCorrect |
Is answer correct? Field can be null. |
bit |
1 |
|
4.8 / 5.2 - Updated column size |
Weight |
Weight associated with answer. Field can be null. |
decimal |
19, 9 |
|
5.7 / 6.0 - Changed Column Size |
Answer |
Answer text. Field can be null. |
nvarchar |
1000 |
|
1.0 |
Comment |
Instructor comment on the answer. Field can be null. |
nvarchar |
1000 |
|
5.7 / 6.0 - Changed Column Size |
Description |
System description for the type of answer expected. |
nvarchar |
256 |
|
1.2 | SurveyObjectId | Unique survey object identifier. | bigint | 8 |
PK, FK |
Survey User Answer Responses
The Survey User Answer Responses Brightspace Data Set returns data to describe the options a user chose or the answers they provided to survey questions. Rows in the data set are filtered out if they are associated with deleted survey attempts.
Returned Fields
Version History |
Field |
Description |
Type |
Column Size |
Key |
---|---|---|---|---|---|
1.0 |
AttemptId |
Unique attempt identifier. |
bigint |
8 |
PK, FK |
1.0 |
AttemptNumber |
Attempt number associated with the attempt ID. |
int |
4 |
|
1.0 |
QuestionId |
Unique question identifier. |
bigint |
8 |
PK, FK |
1.0 |
QuestionVersionId |
Unique question version identifier. |
bigint |
8 |
PK, FK |
1.0 |
AnswerId |
Unique answer identifier. |
bigint |
8 |
PK, FK |
5.7 / 6.0 - Changed Type and Column Size |
SortOrder |
Sort order of the survey answer responses. Field can be null. |
bigint |
8 |
|
1.0 |
IsCorrect |
Is user response correct. Field can be null. |
bit |
1 |
|
1.0 |
UserSelection |
Option the user chose for the question. Field can be null. |
bigint |
8 |
|
1.0 |
UserAnswer |
Answer the user entered. Field can be null. |
nvarchar |
1000 |
|
5.8 / 6.1 | FileSetId | Indicates the auto generated file set ID of uploaded file(s). Field can be null. | bigint | 8 |
Survey User Answers
The Survey User Answers Brightspace Data Set returns data to describe how a user responded to a survey question. Rows in the data set are filtered out if they are associated with deleted survey attempts.
Returned Fields
Version History |
Field |
Description |
Type |
Column Size |
Key |
---|---|---|---|---|---|
1.0 |
AttemptId |
Unique attempt identifier |
bigint |
8 |
PK, FK |
6.7 - Updated description |
QuestionId |
Unique question identifier. |
bigint |
8 |
PK, FK |
1.0 |
QuestionVersionId |
Unique question version identifier. Field can be null. |
bigint |
8 |
PK, FK |
1.0 |
TimeCompleted |
Date/time the survey was completed (UTC). Field can be null. |
datetime2 |
8 |
|
1.0 |
QuestionNumber |
Question number in the survey. Field can be null. |
int |
4 |
|
1.0 |
Comment |
Feedback left by instructor. Field can be null. |
nvarchar |
1000 |
|
1.0 |
SortOrder |
Sort order of the question. |
int |
4 |
|
4.8 / 5.2 - Updated column size |
Score |
Score the user received for the answer. Field can be null. |
decimal |
19, 9 |
|
1.0 |
Page |
Page the question appeared on when the user took the survey |
int |
4 |
|
1.0 | Assigned |
Indicates if the survey is assigned to a user. Field can be null. |
bit | 1 |