Brightspace Data Sets for Attendance

Brightspace Data Sets for Attendance include:

These data sets 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

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

Entity Relationship Diagram for Attendance

 

Brightspace Data Set: Attendance Details

About

Returns attendance details for your org units.

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

AttendanceRegisterId

Unique attendance register identifier

BigInteger

8

 

1.0

OrgUnitId

Unique org unit identifier

Integer

4

FK

1.4 - Added Primary Key designation

UserId

Unique user identifier

Integer

4

PK

FK

1.0

RegisterName

Attendance register name

nvarchar

256

 

1.0

SessionName

Attendance session name

nvarchar

256

 

4.8 / 5.2 - Updated column size

Percentage

Score associated with the symbol. Field can be null.

Numeric

19, 9

 

1.0

Symbol

Attendance symbol

nvarchar

100

 

1.4 - Added AttendanceSessionId Unique attendance session identifier BigInteger 8 PK

 

Brightspace Data Set: Attendance Summary

About

Returns the attendance summary for all users in your org units.

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

AttendanceRegisterId

Unique attendance register identifier

BigInteger

8

PK

1.0

OrgUnitId

Unique org unit identifier

Integer

4

FK

2.0 - Updated to add PK

UserId

Unique user identifier

Integer

4

PK, FK

1.0

RegisterName

Attendance register name

nvarchar

256

 

4.8 / 5.2 - Updated column size

AttendanceScore

Score associated with given attendance symbol. Field can be null

Numeric

19, 9

 

4.8 / 5.2 - Updated column size

CauseForConcernScoreThreshold

Threshold level associated with attendance score. Field can be null

Numeric

19, 9

 

 

Brightspace Data Set: Attendance Registers

About

Describes the registers for taking attendance that exist in your 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.10 / 5.4

AttendanceRegisterId

Unique attendance register identifier.

BigInteger

8

PK

4.10 / 5.4

OrgUnitId

Unique org unit identifier.

Integer

4

FK

4.10 / 5.4

Name

The name given to the register.

nvarchar

256

 

4.10 / 5.4

Description

The description of the attendance register. Can be null.

nvarchar

Truncated to 1000 characters. To change the default value, contact D2L.

 

4.10 / 5.4

SchemeId

Unique identifier of the scheme used for the register.

BigInteger

8

FK

4.10 / 5.4

IsVisible

Indicates if users are allowed to view this register.

Boolean

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. Boolean 1  
4.10 / 5.4 CauseForConcern The threshold at which users will be flagged as a concern. Can be null. Numeric 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. TimeStamp 8  

 

Brightspace Data Set: Attendance Schemes

About

Describes the schemes that are available for use with attendance registers in your 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.10 / 5.4

SchemeId

Unique scheme identifier.

BigInteger

8

PK

4.10 / 5.4

OrgUnitId

Unique org unit identifier

Integer

4

FK

4.10 / 5.4

SchemeName

The given name of the scheme.

nvarchar

258

 

4.10 / 5.4

SchemeSymbolId

Unique scheme symbol identifier.

BigInteger

8

PK

4.10 / 5.4

SymbolName

The name given to the symbol.

nvarchar

256

 

4.10 / 5.4

SymbolValue

The value used for the symbol.

nvarchar

100

 

4.10 / 5.4 Percentage The score as a percentage that contributes towards the attendance score when a symbol is given. Can be null. Numeric 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. TimeStamp 8  

 

Brightspace Data Set: Attendance Sessions

About

Maps the sessions that exist for each register in your 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.10 / 5.4

AttendanceSessionId

Unique identifier for the session.

BigInteger

8

PK

4.10 / 5.4

AttendanceRegisterId

Unique attendance register identifier.

BigInteger

8

FK

4.10 / 5.4

Name

The given name of the session.

nvarchar

256

 

4.10 / 5.4

Description

The description of the session. Can be null.

nvarchar

512

 

4.10 / 5.4

SortOrder

The placement of the session in the register. Can be null.

Integer

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. TimeStamp 8  

 

Brightspace Data Set: Attendance User Sessions

About

Provides the result for each user's session in each register in your 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.10 / 5.4

UserId

Unique user identifier.

Integer

4

PK

4.10 / 5.4

AttendanceSessionId

Unique identifier for the session.

BigInteger

8

PK, FK

4.10 / 5.4

SchemeSymbolId

Unique scheme symbol identifier given to the user for the session.

BigInteger

8

FK

4.10 / 5.4

LastModified

Date the symbol for the user in the session was last modified. Can be null.

DateTime

8