Brightspace Data Sets for Attendance have a dependency on Attendance. 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 Attendance. To enlarge the diagram, right-click on the image and select Open image in a new tab.
Attendance Registers
The Attendance Registers Brightspace Data Set describes the registers for taking attendance that exist in your organization.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 4.10 / 5.4 |
AttendanceRegisterId
|
Unique attendance register identifier.
|
bigint
|
8
|
PK
|
| 4.10 / 5.4 |
OrgUnitId
|
Unique org unit identifier.
|
int
|
4
|
FK
|
| 5.7 / 6.0 - Changed Column Size |
Name
|
The name given to the register.
|
nvarchar
|
128
|
|
| 4.10 / 5.4 |
Description
|
The description of the attendance register.
Field can be null.
|
nvarchar
|
1000
|
|
| 4.10 / 5.4 |
SchemeId
|
Unique identifier of the scheme used for the register.
|
bigint
|
8
|
FK
|
| 4.10 / 5.4 |
IsVisible
|
Indicates if users are allowed to view this register.
|
bit
|
1
|
|
| 4.10 / 5.4 |
IncludeAllUsers |
Indicates that all users in the course can be assessed with this register. If false, only specific groups/sections are included. |
bit |
1 |
|
| 4.10 / 5.4 |
CauseForConcern |
The threshold at which users will be flagged as a concern.
Field can be null.
|
decimal |
19, 9 |
|
| 4.10 / 5.4 |
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 |
|
| 9.9 |
DateDeleted |
Deleted date of the attendance register (UTC).
Field can be null.
|
datetime2 |
8 |
|
| 9.9 |
DeletedBy |
Unique identifier of the user who performed the delete action.
Field can be null.
|
int |
4 |
|
Attendance Schemes
The Attendance Schemes Brightspace Data Set describes the schemes that are available for use with attendance registers in your organization.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 4.10 / 5.4 |
SchemeId
|
Unique scheme identifier.
|
bigint
|
8
|
PK
|
| 4.10 / 5.4 |
OrgUnitId
|
Unique org unit identifier.
Field can be null.
|
int
|
4
|
FK
|
| 5.7 / 6.0 - Changed Column Size |
SchemeName
|
The given name of the scheme.
|
nvarchar
|
128
|
|
| 4.10 / 5.4 |
SchemeSymbolId
|
Unique scheme symbol identifier.
|
bigint
|
8
|
PK
|
| 5.7 / 6.0 - Changed Column Size |
SymbolName
|
The name given to the symbol.
|
nvarchar
|
128
|
|
| 5.7 / 6.0 - Changed Column Size |
SymbolValue
|
The value used for the symbol.
|
nvarchar
|
50
|
|
| 4.10 / 5.4 |
Percentage |
The score as a percentage that contributes towards the attendance score when a symbol is given.
Field can be null.
|
decimal |
19, 9 |
|
| 4.10 / 5.4 |
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 |
|
Attendance Sessions
The Attendance Sessions Brightspace Data Set maps the sessions that exist for each register in your organization.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 4.10 / 5.4 |
AttendanceSessionId
|
Unique identifier for the session.
|
bigint
|
8
|
PK
|
| 4.10 / 5.4 |
AttendanceRegisterId
|
Unique attendance register identifier.
|
bigint
|
8
|
FK
|
| 5.7 / 6.0 - Changed Column Size |
Name
|
The given name of the session.
|
nvarchar
|
128
|
|
| 5.7 / 6.0 - Changed Column Size |
Description
|
The description of the session.
Field can be null.
|
nvarchar
|
256
|
|
| 4.10 / 5.4 |
SortOrder
|
The placement of the session in the register.
Field can be null.
|
int
|
4
|
|
| 4.10 / 5.4 |
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 |
|
| 9.9 |
DateDeleted |
Date the session was deleted (UTC).
Field can be null.
|
datetime2 |
8 |
|
| 9.9 |
DeletedBy |
Unique identifier of the user who performed the delete action.
Field can be null.
|
int |
4 |
|
Attendance User Sessions
The Attendance User Sessions Brightspace Data Set provides the result for each user's session in each register in your organization.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 4.10 / 5.4 |
UserId
|
Unique user identifier.
|
int
|
4
|
PK
|
| 4.10 / 5.4 |
AttendanceSessionId
|
Unique identifier for the session.
|
bigint
|
8
|
PK, FK
|
| 4.10 / 5.4 |
SchemeSymbolId
|
Unique scheme symbol identifier given to the user for the session.
|
bigint
|
8
|
FK
|
| 4.10 / 5.4 |
LastModified
|
Date the symbol for the user in the session was last modified (UTC).
Field can be null.
|
datetime2
|
8
|
|
| 6.15 / 7.3 |
LastModifiedBy |
Unique identifier for the user who last modified the session.
Field can be null.
|
int |
4 |
|
| 9.9 |
IsDeleted |
Indicates if the user session has been deleted. |
bit |
1 |
|
| 9.9 |
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 |
|