Transcript
This category captures overall cumulative academic information and current year course transcript grades. The Student Transcripts category includes the following data views and resources:
Academic Records
This view captures details about the cumulative record of academic achievement for a student. Each student's course transcript must be accompanied by an Academic Record. The layout includes the Student Number, Student Name, Grade Level, School Year, Store Code, UIC (student's SC unique identification code), Last Publish Date, and Publishing ID.
studentAcademicRecord
This resource represents the the cumulative record of academic achievement for a student and functions as the header record for the student CourseTranscript resource.
Primary PowerSchool Source Data
[Students]
[S_NM_STU_X]
[Terms]
[S_NM_FinalGradeStoreCodes_S]
Selection Criteria
Records are published if the following criteria are met:
StudentUniqueId must be populated in PowerSchool.
The student must not be excluded from state reporting.
The school associated with the student must have Final Grade Mapping records created.
Resource Output
A separate studentAcademicRecord is published for each combination of student and school year that meets the required criteria.
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 in real time or on-demand ("Schedule" button).
Note: Click Export to export the data collection results to an Excel spreadsheet.
Data Element | Description | Data Type | Stored in [Table]Field | Req'd |
|---|---|---|---|---|
educationOrganizationReference | ||||
/educationOrganizationId | State-assigned number for the district. | String | If the first 3 digits of the ID are "999" then use [students]Graduated_SchoolID | R |
schoolYearTypeReference | R | |||
/schoolYear | The school year associated with the studentAcademicRecord. | Number | P_Yearid + 1991 | R |
studentReference A reference to the related Student resource | ||||
/studentUniqueId | The student associated with the studentAcademicRecord. | String | [Students]State_StudentNumber | R |
/termDescriptor | The name of the term associated with the studentAcademicRecord, for example, First semester, Second semester, Year long, Summer school. | String | Derived from: | R |
diploma | ||||
/diplomaTypeDescriptor | The type of diploma awarded. | String | [S_NM_STU_X]DiplomaType | |
/diplomaAwardDate | The student's date of graduation. | Datetime | [S_NM_STU_X]LastStatusUpdate | |