Content and tools

LTI Advantage Deployment Audit data set: columns, keys and joins

Primary key: DeploymentIDTimestamp 32 columns

Checked against D2L on October 31, 2026

Back to the map

Columns

ColumnTypeSizeKey
Actionnvarchar10
DeploymentIDnvarchar36PK
ClientIDnvarchar36FK
DeploymentNamenvarchar200
IsDeploymentEnabledbit1
HasAssignmentsAndGradesbit1
HasDeepLinkingbit1
HasNamesAndRolesbit1
HasSubmissionReviewbit1
HasActivityItemProfilebit1
HasPlatformNotificationServicebit1
HasContextCopybit1
ModifiedBybigint8FK
Anonymousbit1
PreProvisioningEnabledbit1
SendOrgUnitInfobit1
SendUserFirstNamebit1
SendUserMiddleNamebit1
SendUserLastNamebit1
SendUserEmailbit1
SendBrightspaceUserIDbit1
SendBrightspaceUsernamebit1
SendBrightspaceOrgDefinedIdbit1
SendLinkTitlebit1
SendLinkDescriptionbit1
OpenAsExternalbit1
AutoMigrateLinksbit1
IsSharedToManyOrgUnitsbit1
AutoCreateGradesbit1
IncludeInFinalGradebit1
Timestampdatetime28PK
HasAssetProcessorbit1

Joins to (0)

None

Joined from (0)

None

Edit history links

  • UsersModifiedBy → UserId

Foreign keys without a stated target

  • ClientID: Marked as a foreign key by D2L, without a stated target data set.

Source