Michigan Ed-Fi Data v3.1 - Course Transcripts

Tool Search: 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. When a resync is completed, all valid transcript records for all years will send for the Student. The School that the Student is enrolled must be selected in the Resync Tool. If the District Number on the Transcript record matches the reporting district, send the record. Ed-Fi will send an error if the Course does not already exist in the ODS and a resync will need to be done on the Course. Do not send a record if the course is marked as inactive or state exclude. Do not send a record if enrollment is marked as No Show or State Exclude. If the District Number on the Transcript record does not match the reporting district look to see if the course number exists in the School: If the Course Number exists anywhere in the School for the scope year, and is not marked as inactive or exclude, report the record with the Course Reference for that course/school. If more than 1 Course exits with that Course Number in different schools in the scope year, report the course reference with the School where the student is enrolled. If the Course Number does not exists in the School for the scope year, do not report the record.
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.)
Delete	When the district number on the Transcript record no longer matches the reporting district.
Delete	If the student's enrollment is marked as No Show or State Exclude.

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 change: If the Natural Key changes from the Course Reference or Student Academic Reference, the cascading delete/post logic from those resources will trigger updates to the Course Transcripts. Records will delete/post if the Credits Earned or Credits Attempted are changed on a student's transcript record.

Action

Trigger

Post/Delete

Natural Key change:

If the Natural Key changes from the Course Reference or Student Academic Reference, the cascading delete/post logic from those resources will trigger updates to the Course Transcripts.
Records will delete/post if the Credits Earned or Credits Attempted are changed on a student's transcript record.

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. Data will only send for years that have valid configuration. A resync must be completed at the beginning of each year so that all years transcript records will be loaded in the ODS.

Logic

Transcript records will send to each scope year where the student has a Student School Association, regardless of the Transcript School Year.

Data will only send for years that have valid configuration.
A resync must be completed at the beginning of each year so that all years transcript records will be loaded in the ODS.

Resource Preferences

This table describes the Resource Preferences of this object.

Data Element Label	Mapping Needed
Credit Earned/Attempted	Course Attempt Result Descriptor

Event Queue Detail

This table describes the Event Queue Detail of this object.

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 Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
courseAttemptResult Descriptor	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. Report the Ed-Fi Code from the mapping for the following options: When the sum of credits Earned is >= the sum of credits Attempted. When the sum of credits Earned is blank or = 0. When the sum of credits Earned is not blank or = 0 and < than the sum of credits Attempted.	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.	M
externalEducation OrganziationReference	The identifier assigned to an education organization.		O
studentAcademic RecordReference	A reference to the related Student Academic Record resource.	Reports the Natural Key fields for the Student Academic Record resource.	M
alternativeCourse Code	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
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.	Report the sum of credits from the Attempted field on the Transcript record being reported.	O	Student Information> General> Transcripts> Attempted	transcriptcredit.creditsAttempted
attemptedCreditType Descriptor	The type of credits or units of value attempted for the completion of a course.	This is optional, does not report.	O
courseRepeatCode Descriptor	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.	Reports College Credit from associated the Grading Task. See array for field logic. This field is only reported if the student has a grading task with associated credit to 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
earnedCreditType Descriptor	The type of credits or units of value awarded for the completion of a course.	This is optional, does not report.	O
finalLetterGradeEarned	The final letter grade earned for the course.	Determine if the posted score is an integer or not: If the posted value is not an Integer, then report the posted score here. If the posted value is an Integer, then report in Final Number Grade Earned field below.	O	Student Information> General> Transcripts> Current Score	transcriptcourse.score
finalNumericGrade Earned	The final numeric grade earned for the course.	Determine if the posted score is an integer or not: If the posted value is an Integer, then report the posted score here. If the posted value is not an Integer, then report in Final Letter Grade Earned field above.	O	Student Information> General> Transcripts> Current Score	transcriptcourse.score
methodCreditEarned Type	The method the credits were earned, for example: Classroom, Examination, Transfer.	This is optional, does not report.	O
whenTakengradeLevel Descriptor	Student's grade level at time of course.	If the grade selected on the transcript record matches a valid Ed-Fi code, report the grade. When no matching grade found with a grade level mapping, do not report this property.	O	Student Info> General> Transcript> Transcript Course Editor> Grade

Arrays

Click here to expand...

Data Element Label	Business Requirement	Business Rules	M, C or O	Data Source GUI Path	Database Field
additionalCreditTypeDescriptor	The type of credits awarded or earned for the course.,	Report 'Dual credit'.	M
credits	The number of credits awarded or earned for the course.	Reports credit from grading task X credit coefficient associated with the Score the student received. Grading task must have State Reported = Selected and a Code = CC64b. Grading task is determined from sectionID found on the transcript record.	M	Grading & Standards > Grading Task > Code, State Reported Grading & Standards > Score Groups

Data Element Label

Business Requirement

Business Rules

M, C or O

Data Source GUI Path

Database Field

additionalCreditTypeDescriptor

The type of credits awarded or earned for the course.,

Report 'Dual credit'.

credits

The number of credits awarded or earned for the course.

Reports credit from grading task X credit coefficient associated with the Score the student received.
1. Grading task must have State Reported = Selected and a Code = CC64b.
2. Grading task is determined from sectionID found on the transcript record.

Grading & Standards > Grading Task > Code, State Reported

Grading & Standards > Score Groups

Type/Descriptor