Arizona 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.

Object Triggering Logic

This table describes logic for triggering syncing of this object.

Action	Trigger
Post	When transcript records are posted for a student for course with a state code and in grades 9-12. OR When a grade is posted to a grading task that is marked as State Reported and the student is in grades K-8. Only report transcript records where the record's school number is equal to the school number where the student is enrolled. Only reports records for the school year the enrollment is aligned to. 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. Do not report if the Course is marked as inactive or State Excluded.
Post/Delete	When a grade is changed on a state reported grading task or 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	When a state reported grade is deleted for a student.
Delete	Transcript records will delete when a student has only 1 Student School Association record for a specific School and 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 checkbox is checked. (Note: If the box is unchecked the data will not post, a resync must be completed to resend the data)
Delete	When the District Number on the course transcript is changed and it no longer matches the reporting districts number.

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
Final Letter Grade Descriptors	Score

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
courseAttempt ResultDescriptor	The result from the student's attempt to take the course, for example: Pass/Fail/ Incomplete/Withdrawn/Expelled - To be used by K-8 grades that do not fullfill subject matter courses.	When reporting from State Reported Grading Task or Standard use the Score Group or Rubric 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 'Pass' when the sum of credits Earned is >= the sum of credits Attempted. Report 'Fail' when the sum of credits Earned is blank or = 0. Report 'Incomplete' when the sum of credits Earned is not blank or = 0 and < than the sum of credits Attempted. **We do not report Incomplete or Withdrawn from Grading Tasks or Standards and will not report "Withdrawn from transcript records". These values will not report.	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 Organziation Reference	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. Note: The Ed-Fi ID reports from the Student State ID field.	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 cod.	Report the Course Number from the transcript record.	O	Student Information> General> Transcripts> Course Number	transcriptcourse. courseNumber
alternativeCourse Title	The descriptive name given to a course of study offered in the school, if different from the CourseTitle.	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
attemptedCredit TypeDescriptor	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
earnedadditional Credits	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
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 value of credits or units of value awarded for the completion of a course. Required for HS courses when the student has been exited from the section (Student Enrollment Use Case).	For students in Grades K-8, report '1'. For all other students, 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
finalLetterGrade Earned	The final indicator of student performance in a class as submitted by the instructor. This may be A-F scores, FAME score, percentages, standards based with size limitations, etc.	Report the Current Score posted to the transcript record. Report the Score Name when reporting from the State Reported Grading Task or Standard. 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. Else, report the score in the Final Numeric Grade Earned.	O	Student Information > General > Transcripts > Current Score or Score > Name
finalNumeric GradeEarned	Does not report.	Does not report.
methodCredit EarnedType	The method the credits were earned, for example: Classroom, Examination, Transfer.	This is optional, does not report.
whenTakengrade LevelDescriptor	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 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. When a grade is posted to a grading task that is marked as State Reported and the student is in grades K-8, use AZ-localized logic: Report the mapped Grade Level from the Grade that the student was in when they completed the course. Report from the enrollment record with same School Year as the transcript record. If there are multiple enrollments that match, report a single grade based on the following Local Service Type Hierarchy: P: Primary T: AOI A: Ancillary O: Program Only If student has multiple enrollments that meet the above criteria, report from 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
finalLetterGrade Descriptor	The final indicator of student performance in a class as submitted by the instructor. Valid values include 'AboveAverage', 'Average' & 'BelowAverage'.	Use finalLetterGradeEarned as the initial input. Look in AZ configurations for CourseTranscript > Final Letter Grade Mapping. If the finalLetterGradeEarned matches a value in the Final Letter Grade column, report the corresponding Ed-Fi code. If the corresponding Ed-Fi code is not populated, report blank. If the finalLetterGradeEarned does not match any values in the Final Letter Grade column, report blank.	C	Student Information > General > Transcripts > Current Score or Score > Name

Type/Descriptor

Course Attempt Result Descriptor

Code Value	Description	Namespace	Short Description
Pass	Pass	uri://ed-fi.org/CourseAttemptResultDescriptor	Pass
Incomplete	Incomplete	uri://ed-fi.org/CourseAttemptResultDescriptor	Incomplete
Fail	Fail	uri://ed-fi.org/CourseAttemptResultDescriptor	Fail
Withdrawn	Withdrawn	uri://ed-fi.org/CourseAttemptResultDescriptor	Withdrawn