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.

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

To show the relationships between entities used to create Brightspace Data Sets for Surveys, click the following thumbnail image:

Entity Relationship Diagram for Surveys

 

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:

 

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

bigint

8

PK

1.0

SurveyId

Unique survey identifier.

Field can be null.

bigint

8

 

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  

 

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

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

 

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

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

 

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.

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  

 

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

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  

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

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

 

Brightspace Data Set: Survey Objects

About

The Survey Objects data set describes all the surveys 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

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  
5.6 AttemptsAllowed Indicates the number of attempts of the survey that a user is allowed to take. 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