Users and access

Users data set: columns, keys and joins

Primary key: UserId 12 columns

Checked against D2L on October 31, 2026

Columns

Column	Type	Size	Key
`UserId`	`int`	`4`	PK
`UserName`	`nvarchar`	`270`
`OrgDefinedId`	`nvarchar`	`256`
`FirstName`	`nvarchar`	`64`
`MiddleName`	`nvarchar`	`64`
`LastName`	`nvarchar`	`64`
`IsActive`	`bit`	`1`
`ExternalEmail`	`nvarchar`	`256`
`CreationDate`	`datetime2`	`8`
`Version`	`bigint`	`8`
`OrgRoleId`	`int`	`4`
`DateDeleted`	`datetime2`	`8`

Joins to (0)

None

Joined from (48)

Activity Exemptions LogUserId → UserId
Activity Feed Comment LogUserId → UserId
Activity Feed Post LogUserId → UserId
AI ConsumptionUserId → UserId
Assignment Special AccessUserId → UserId
Assignment Submission DetailsUserId → UserId
Awards IssuedUserId → UserId
Calendar EventsUserId → UserId
Checklist CompletionsUserId → UserId
Competency Activity ResultsUserId → UserId
Content User CompletionUserId → UserId
Content User ProgressUserId → UserId
Course AccessUserId → UserId
Course Access LogUserId → UserId
Course Copy LogsUserId → UserId
Course Publisher LaunchesUserId → UserId
CPD Question AnswersUserId → UserId
CPD User RecordsUserId → UserId
CPD User TargetsUserId → UserId
Creator+ Practices EngagementUserId → UserId
Discussion PostsUserId → UserId
Discussion Posts Read StatusUserId → UserId
Discussion Topic User ScoresUserId → UserId
Enrollments and WithdrawalsUserId → UserId
Grade Objects LogUserId → UserId
Grade ResultsUserId → UserId
Intelligent Agent Run UsersUserId → UserId
JIT Provisioned Users LogUserId → UserId
Local Authentication Security LogUserId → UserId
LTI Link Migration AuditUserId → UserId
Media Consumption LogUserId → UserId
Organizational Unit Recent AccessUserId → UserId
Portfolio Evidence LogUserId → UserId
PreRequisite Conditions MetUserId → UserId
Quiz AttemptsUserId → UserId
Quiz Attempts LogUserId → UserId
Release Condition ResultsUserId → UserId
Rubric AssessmentUserId → UserId
SCORM VisitsUserId → UserId
Session HistoryUserId → UserId
SIS Course Merge LogUserId → UserId
Source Course Deploy HistoryUserId → UserId
Survey AttemptsUserId → UserId
System Access LogUserId → UserId
System Access SummaryUserId → UserId
User Attribute ValuesUserId → UserId
User EnrollmentsUserId → UserId
User LoginsUserId → UserId

Edit history links

Accommodations Profile LogModifiedBy → UserId
Activity Exemptions LogLastModifiedBy → UserId
Activity Feed Comment ObjectsLastModifiedBy → UserId
Activity Feed Post ObjectsLastModifiedBy → UserId
AnnouncementsDeletedByUserId → UserId
Assignment Special AccessModifiedBy → UserId
Auditor Relationships LogModifiedBy → UserId
Awards IssuedIssuedBy → UserId
Awards IssuedLastModifiedBy → UserId
Awards IssuedRevokedBy → UserId
Calendar EventsCreatedByUserId → UserId
Checklist Category DetailsDeletedBy → UserId
Checklist CompletionsDeletedBy → UserId
Checklist Item DetailsDeletedBy → UserId
Checklist ObjectsDeletedBy → UserId
Competency Activity LogModifiedBy → UserId
Competency LogModifiedBy → UserId
Content Files Properties LogLastModifiedBy → UserId
Creator+ Practices AdoptionCreatedById → UserId
Discussion ForumsDeletedByUserId → UserId
Discussion TopicsDeletedByUserId → UserId
Grade ObjectsDeletedByUserId → UserId
Grade ResultsLastModifiedBy → UserId
Intelligent Agent ObjectsLastModifiedBy → UserId
Local Authentication Security LogModifiedBy → UserId
LTI Advantage Deployment AuditModifiedBy → UserId
LTI Advantage Registration AuditModifiedBy → UserId
LTI LinksLastModifiedBy → UserId
Outcome DetailsCreatedBy → UserId
Outcome DetailsLastModifiedBy → UserId
Outcomes Aligned to Tool ObjectsCreatedBy → UserId
Outcomes Aligned to Tool ObjectsLastModifiedBy → UserId
Outcomes Course Specific ScalesLastModifiedBy → UserId
Outcomes DemonstrationsLastModifiedBy → UserId
Outcomes in RegistriesCreatedBy → UserId
Outcomes in RegistriesLastModifiedBy → UserId
Outcomes Rubric AlignmentsCreatedBy → UserId
Outcomes Rubric AlignmentsLastModifiedBy → UserId
Outcomes Scale DefinitionCreatedBy → UserId
Outcomes Scale DefinitionLastModifiedBy → UserId
Outcomes Scale Level DefinitionCreatedBy → UserId
Outcomes Scale Level DefinitionLastModifiedBy → UserId
Outcomes Set CourseCreatedBy → UserId
Outcomes Set CourseLastModifiedBy → UserId
Outcomes Set OrgCreatedBy → UserId
Outcomes Set OrgLastModifiedBy → UserId
Portfolio CategoriesLastModifiedBy → UserId
Portfolio Evidence CategoriesLastModifiedBy → UserId
Portfolio Evidence ObjectsLastModifiedBy → UserId
Quiz ObjectsCreatedBy → UserId
Quiz ObjectsLastModifiedBy → UserId
Quiz Survey SectionsCreatedBy → UserId
Quiz Survey SectionsLastModifiedBy → UserId
Quiz User AnswersLastModifiedBy → UserId
Reoffer CourseCreatedBy → UserId
Role DetailsDeletedBy → UserId
SCORM ObjectsLastModifiedBy → UserId
Survey ObjectsCreatedBy → UserId
Survey ObjectsLastModifiedBy → UserId
Survey User AnswersLastModifiedBy → UserId
User Attribute DefinitionsModifiedBy → UserId
User Attribute ValuesModifiedBy → UserId

Source

Source: Users data sets on the D2L Brightspace Community