Student Transcripts
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.
studentAcademicRecords
This resource represents the cumulative record of academic achievement for a student and functions as the header record for the student CourseTranscript resource.
Academic transcripts are available for all years for all students whose records meet the selection criteria for publishing.
Primary PowerSchool Source Data
- [StoredGrades]
- [Students]
- [Sections]
- [Terms]
- [ClassRank]
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 StoredGrades record must not be excluded from state reporting.
- The stored grade must not be excluded from transcripts.
The Academic Transcripts are available only for the current year and the previous three years for historic transcripts. For example, if 2022 is the current year, then transcripts will be available for the historical years 2021, 2020, and 2019.
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 A reference to the related EducationOrganization resource. | ||||
/educationOrganizationId | State-assigned number for the district. | Integer | If the first 3 digits of the ID are "999" then use [students]Graduated_SchoolID | R |
| schoolYearTypeReference A reference to the related SchoolYearType resource. | R | |||
/schoolYear | The school year associated with the studentAcademicRecord. | Integer | 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 |
| cumulativeAttemptedCredits | The cumulative number of credits an individual earns by completing courses or examinations during his or her enrollment in the current school as well as those credits transferred from schools in which the individual had been previously enrolled. | Sum of [StoredGrades]potentialcrhrs across all records where [StoredGrades]grade_level is higher or equal to 7 | ||
| cumulativeEarnedCredits | The cumulative number of credits an individual earns by completing courses or examinations during his or her enrollment in the current school as well as those credits transferred from schools in which the individual had been previously enrolled. | Number | Sum of [StoredGrades]EarnedCrHrs across all records where [StoredGrades]grade_level is higher or equal to 7 | |
| projectedGraduationDate | The projected year of graduation. | [STUDENTCOREFIELDS]graduation_year or [STUDENTS]classof | ||
classRanking Only records in CR table where gpamethod = 'SC_GPA_UGP_Round' or 'SC_GPA_4.0_Round'. | ||||
| /classRank | The academic rank of a student in relation to his or her graduating class (e.g., 1st, 2nd, 3rd). | [ClassRank]rank | R | |
| /classRankingDate | The total number of students in the student's graduating class. | [ClassRank]dateranked | ||
| /percentageRanking | The academic rank of a student in relation to his or her graduating class (e.g., 1st, 2nd, 3rd). | round(100*(1.0-rank/outof), 2) | ||
| /totalNumberInClass | The total number of students in the student's graduating class. | [ClassRank]outof | R | |
| sessionAttemptedCredits | The number of credits attempted for a session. | sum [StoredGrades]potentialcrhrs across all records where [StoredGrades]grade_level is more or equal to 7 and [StoredGrades]datestored is between [Terms]firstday and [Terms]lastday | ||
| sessionEarnedCredits | The number of credits awarded or earned for the session. | sum [StoredGrades]earnedcrhrs across all records where [StoredGrades]grade_level is more or equal to 7 and [StoredGrades]datestored is between [Terms]firstday and [Terms]lastday | ||
| academicHonors | ||||
/honorDescription | The type of diploma or honor awarded to the course. | [S_SC_STU_X]Seeking_Emp_Credential | R | |
| /academicHonorCategoryDescriptor | [S_SC_STU_X]Seeking_Emp_Credential | |||
| /criteria | [S_SC_STU_SEAL_OF_BILIT_C]Proficiency_Score | |||
| /evidenceStatement | [S_SC_STU_SEAL_OF_BILIT_C]English_Qualification [S_SC_STU_SEAL_OF_BILIT_C]Proficiency_Test [S_SC_STU_SEAL_OF_BILIT_C]YEAR | |||
/honorAwardDate | If honorDescription is "Employability Credential Track" or "Employability Credential Earned" then [S_SC_STU_X]emp_credential_date If honorDescription, 1, 19 = Seal of Biliteracy_ then derive the June 1 date (day is always June 1) where S_SC_STU_SEAL_OF_BILIT_C.YEAR = '23' is year 2023, '24' is year 2024, and so on. For example: 2023-06-01 | |||
| diploma | ||||
| /diplomaTypeDescriptor | The type of diploma awarded to the course. | [S_SC_STU_X]DiplomaEarnedCode if [S_SC_STU_X]Diploma_Type = "F" then "Seeking_F" | ||
| /diplomaAwardDate | The student's date of graduation. | [S_SC_STU_X]graddate if not null | ||
Transcript Courses
This view captures details about the final record of a student’s performance in their courses at the end of a semester or school year. The layout includes the Student Number, Student Name, Grade Level, Store Code, Final Grade, Course Code, Section, Course Title, Teacher Name, UIC (student's SC unique identification code), Last Publish Date, and Publishing ID.
courseTranscripts
This resource represents 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]
- [Students]
- [Sections]
- [CC]
- [Terms]
- [Courses]
- [GradeScaleItem]
Selection Criteria
Records are published if the following criteria are met:
- The student was previously published in the Student Parent category.
- StudentUniqueId must be populated in PowerSchool.
- The student must not be excluded from state reporting.
- The school must not be excluded from state reporting.
- The section associated with the stored grades must not be excluded from state reporting.
- The stored grades record must not be excluded from the transcript.
- The Store Code for the grade must be a final grade code for the course term.
CourseTranscripts are available for all years for all students whose records meet the selection criteria for publishing.
Resource Output
- A separate Course Transcript record is published for each student and each course attempt with a Stored Grades record that meets the required criteria.
- The StudentProgramAssociation resource is dependent on the prior publishing of the following resources: Student Demographics.
- 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 |
|---|---|---|---|---|
courseReference A reference to the related Course resource. | R | |||
/educationOrganizationId | State-assigned number for the district associated with the course. | Integer | [Prefs] where name = districtnumber | R |
/courseCode | The actual code that identifies the organization of subject matter and related learning experiences provided for the instruction of students. | String | [courses]course_number [CoursesCoreFields]Alt_Course_Number | R |
studentAcademicRecordReference A reference to the related StudentAcademicRecord resource. | R | |||
/educationOrganizationId | State-assigned number for the district associated with the studentAcademicRecord. | Integer | [Students]SchoolId [ReEnrollments]SchoolId (historical) | R |
/schoolYear | The identifier for the school year. | Integer | p_yearid + 1991 | R |
/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 |
| courseAttemptResultDescriptor | The result from the student's attempt to take the course, for example: Pass Fail Incomplete Withdrawn Expelled | String | Derived from: [cc]termid, [StoredGrades]grade, [StoredGrades]percent, [StoredGrades]potentialcrhrs, [StoredGrades]earnedcrhrs,[GradeScaleItem]cutoffpercentage | R |
| EarnedCredits/Credits | ||||
| CreditTypeDescriptor | course_number,7,1 “A” Advanced Placement; "I” International Baccalaureate); “C” College Prep; “H”Honors; “E” dual enrollment; or “G” Cambridge’s Advanced International Certificate of Examination | |||
| courseTitle | The descriptive name given to a course of study offered in a school or other institution or organization. In departmentalized classes at the elementary, secondary, and postsecondary levels (and for staff development activities), this refers to the name by which a course is identified (e.g., American History, English III). For elementary and other non-departmentalized classes, it refers to any portion of the instruction for which a grade or report is assigned (e.g., reading, composition, spelling, and language arts). | String | [Courses]course_name | O |
| attemptedCredits | The number of credits attempted for a course. | Number | [StoredGrades]potentialcrhrs if [StoredGrades]grade_level is greater than or equal to 7, otherwise, it is 0 | O |
| earnedCredits | The number of credits awarded or earned for the course. | Number | [StoredGrades]earnedcrhrs if [StoredGrades]grade_level is greater than or equal to 7, otherwise, it is 0 | R |
| finalLetterGradeEarned | The final indicator of student performance in a class as submitted by the instructor. | String | [StoredGrades]grade | O |
| finalNumericGradeEarned | The final indicator of student performance in a class as submitted by the instructor. | Number | [StoredGrades]percent if more than 0 If [StoredGrades]percente is null then 0 | O |
| whenTakenGradeLevelDescriptor | The student's grade level at time of course. | String | [StoredGrades]grade_level | O |
| methodCreditEarnedType | The method the credits were earned, for example: Classroom, Examination, Transfer. | String | If [StoredGrades]sectionid= 0 and [StoredGrades]storecode is not equal to SS then 'Transfer credit', otherwise, 'Classroom credit' | O |
| alternativeCourseCode | The local code assigned by the school that identifies the course offering, the code from an external educational organization, or other alternate course code. | String | [Courses]CourseNumber | O |
| alternativeCourseTitle | The descriptive name given to a course of study offered in the school, if different from the CourseTitle. | String | [Courses]CourseName | O |
| courseRepeatCodeDescriptor | If there are multiple stored grades for a single course this value is Y. Other it is N. The highest grade should be included in the student's GPA. | |||
| courseRepeatCodeDescriptor | ||||
| gpaPoints | [StoredGrades]GPA_Points | |||
| gpaCalculation | [StoredGrades]ExcludeFromGPA | |||
| graduationCalculation | [StoredGrades]ExcludeFromGraduation | |||
| creditType | [StoredGrades]Credit_Type | |||