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 Michigan 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
- [Terms]
- [StoredGrades]
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.
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. | R | |||
/educationOrganizationId | The school associated with the studentAcademicRecord. | Integer | [Students]SchoolId | R |
| schoolYearTypeReference A reference to the related SchoolYearType resource. | R | |||
/schoolYear | The school year associated with the studentAcademicRecord. | Integer | [Terms]YearID | |
studentReference A reference to the related Student resource | R | |||
/studentUniqueId | The student associated with the studentAcademicRecord. | String | [Students]State_StudentNumber | |
| termDescriptor | The name of the term associated with the studentAcademicRecord, for example, First semester, Second semester, Year long, Summer school. | String | Derived from: Y1: 'Year Round' | R |
| 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 | [StoredGrades]EarnedCrHrs | O |
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 Michigan unique identification code), Last Publish Date, and Publishing ID.
courseTranscript
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
- [Courses]
- [StoredGrades]
- [Terms]
- [S_MI_TRM_TSDL_X]
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.
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 | The district associated with the course. | Integer | [Prefs] where name = districtnumber | R |
/code | The actual code that identifies the organization of subject matter and related learning experiences provided for the instruction of students. | String | [Courses]CourseNumber | R |
studentAcademicRecordReference A reference to the related StudentAcademicRecord resource. | R | |||
/studentUniqueId | The student associated with the studentAcademicRecord. | String | [Students]State_StudentNumber | R |
/educationOrganizationId | The school associated with the studentAcademicRecord. | Integer | [Students]SchoolId [ReEnrollments]SchoolId (historical) | R |
/schoolYear | The identifier for the school year. | Integer | [Terms]YearID | R |
/termDescriptor | The name of the term associated with the studentAcademicRecord, for example, First semester, Second semester, Year long, Summer school. | String | Derived from: Y1: 'Year Round' | R |
| courseAttemptResultType | The result from the student's attempt to take the course, for example: Pass Fail Incomplete Withdrawn Expelled | String | The value is passed for first condition that is met. [S_MI_TRM_TSDL_X]completionstatus = 'TO', 'CP', or 'CS': 'Pass' [MaxTerm]TermID < 0: 'Withdrawn' [StoredGrades]Grade starts with 'P': 'Pass' If [StoredGrades]Percent >= [GradeScaleItem]CutOffPercentage and the record for the max value of [GradeScaleItem]GraduationCredit = 1: ‘Pass’ | R |
| attemptedCredits | The number of credits attempted for a course. | Number | If [StoredGrades]Grade_Level < 7 or [StoredGrades]PotentialCrHrs is empty then '0' Otherwise [StoredGrades]PotentialCrHrs | O |
| earnedCredits | The number of credits awarded or earned for the course. | Number | If [StoredGrades]Grade_Level < 7 or [StoredGrades]EarnedCrHrs is empty then '0' Otherwise [StoredGrades]EarnedPotentialCrHrs | R |
| whenTakenGradeLevelDescriptor | The student's grade level at time of course. | String | If [StoredGrades]Grade_Level =
| O |
| methodCreditEarnedType | The method the credits were earned, for example: Classroom, Examination, Transfer. | String | If [StoredGrades]SectionID = 0 then 'Transfer credit' | O |
| finalLetterGradeEarned | The final indicator of student performance in a class as submitted by the instructor. | String | [StoredGrades]Grade if not Null | O |
| finalNumericGradeEarned | The final indicator of student performance in a class as submitted by the instructor. | Number | [StoredGrades]Percent if not Null | O |
| 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]CourseName | O |
| alternativeCourseTitle | The descriptive name given to a course of study offered in the school, if different from the CourseTitle. | String | [Courses]CourseName | 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 |