The CEDS Integrated Data Store factors the entities and attributes of the CEDS Domain Entity Schema (DES) with standard technical syntax and 3rd normal form database normalization. The IDS Logical Model provides a standard framework for integration of P-20 data systems through a well-normalized “operational data store”. In a P-20 data system, the IDS models the most current view of data available to the enterprise, including some historical data (such as prior assessment data and enrollment records). A “record” is generally added for each Person-Organization Relationship change event in the system. This CEDS logical model does not directly address the production aspects of log and change management.
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 (https://github.com/CEDStandards/CEDS-Elements/issues/254) related to the exam score, but through conversations with North Carolina, the addition of the AssessmentResultId would resolve the issue.
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 (https://github.com/CEDStandards/CEDS-Elements/issues/254) related to the exam score, but through conversations with North Carolina, the addition of the AssessmentResultId would resolve the issue.