This partner data set is only available to customers with Bongo Premium. If you turn Virtual Classroom on and off during the data set query period, there may be unexpected or missing content in your data sets.
Entity Relationship Diagram
The following diagram shows the relationships between entities used to create Brightspace Data Sets for Virtual Classroom. To enlarge the diagram, right-click on the image and select Open image in a new tab.
Virtual Classroom Usage
The Virtual Classroom Usage Brightspace Data Set returns information about how Virtual Classroom by Bongo is being used for Bongo Premium customers. The first data point is from July 1, 2018 and the data set will only appear for Bongo Premium customers if there is usage to retrieve.
Note: The data includes all Virtual Classroom meetings that have ever been created. Cancelled meetings can be identified using the IsCancelled field, and do not appear in the LTI Links Brightspace Data Set. The Virtual Classroom UI only displays meetings that are scheduled to occur in the future, or have occurred and were recorded.
Note: This data set is available as a FULL CSV containing all of the data and does not include a differential. Data is produced on a weekly basis, regardless of whether you purchased the hourly data freshness add-on. Since the data is owned by Bongo, data set generation is done on a region schedule and may not align to existing schedules.
Returned Fields
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 4.9 / 5.3 |
OrgUnitId
|
Unique org unit identifier of the course where the meeting was scheduled.
Will be null if the meeting was cancelled.
|
int
|
4
|
FK
|
| 6.14 / 7.2 - Updated Column size |
CourseName
|
The name of the course where the meeting was scheduled.
Will be null if the meeting was cancelled.
|
nvarchar
|
255
|
|
| 4.9 / 5.3 |
MeetingId
|
Unique meeting identifier. If a meeting is reoccurring, each occurrence is represented in a new row.
|
nvarchar
|
36
|
PK
|
| 4.9 / 5.3 |
MeetingName
|
The name of the Virtual Classroom meeting.
|
nvarchar
|
255
|
|
| 4.9 / 5.3 |
CreationUserId
|
Unique identifier of the user who scheduled the meeting.
|
int
|
4
|
FK
|
| 4.9 / 5.3 |
CreationDate
|
The date and time the meeting was created (UTC).
|
datetime2
|
8
|
|
| 4.9 / 5.3 |
ScheduledDate
|
The date and time the meeting is scheduled to start (UTC).
|
datetime2
|
8
|
|
| 4.9 / 5.3 |
ScheduledDuration
|
Planned length of the meeting in minutes.
|
int
|
4
|
|
| 4.9 / 5.3 |
IsPublished
|
Indicates if the option to automatically publish the recording to attendees is enabled.
|
bit
|
1
|
|
| 4.9 / 5.3 |
ExternalLinksEnabled
|
Indicates if the option to use external links to join the meeting was enabled when the Virtual Classroom session was scheduled.
|
bit
|
1
|
|
| 4.9 / 5.3 |
WholeClassInvited |
Indicates if all users in an org unit were invited. |
bit |
1 |
|
| 4.9 / 5.3 |
IsCancelled |
Indicates if the meeting is cancelled. Comparable to IsDeleted in other data sets. |
bit |
1 |
|
| 4.9 / 5.3 |
StartDateTime |
The DateTime that the Virtual Classroom session was started (UTC).
Will be null if the meeting was not started or canceled.
|
datetime2 |
8 |
|
| 4.9 / 5.3 |
EndDateTime |
The DateTime that the Virtual Classroom session was ended (UTC).
Will be null if the meeting was not started or canceled.
|
datetime2 |
8 |
|
| 4.9 / 5.3 |
IsRecorded |
Indicates if the meeting was recorded. |
bit |
1 |
|