Wisconsin Ed-Fi Data v3.5 - Course Transcripts

Classic View: System Administration > Ed-Fi

Search Terms: 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.

For the 2020-21 school year, do not configure or turn on the Course Transcripts resource until notified to do so.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	When transcript records are posted for students in grades 9-12. or When a grade is posted to a grading task that is marked as 'Posts to Transcript' for a course with Transcript box checked and the student is in state grade = 12.
	Do not report if posted from a course in an excluded calendar. If transcript is manually entered, only report if student has an enrollment in a calendar not marked as excluded .
	When reporting from grading task, do not report if the Course is marked as inactive or State Excluded.
	When reporting from grading task, do not report if Ed-Fi Exclude is checked.
	Do not report if Enrollment State Exclude or Wise Exclude are checked.
Post/Delete	When a grade is changed on a transcript record for a student or part of the Natural Key is changed. OR When a grade is changed on a grading task marked 'Posts to Transcript' or part of the Natural Key is changed.
Put	When any field not part of the Natural Key is changed.
Delete	When a transcript record is deleted for a student.
Delete	When a grade for a grading task marked 'Posts to Transcript' is deleted for a student.
Delete	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 Enrollment State Exclude or WISE Exclude checkbox is checked.

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
course Reference	A reference to the related Course resource.	Reports the Natural Key fields for the Course resource For 9-12 grade levels with a transcript record: courseReference - CourseCode Report the TranscriptCourse.transcriptID from the transcript record. Prefix with 'TC' to indicate it is from Transcript record. courseReference - educationOrganizationId - Report the Ed-Fi schoolID for the school name associated with the transcript record. For 12th grade without a transcript record in the current school/config year: courseReference - CourseCode Report the GradingScore.scoreID from the Grading Task marked marked State Reported for a course with a state code when a grade is added or modified. Prefix with 'GS' to indicate it is from Course. courseReference - educationOrganizationId - Report the Ed-Fi schoolID for the school name associated with the course record.	M	Student Information> General> Transcripts> TranscriptID Student Information > General > Transcripts > School Name	Transcript Course. transcriptID transcriptDetail. schoolName
external Education Organziation Reference	The identifier assigned to an education organization.		O
student Academic Record Reference	A reference to the related Student Academic Record resource.	Reports the Natural Key fields for the Student Academic Record resource.	M
alternative Course 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.	For 9-12th grade levels with a transcript record: Report the Course Number for the Course from the transcript record. For 12th grade without a transcript record in the current school/config year: Report the Course Number for the Course from Courses > Course > Number. Course must be Active and not marked Exclude from State Reporting.	M	Student Information> General> Transcripts> Course Number Courses > Course > Number	transcript course. course Number course.number
alternative Course Title	The descriptive name given to a course of study offered in the school, if different from the Course Title.	For 9-12th grade levels with a transcript record: Report the Course Name from the transcript record. For 12th grade without a transcript record in the current school/config year: Report the Name for the Course from Courses > Course > Name. Course must be Active and not marked Exclude from State Reporting.	M	Student Information > General > Transcripts > Transcript > Course Name Courses > Course > Name	transcript course. course Name course.name
course Attempt Result Descriptor	The result from the student's attempt to take the course, for example: Pass/Fail/ Incomplete/ Withdrawn/ Expelled.	When reporting from State Reported Grading Task use the Score Group or used for the posted grade to determine the Result Type: Report 'Pass' when the posted score has the Passing check box checked on the score group where the grade was posted from. Report 'Fail' when the posted grade does not have the Passing check box checked on the score group where the grade was posted from. When reporting from Transcript Records use the Credits Earned vs. Credit Attempted to determine the Result Type: 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	transcript credit. credits Attempted AND transcript credit. credits Earned
attempted Credit Conversion	Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units.	This is optional, does not report.	O
attempted Credits	The number of credits attempted for a course.	This is optional, does not report.	O	Student Information> General> Transcripts> Attempted	transcript credit. credits Attempted
attempted Credit Type Descriptor	The type of credits or units of value attempted for the completion of a course.	This is optional, does not report.	O
course Repeat Code 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
Course Title	Reports the name of the course completed.	For 9-12th grade levels with a transcript record: Report the Course Name from the transcript record. For 12th grade without a transcript record in the current school/config year: Report the Name for the Course from Courses > Course > Name. Course must be Active and not marked Exclude from State Reporting.		Student Information> General> Transcripts> Course Name Courses > Course > Name	transcript course. course Name
earned additional Credits	An unordered collection of course Transcript Additional Credits. 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
earned Credit Conversion	Conversion factor that when multiplied by the number of credits is equivalent to Carnegie units.	This is optional, does not report.	O
earned Credits	The value of credits or units of value awarded for the completion of a course. Required for HS courses (usually 0.5, 1, 2)	Report the sum of credits from the Earned field on the Transcript record being reported. When a grade is posted to a Grading Task marked state reported for a course that has 'post to transcript' checked and the student is in state grade level 12, report the value in the Credit field of the associated Grading Task.	M	Student Information> General> Transcripts> Earned	transcript credit. credits Earned
earnedCredit Type Descriptor	The type of credits or units of value awarded for the completion of a course.	This is optional, does not report.	O
finalLetter Grade Earned	The final letter grade earned for the course.	Report the Current Score posted to the transcript record. Report the Score Name when reporting from the grading task marked 'Posts to Transcript' for students in state grade level 12. Look at the score being reported and determine if it is an integer or not. If the posted value is not an Integer then report the value here.	M	Student Information > General > Transcripts > Current Score or Score > Name	transcript course. score
final Numeric Grade Earned	The final numeric grade earned for the course.	Determine if the posted transcript 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 FinalLetterGradeEarned field. If the score reported from the grading task marked 'Posts to Transcript' is an integer, report here. Otherwise, do not report.	O	Student Information> General> Transcripts> Current Score	transcript course. score
method Credit Earned Type	The method the credits were earned, for example: Classroom, Examination, Transfer.	This is optional, does not report.	O
whenTaken grade Level Descriptor	Student's grade level at time of course.	When transcript records are posted for a student for course with a state code and in grades 9-12, use core logic: If the grade level selected on the transcript record matches a valid Ed-Fi code, report the grade level. When no matching grade level found with a grade level mapping, do not report this property. When a grade is posted to a grading task that is marked as State Reported for a course that has 'po and the student is in state grade level 12, use the following logic: Report the mapped Grade Level from the Grade that the student is in when the grade/score is posted to a state reported grading task. Report from the enrollment record with same School Year as the courseTranscript record. If there are multiple enrollments that match, report from the most recent start date. If start dates are the same, report from highest enrollment ID. If the student does not have a corresponding enrollment record, report blank.	M	Student Information > General > Enrollments > Grade	enrollment. grade

Type/Descriptor

Course Attempt Result Descriptor

Code Value	Description	Short Description
Pass	Pass	Pass
Incomplete	Incomplete	Incomplete
Fail	Fail	Fail