Organizational Units data set: columns, keys and joins
Checked against D2L on October 31, 2026
Back to the mapColumns
| Column | Type | Size | Key |
|---|---|---|---|
OrgUnitId | int | 4 | PK |
Organization | nvarchar | 50 | |
Type | nvarchar | 50 | |
Name | nvarchar | 128 | |
Code | nvarchar | 50 | |
StartDate | datetime2 | 8 | |
EndDate | datetime2 | 8 | |
IsActive | bit | 1 | |
CreatedDate | datetime2 | 8 | |
IsDeleted | bit | 1 | |
DeletedDate | datetime2 | 8 | |
RecycledDate | datetime2 | 8 | |
Version | bigint | 8 | |
OrgUnitTypeId | int | 4 |
Joins to (0)
None
Joined from (59)
- Accommodations Profile Log
OrgUnitId→OrgUnitId - Activity Exemptions Log
OrgUnitId→OrgUnitId - Activity Feed Comment Log
OrgUnitId→OrgUnitId - Activity Feed Comment Objects
OrgUnitId→OrgUnitId - Activity Feed Post Log
OrgUnitId→OrgUnitId - Activity Feed Post Objects
OrgUnitId→OrgUnitId - AI Consumption
OrgUnitId→OrgUnitId - Announcements
OrgUnitId→OrgUnitId - Assignment Submissions
OrgUnitId→OrgUnitId - Assignment Summary
OrgUnitId→OrgUnitId - Attendance Registers
OrgUnitId→OrgUnitId - Attendance Schemes
OrgUnitId→OrgUnitId - Auditor Relationships Log
OrgUnitId→OrgUnitId - Awards Issued
OrgUnitId→OrgUnitId - Calendar Events
OrgUnitId→OrgUnitId - Checklist Objects
OrgUnitId→OrgUnitId - Competency Activities
OrgUnitId→OrgUnitId - Competency Activity Results
OrgUnitId→OrgUnitId - Competency Objects
OrgUnitId→OrgUnitId - Content Files Properties Log
OrgUnitId→OrgUnitId - Content Objects
OrgUnitId→OrgUnitId - Content User Completion
OrgUnitId→OrgUnitId - Course Access
OrgUnitId→OrgUnitId - Course Access Log
OrgUnitId→OrgUnitId - Course Awards
OrgUnitId→OrgUnitId - Course Publisher Launches
OrgUnitId→OrgUnitId - Creator+ Practices Adoption
OrgUnitId→OrgUnitId - Creator+ Practices Engagement
OrgUnitId→OrgUnitId - Discussion Forums
OrgUnitId→OrgUnitId - Discussion Posts
OrgUnitId→OrgUnitId - Discussion Topics
OrgUnitId→OrgUnitId - Enrollments and Withdrawals
OrgUnitId→OrgUnitId - Grade Book Settings
OrgUnitId→OrgUnitId - Grade Objects
OrgUnitId→OrgUnitId - Grade Results
OrgUnitId→OrgUnitId - Grade Schemes
OrgUnitId→OrgUnitId - Intelligent Agent Objects
OrgUnitId→OrgUnitId - Intelligent Agent Run Users
OrgUnitId→OrgUnitId - LTI Link Migration Audit
OrgUnitId→OrgUnitId - LTI Links
OrgUnitId→OrgUnitId - Organizational Unit Ancestors
OrgUnitId→OrgUnitId - Organizational Unit Descendants
OrgUnitId→OrgUnitId - Organizational Unit Parents
OrgUnitId→OrgUnitId - Organizational Unit Recent Access
OrgUnitId→OrgUnitId - Outcomes Course Specific Scales
OrgUnitId→OrgUnitId - Outcomes Set Course
OrgUnitId→OrgUnitId - Portfolio Categories
OrgUnitId→OrgUnitId - Portfolio Evidence Log
OrgUnitId→OrgUnitId - Portfolio Evidence Objects
OrgUnitId→OrgUnitId - Quiz Attempts
OrgUnitId→OrgUnitId - Quiz Objects
OrgUnitId→OrgUnitId - Release Condition Objects
OrgUnitId→OrgUnitId - Rubric Assessment
OrgUnitId→OrgUnitId - SCORM Objects
OrgUnitId→OrgUnitId - SCORM Visits
OrgUnitId→OrgUnitId - Survey Attempts
OrgUnitId→OrgUnitId - Survey Objects
OrgUnitId→OrgUnitId - User Enrollments
OrgUnitId→OrgUnitId - Virtual Classroom Usage
OrgUnitId→OrgUnitId
Edit history links
None