Transcripts

This category captures overall cumulative academic information and course transcript grades as published within the Student Transcript category.

studentAcademicRecord

This view captures information about each student's cumulative academic record as published in the StudentAcademicRecord resource within the Student Transcript category. Each student's course transcript must be accompanied by an Academic Record. The layout includes the School Name, Student Number, Student Name, Grade Level, Last Publish Date, and the Publishing ID.

studentAcademicRecord

This educational resource represents the cumulative record of academic achievement for a student, and functions as the header record for the student courseTranscript resource. A record is published for each school year indicating the cumulative credits for the student.

Primary PowerSchool Source Data

• [StoredGrades]

Selection Criteria

Records are published if the following criteria are met:

• The student was published in the Student category.
• StudentUniqueId must be populated in PowerSchool.
• The student must not be excluded from state reporting.
• The school associated with the stored grades record must not be excluded from state reporting.
• The section at the school where the grade was recorded must not be excluded from state reporting ("State_ExcludeFromReporting").
• The stored grades record must not be excluded from transcripts ("excludefromtranscripts").
• The course must have a valid state course code.
• The course must not be excluded from printing ("sched_do_not_print").
• The store code for the grade must be a final grade code for the course term where Storecode is either 'Y1' for a year grade, or matches a term record for the school where [StoredGrades]StoreCode = [Terms]Abbreviation.
• If the stored grades SectionId is greater than 0, the record is the most recent for the section, student, and store code based on DateStored.

Resource Output

• A separate studentAcademicRecord is published for each unique combination of student and school year that meets the required criteria.
• As this data is accumulated at the district level, the Education Organization reference in these records is the district (LEAId).
• The cumulativeEarnedCredits complex type is required and represents a rolling accumulation of credits. For each school year, the total cumulative earned credits to date are summed.
• The studentAcademicRecord resource is dependent on the prior publishing of the following resources: student and studentSchoolAssociation.
• LEAs and Schools may upload (publish) data to the Ed-Fi ODS manually through Publish All / Publish Missing or by scheduling a time to publish ("Schedule" button).

Note: Click Export to export the data collection results to an Excel spreadsheet.

courseTranscript

This view captures the student transcripts entries including course attempts and results for those attempts. The layout includes the School Name, Student Number, Student Name, School Year, Grade Level, Course Title, Section, and Teacher Name, along with the Store Code, Final Grade, Attempted Credit, Earned Credit, Last Publish Date, and the Publishing ID.

courseTranscript

This resource is the final record of a student's performance in their courses by school year.

Primary PowerSchool Source Data

• [StoredGrades]
• [Sections]
• [CC]

Selection Criteria

Records are published if the following criteria are met:

• The student was published in the Student category.
• StudentUniqueId must be populated in PowerSchool.
• The student must not be excluded from state reporting.
• The student must be enrolled in the district during the school year for the term selected in the PowerSchool UI.
• The school associated with the stored grades record must not be excluded from state reporting.
• The section at the school where the grade was recorded must not be excluded from state reporting ("State_ExcludeFromReporting").
• The stored grades record must not be excluded from transcripts ("excludefromtranscripts").
• The course must have a valid state course code.
• The course must not be excluded from printing ("sched_do_not_print").
• The store code for the grade must be a final grade code for the course term where Storecode is either 'Y1' for a year grade, or matches a term record for the school where [StoredGrades]StoreCode = [Terms]Abbreviation.
• If the stored grades SectionId is greater than 0, the record is the most recent for the section, student, and store code based on DateStored.

Resource Output

• A separate courseTranscript record is published for each student and each course attempt with a stored grades record that meets the required criteria.
• As this data is accumulated at the district level, the Education Organization in the studentAcademicReference complex type is the district (LEAId).
• The schoolID is included in the courseReference complex type for courses taken within the district; courses taken outside the district appear within the externalCourse complex type with the school reported in the nameofInstitution element.
• The Course Code and Education Organization reported in the courseReference complex type is the State Course Code and the SEAId.
• For each course, a courseAttemptResult must be reported with possible values of 'Pass', 'Fail', 'Incomplete' or 'Withdrawn'.
• For each course, earnedCredits must be reported; if no credit was earned, a default of '0' is output.
• The sum of the earned credits per session should match the sessionEarnedCredits in the corresponding studentAcademicRecord for the student.
• Where available, both the final letter grade and final numeric grade are published.
• The courseTrancript resource is dependent on the prior publishing of the following resources: student, studentSchoolAssociation, and studentAcademicRecord.
• LEAs and Schools may upload (publish) data to the Ed-Fi ODS manually through Publish All / Publish Missing or by scheduling a time to publish ("Schedule" button).

Note: Click Export to export the data collection results to an Excel spreadsheet.

The final indicator of student performance in a class as submitted by the instructor.

If finalLetterGradeEarned is not provided, then finalNumericGradeEarned is required.