Add AssessmentResultId to TeacherEducationCredentialExam Table

[AEMDuaneBrown]

This is for capturing needs not currently supported by the CEDS model. Please do not send or share actual data as examples in this issue or in attachments.

Author(s)
Duane Brown
Authoring Organization(s)
CEDS
Email Address
duane.brown@aemcorp.com
Use Case Title
Add AssessmentResultId to TeacherEducationCredentialExam Table

Use Case Overview
The TeacherEducationCredentialExam table contains information related to specific assessments for credentials for teachers, but it does not contain a score for the exam or a link back to the Assessment table to retrieve a score. Adding the AssessmentResultId will provide a location where the score and any additional information about the results or the assessment itself can be stored.

Additionally to ensure that AssessmentResult can be used alone without having to add additional assessment information, we would make the the AssessmentSubtestId and AssessmentRegistrationId columns nullable.

Use Case Background
North Carolina requested a new element (CEDStandards/CEDS-Elements#254) related to the exam score, but through conversations with North Carolina, the addition of the AssessmentResultId would resolve the issue.