Brightspace Data Sets for Organizational Units do not depend on specific tools being turned on.
Entity Relationship Diagram
The following diagram shows the relationships between entities used to create Brightspace Data Sets for Organizational Units. To enlarge the diagram, right-click on the image and select Open image in a new tab.
Organizational Units
The Organizational Units Brightspace Data Set returns details about all org units within your organization.
Returned Fields
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 1.0 |
OrgUnitId
|
Unique org unit identifier
|
int
|
4
|
PK
|
| 5.7 / 6.0 - Changed Column Size |
Organization
|
Organization name
|
nvarchar
|
50
|
|
| 6.16 / 7.4 - Updated description |
Type
|
Org unit type. For example: Group, Section, Semester, Department, etc.
|
nvarchar
|
50
|
|
| 5.7 / 6.0 - Changed Column Size |
Name
|
Org unit name.
Field can be null.
|
nvarchar
|
128
|
|
| 4.8 / 5.2 - Updated description & column size |
Code
|
Org unit code.
Field can be null.
|
nvarchar
|
50
|
|
| 1.0 |
StartDate
|
Availability start date (UTC).
Field can be null.
|
datetime2
|
8
|
|
| 1.0 |
EndDate
|
Availability end date (UTC).
Field can be null.
|
datetime2
|
8
|
|
| 1.0 |
IsActive
|
Is the org unit active
|
bit
|
1
|
|
| 1.0 |
CreatedDate
|
Org unit create date
|
datetime2
|
8
|
|
| 1.9 |
IsDeleted |
Is the org unit soft deleted or recycled.
Soft delete - the org unit has been soft deleted from the application, but is still present in the database.
Recycled - the org unit remains in the recycle bin until removed, at which point it is deleted.
The OrgName for recycled or soft deleted org units is SYSTEM.
Backfill of historical IsDeleted, DeletedDate, and RecycledDate values is determined by the date/time values in the OrgUnit audit log.
Field can be null.
|
bit |
1 |
|
| 1.9 |
DeletedDate |
Date the org unit was soft deleted.
Field can be null.
|
datetime2 |
8 |
|
| 1.9 |
RecycledDate |
Date the org unit was recycled.
Field can be null.
|
datetime2 |
8 |
|
| 3.1 |
Version |
Indicates the version of the content in the row. |
bigint |
8 |
|
| 4.8 / 5.2 |
OrgUnitTypeId |
Identifier for the org unit type. |
int |
4 |
|
Organizational Unit Ancestors
The Organizational Unit Ancestors Brightspace Data Set returns a list of all the org units and the corresponding ancestors for an org unit. An ancestor is defined as a parent of an org unit.
Returned Fields
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 1.0 |
OrgUnitId
|
Unique org unit identifier
|
int
|
4
|
PK, FK
|
| 1.0 |
AncestorOrgUnitId
|
Parent org unit identifier
|
int
|
4
|
PK, FK
|
Organizational Unit Descendants
The Organizational Unit Descendants Brightspace Data Set returns a list of all the org units and the corresponding descendants for an org unit. A descendant is defined as the child of an org unit.
Returned Fields
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 1.0 |
OrgUnitId
|
Unique org unit identifier
|
int
|
4
|
PK, FK
|
| 1.0 |
DescendantOrgUnitId
|
Child org unit identifier
|
int
|
4
|
PK, FK
|
Organizational Unit Parents
The Organizational Unit Parents Brightspace Data Set returns the direct parent of each org unit in order to build out the initial org unit structure.
Returned Fields
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 2.3 |
OrgUnitId
|
Unique org unit identifier
|
int
|
4
|
PK, FK
|
| 2.3 |
ParentOrgUnitId
|
Parent org unit identifier
|
int
|
4
|
PK, FK
|
| 5.7 / 6.0 - Changed Type and Column Size |
RowVersion |
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 |
|
| 8.6 |
DateDeleted |
Date the parent-child relationship was deleted (UTC).
Field can be null.
|
datetime2 |
8 |
|
Organizational Unit Recent Access
The Organizational Unit Recent Access Brightspace Data Set returns a list of users, corresponding org units, and the time stamp when they most recently accessed the org unit.
Returned Fields
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 1.0 |
OrgUnitId
|
Unique org unit identifier
|
int
|
4
|
PK, FK
|
| 8.6 - Fixed Field name |
UserId
|
User Id of the user that accessed the org unit
|
int
|
4
|
PK, FK
|
| 1.0 |
LastAccessedDate
|
Date the org was last accessed (UTC).
|
datetime2
|
8
|
|