Modify Credential Award table to include foreign key to Credential Definition Grade Level #97
Description
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) CJ Gilbert
Authoring Organization(s) CEPI, Michigan
Email address GilbertC6@Michigan.gov
Use Case Title
Modify Credential Award table to include foreign key to Credential Definition Grade Level.
Use Case Overview
Right now, CEDS has a way to link the award of a certificate to a specific endorsement using Credential Award Relationship, and it has a way to link an endorsement to a variety of grade levels using the Credential Definition Grade Level table, but it does not have a way to link a certificate to a specific record in the Credential Definition Grade Level table so as to identify which grade band associated with that endorsement is the right one for this specific certificate.
Use Case Background
It is necessary to link the award of a credential to the specific Grade Level. For example, in the Credential Definition space, it may be than a Mathematics teaching credential could be offered for grades 6-9 or grades 9-12, which means there would be two records in the CredentialDefGradeLevel table. When a person is awarded a Mathematics teaching credential, we need to know which of those two grade ranges are attached to the credential.
Components Affected
*CEDS Integrated Data Store
*CEDS Data Warehouse (possibly affected -- it depends on how the IDS tables are flattened out in the DW)
INTEGRATED DATA STORE DESIGN OVERVIEW
Description of Proposed Changes
Add CredentialDefGradeLevelId to the CredentialAward table.
Diagram (proposed additions marked on as-is diagram)
