Brightspace Data Sets for Surveys
Brightspace Data Sets for Surveys include:
- Survey Attempts
- Survey Question Answer Options
- Survey Question Answers
- Survey Questions
- Survey User Answer Responses
- Survey User Answers
- Quiz Survey Sections
These data sets 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.
Entity Relationship Diagram
To show the relationships between entities used to create Brightspace Data Sets for Surveys, click the following thumbnail image:
Brightspace Data Set: Survey Attempts
About
Returns details for each user survey attempt for all your org units. This data set includes completed survey attempts and in-progress survey attempts.
Data Set Availability
This data set is available as:
- Full CSV, produced on a weekly basis, containing all of the data.
- Differential CSV, produced on a daily basis or hourly basis as a paid add-on, containing the differences (diffs) of the data that was updated or inserted since the last successful differential which is typically the previous day or hour, respectively.
Returned Fields
|
Version History |
Field |
Description |
Type |
Column Size |
Key |
|
1.0 |
AttemptId |
Unique attempt identifier |
BigInteger |
8 |
PK |
|
1.0 |
SurveyId |
Unique survey identifier |
BigInteger |
8 |
|
|
1.0 |
UserId |
Unique user identifier |
Integer |
4 |
FK |
|
1.0 |
OrgUnitId |
Unique org unit identifier |
Integer |
4 |
FK |
|
1.0 |
SurveyName |
Survey name |
nvarchar |
512 |
|
|
1.0 |
AttemptNumber |
Attempt number for the survey |
Integer |
4 |
|
|
1.0 |
TimeStarted |
Survey attempt start time (UTC). |
DateTime |
8 |
|
|
1.0 |
TimeCompleted |
Survey attempt complete time (UTC). Field can be null. |
DateTime |
8 |
|
|
1.1 - Added |
AttemptedFromOrgUnitId | Org unit identifier where the survey was attempted from. Field can be null. | Integer | 4 | FK |
| 1.10 | OldAttemptNumber | Number of previous times a learner has attempted the survey. Field can be null. | Integer | 4 | |
| 1.10 | IsDeleted | Indicates that the survey attempt is deleted. | Boolean | 1 |
Brightspace Data Set: Survey Question Answer Options
About
Returns possible options for a given survey question. For example, if the survey has different options, this data set displays the options users can choose from. Rows in the data set are filtered out if they are associated with deleted survey questions.
Data Set Availability
This data set is available as:
- Full CSV, produced on a weekly basis, containing all of the data.
- Differential CSV, produced on a daily basis or hourly basis as a paid add-on, containing the differences (diffs) of the data that was updated or inserted since the last successful differential which is typically the previous day or hour, respectively.
Returned Fields
| Version History |
Field |
Description |
Type |
Column Size |
Key |
| 1.0 |
AnswerId |
Unique answer identifier |
BigInteger |
8 |
PK |
| 1.0 |
AnswerText |
Answer the user entered |
nvarchar |
Truncated to 1000 characters. To change the default value, contact D2L. |
|
| 1.0 |
Weight |
Weight associated with the answer |
Numeric |
9 |
|
| 1.0 |
QuestionId |
Unique question identifier |
BigInteger |
8 |
PK |
| 1.0 |
QuestionVersionId |
Unique question version identifier |
BigInteger |
8 |
PK |
| 2.5/3.0 Added keys | SurveyObjectId | Unique survey object identifier | BigInteger | 8 | PK, FK |
| 1.2 - Added | AnswerOptionId | Unique survey answer identifier | BigInteger | 8 | PK |
Brightspace Data Set: Survey Question Answers
About
Returns possible answers for a given survey. Rows in the data set are filtered out if they are associated with deleted survey questions.
Data Set Availability
This data set is available as:
- Full CSV, produced on a weekly basis, containing all of the data.
- Differential CSV, produced on a daily basis or hourly basis as a paid add-on, containing the differences (diffs) of the data that was updated or inserted since the last successful differential which is typically the previous day or hour, respectively.
Returned Fields
| Version History |
Field |
Description |
Type |
Column Size |
Key |
| 1.0 |
AnswerId |
Unique answer identifier |
BigInteger |
8 |
PK |
| 1.0 |
QuestionId |
Unique question identifier |
BigInteger |
8 |
PK |
| 1.0 |
QuestionVersionId |
Unique question version identifier |
BigInteger |
8 |
PK |
| 1.0 |
SortOrder |
Order in which the survey answers are displayed or correct answer order for ordering questions |
Integer |
4 |
|
| 1.0 |
IsCorrect |
Is answer correct. Field can be null. |
Boolean |
1 |
|
| 1.0 |
Weight |
Weight associated with answer. Field can be null. |
Numeric |
9 |
|
| 1.0 |
Answer |
Answer text |
nvarchar |
Unlimited |
|
| 1.0 |
Comment |
Instructor comment on the answer. Field can be null. |
nvarchar |
Truncated to 1000 characters. To change the default value, contact D2L. |
|
| 1.0 |
Description |
System description for the type of answer expected. Field can be null. |
nvarchar |
512 |
|
| 1.2 - Added | SurveyObjectId | Unique survey object identifier | BigInteger | 8 |
PK |
Brightspace Data Set: Survey Questions
About
Returns information about each question in each survey.
Data Set Availability
This data set is available as:
- Full CSV, produced on a weekly basis, containing all of the data.
- Differential CSV, produced on a daily basis or hourly basis as a paid add-on, containing the differences (diffs) of the data that was updated or inserted since the last successful differential which is typically the previous day or hour, respectively.
Returned Fields
| Version History |
Field |
Description |
Type |
Column Size |
Key |
| 2.5/3.0 - Removed FK |
SurveyId |
Unique survey identifier |
BigInteger |
8 |
|
| 1.0 |
Order |
Order in which the survey questions are displayed |
BigInteger |
8 |
|
| 1.0 |
CreatedDate |
Date the question was created (UTC). |
DateTime |
8 |
|
| 1.0 |
Difficulty |
Difficulty level assigned to the question. Field can be null. |
Integer |
4 |
|
| 1.0 |
IsBonus |
Is the question a bonus question. Field can be null. |
Boolean |
1 |
|
| 1.0 |
IsMandatory |
Is the question mandatory |
Boolean |
1 |
|
| 1.0 |
IsAutoGraded |
Is the question auto graded |
Boolean |
1 |
|
| 1.0 |
SectionName |
Section name. Field can be null. |
nvarchar |
256 |
|
| 1.0 |
LastModified |
Date time the question was last modified (UTC) |
DateTime |
8 |
|
| 1.0 |
Points |
Number of points associated with the question. Field can be null. |
Numeric |
9 |
|
| 1.0 |
QuestionId |
Unique question identifier |
BigInteger |
8 |
PK |
| 1.0 |
QuestionVersionId |
Unique question version identifier |
BigInteger |
8 |
PK |
| 1.0 |
QuestionType |
Name of type of question |
nvarchar |
512 |
|
| 1.0 |
Name |
Question name |
nvarchar |
512 |
|
| 1.0 |
Question |
Question text |
nvarchar |
Truncated to 1000 characters. To change the default value, contact D2L. |
|
| 1.0 |
Comment |
Question comment |
nvarchar |
Truncated to 1000 characters. To change the default value, contact D2L. |
|
| 1.0 |
AnswerKey |
Question hint. Field can be null. |
nvarchar |
Truncated to 1000 characters. To change the default value, contact D2L. |
|
| 1.3 | ObjectId | Unique survey question ID | BigInteger | 8 | PK |
| 1.10 | IsDeleted | Indicates if the survey question is deleted | Boolean | 1 |
Brightspace Data Set: Survey User Answer Responses
About
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.
Data Set Availability
This data set is available as:
- Full CSV, produced on a weekly basis, containing all of the data.
- Differential CSV, produced on a daily basis or hourly basis as a paid add-on, containing the differences (diffs) of the data that was updated or inserted since the last successful differential which is typically the previous day or hour, respectively.
Returned Fields
| Version History |
Field |
Description |
Type |
Column Size |
Key |
| 1.0 |
AttemptId |
Unique attempt identifier |
BigInteger |
8 |
PK |
| 1.0 |
AttemptNumber |
Attempt number associated with the attempt ID |
Integer |
4 |
|
| 1.0 |
QuestionId |
Unique question identifier |
BigInteger |
8 |
PK |
| 1.0 |
QuestionVersionId |
Unique question version identifier |
BigInteger |
8 |
PK |
| 1.0 |
AnswerId |
Unique answer identifier |
BigInteger |
8 |
PK |
| 1.0 |
SortOrder |
Sort order of the survey answer responses |
Integer |
4 |
|
| 1.0 |
IsCorrect |
Is user response correct |
Boolean |
1 |
|
| 1.0 |
UserSelection |
Option the user chose for the question. Field can be null. |
BigInteger |
8 |
|
| 1.0 |
UserAnswer |
Answer the user entered. Field can be null. |
nvarchar |
Truncated to 1000 characters. To change the default value, contact D2L. |
|
Brightspace Data Set: Survey User Answers
About
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.
Data Set Availability
This data set is available as:
- Full CSV, produced on a weekly basis, containing all of the data.
- Differential CSV, produced on a daily basis or hourly basis as a paid add-on, containing the differences (diffs) of the data that was updated or inserted since the last successful differential which is typically the previous day or hour, respectively.
Returned Fields
| Version History |
Field |
Description |
Type |
Column Size |
Key |
| 1.0 |
AttemptId |
Unique attempt identifier |
BigInteger |
8 |
PK |
| 1.0 |
QuestionId |
Unique question identifier |
BigInteger |
8 |
PK |
| 1.0 |
QuestionVersionId |
Unique question version identifier |
BigInteger |
8 |
PK |
| 1.0 |
TimeCompleted |
Date/time the survey was completed (UTC). Field can be null. |
DateTime |
8 |
|
| 1.0 |
QuestionNumber |
Question number in the survey. Field can be null. |
Integer |
4 |
|
| 1.0 |
Comment |
Feedback left by instructor. Field can be null. |
nvarchar |
Truncated to 1000 characters. To change the default value, contact D2L. |
|
| 1.0 |
SortOrder |
Sort order of the question |
Integer |
4 |
|
| 1.0 |
Score |
Score the user received for the answer. Field can be null. |
Numeric |
9 |
|
| 1.0 |
Page |
Page the question appeared on when the user took the survey |
Integer |
4 |
|
| 1.0 | Assigned | Indicates if the survey is assigned to a user. | Boolean | 1 |
Brightspace Data Set: Quiz Survey Sections
About
The Quiz Survey Sections data set returns information about all the sections and question pools that have been created in quizzes in the organization.
Data Set Availability
This data set is available as:
- Full CSV, produced on a weekly basis, containing all of the data.
- Differential CSV, produced on a daily basis or hourly basis as a paid add-on, containing the differences (diffs) of the data that was updated or inserted since the last successful differential which is typically the previous day or hour, respectively.
Returned Fields
| Version History |
Field |
Description |
Type |
Column Size |
Key |
| 3.4 | CollectionId | Unique question collection identifier | BigInteger | 8 | FK |
| 3.4 | SectionId | Unique section identifier. | BigInteger | 8 | PK |
| 3.4 | Name | Can be Null. | Nvarchar | 512 | |
| 3.4 | NameIsDisplayed | Indicates if the section name is hidden or shown. | Boolean | 1 | |
| 3.4 | IsQuestionPool | Indicates if the question pool is a random section. | Boolean | 1 | |
| 3.4 | SectionText | Can be Null | Nvarchar | Truncated to 1000 characters. To change the default value, contact D2L. | |
| 3.4 | SectionTextIsHTML | Indicates if the section text is HTML or plain text. | Boolean | 1 | |
| 3.4 | IsSectionTextHidden | Indicates if the section text is hidden or shown. Values are 0 for hidden, and 1 for shown. | Boolean | 1 | |
| 3.4 | QuestionPoints | Can be Null | Numeric | 10 | |
| 3.4 | NumQuestions | Indicates the number of questions in the quiz section. | Integer | 4 | |
| 3.4 | NumChoices | Indicates the number of choices in the question pool from which the quiz can be created. | Integer | 4 | |
| 3.4 | Shuffle | Indicates that the quiz questions in the pool are shuffled. | Boolean | 1 | |
| 3.4 | CreationDate | Date the quiz was created (UTC). | DateTime | 8 | |
| 3.4 | CreatedBy | Id of the user who created the quiz. Field can be null. | BigInteger | 8 | |
| 3.4 | LastModified | Date when the quiz was last modified (UTC). | DateTime | 8 | |
| 3.4 | LastModifiedBy | Id of the user who last modified the quiz. Field can be null. | BigInteger | 8 | |
| 3.4 | IsDeleted | Indicates that the quiz question is deleted | Boolean | 1 |