Student Transcripts

This category captures overall cumulative academic information and current year course transcript grades. The Student Transcript category includes the following data views and resources:

Academic Records

This view captures information about student cumulative academic records and cumulative earned credits as published in the studentAcademicRecord resource within the Student Transcript category. Each student's course transcript must be accompanied by an Academic Record. For Nebraska, student cumulative credit records are limited to courses taken in grade levels 9 and higher. The layout includes the School Name, Student Number, Student Name, and Grade Level, along with the Store Code, State Student Number, 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.

Primary PowerSchool Source Data

• [StoredGrades]
• [ReportingStoreCodes] / [VirtualTablesData]

Selection Criteria

Records are published if the following criteria are met:

• The student was published in the student category.
• The studentUniqueId must be populated in PowerSchool.
• The student must not be excluded from state reporting.
• The student must have an active school enrollment.
• The student is/was enrolled during the year for the term selected in the PowerSchool UI.
• The course must not be excluded from state reporting ("NE_StateExcludeFromReporting").
• The course must not be excluded from Ed-Fi ([S_NE_CRS_X]ExcludeFromEdFi).
• The section must not be excluded from Ed-Fi ([S_NE_SEC_X]ExcludeFromEdFi).
• At least one StoredGrades record for the student meets the following criteria:
  • The course must have a valid state course code, or have a valid state course code override; overrides in the StoredGrades record are given priority over the normal state course code.
  • The school associated with the StoredGrades record must not be excluded from state reporting.
  • The course must not be excluded from printing ("sched_do_not_print")
  • The section must not be excluded from state reporting ("Exclude_State_Rpt_YN").
  • The StoredGrades record must not be excluded from state reporting ("NE_StateExcludeFromReporting").
  • The StoredGrades record must not be excluded from transcripts ("excludefromtranscripts").
  • The StoreCode for the grade must conform to one of the following scenarios:
    • StoreCode must be a final grade code for the course term where Storecode is either 'Y1', 'S1', or 'S2' for a year/final grade
    • StoreCode must match a term record for the school where [StoredGrades]StoreCode = [Terms]Abbreviation.
    • There is a matching storecode record for term in [ReportingStoreCodes]

Resource Output

• A separate studentAcademicRecord is published for each unique combination of student, school year, and StoreCode (i.e. Ed-Fi 'Term') 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.
• Credits are summed only where the grade level when taken is equal to or greater than 9.
• If the StoredGrades SectionId is greater than 0, it is the most recent for the section, student, and storecode based on DateStored.
• 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 ODS on-demand ("Run Now" button).

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

Transcript Courses

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

courseTranscripts

This resource is the final record of a student's performance in their courses at the end of a semester or school year.

Primary PowerSchool Source Data

• [StoredGrades]
• [ReportingStoreCodes] / [VirtualTablesData]
• [Sections]
• [CC]

Selection Criteria

Records are published if the following criteria are met:

• The student was published in the student category.
• The studentUniqueId must be populated in PowerSchool.
• The student must not be excluded from state reporting.
• The student must have an active school enrollment.
• The student is/was enrolled during the year for the term selected in the PowerSchool UI.
• The school associated with the StoredGrades record must not be excluded from state reporting.
• The course must have a valid state course code, or have a valid state course code override; overrides in the StoredGrades record are given priority over the normal state course code.
• The course must not be excluded from printing ("sched_do_not_print")
• The section must not be excluded from state reporting ("Exclude_State_Rpt_YN").
• The StoredGrades record must not be excluded from state reporting ("NE_StateExcludeFromReporting").
• The StoredGrades record must not be excluded from transcripts ("excludefromtranscripts").
• The course must not be excluded from Ed-Fi ([S_NE_CRS_X]ExcludeFromEdFi).
• The section must not be excluded from Ed-Fi ([S_NE_SEC_X]ExcludeFromEdFi).
• The StoreCode for the grade must conform to one of the following scenarios:
  • StoreCode must be a final grade code for the course term where Storecode is either 'Y1', 'S1', or 'S2' for a year/final grade
  • StoreCode must match a term record for the school where [StoredGrades]StoreCode = [Terms]Abbreviation.
  • There is a matching storecode record for term in [ReportingStoreCodes]
• If the StoredGrades SectionId is greater than 0, the record is the most recent for the section, student, and storecode based on DateStored.

Resource Output

• A courseTranscripts record is published for each student and each course attempt with a StoredGrades 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 courseCode and educationOrganization reported in the courseReference complex type are 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 or the grade level when taken is less than 9, a default of '0' is output.
• The sum of all the courseTranscripts earnedCredits per student should match the most recent school year Student Academic Record's Cumulative Earned Credits value.
• Where available, both the final letter grade and final numeric grade are published.
• The courseTrancripts resource is dependent on the prior publishing of the following resources: student, studentSchoolAssociation, and studentAcademicRecord.
• LEAs and Schools may upload (publish) data to the ODS on-demand ("Run Now" button).

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