CPD User Records data set: columns, keys and joins
Checked against D2L on October 31, 2026
Back to the mapColumns
| Column | Type | Size | Key |
|---|---|---|---|
RecordId | int | 4 | PK |
RecordName | nvarchar | 256 | |
State | nvarchar | 50 | |
UserId | int | 8 | FK |
Category | int | 8 | FK |
Method | int | 8 | FK |
CreditMinutes | int | 8 | |
Evidence | nvarchar | 4000 | |
Type | nvarchar | 50 | |
Grade | decimal | 4, 3 | |
DateCompleted | datetime2 | 8 | |
LastModified | datetime2 | 8 | |
DateDeleted | datetime2 | 8 | |
Version | bigint | 8 |
Joins to (1)
- Users
UserId→UserId
Joined from (1)
- CPD Question Answers
RecordId→RecordId
Edit history links
None
Foreign keys without a stated target
Category: Marked as a foreign key by D2L, without a stated target data set.Method: Marked as a foreign key by D2L, without a stated target data set.