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.
Version
History
|
Field
|
Description
|
Type
|
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 |
| 9.4 - Updated description |
Name |
Name of the section (title).
Field can be null.
|
nvarchar |
256 |
|
| 9.4 - Updated description |
NameIsDisplayed |
Indicates if the section name (title) is hidden or shown. Values are 0 for hidden, and 1 for shown. |
bit |
1 |
|
| 9.4 - Updated description |
IsQuestionPool |
Indicates if the section is a question pool. |
bit |
1 |
|
| 9.4 - Updated description |
SectionText |
Section text.
Field can be null.
|
nvarchar |
1000 |
|
| 3.4 |
SectionTextIsHTML |
Indicates if the section text is HTML or plain text. |
bit |
1 |
|
| 9.4 - Updated description |
IsSectionTextHidden |
Indicates if the section text is hidden or shown. Values are 0 for hidden, and 1 for shown.
|
bit |
1 |
|
|
9.4 - Updated description
|
QuestionPoints |
Number of points the section is worth when the section is a question pool. Sections that are not question pools will show as null.
Field can be null.
|
decimal |
19, 9 |
|
| 9.4 - Updated description |
NumQuestions |
Indicates the number of questions in the section if the section is a question pool. If the section is not a question pool, 0 is displayed. |
int |
4 |
|
| 9.4 - Updated description |
NumChoices |
Indicates the number of choices in the question pool (pool size). |
int |
4 |
|
| 9.4 - Updated description |
Shuffle |
Indicates that the questions in the section are shuffled. Not to be confused with a question pool; a shuffled section displays the questions shuffled randomly. |
bit |
1 |
|
| 9.4 - Updated description |
CreationDate |
Date the section was created (UTC). |
datetime2 |
8 |
|
| 9.4 - Updated description & key |
CreatedBy |
Id of the user who created the section.
Field can be null.
|
bigint |
8 |
FK |
| 9.4 - Updated description |
LastModified |
Date when the section was last modified (UTC). |
datetime2 |
8 |
|
| 9.4 - Updated description & key |
LastModifiedBy |
Id of the user who last modified the section. If questions are imported into the section, this will be null.
Field can be null.
|
bigint |
8 |
FK |
| 9.4 - Updated description |
IsDeleted |
Indicates that the section is deleted.
Field can be null.
|
bit |
1 |
|
| 9.4 - Updated description |
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.
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.
|
Version
History
|
Field
|
Description
|
Type
|
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.
Version
History
|
Field
|
Description
|
Type
|
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 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.
Version
History
|
Field
|
Description
|
Type
|
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.
Version
History
|
Field
|
Description
|
Type
|
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 |
|
| 9.10 |
LastModified |
Date and time when the question answer response was last modified (UTC). |
datetime2 |
8 |
|
| 9.10 |
IsDeleted |
Indicates if the question answer response is deleted.
Field can be null.
|
bit |
1 |
|
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.
Version
History
|
Field
|
Description
|
Type
|
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
|
| 8.11 / 9.0 - Updated description |
TimeCompleted
|
Date/time when the question was completed (UTC). No data is provided for question pools or sections.
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 |
|
| 9.8 |
IsDeleted |
Indicates if the answer is deleted. |
bit |
1 |
|
| 9.8 |
LastModified |
Date and time when the question answer was last modified (UTC). |
datetime2 |
8 |
|
| 9.8 |
LastModifiedBy |
Id of the user or task who last modified the question. |
int |
4 |
FK
|
| 9.8 |
SurveyTimeCompleted |
Date and time the survey attempt was completed (UTC). |
datetime2 |
8 |
|
