Student Transcripts
This category captures overall cumulative academic information and course transcript grades. The Transcripts category includes the following data views and resources:
Academic Records
This data view represents a detailed list of Student Academic Records successfully published to the ODS. This entity represents the cumulative record of academic achievement for a student, and functions as the header record for the student Course Transcript entity. Records are published if the following criteria are met: The student was previously published in the Student Demographics category, the student's unique identification code (UIC) must be populated in PowerSchool, the student, the school and the section associated with the stored grades must not be excluded from state reporting and the stored grades record must not be excluded from the transcript. A separate Student Academic Record is published for each combination of student, school year and StoreCode (Term). The published view layout provides the School Name, Student Number, Student Name, WISER ID, School Year, Grade Level, Store Code Term, Cumulative Earned Credits, Last Publish Date, Publishing ID, and Resource ID.
studentAcademicRecords
Primary PowerSchool Source Data
- [Students]
Selection Criteria
Records are published if the following criteria are met:
- The StudentUniqueId (Indiana Student Number) must be populated in PowerSchool.
- The student must not be excluded from state reporting.
- The student’s school of enrollment 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.
Resource Output
- A separate Student Academic Record is published for each combination of student, school year and StoreCode (Term).
- The studentAcademicRecords resource is dependent on the prior publishing of Ed-Fi resources: students and studentSchoolAssociations.
- LEAs and Schools may upload (publish) data to the Ed-Fi ODS manually through Publish All / Publish Missing or by scheduling a time to publish ("Schedule" 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 EducationOrganization resource. | R | |||
/educationOrganizationId | The school associated with the studentAcademicRecord. | Integer | Derived from:[S_IN_SCH_X]SchoolNumberPrefix, if populated. Otherwise: [Schools]Alternate_School_Number or | R |
schoolYearTypeReference A reference to the related SchoolYearType resource. | R | |||
/schoolYear | The school year associated with the studentAcademicRecord. | Integer | Derived from: YearId for term selected in the PowerSchool UI | R |
studentReference A reference to the related Student resource. | 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. | Descriptor | NEED INFO | 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 | NEED INFO | O |
Transcript Courses
This data view represents the final record of a student’s performance in their courses at the end of a semester or school year. Records are published if the following criteria are met: The student was previously published in the Student Demographics category, the student's unique identification code (UIC) must be populated in PowerSchool, the student, the school and the section associated with the stored grades must not be excluded from state reporting and 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. 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 published view layout provides the School Name, Student Number, Student Name, WISER ID, Grade Level, Store Code Term, Final Letter Grade, Final Numeric Grade, Course Code, Section, Course Title, Teacher Name, Last Publish Date, Publishing ID, and Resource ID.
courseTranscripts
Primary PowerSchool Source Data
- [Students]
- [Courses]
- [StoredGrades]
Selection Criteria
Records are published if the following criteria are met:
- The StudentUniqueId (Indiana Student Number) must be populated in PowerSchool.
- The student must not be excluded from state reporting.
- The student’s school of enrollment 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 courseTranscriptsresource is dependent on the prior publishing of Ed-Fi resources: student, courses, and studentAcademicRecords.
- LEAs and Schools may upload (publish) data to the Ed-Fi ODS manually through Publish All / Publish Missing or by scheduling a time to publish ("Schedule" 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 Course resource. | R | |||
/educationOrganizationId | The district associated with the course. | Integer | Derived from: [Prefs]Name=DistrictNumber If subdistricts are configured ([Prefs]Value = '1' where name = 'PSSR_SubDistrict'), then: [CST_SubDistricts]Subdistrict_Number | R |
/code | The actual code that identifies the organization of subject matter and related learning experiences provided for the instruction of students.nts. | String | [Courses]Course_Number | R |
schoolReference A reference to the related School resource. | R | |||
/schoolId | The school associated with the studentAcademicRecord. | Integer | Derived from:[S_IN_SCH_X]SchoolNumberPrefix, if populated. Otherwise: [Schools]Alternate_School_Number or | 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 | Derived from:[S_IN_SCH_X]SchoolNumberPrefix, if populated. Otherwise: [Schools]Alternate_School_Number or | R |
/schoolYear | The identifier for the school year. | Integer | Derived from:YearId for term selected in the PowerSchool UI | R |
/termDescriptor | The name of the term associated with the studentAcademicRecord, for example, First semester, Second semester, Year long, Summer school. | String | NEED INFO | R |
courseAttemptResultType | The result from the student's attempt to take the course, for example: Pass Fail Incomplete Withdrawn Expelled. | String | NEED INFO | R |
attemptedCredits | The number of credits attempted for a course. | Number | When [StoredGrades] is less than 7: '0' Otherwise: [StoredGrades]EarnedCrHrs | O |
earnedCredits | The number of credits awarded or earned for the course. | Number | When [StoredGrades]Grade_Level is less than 7: '0' Otherwise: [StoredGrades]PotentialCrHrs | R |
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 | When [StoredGrades]SectionID is equal to 0 and [StoredGrades] is not equal to SS: 'Transfer Credit' Otherwise: 'Classroom credit' | O |
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 | When [StoredGrades]Percent is greater than 0: [StoredGrades]Percent or When [StoredGrades]Grade is blank: '0' | 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]Course_Name | O |
alternativeCourseTitle | The descriptive name given to a course of study offered in the school, if different from the CourseTitle. | String | When [StoredGrades]Course_Number is not equal to [Courses]Course_Number: [Courses]Course_Name or When [StoredGrades]Course_Name is not equal to [Courses]Course_Name: [StoredGrades]Course_Name | 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 | Populated from the first valid value. When [StoredGrades]Course_Number is not equal to [Courses]Course_Number: [StoredGrades]Course_Number (formatted to replace spaces with an underscore) When [CST_PUBCRSTRANSCRIPT_TMP]Alt_Course_Number is not equal to [Courses]Course_Number:[CST_PUBCRSTRANSCRIPT_TMP]Alt_Course_Number When [Courses]Course_Number is not equal to [Courses]Course_Number with formatting using underscores instead of spaces: [Course]Course_Number formatted to replace spaces with an underscore | O |