Brightspace Data Sets for Surveys

Brightspace Data Sets for Surveys include:

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:

Entity Relationship Diagram for Surveys

 

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.

 

4.8 / 5.2 - Updated column size

Weight

Weight associated with the answer

Numeric

19, 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

 

4.8 / 5.2 - Updated column size

Weight

Weight associated with answer. Field can be null.

Numeric

19, 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 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

 

4.8 / 5.2 - Updated column size

Score

Score the user received for the answer. Field can be null.

Numeric

19, 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 - Added

4.7 / 5.1 - Updated description

CollectionId Unique identifier for the quiz or survey. 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 - Added

4.8 / 5.2 - Updated column size

QuestionPoints Can be Null Numeric 19, 9  
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