Details
-
Improvement
-
Resolution: Approved
-
Minor
-
None
-
Data Standard v2.0, Data Standard v2.1
-
None
-
DS Refinement
Description
Are there any plans to add more primary keys to the Course Transcript resource in the Ed-Fi data model?
Students who take multiple parts of the same course within the same term are unable to keep multiple transcript records because their data submissions keep being overridden.
Example:
Online Schools will enroll students in multiple parts of the same course. These records will utilize the same CourseCode and TermType (these will normally be Year-Round for online schools).
For example, a student can take the following course parts during the same term:
Name | Local Course Code | CourseCode | TermType | EdOrgID |
Business Math Part A | 30945 | AZ02154 | Year Round | 1234 |
Business Math Part B | 32888 | AZ02154 | Year Round | 1234 |
The School can only submit one Transcript record instead of two. This is because submissions with the the same CourseCode and TermType at the same EdOrgId will override one another. As a result, the student will have one Transcript record instead of two. This is because an item like Local Course Code is not part of the Primary Key:
Are there any discussions or plans to add more Primary Keys to assist with maintaining the Transcript records for circumstances like these?
Thank you!
Attachments
Issue Links
- relates to
-
DATASTD-1408 Course Transcripts - remove Course and Student Academic Record references as being required
- Closed
-
DATASTD-1670 Proposed Model for Course Ref within course transcripts
- Closed
-
DATASTD-1924 Develop model options for student academic record
- Closed