Student Transcripts
This category captures the cumulative record of academic achievement for a student in the form of student diploma information. The Student Transcripts category includes the following data views and resources:
Academic Records
This view captures information about student diplomas as published in the studentAcademicRecord resource. The layout includes the School Name, Student Number, Student Name, and Grade Level, along with Exit Date, Exit Type, High School Completion Credential, Wisconsin Student Number, Last Publish Date, and the Publishing ID.
studentAcademicRecord
This educational resource represents the student and diploma information.
Primary PowerSchool Source Data
[Students]
[ReEnrollments]
[S_GA_STU_X]
[S_GA_REN_X]
Selection Criteria
Records are published if the following criteria are met:
The student's school of enrollment must not be excluded from state reporting.
The student's school of enrollment must have an Ed-Fi State School number.
The student must not be excluded from state reporting.
A student record has been published for the student.
The studentUniqueId must be populated in PowerSchool.
The student must have at least one school enrollment with an Entry Date that falls on or within the date range defined by [Terms]FirstDay and [Terms]LastDay of the year for the Term selected in the PowerSchool UI.
The enrollment ExitDate is greater than the EntryDate.
The student is in grade level 9 or above.
Resource Output
A studentAcademicRecord is published for each student enrolled in the current school year who meets the selection criteria.
Only information from the student's most recent school of enrollment is published. When changes to any of the following elements occur within PowerSchool, an update to the student's Academic Record is published:
ExitDate or ExitCode modified
GradeLevel modified
Student transfers to School 999999
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 in real time ("Run Now" button).
Note: Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | [Table]Data Type | Stored in [Table]Field | Req’d |
|---|---|---|---|---|
educationOrganizationReference A reference to the related school resource. | R | |||
/educationOrganizationID | The education organization that is associated with the student academic record. | Integer | AcademicRecordOrgID | R |
schoolYearTypeReference | The identifier for the school year. | String | [Terms]YearID | R |
/schoolYear | The identifier for the school year. | Number | [CourseTranscripts]SchoolYear | R |
studentReference A reference to the related student resource. | R | |||
/studentUniqueId | Identifies the student associated with the student academic record. | Integer | StudentUID | R |
termDescriptor | The term for the session during the school year. | String | [CourseTranscripts]Term_DX | R |
cumulativeEarnedCredits | Number | CumulativeEarnedCredits | ||
cumulativeAttemptedCredits | Number | CumulativeAttemptedCredits | ||
sessionEarnedCredits | Number | SessionEarnedCredits | ||
sessionAttemptedCredits | Number | SessionAttemptedCredits | ||
cumulativeGradePointAverage | Number | CumulativeGPA | ||
classRank | Number | ClassRank | ||
totalNumberInClass | Number | TotalNumberInClass | ||
percentageRanking | Number | PercentageRanking | ||
classRankingDate | DateTime | ClassRankingDate | ||
courseTranscripts
This educational resource represents the student and diploma information.
Primary PowerSchool Source Data
[Students]
[ReEnrollments]
[S_GA_STU_X]
[S_GA_REN_X]
[Courses]
Selection Criteria
Records are published if the following criteria are met:
The student's school of enrollment must not be excluded from state reporting.
The student's school of enrollment must have an Ed-Fi State School number.
The student must not be excluded from state reporting.
A student record has been published for the student.
The studentUniqueId must be populated in PowerSchool.
The student must have at least one school enrollment with an Entry Date that falls on or within the date range defined by [Terms]FirstDay and [Terms]LastDay of the year for the Term selected in the PowerSchool UI.
The enrollment ExitDate is greater than the EntryDate.
The student is in grade level 9 or above.
The stored grade must be marked to be included on the transcript.
The course and section must not be marked as excluded from state reporting for records with a section/course in the database.
Resource Output
A courseTranscript record is published for each stored grade for a student for grades 9 and above.
The courseTranscript 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 in real time ("Run Now" button).
Note: Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | [Table]Data Type | Stored in [Table]Field | Req’d |
|---|---|---|---|---|
courseReference A reference to the related school resource. | R | |||
/educationOrganizationID | The education organization that is associated with the student academic record. | Integer | [CourseTranscripts]LEAOrgID | |
/courseCode | State Course Code. Derived from the course list downloaded from the state and associated based on the SCED 5 Code, the Course code and then the alternate course number. | String | [CourseTranscripts]CourseKeyID | R |
studentAcademicRecordReference A reference to the related student resource. | R | |||
/studentUniqueId | Identifies the student associated with the student academic record. | String | StudentUID | R |
/educationOrganizationId | The organization where this class was taught. | AcademicRecordOrgID | R | |
/schoolYear | The identifier for the school year. | Integer | [CourseTranscripts]SchoolYear | R |
/termDescriptor | The identifier for the associated term based on the term associated with the stored grade. | String | [CourseTranscripts]Term_DX | R |
/courseAttemptResultDescriptor | The identifier of the attempt result of the grade. | String | [CourseTranscripts]CourseAttemptResult_DX | R |
/earnedCredits | Credits earned for this class. | Number | [CourseTranscripts]EarnedCredits | R |
/finalLetterGradeEarned | Final Grade Letter earned. | String | [CourseTranscripts]FinalLetterGrade | O |
/finalNumericGradeEarned | Final Percentage earned. | Number | [CourseTranscripts]FinalNumericGrade | O |