Tool Search Term: Ed-Fi
This entity is the final record of a student's performance in their courses at the end of a semester or school year.
Object Triggering Logic
This table describes logic for triggering syncing of this object.
| Action | Trigger |
|---|---|
| Post | When transcript records are posted for a student and they have a valid Student School Association for the Scoped Year. or When a resync is completed, all valid 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 | User removes value from Pass/Fail Credit drop list. |
| Delete | All Transcript records will only delete when a student has only one 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
| 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
| Action | Trigger |
|---|---|
| Post/Delete | Natural Key change:
|
Scope Year Logic
| Logic |
|---|
Transcript records will send to each scope year where the student has a Student School Association, regardless of the Transcript School Year.
|
Resource Preferences
| Data Element Label | Mapping Needed |
|---|---|
| Credit Earned/Attempted | Course Attempt Result Descriptor |
Identity Mapping Object Key
| Campus Object Type | 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. |
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 |
|---|---|---|---|---|
| courseAttempt ResultDescriptor | The result from the student's attempt to take the course, for example: Pass, Fail, Incomplete, Withdrawn. | When reporting from Transcript Records use the Credits Earned vs. Credit Attempted to determine the result. Reports the Ed-Fi Code from the mapping for the following options:
| 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 mapped Ed-Fi Code of Pass/Fail Credit. | M | Student Information> General > Transcripts > Credit Info > Pass/Fail Credit |
| externalEducation OrganziationReference | The identifier assigned to an education organization. | This is optional, does not report. | O | |
| studentAcademic RecordReference | A reference to the related Student Academic Record resource. | Reports the Natural Key fields for the Student Academic Record resource. | 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. | Reports 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. | This is optional, does not report. | O | |
| attemptedCredit Conversion | 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. | This is optional, does not report. | O | |
| 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. | Reports the Course Name from the transcript record. | O | Student Information > General > Transcripts > Course Name transcriptcourse.courseName |
| earnedadditional Credits | An unordered collection of courseTranscript AdditionalCredits. 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 | |
| earnedCredit Conversion | 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. creditsAttempted |
| earnedCredit TypeDescriptor | The type of credits or units of value awarded for the completion of a course. | This is optional, does not report. | O | |
| finalLetterGrade Earned | The final letter grade earned for the course. | This is optional, does not report. | O | |
| finalNumericGradeEarned | The final numeric grade earned for the course. | This is optional, does not report. | O | |
| methodCreditEarnedType | The method the credits were earned, for example: Classroom, Examination, Transfer. | This is optional, does not report. | O | |
| whenTakengrade LevelDescriptor | The student's grade level at the time of the course. | This is optional, does not report. | O | |
| CollegeCreditHours | The number of college hours a student earned for the completion of a dual credit course. | Reports the field value. If blank, does not report. Student must have a grading task with a Pass/Fail Indicator of 01, 04, 05 AND a Score on the transcript in order to report this value. | O | Course/Section > Course > College Credit Hours |
| DualCreditIndicator | Indicates whether the student was eligible to receive both high school and college credit for a college course. | If Dual Indicator is a No, reports '0'. If Dual Indicator is Yes reports '1'. | O | Course/Section > Course Editor > Dual Credit Indicator |
| ATCIndicator | Indicates a high school course for which college credit may be awarded by a post-secondary institution under the conditions of a local articulation agreement or the statewide Advanced Technical Credit (ATC) program agreement. | If the ATC Indicator code box is marked, reports '1'. Otherwise, reports '0'. | O | Course/Section > Course > ATC Indicator Code |
