System Access Log data set: columns, keys and joins
Checked against D2L on October 31, 2026
Back to the mapColumns
| Column | Type | Size | Key |
|---|---|---|---|
SessionId | nvarchar | 36 | PK |
UserId | int | 4 | PK, FK |
Timestamp | datetime2 | 8 | PK |
State | nvarchar | 20 | PK |
Source | nvarchar | 20 | |
AppVersion | nvarchar | 20 | |
Device | nvarchar | 50 | |
IsOfflineMode | bit | 1 | |
IPAddress | nvarchar | 45 |
Joins to (1)
- Users
UserId→UserId
Joined from (0)
None
Edit history links
None