This entity is the final record of a student's performance in their courses at the end of a semester or school year.
- Students with hand entered Course Transcript records may not report if there is no section to tie back to for the term.
- The Sessions, Course Offerings, Sections, and Locations resources all need to be present for the Course Transcripts resource to process and send.
Object Triggering Logic
This table describes logic for triggering syncing of this object.
| Action | Trigger | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Post | When transcript records are posted for a student (either through the system or manual entry) and they have a valid Student School Association for the configured year. OR When a resync is completed for the school the student is enrolled, all eligible transcript records for all years will send for the Student.
| ||||||||||||
| Post/Delete | When any part of the Natural Key is changed. | ||||||||||||
| Put | When fields that are not part of the natural key are changed. | ||||||||||||
| Delete | When a transcript record is deleted for a student. | ||||||||||||
| Delete | All Transcript records will only delete when a student has only 1 Student School Association record for a specific Year and that record is deleted. (Note: If a new Student School Association record is created, existing records will not re-post, a resync must be completed to resend the data.) |
School Exclude, Calendar Exclude, Resource Toggle and Resync Logic
This table describes the School Exclude, Calendar Exclude, Resource Toggle and Resync logic of this object.
| Action | Trigger |
|---|---|
| None | If a resource is toggled to 'OFF' after data has sent, all sent data will remain in the ODS but no new data will send. |
| Resync | If a record is in the Ed-Fi Identity Mapping table and not in the ODS, it will be deleted from the Ed-Fi Identity Mapping table. |
| Resync | If a record is in the ODS and it does not have a matching record in Campus or the Ed-Fi Identity Mapping table, it will be deleted from the ODS. |
| Resync | If a mapping is changed in Resource Preferences, a resync will need to be done to reflect the changes. |
Natural Key Changes, Cascading Updates, and Deletes Logic
This table describes the Natural Key Changes/Cascading Updates and Deletes logic of this object.
| Action | Trigger |
|---|---|
| Post/Delete | Natural Key changes:
|
Scope Year Logic
This table describes scope year logic of this object.
| Logic |
|---|
Transcript records will send to each scope year where the student has a Student School Association, regardless of the Transcript School Year.
|
Identity Mapping Object Key
campusObjectType | Object Key Data Source |
|---|---|
| TranscriptCourse | transcriptID |
Event Queue Detail
| Campus Table | Ed-Fi Action | Fields |
|---|---|---|
| transcriptcourse | Post/Put/Delete | The primary table used for sending data for this resource. |
| transcriptcredit | Post/Put/Delete | The primary table used for sending data for this resource. |
Error Log
| Error | Possible Causes / How to Correct |
| The score assigned to the student is not mapped to a State Score. Please navigate to the "[ScoreGroupName or RubricName]" Score Group or Rubric and map the score to a State Score. | [ScoreGroupName or RubricName] will be replaced with the Score Group or Rubric name the erroneous score is a part of. This error is caused when a score is not assigned to a mapped State Score. The score needs to be mapped to a State Score in Grading & Standards > Score Groups & Rubrics > Score Groups & Rubrics Editor > [Select the Score Group or Rubric needing to be edited] > State Score. Incomplete is not a valid mapping for Grades K-8 - The state does not accept this value for those scores associated with grades. |
| Transcript ID [TranscriptID] in Group [GroupName] does not have a valid School Number entered. Please enter a valid School Number. | Where [TranscriptID] is replaced with the erroneous TranscriptID. Where [GroupName] is replaced with the group name (e.g 22-23 - SchoolName - Grade) the erroneous TranscriptID is in. This error is caused when a manual transcript entry has a blank School Number. Go to the transcriptID mentioned in the error and add a School Number. |
| Transcript ID [TranscriptID] in Group [GroupName] does not have a valid District Number entered. Please enter a valid District Number. | Where [TranscriptID] is replaced with the erroneous TranscriptID. Where [GroupName] is replaced with the group name (e.g 22-23 - SchoolName - Grade) the erroneous TranscriptID is in. This error is caused when a manual transcript entry has a blank District Number. Go to the transcriptID mentioned in the error and add a District Number. |
| Transcript ID [TranscriptID] in Group [GroupName] does not have a valid Course Name entered. Please enter a valid Course Name. | Where [TranscriptID] is replaced with the erroneous TranscriptID. Where [GroupName] is replaced with the group name (e.g 22-23 - SchoolName - Grade) the erroneous TranscriptID is in. This error is caused when a manual transcript entry has a blank Course Name. Go to the transcriptID mentioned in the error and add a Course Name. |
| Transcript ID [TranscriptID] in Group [GroupName] does not have a valid State Code entered. Please enter a valid State Code. | Where [TranscriptID] is replaced with the erroneous TranscriptID. Where [GroupName] is replaced with the group name (e.g 22-23 - SchoolName - Grade) the erroneous TranscriptID is in. This error is caused when a manual transcript entry has a blank State Code. Go to the transcriptID mentioned in the error and add a State Code. |
| Transcript ID [TranscriptID] in Group [GroupName] does not have a valid Unweighted GPA Value entered. Please enter a valid Unweighted GPA Value. | Where [TranscriptID] is replaced with the erroneous TranscriptID. Where [GroupName] is replaced with the group name (e.g 22-23 - SchoolName - Grade) the erroneous TranscriptID is in. This error is caused when a manual transcript entry has a blank Unweighted GPA Value. Go to the transcriptID mentioned in the error and add an Unweighted GPA Value. |
| Transcript ID [TranscriptID] in Group [GroupName] does not have a valid Ed-Fi Term Type entered. Please enter a valid Ed-Fi Term Type. | Where [TranscriptID] is replaced with the erroneous TranscriptID. Where [GroupName] is replaced with the group name (e.g 22-23 - SchoolName - Grade) the erroneous TranscriptID is in. This error is caused when a manual transcript entry has a blank Ed-Fi Term Type. Go to the transcriptID mentioned in the error and add an Ed-Fi Term Type. |
Object Data Elements
This table describes data elements sent within the Course Transcripts resource. Data Element Labels in bold are part of the Natural Key and are required data elements for Data to send to Ed-Fi.
| Data Element Label | Business Requirement | Business Rules | M, C or O | Location |
|---|---|---|---|---|
| courseAttemptResultTYPE | The result from the student's attempt to take the course, for example: Pass, Fail, Incomplete, Withdrawn. This is a TYPE not a Descriptor. See Types list below. | When reporting from Transcript Records use the Credits Earned vs. Credit Attempted to determine the result.
| M | Student Information > General > Transcripts > Earned AND Student Information > General > Transcripts > Attempted transcriptcredit.creditsAttempted AND transcriptcredit.creditsEarned |
| courseReference | A reference to the related Course resource. | Reports the Natural Key fields for the Course resource.
Notes:
| M | |
| schoolReference | The identifier assigned to an education organization. | Reports the Education Organization information for the district. Reports the schoolID:
| M | |
| studentAcademic RecordReference | A reference to the related Student Academic Record resource. | Reports the Natural Key fields for the Student Academic Record resource.
Note: TermDescriptor must be within the Student Academic Record Reference | M | |
| alternativeCourseCode | The local code assigned by the school that identifies the course offering, the code from an external educational organization, or other alternate course code. | Report the Course Number from the transcript record. | O | Student Information > General > Transcripts > Course Number transcriptcourse. courseNumber |
| alternativeCourseTitle | The descriptive name given to a course of study offered in the school, if different from the Course Title. | Report the Course Name from the transcript record. | O | Student Information > General > Transcripts > Course Name transcriptcourse. courseName |
| attemptedCreditConversion | Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units. | This is optional, does not report. | O | |
| attemptedCredits | The number of credits attempted for a course. | Report the sum of credits from the Attempted field on the Transcript record being reported | O | Student Information > General > Transcripts > Attempted transcriptcredit. creditsAttempted |
| attemptedCredit TypeDescriptor | The type of credits or units of value attempted for the completion of a course. | This is optional, does not report. | O | |
| courseRepeat CodeDescriptor | Indicates that an academic course has been repeated by a student and how that repeat is to be computed in the student's academic grade average. | This is optional, does not report. | O | |
| CourseTitle | Reports the name of the course completed. | Report the Course Name from the transcript record. | O | Student Information > General > Transcripts > Course Name transcriptcourse. courseName |
| earnedadditionalCredits | An unordered collection of courseTranscriptAdditionalCredits. This entity is the final record of a student's performance in their courses at the end of a semester or school year. | This is optional, does not report. | O | |
| earnedCreditConversion | Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units. | This is optional, does not report. | O | |
| earnedCredits | The number of credits awarded or earned for the course. | Report the sum of credits from the Earned field on the Transcript record being reported. | M | Student Information > General > Transcripts > Earned transcriptcredit.creditsEarned |
| earnedCreditTypeID | The type of credits or units of value awarded for the completion of a course. | Reports as creditType.
| C | Student Information > General > Transcript > [Select a Transcript Entry] > Post Secondary Institution + Applied Units |
| finalLetterGradeEarned | The final letter grade earned for the course. | Determine if the posted score is an integer or not:
| O | Student Information > General > Transcripts > Current Score transcriptcourse.score |
| finalNumericGradeEarned | The final numeric grade earned for the course. |
| C | Student Information > General > Transcripts > Unweighted GPA Value |
| methodCreditEarnedType | The method the credits were earned, for example: Classroom, Examination, Transfer. | This is optional, does not report. | O | |
| whenTakengradeLevelDescriptor | The student's grade level at time of the course. | If the grade selected on the transcript record matches a valid Ed-Fi code, report the grade.
| O | Student Info > General > Transcript > Transcript Course Editor > Grade |
| postSecondaryInstitution | Students with Dual Credit need to report the post secondary institution that makes this Dual Credit. | When earnedCreditType = Dual Credit, send a value in postSecondaryInstitution:
| C | Index > Course/Section > Search > Course > Post Secondary Institution drop list. Index > Student Info > Counseling > General > Transcript > Select Transcript Entry > Scroll to Additional Information > Post Secondary Institution drop list. |
| courseEducationOrganizationID | The state owns the course /curricular material. | Report states Ed Org ID 1088000000 | M | Hardcoded Value |
Types/Descriptors
References
References of the courseTranscript Resource in Indiana
| References | Details | Notes |
| StudentAcademicRecord |
| TermDescriptor must be within the StudentAcademicRecordReference |
| SchoolReference | schoolID = 10+District+School | |
| CourseReference |
|
|
