Brightspace Data Sets for Continuous Professional Development (CPD) are only available to new customers who have purchased the Continuous Professional Development tool as part of the D2L for Associations Package.
Entity Relationship Diagram
The following diagram shows the relationships between entities used to create Brightspace Data Sets for Continuous Professional Development. To enlarge the diagram, right-click on the image and select Open image in a new tab.
CPD Job Targets
The CPD Job Targets Brightspace Data Set returns a list of all targets set by the user attribute Job Title. If no user attributes are defined for your organization, the data set will be empty.
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 9.6 |
PrincipalId |
Unique identifier for the principal which sets the job target. |
int |
4 |
PK |
| 9.6 |
SubjectId |
Unique identifier for the subject associated with the job target. |
int |
4 |
PK, FK |
| 9.6 |
JobTitle |
The title of the job. |
nvarchar |
4000 |
|
| 9.6 |
StructuredMinutes |
The structured record duration of the job target.
Field can be null.
|
int |
4 |
|
| 9.6 |
UnstructuredMinutes |
The unstructured record duration of the job target.
Field can be null.
|
int |
4 |
|
| 9.6 |
StructuredRecordCount |
The structured record count of the job target.
Field can be null.
|
int |
4 |
|
| 9.6 |
UnstructuredRecordCount |
The unstructured record count of the job target.
Field can be null.
|
int |
4 |
|
| 9.6 |
StartDate |
The date (UTC) of rolling or specific SPS for job annual target and progress tracking has been updated.
Field can be null.
|
datetime2 |
8 |
|
| 9.6 |
DateDeleted |
The date and time (UTC) the subject was deleted.
Field can be null.
|
datetime2 |
8 |
|
| 9.6 |
LastModified |
The date and time (UTC) the job target was added or last updated based on the Tracking Method. |
datetime2 |
8 |
|
| 9.6 |
Version |
Indicates the version of the row. The Version of the job target is updated based on the Tracking Method. |
bigint |
8 |
|
CPD Methods
The CPD Methods Brightspace Data Set returns a list of all methods defined within the CPD tool.
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 9.6 |
MethodId |
Unique identifier for each method. |
int |
4 |
PK |
| 9.6 |
Name |
The name of the method. |
nvarchar |
4000 |
|
| 9.6 |
LastModified |
The date and time (UTC) the method was added or last updated.
Field can be null.
|
datetime2 |
8 |
|
| 9.6 |
DateDeleted |
The date and time (UTC) the method was deleted.
Field can be null.
|
datetime2 |
8 |
|
| 9.6 |
Version |
Indicates the version of the row. This information is used to determine which table row occurred first. |
bigint |
8 |
|
CPD Question Answers
The CPD Question Answers Brightspace Data Set returns a list of all answers provided by each user per CPD record for the CPD questions defined for the CPD tool.
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 9.6 |
AnswerId |
Unique identifier for each answer to a question. |
int |
4 |
PK |
| 9.6 |
AnswerText |
The text containing the answer to the question. |
nvarchar |
4000 |
|
| 9.6 |
QuestionId |
Unique identifier for the question. |
int |
4 |
FK |
| 9.6 |
RecordId |
Unique identifier of the Record where the action occurred. |
int |
4 |
FK |
| 9.6 |
UserId |
Unique user identifier. |
int |
4 |
FK |
| 9.6 |
Action |
The action that occurred: Created, Updated or Deleted. |
nvarchar |
16 |
|
| 9.6 |
LastModified |
The date and time (UTC) the answer was added or last updated.
Field can be null.
|
datetime2 |
8 |
|
| 9.6 |
DateDeleted |
The date and time (UTC) the answer was deleted.
Field can be null.
|
datetime2 |
8 |
|
| 9.6 |
Version |
Indicates the version of the row. This information is used to determine which table row occurred first. |
bigint |
8 |
|
CPD Questions
The CPD Questions Brightspace Data Set returns a list of all CPD questions defined for the CPD tool.
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 9.6 |
QuestionId |
Unique identifier for each question. |
int |
4 |
PK |
| 9.6 |
QuestionText |
The text containing the question. |
nvarchar |
4000 |
|
| 9.6 |
LastModified |
The date and time (UTC) the question was added or last updated.
Field can be null.
|
datetime2 |
8 |
|
| 9.6 |
DateDeleted |
The date and time (UTC) the method was deleted.
Field can be null.
|
datetime2 |
8 |
|
| 9.6 |
Version |
Indicates the version of the row. This information is used to determine which table row occurred first. |
bigint |
8 |
|
CPD Subjects
The CPD Subjects Brightspace Data Set returns a list of all subjects defined for the CPD tool.
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 9.6 |
SubjectId |
Unique identifier for each subject. |
int |
4 |
PK |
| 9.6 |
Name |
The name of the subject. |
nvarchar |
4000 |
|
| 9.6 |
LastModified |
The date and time (UTC) the subject was added or last updated.
Field can be null.
|
datetime2 |
8 |
|
| 9.6 |
DateDeleted |
The date and time (UTC) the method was deleted.
Field can be null.
|
datetime2 |
8 |
|
| 9.6 |
Version |
Indicates the version of the row. This information is used to determine which table row occurred first. |
bigint |
8 |
|
CPD User Records
The CPD User Records Brightspace Data Set returns a list of all CPD records created by users in your organization.
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 9.6 |
RecordId |
Unique identifier for each user record. |
int |
4 |
PK |
| 9.6 |
RecordName |
The name of the user record. |
nvarchar |
256 |
|
| 9.6 |
State |
The state of the record: Published or Draft. |
nvarchar |
50 |
|
| 9.6 |
UserId |
Unique user identifier for the owner of the record. |
int |
8 |
FK |
| 9.6 |
Subject |
The ID of the record's selected subject. |
int |
8 |
FK |
| 9.6 |
Method |
The ID of the record's selected method. |
int |
8 |
FK |
| 9.6 |
CreditMinutes |
Number of minutes credited by the record. |
int |
8 |
|
| 9.6 |
Evidence |
Comma delimited list of evidence file names. |
nvarchar |
4000 |
|
| 9.6 |
Type |
The type of the record: Structured or Unstructured. |
nvarchar |
50 |
|
| 9.6 |
Grade |
The grade value of the associated award.
Field can be null.
|
decimal |
4, 3 |
|
| 9.6 |
DateCompleted |
The user provided date that the record was completed. |
datetime2 |
8 |
|
| 9.6 |
LastModified |
The date and time (UTC) the record was added or last updated.
Field can be null.
|
datetime2 |
8 |
|
| 9.6 |
DateDeleted |
The date and time (UTC) the method was deleted.
Field can be null.
|
datetime2 |
8 |
|
| 9.6 |
Version |
Indicates the version of the row. This information is used to determine which table row occurred first. |
bigint |
8 |
|
CPD User Targets
The CPD User Targets Brightspace Data Set returns a list of all CPD targets set for each user in your organization. If a user doesn't have any targets set, they will not have a row included in this data set.
Version History
|
Field
|
Description
|
Type
|
Column Size
|
Key
|
|---|
| 9.6 |
PrincipalId |
Unique identifier for the user target set by a principal. |
int |
4 |
PK |
| 9.6 |
SubjectId |
Unique identifier for the user target for each subject. |
int |
4 |
PK, FK |
| 9.6 |
UserId |
Unique user identifier. |
int |
4 |
FK |
| 9.6 |
StructuredMinutes |
The structured record duration of the user target.
Field can be null.
|
int |
4 |
|
| 9.6 |
UnstructuredMinutes |
The unstructured record duration of the user target.
Field can be null.
|
int |
4 |
|
| 9.6 |
StructuredRecordCount |
The structured record count of the user target.
Field can be null.
|
int |
4 |
|
| 9.6 |
UnstructuredRecordCount |
The unstructured record count of the user target.
Field can be null.
|
int |
4 |
|
| 9.6 |
StartDate |
The date (UTC) of rolling or specific SPS for user annual target and progress tracking has been updated.
Field can be null.
|
datetime2 |
8 |
|
| 9.6 |
DateDeleted |
The date and time (UTC) the subject was deleted.
Field can be null.
|
datetime2 |
8 |
|
| 9.6 |
LastModified |
The date and time (UTC) the user target was added or last updated based on the Tracking Method. |
datetime2 |
8 |
|
| 9.6 |
Version |
Indicates the version of the row. The Version of the user target is updated based on the Tracking Method. |
bigint |
8 |
|