Transcripts
This category captures overall cumulative academic information and course transcript grades as published within the Student Transcript category.
studentAcademicRecord
This view captures information about each student's cumulative academic record as published in the StudentAcademicRecord resource within the Student Transcript category. Each student's course transcript must be accompanied by an Academic Record. The layout includes the School Name, Student Number, Student Name, Grade Level, Last Publish Date, and the Publishing ID.
studentAcademicRecord
This educational resource represents the cumulative record of academic achievement for a student, and functions as the header record for the student courseTranscript resource. A record is published for each school year indicating the cumulative credits for the student.
Primary PowerSchool Source Data
[StoredGrades]
Selection Criteria
Records are published if the following criteria are met:
The student was published in the Student category.
StudentUniqueId must be populated in PowerSchool.
The student must not be excluded from state reporting.
The school associated with the stored grades record must not be excluded from state reporting.
The section at the school where the grade was recorded must not be excluded from state reporting ("State_ExcludeFromReporting").
The stored grades record must not be excluded from transcripts ("excludefromtranscripts").
The course must have a valid state course code.
The course must not be excluded from printing ("sched_do_not_print").
The store code for the grade must be a final grade code for the course term where Storecode is either 'Y1' for a year grade, or matches a term record for the school where [StoredGrades]StoreCode = [Terms]Abbreviation.
If the stored grades SectionId is greater than 0, the record is the most recent for the section, student, and store code based on DateStored.
Resource Output
A separate studentAcademicRecord is published for each unique combination of student and school year that meets the required criteria.
As this data is accumulated at the district level, the Education Organization reference in these records is the district (LEAId).
The cumulativeEarnedCredits complex type is required and represents a rolling accumulation of credits. For each school year, the total cumulative earned credits to date are summed.
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 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 | Data Type | Stored in [Table]Field | Req’d |
|---|---|---|---|---|
termDescriptor | The term for the session during the school year. | String | Enumerated List | R |
educationOrganizationReference/ | The school number assigned by the state. The value is the concatenation of the district number and school number. | Int32 | SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | M |
schoolYearTypeReference/schoolYear | The school year associated with the student’s enrollment. | Int32 | Derived from: YearId for term selected in the PowerSchool UI | R |
studentReference/studentUniqueId | Student enrolled in the school. | Integer | StudentUniqueId downloaded from State Derived from: [Students]DCID | R |
academicHonors (1-many) (Need to update if 1-many for 1-1) | ||||
/academicHonorCategoryDescriptor | NTP | String | NTP | NTP |
/honorDescription | NTP | String | NTP | NTP |
/achievementCategoryDescriptor | NTP | String | NTP | NTP |
/achievementCategorySystem | NTP | String | NTP | NTP |
/achievementTitle | NTP | String | NTP | NTP |
/criteria | NTP | String | NTP | NTP |
/criteriaURL | NTP | String | NTP | NTP |
/evidenceStatement | NTP | String | NTP | NTP |
/honorAwardDate | NTP | DateTime | NTP | NTP |
/honorAwardExpiresDate | NTP | DateTime | NTP | NTP |
/imageURL | NTP | String | NTP | NTP |
/issuerName | NTP | String | NTP | NTP |
/issuerOriginURL | NTP | String | NTP | NTP |
classRanking (1-many) (Need to update if 1-many for 1-1) | ||||
/classRank | NTP | Int32 | NTP | NTP |
/classRankingDate | NTP | DateTime | NTP | NTP |
/percentageRanking | NTP | Int32 | NTP | NTP |
/totalNumberInClass | NTP | Int32 | NTP | |
/cumulativeAttemptedCreditConversion | NTP | Double | NTP | NTP |
NTP | Double | NTP | NTP | |
/cumulativeAttemptedCreditTypeDescriptor | NTP | String | NTP | NTP |
/cumulativeEarnedCreditConversion | NTP | Double | NTP | NTP |
/cumulativeEarnedCredits | NTP | Double | NTP | NTP |
/cumulativeEarnedCreditTypeDescriptor | NTP | String | NTP | NTP |
/cumulativeGradePointAverage | NTP | Double | NTP | NTP |
/cumulativeGradePointsEarned | NTP | Double | NTP | NTP |
diplomas (1-many) (Need to update if 1-many for 1-1) | ||||
/diplomaTypeDescriptor | The type of diploma in which the student is enrolled. The following values can be published:
| String | Enumerated List | R |
/diplomaAwardDate | The date on which the student completed the diploma. | Date | R | |
/achievementCategoryDescriptor | NTP | String | ||
/diplomaLevelDescriptor | NTP | String | ||
/achievementCategorySystem | NTP | String | ||
/achievementTitle | NTP | String | ||
/criteria | NTP | String | ||
/criteriaURL | NTP | String | ||
/cteCompleter | NTP | Boolean | ||
/diplomaAwardExpiresDate | NTP | DateTime | ||
/diplomaDescription | NTP | String | ||
/evidenceStatement | NTP | String | ||
/imageURL | NTP | String | ||
/issuerName | NTP | String | ||
/issuerOriginURL | NTP | String | ||
gradeValueQualifier | NTP | String | ||
projectedGraduationDate | NTP | DateTime | ||
/evidenceStatement | NTP | String | ||
/recognitionAwardDate | NTP | DateTime | ||
/recognitionAwardExpiresDate | NTP | DateTime | ||
/recognitionDescription | NTP | String | ||
reportCards/reportCardReference (1-many) (Need to update if 1-many for 1-1) | ||||
/educationOrganizationId | NTP | Int32 | ||
/gradingPeriodDescriptor | NTP | String | ||
/gradingPeriodSchoolId | NTP | Int32 | ||
/gradingPeriodSchoolYear | NTP | Int32 | ||
/gradingPeriodSequence | NTP | Int32 | ||
/studentUniqueId | NTP | String | ||
sessionAttemptedCreditConversion | NTP | Double | ||
sessionAttemptedCredits | NTP | Double | ||
sessionAttemptedCreditTypeDescriptor | NTP | String | ||
sessionEarnedCreditConversion | NTP | Double | ||
sessionEarnedCredits | NTP | Double | ||
sessionEarnedCreditTypeDescriptor | NTP | String | ||
sessionGradePointAverage | NTP | Double | ||
sessionGradePointsEarned | NTP | Double | ||
_ext.tdoe (1-many) (Need to update if 1-many for 1-1) | ||||
/endOfService/endOfServiceActionDescriptor | NTP | String | NTP | |
/endOfService/endOfServiceActionDate | NTP | DateTime | NTP | |
/submittedForSchoolYearTypeReference/schoolYear | NTP | Int32 | NTP | NTP |
/submittedByEducationOrganizationReference/EducationOrganizationId | The school number assigned by the state. The value is the concatenation of the district number and school number. | Int32 | SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | NTP |
courseTranscript
This view captures the student transcripts entries including course attempts and results for those attempts. The layout includes the School Name, Student Number, Student Name, School Year, Grade Level, Course Title, Section, and Teacher Name, along with the Store Code, Final Grade, Attempted Credit, Earned Credit, Last Publish Date, and the Publishing ID.
courseTranscript
This resource is the final record of a student's performance in their courses by school year.
Primary PowerSchool Source Data
[StoredGrades]
[Sections]
[CC]
Selection Criteria
Records are published if the following criteria are met:
The student was published in the Student category.
StudentUniqueId must be populated in PowerSchool.
The student must not be excluded from state reporting.
The student must be enrolled in the district during the school year for the term selected in the PowerSchool UI.
The school associated with the stored grades record must not be excluded from state reporting.
The section at the school where the grade was recorded must not be excluded from state reporting ("State_ExcludeFromReporting").
The stored grades record must not be excluded from transcripts ("excludefromtranscripts").
The course must have a valid state course code.
The course must not be excluded from printing ("sched_do_not_print").
The store code for the grade must be a final grade code for the course term where Storecode is either 'Y1' for a year grade, or matches a term record for the school where [StoredGrades]StoreCode = [Terms]Abbreviation.
If the stored grades SectionId is greater than 0, the record is the most recent for the section, student, and store code based on DateStored.
Resource Output
A separate courseTranscript record is published for each student and each course attempt with a stored grades record that meets the required criteria.
As this data is accumulated at the district level, the Education Organization in the studentAcademicReference complex type is the district (LEAId).
The schoolID is included in the courseReference complex type for courses taken within the district; courses taken outside the district appear within the externalCourse complex type with the school reported in the nameofInstitution element.
The Course Code and Education Organization reported in the courseReference complex type is the State Course Code and the SEAId.
For each course, a courseAttemptResult must be reported with possible values of 'Pass', 'Fail', 'Incomplete' or 'Withdrawn'.
For each course, earnedCredits must be reported; if no credit was earned, a default of '0' is output.
The sum of the earned credits per session should match the sessionEarnedCredits in the corresponding studentAcademicRecord for the student.
Where available, both the final letter grade and final numeric grade are published.
The courseTrancript resource is dependent on the prior publishing of the following resources: student, studentSchoolAssociation, and studentAcademicRecord.
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 | Data Type | Stored in [Table]Field | Req’d |
|---|---|---|---|---|
courseAttemptResultDescriptor | The result from the student’s attempt to take the course, for example, Pass, Fail, Incomplete, Withdrawn. | String | Calculated from: NTP [StoredGrades]PotentialCrHr, EarnedCrHrs, Grade, and Percent, [CC]TermID, [Sections], [Courses] and [GradeScaleItem] ‘Withdrawn’:
‘Pass’:
‘Fail’:
‘Incomplete’:
| R NTP |
courseReference (1-many) (Need to update if 1-many for 1-1) The course recorded in the Course transcript entry. | ||||
/courseCode | The course being offered by the school. This is typically the courseCode in the downloaded course resource, usually the state courseCode. Typically, if courseCode does not match a courseCode in the downloaded course resource, it will result in an error and/or be prevented from publishing. | String | State CourseCode: NTP [Courses]Alt_Course_Number [S_TN_SGR_X]Alternate_District_Course_Num | R NTP |
/educationOrganizationReference | The Education Organization that defines the curriculum and courses offered - often the LEA or school. This organization identifier matches the educationOrganizationId in the downloaded course resource, usually the SEAId. | Int32 | This value is preset to 47. NTP | R NTP |
externalEducationOrganizationReference/educationOrganizationId | Optional. Only used if a student enrolls for a course in another school or institution. | Int32 | SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | R NTP |
studentAcademicRecordReference (1-many) (Need to update if 1-many for 1-1) NTP | ||||
/educationOrganizationId | The value must match the value specified for Education Organization in the studentAcademicRecord resource. | Int32 | SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | M NTP |
/schoolYear | The identifier for the school year. NTP | Int32 | [StoredGrades]TermID NTP | M NTP |
/studentUniqueId | Identifies the student associated with the studentAcademicRecord. NTP | String | StudentUniqueId downloaded from State Derived from: [StoredGrades]StudentID | M |
/termDescriptor | The term for the session during the school year. NTP | String | ‘Year Round’ is output in all records. NTP | M |
alternativeCourseCode | NTP | String | ||
alternativeCourseTitle | NTP | String | ||
attemptedCreditConversion | NTP | Double | ||
attemptedCredits | NTP | Double | ||
attemptedCreditTypeDescriptor | NTP | String | ||
courseRepeatCodeDescriptor | ||||
courseTitle | ||||
earnedAdditionalCredits (1-many) (Need to update if 1-many for 1-1) NTP | ||||
/additionalcreditTypeDescriptor | The type of credits or units of value awarded for the completion of a course.NTP | String | ‘Carnegie unit’ | O NTP |
/credit | The number of credits awarded or earned for the course. NTP | Double | [StoredGrades]EarnedCrHrs | R NTP |
earnedCreditConversion | NTP | Double | NTP | NTP |
earnedCredits | The number of credits awarded or earned for the course. NTP | Double | [StoredGrades]EarnedCrHrs | R |
earnedCreditTypeDescriptor | The type of credits or units of value awarded for the completion of a course. NTP | String | ‘Carnegie unit’ | O |
finalLetterGradeEarned | The final indicator of student performance in a class as submitted by the instructor. NTP If finalNumericGradeEarned is not provided, then finalLetterGradeEarned is required. | String | NTP | |
finalNumericGradeEarned | The final indicator of student performance in a class as submitted by the instructor. NTP If finalLetterGradeEarned is not provided, then finalNumericGradeEarned is required. | Double | NTP | |
methodCreditEarnedDescriptor | NTP | String | NTP | |
whenTakenGradeLevelDescriptor | This value is prefixed with the namespace. Example - “uri://tdoe.edu/GradeLevelDescriptor#09” Number 09 is published instead of Ninth Grade. | String | NTP | |
_ext.tdoe/sectionReference (1-many) (Need to update if 1-many for 1-1) NTP | ||||
/sectionIdentifier | NTP | String | NTP | NTP |
/localCourseCode | NTP | String | NTP | NTP |
/schoolId | NTP | Int32 | NTP | NTP |
/schoolYear | NTP | Int32 | NTP | NTP |
/sessionName | NTP | String | NTP | NTP |
_ext.tdoe (1-many) (Need to update if 1-many for 1-1) NTP | ||||
/submittedForSchoolYearTypeReference.schoolYear | NTP | Int32 | NTP | NTP |
/submittedByEducationOrganizationReference.educationOrganizationId | The value must match the value specified for Education Organization in the studentAcademicRecord resource. | Int32 | SchoolID downloaded from State Derived from: [Prefs]Name=districtnumber and [Schools]Alternate_School_Number if value is greater than 0 | NTP |