CPD Job Targets data set: columns, keys and joins
Checked against D2L on October 31, 2026
Back to the mapColumns
| Column | Type | Size | Key |
|---|---|---|---|
PrincipalId | int | 4 | PK |
CategoryId | int | 4 | PK, FK |
JobTitle | nvarchar | 256 | |
StructuredMinutes | int | 4 | |
UnstructuredMinutes | int | 4 | |
StructuredRecordCount | int | 4 | |
UnstructuredRecordCount | int | 4 | |
StartDate | datetime2 | 8 | |
DateDeleted | datetime2 | 8 | |
LastModified | datetime2 | 8 | |
Version | bigint | 8 |
Joins to (1)
- CPD Categories
CategoryId→CategoryId
Joined from (0)
None
Edit history links
None