Brightspace Data Sets for Calendar have a dependency on Calendar. 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
The following diagram shows the relationships between entities used to create Brightspace Data Sets for Calendar. To enlarge the diagram, right-click on the image and select Open image in a new tab.
Calendar Events
The Calendar Events Brightspace Data Set returns a list of calendar events and their details for your org units.
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 1.0 |
ScheduleId
|
Unique identifier of the scheduled event
|
bigint
|
8
|
PK
|
| 1.0 |
OrgUnitId
|
Unique org unit identifier. For course-level events, the org unit ID displays.
Field can be null.
|
bigint
|
8
|
FK
|
| 1.0 |
UserId
|
Unique user identifier. For user-level events, the user ID displays.
Field can be null.
|
bigint
|
8
|
FK
|
| 5.7 / 6.0 - Changed Column Size |
Title
|
Calendar event title.
|
nvarchar
|
256
|
|
| 1.0 |
StartDate
|
Calendar event start date.
Field can be null.
|
datetime2
|
8
|
|
| 1.0 |
EndDate
|
Calendar event end date.
Field can be null.
|
datetime2
|
8
|
|
| 1.0 |
TimeZoneIdentifier
|
Time zone identifier.
|
varchar
|
256
|
|
| 1.0 |
IsAllDayEvent
|
Is all day event
|
bit
|
1
|
|
| 5.7 / 6.0 - Changed Column Size |
RecurrenceType
|
Calendar recurrence type: None, Daily, Weekly, Monthly, Yearly.
Field can be null.
|
varchar
|
7
|
|
| 1.0 |
RecurrenceInterval
|
Calendar recurrence interval.
|
int
|
4
|
|
| 1.0 |
CreatedByUserId
|
Created by user ID.
|
int
|
4
|
FK
|
| 1.0 |
LastModified
|
Last modified date and time.
|
datetime2
|
8
|
|
| 5.7 / 6.0 - Changed Column Size |
EventObjectTypeName
|
If event is associated with an object, displays the object type name.
Field can be null.
|
nvarchar
|
200
|
|
| 1.0 |
ObjectLookupId1
|
Shows primary look-up object ID of the associated object.
Field can be null.
|
bigint
|
8
|
|
| 1.0 |
ObjectLookupId2
|
Shows secondary look-up object ID of the associated object.
Field can be null.
|
bigint
|
8
|
|