Brightspace Data Sets for Users have no tool dependency.
Entity Relationship Diagram
The following diagram shows the relationships between entities used to create Brightspace Data Sets for Users. To enlarge the diagram, right-click on the image and select Open image in a new tab.
Auditor Relationships Log
The Auditor Relationships Log Brightspace Data Set has a record of auditors and the users they audit in the organization. The User Auditors tool must be enabled to access this data.
Note: The data set may appear blank unless new auditor-learner relationships are added. All historical data is populated 30 to 60 days after the November 2021/20.21.11 release.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 6.13 / 7.1 |
AuditorId
|
UserId (unique identifier) of the auditor.
|
int
|
4
|
PK, FK
|
| 6.13 / 7.1 |
UserToAuditId
|
UserId (unique identifier) of the user to be audited by the auditor.
|
int
|
4
|
PK, FK
|
| 6.15 / 7.3 - Updated description |
OrgUnitId
|
Org Unit identifier where the auditor relationship exists.
|
int
|
4
|
PK, FK
|
| 6.13 / 7.1 |
Action
|
The action performed on the relationship. Either Created or Deleted.
|
nvarchar
|
16
|
|
| 6.13 / 7.1 |
ModifiedBy
|
UserId who modified the auditor relationship.
|
int
|
4
|
FK
|
| 6.13 / 7.1 |
ModifiedDate
|
Date and time when the auditor relationship was modified (UTC).
|
datetime2
|
8
|
PK
|
Course Access
The Course Access Brightspace Data Set returns information on each day each user has accessed each course offering from the LMS (via a browser) across the organization. The data set does not include course access via any of our Apps.
The data set contains data from 1 January 2021 onwards and adheres to the default system limit of 150 million rows of the most recent data.
Note: If an administrator changes your time zone at the organization level, this can affect the calculation of DayAccessed because this field is in local time.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 2.4 |
OrgUnitId
|
Unique org unit identifier.
|
int
|
4
|
PK, FK
|
| 2.4 |
UserId
|
Unique user identifier.
|
int
|
4
|
PK, FK
|
| 7.5 - Updated description |
DayAccessed
|
Indicates the most recent day in local time when a user accessed the course.
|
datetime2
|
8
|
PK
|
Course Access Log
The Course Access Log Brightspace Data Set returns information on users accessing their course offerings using the Pulse app. The data set creates a row with a timestamp when a user initially accesses a course, then creates additional rows for every 30 minutes that the user spends in the course.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 7.5 |
OrgUnitId
|
Unique identifier for the org unit.
|
int
|
4
|
PK, FK
|
| 7.5 |
UserId
|
Unique identifier for the user.
|
int
|
4
|
PK, FK
|
| 7.5 |
Timestamp
|
Indicates the time in UTC that a user accessed the course.
|
datetime2
|
8
|
PK
|
| 7.5 |
Source |
The source of the course access. Only Pulse data is available at this time. |
nvarchar |
20 |
PK |
Enrollments and Withdrawals
The Enrollments and Withdrawals Brightspace Data Set returns a list of enrollments and withdrawals for all users in your organization.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
|
7.7 - Updated description
|
LogId |
Unique log entry identifier for any change to the user enrollment.
|
bigint |
8 |
PK |
|
5.7 / 6.0 - Added FK
|
UserId
|
Unique user identifier
|
int
|
4
|
FK
|
|
5.7 / 6.0 - Added FK
|
OrgUnitId
|
Unique org unit identifier
|
int
|
4
|
FK
|
|
5.7 / 6.0 - Added FK
|
RoleId
|
Unique role identifier.
Field can be null.
|
int
|
4
|
FK
|
| 3.2 |
Action |
Indicates whether the item is an enrollment or a withdrawal |
varchar |
50 |
|
| 3.2 |
ModifiedByUserId |
Identifies the last user who modified the enrollment status for the user.
Field can be null.
|
int |
4 |
|
| 3.2 |
EnrollmentDate
|
Date enrolled (UTC)
|
datetime2
|
8
|
|
User Attribute Definitions
The User Attribute Definitions Brightspace Data Set returns a list of all defined user attributes in your organization. If no user attributes are defined for your organization, the data set will not generate.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 4.10 / 5.4 |
AttributeId |
Unique identifier of the attribute. |
nvarchar |
128 |
PK |
| 4.10 / 5.4 |
Name
|
Display name for the attribute.
|
nvarchar
|
128
|
|
| 4.10 / 5.4 |
Type
|
Indicates the type of data stored in the attribute. Can be one of "string", "date", "user", or "org_unit".
|
nvarchar
|
8
|
|
| 4.10 / 5.4 |
AllowMultiple
|
Indicates if multiple values are allowed for the attribute (TRUE - 1) or not (FALSE - 0).
|
bit
|
1
|
|
| 4.10 / 5.4 |
IsDefault |
Indicates if the attribute is a default (TRUE - 1) or a custom attribute (FALSE - 0). |
bit |
1 |
|
| 4.10 / 5.4 |
LastModified
|
Date the attribute definition was last modified (UTC).
|
datetime2
|
8
|
|
| 4.10 / 5.4 |
ModifiedBy |
User who last modified the attribute definition. |
int |
4 |
FK |
| 4.10 / 5.4 |
IsDeleted
|
Indicates if the attribute definition is deleted (TRUE - 1) or not (FALSE - 0).
|
bit
|
1
|
|
| 4.10 / 5.4 |
Version |
Indicates the version of the row. This information is used to determine which table row occurred first. |
bigint |
8 |
|
User Attribute Values
The User Attribute Values Brightspace Data Set returns a list of all values for all defined user attributes for each user in your organization. If no user attributes are defined for your organization, the data set will not generate.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
|
5.7 / 6.0 - Added FK
|
UserId |
Unique identifier of the user who the attribute is assigned to. |
int |
4 |
PK, FK |
| 4.10 / 5.4 |
AttributeId |
Unique identifier of the attribute. |
nvarchar |
128 |
PK, FK |
| 7.19 / 8.5 - Updated description |
Value
|
Value or list of values assigned to the user for the given attribute. Formatted as comma-separated values (CSV).
|
nvarchar
|
4000
|
|
| 4.10 / 5.4 |
LastModified
|
Date the attribute value was last modified (UTC).
|
datetime2
|
8
|
|
| 4.10 / 5.4 |
ModifiedBy |
User who last modified the attribute value. |
int |
4 |
FK |
| 4.10 / 5.4 |
IsDeleted
|
Indicates if the attribute value is deleted (TRUE - 1) or not (FALSE - 0).
|
bit
|
1
|
|
| 4.10 / 5.4 |
Version |
Indicates the version of the row. This information is used to determine which row occurred first. |
int |
4 |
|
User Enrollments
The User Enrollments Brightspace Data Set returns a list of enrollments for all users in your organization.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 1.0 |
OrgUnitId
|
Unique org unit identifier
|
int
|
4
|
PK, FK
|
| 1.0 |
UserId
|
Unique user identifier
|
int
|
4
|
PK, FK
|
|
5.7 / 6.0 - Updated column size
|
RoleName
|
Role name
|
nvarchar
|
60
|
|
| 1.0 |
EnrollmentDate
|
Date enrolled (UTC)
|
datetime2
|
8
|
|
|
5.7 / 6.0 - Updated column size
|
EnrollmentType
|
Enrollment type.
Field can be null.
|
varchar
|
50
|
|
|
5.7 and 6.0 - Added FK
|
RoleId |
Unique role identifier |
int |
4 |
FK |
User Logins
The User Logins Brightspace Data Set returns a list of all login attempts for your organization.
The User Logins Brightspace Data Set contains data from 1 January 2021 onwards and adheres to the default system limit of 150 million rows of the most recent data.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 9.0 - Updated description |
UserId
|
Unique user identifier.
|
int
|
4
|
FK
|
|
6.6 - Updated description
|
UserName
|
User name used to attempt log in.
|
nvarchar
|
256
|
|
| 1.0 |
IP
|
IP address
|
varchar
|
64
|
|
| 2.5 / 3.0 - Removed FK |
SessionId
|
Unique session identifier.
Field can be null.
|
int
|
4
|
|
| 9.0 - Updated type |
StatusType
|
Login status
|
nvarchar
|
50
|
|
| 1.0 |
AttemptDate
|
Attempt date (UTC)
|
datetime2
|
8
|
|
| 1.0 |
ImpersonatingUserId
|
User ID of impersonator.
Field can be null.
|
int
|
4
|
FK
|
| 9.0 - Updated type and size |
LoginAttemptId |
Unique login attempt identifier |
nvarchar |
36 |
PK |
| 9.0 |
LoginSource |
The source of the login attempt, for example: Brightspace. |
nvarchar |
50 |
|
Users
The Users Brightspace Data Set returns a list of users in your organization.
Version 4.10 / 5.4 adds a system user entry with UserId = 0 to this data set. The system user is only included in the full CSV.
Version
History
|
Field
|
Description
|
Type
|
Size
|
Key
|
|---|
| 1.0 |
UserId
|
Unique user identifier
|
int
|
4
|
PK
|
|
5.7 / 6.0 - Updated column size
|
UserName
|
User name
|
nvarchar
|
270
|
|
| 4.9 / 5.3 - Corrected column size |
OrgDefinedId
|
Org defined ID.
Field can be null.
|
nvarchar
|
256
|
|
|
6.13 / 7.1 - Updated description
|
FirstName
|
User's first name. If a preferred first name is provided, it is used. If not, the legal first name is used.
|
nvarchar
|
64
|
|
|
5.7 / 6.0 - Updated column size
|
MiddleName
|
Middle name.
Field can be null.
|
nvarchar
|
64
|
|
|
6.13 / 7.1 - Updated description
|
LastName
|
User's last name. If a preferred last name is provided, it is used. If not, the legal last name is used.
|
nvarchar
|
64
|
|
| 1.0 |
IsActive
|
Is user active?
Field can be null.
|
bit
|
1
|
|
|
5.7 / 6.0 - Updated column size
|
Organization
|
Organization name.
Field can be null.
|
varchar
|
256
|
|
|
5.7 / 6.0 - Updated column size
|
ExternalEmail
|
External email address.
Field can be null.
|
nvarchar
|
256
|
|
| 1.0 |
SignupDate
|
Date the user was created in the system (UTC).
Field can be null.
|
datetime2
|
8
|
|
| 3.0 - Added |
FirstLoginDate |
Date when the user first logged in to the system (UTC).
Field can be null.
|
datetime2 |
8 |
|
|
3.1 -Added
|
Version |
Indicates the version of the content in the row.
Field can be null.
|
bigint |
8 |
|
| 4.10 / 5.4 - Added |
OrgRoleId |
The unique role identifier for the role of the user at the org level.
Field can be null.
|
int |
4 |
|
| 6.13 / 7.1 - Updated description |
LastAccessed |
The date the user last accessed the system. If the user has never accessed the system, captures the date the user was created.
|
datetime2 |
8 |
|