PowerSchool SIS Oklahoma

Student Academic Record

This object conveys a student’s academic record data for student record exchange and transcript purposes. This object is designed to be a dual-purpose object. It can be linked to a StudentRecordExchange object for record exchange purposes. There may also be Zones where systems can provide this information for record exchange systems or general informational purposes, in which case the object can be linked directly to StudentPersonal.

Publishing Update

The Transcripts publishing process has been updated to correctly pull data from the Course History section.

A previous update introduced a key‑matching issue that caused Course History records to drop silently during transcript generation. As a result, published transcripts displayed term‑level information but omitted courses, marks, and grades for both enrolled and transfer/imported students.

The following changes are a result of the publishing process update:

  • Course History now publishes correctly - Courses, marking periods, and marks are properly nested under each term and publish as expected for all students—both enrolled and transferred.

  • Improved handling of transfer/imported grades - Grades from multiple external schools within the same term are now distinguished correctly, preventing duplicate‑key errors.

  • Configurable store code support - Hard‑coded store code filters have been replaced with the Final Grade Store Codes setting. When configured, grades from non‑standard grading periods are now included in transcript publishing.

Standard Default Values

The list of store codes that identify hard-coded final grades in the system as follows:

  • Q1, Q2, Q3, Q4

  • S1, S2

  • T1, T2, T3

The above store codes continue to publish if the Final Grade Store Codes setting is not configured. However, the update ensures that the Final Grade Store Codes setting is configurable per school and school year.

Final Grade Store Codes Configuration

Districts that need to include non‑standard term grades in transcripts must configure the Final Grades Store Codes setting at the school level. Once configured, the system uses the school's configured store codes for that school year instead of the built-in standard defaults. As a result, districts get complete control over which grades publish to the transcript.

This update also ensures that credits and GPA calculations (Potential Credits, Total Credits, GPA Credits, GPA Points) remain aligned with the grades that are published.

  • Once a school configures the mapping for a school year, any store code not included in the configured list will not be published.

  • If a grade stops appearing on a transcript after configuring the Final Grades Store Codes, verify that the store code is included in the configured list for that school and year.

Configuration Path:
School > State Reporting > CRDC Final Grade Store Codes — enter store codes as a comma-separated list (e.g., S1,S2) for each term.

The following table lists the elements that are published for this object:

Element Name or @Attribute

Submission

Definition

Code Set, if applicable

[Table]Field Mapping

Business Rules

@RefID

Yes

The ID (GUID) of this record.


Students


@SIF_RefId

Yes

The GUID of an associated object, either StudentRecordExchange or StudentPersonal.


Students


@SIF_RefObject

Yes

The associated object type.


 

Default: StudentPersonal

ReportingDate

Yes

The date this record was prepared.


 

This is the date value only. Not DateTime.

DistrictEntryDate

Optional

The date the student originally enrolled in the district of the school of record.


Students


StudentSchoolEnrollmentData

@SchoolAttendedRefId

Yes

Collects elements of interest from StudentSchoolEnrollment.

References the school of record for the student.


Schools


StudentSchoolEnrollmentData/GradeLevel

Yes

The grade level of the student.


Students


StudentSchoolEnrollmentData/GradeLevel/Code

Yes

Code representing the grade level.


Students


StudentSchoolEnrollmentData/GradeLevel/OtherCodeList/OtherCode

Yes

A state/province code, local code, other code, or a text string that crosswalks to or serves as a translation of an associated Code element.


 


SchoolAttendanceHistory/SchoolAttendanceHistory

@RefId

Yes

Data about each individual school attended.

ID used internally to StudentAcademicRecord to avoid duplication of school-related data


Schools


SchoolAttendanceHistory/SchoolAttended/ LEAInfoData/LEAName

Yes

The name of the LEA.


PREFS


SchoolAttendanceHistory/SchoolAttended/ LEAInfoData/LocalId

Optional

The local Id of the LEA.


PREFS


SchoolAttendanceHistory/SchoolAttended/ LEAInfoData/StateProvinceId

Optional

The state/province Id of the LEA.


PREFS


SchoolAttendanceHistory/SchoolAttended/ LEAInfoData/NCESId

Optional

The NCESId of the school.


[S_OK_SCH_X]NCESId


SchoolAttendanceHistory/SchoolAttended/ SchoolInfoData/LocalId

Yes

The local Id of the school.


[Schools]School_Number


SchoolInfoData/SchoolName

Yes

The name of the school.


[Schools]Name


SchoolAttendanceHistory/SchoolAttended/ SchoolInfoData/StateProvinceId

Optional

The state/province Id in which the school is located.


[Schools]SIF_StatePRID


SchoolAttendanceHistory/SchoolAttended/ SchoolInfoData/GradeLevels

Optional

The grade levels offered by the school.


Students


SchoolAttendanceHistory/SchoolAttended/ MarkingSystems/MarkValueInfoData/Name

Yes

The text name of the value list ("Letter Grades", "Letter Grades (+/-)", "ESU", "Pass/Fail", "Override Grades", "Citizenship Comment Codes", etc.).


[GradeScaleItem]Name


SchoolAttendanceHistory/SchoolAttended/ MarkingSystems/MarkValueInfoData

@RefId

Yes

Marking system/grading table used by the school.

ID used internally to StudentAcademicRecord to link marks to their marking systems.


GradeScaleItem


SchoolAttendanceHistory/SchoolAttended/ MarkingSystems/MarkValueInfoData/Letter/ ValidMark/Code

Yes

String representing the actual Mark that would appear on the report card (e.g., "A+", "I", "100").


GradeScaleItem


SchoolAttendanceHistory/SchoolAttended/ MarkingSystems/MarkValueInfoData/Letter/ ValidMark/Description

Optional

The description for this code. (e.g. "Excellent", "Participates in Class", "Incomplete", etc...).


GradeScaleItem


SchoolAttendanceHistory/SchoolAttended/ MarkingSystems/MarkValueInfoData/Letter/ ValidMark/NumericEquivalent

Optional

Numeric equivalent for the Mark (e.g., 100, 4.0).


GradeScaleItem


EnrollmentHistory/StudentSchoolEnrollmentData/EntryDate

Optional

The date on which the student started attending school.


[Students]EntryDate [ReEnrollments]EntryDate


EntryType, Code, value


The code to describe the type of entry.


[Students]EntryCode [ReEnrollments]EntryCode


OtherCodeList, OtherCode, value




Students and ReEnrollments


OtherCodeList, OtherCode, Codeset




 

StateProvince

EnrollmentHistory/StudentSchoolEnrollmentData/ExitDate

Optional

The date on which the student stopped attending school.


Students and ReEnrollments

Mandatory if student exited school.

EnrollmentHistory/StudentSchoolEnrollmentData/ExitType/Code

Yes

Code indicating the type of exit for this enrollment.


Students and ReEnrollments


OtherCodeList, OtherCode, value




Students and ReEnrollments


OtherCodeList, OtherCode, Codeset




 

StateProvince

EnrollmentHistory/ StudentSchoolEnrollmentData/GradeLevel

Optional

Grade level of student.


Students


OtherCodeList, OtherCode, value




Students and ReEnrollments


OtherCodeList, OtherCode, codeset




 

StateProvince

SchoolYear


The current school year.


 


CurrentCourseActivity/TermInfoData

@SchoolAttendedRefId

Yes

Collects elements of interest from TermInfo.

Reference to the school of record for the courses being taken (see SchoolAttended).


Schools


CurrentCourseActivity/TermInfoData/StartDate

Yes

The start date of the current term.


[Terms]FirstDay


CurrentCourseActivity/TermInfoData/EndDate

Yes

The end date of the current term.


[Terms]LastDay


CurrentCourseActivity/TermInfoData/Description

Yes

A brief description of the current term.


[Terms]Description


CurrentCourseActivity/TermInfoData/SchoolYear

Yes

The current school year


 


CurrentCourseActivity/TermInfoData/TermCode

Yes

The code to describe the current term.


[Terms]Code


CurrentCourseActivity/TermInfoData/TermSpan

Yes

The duration of the current term.


Terms


OtherCodeList, OtherCode, value




Terms


OtherCodeList, OtherCode, codeset




 

StateProvince

CurrentCourseActivity/Courses/Course/StartDate

Optional

The date on which the course section started.


StoredGrade


CurrentCourseActivity/Courses/Course/EndDate

Optional

The date on which the course section ended or will end.


StoredGrade


CurrentCourseActivity/Courses/Course/SchoolAttendedRefId

Yes

Reference to the school where the course is being taken (see SchoolAttended); may be omitted if the school is the same as the school of record.


Schools


CurrentCourseActivity/Courses/Course/ SchoolCourseInfoData/CourseCode

Yes

The code or number associated with the course.


[Courses]Course_Number


CurrentCourseActivity/Courses/Course/ SchoolCourseInfoData/CourseTitle

Yes

The title of the course.


[Courses]Course_Name


CurrentCourseActivity/Courses/Course/ SchoolCourseInfoData/StateCourseCode

Yes



CoursesCoreFields]ALT_Course_Number


CurrentCourseActivity/Courses/Course/ SchoolCourseInfoData/DistrictCourseCode

Yes



[Courses]Course_Number


CurrentCourseActivity/Courses/Course/ SchoolCourseInfoData/NationalCourseCode

Optional



[Courses]Code


CurrentCourseActivity/Courses/Course/ SchoolCourseInfoData/Department

Optional



[Courses]Sched_Department


CurrentCourseActivity/Courses/Course/ SchoolCourseInfoData/InstructionalLevel

Yes



S_OK_CRS_X


CurrentCourseActivity/Courses/Course/ MarkingPeriod/TermInfoData/StartDate

Yes

The start date of the current term.


PGFinalGrades

[Terms]FirstDay


CurrentCourseActivity/Courses/Course/ MarkingPeriod/TermInfoData/EndDate

Yes

The end date of the current term.


PGFinalGrades

[Terms]LastDay


CurrentCourseActivity/Courses/Course/ MarkingPeriod/TermInfoData/Description

Yes

A brief description of the current term.


[Terms]Description


CurrentCourseActivity/Courses/Course/ MarkingPeriod/TermInfoData/TermCode

Yes

The code to describe the current term.


PGFinalGrades

[Terms]code


CurrentCourseActivity/Courses/Course/ MarkingPeriod/TermInfoData/TermSpan

Yes

The duration of the current term.


Terms


OtherCodeList, OtherCode, value




Terms


OtherCodeList, OtherCode, codeset




 

StateProvince

CurrentCourseActivity/Courses/Course/ MarkingPeriod/TermInfoData/GradeLevelWhenTaken

Yes

Student's grade level at time of course.


Students


OtherCodeList, OtherCode, value




Students


OtherCodeList, OtherCode, codeset




 

StateProvince

CurrentCourseActivity/Courses/Course/ MarkingPeriod/MarkData/Numeric

Optional

The raw numeric score for this mark.


PGFinalGrades

Schools


CurrentCourseActivity/Courses/Course/ MarkingPeriod/MarkData/Letter

Optional

The letter grade for this mark.


PGFinalGrades


CurrentCourseActivity/Courses/Course/ MarkingPeriod/MarkData/Percentage

Optional

The percent score for this mark (0.00 - 100.00).


PGFinalGrades


CurrentCourseActivity/Courses/Course/ MarkingPeriod/MarkData/Narrative

Optional

The free form text narrative for this mark.


[GradeScaleItem]Description


CurrentCourseActivity/Courses/Course/ MarkingPeriod/MarkData/CourseCreditsAttempted

Optional

The number of course credits attempted.


[Courses]Credit_Hours


CurrentCourseActivity/Courses/Course/ MarkingPeriod/MarkData/CourseCreditsEarned

Optional

The number of course credits earned.


[StoredGrades]EarnedCrHrs


AcademicPerformanceHistory/ TermPerformance/ DaysAbsent

Optional

Number of days absent.


[StoredGrades]Absences


AcademicPerformanceSummary/ TotalCreditsAttempted

Optional

Total credits attempted during the academic career.


StoredGrades

Required if student has completed at least one hour of high school credit.

AcademicPerformanceSummary/ TotalCreditsEarned

Optional

Total credits earned during the academic career.


StoredGrades

Required if student has completed at least one hour of high school credit.

AcademicPerformanceSummary/ CumulativeGPACreditsEarned

Optional

The cumulative number of GPA credits earned during the academic career.


StoredGrades


AcademicPerformanceSummary/ CumulativeGradePoints

Optional

The cumulative number of grade points earned during the academic career.


StoredGrades


AcademicPerformanceSummary/GPAType

Optional

Brief name/description of the type of GPA.


[ClassRank]GPAMethod


AcademicPerformanceSummary/ClassRank

Optional

The student's rank in the graduating class.


[ClassRank]Rank


AcademicPerformanceSummary/ClassTotalNumber

Optional

The total number of students in the student's graduating class.


ClassRank


AcademicPerformanceSummary/ClassRankingDate

Optional

The date on which the class ranking was determined.


ClassRank


AcademicPerformanceSummary/ProjectedGraduationDate

Yes

The projected date of graduation.


Students


AcademicPerformanceHistory/ TermPerformance/TermInfoData/SchoolYear

Optional

The current school year.


 


AcademicPerformanceHistory/ TermPerformance/TermInfoData/StartDate

Optional

The start date of the term.


[Terms]FirstDay


AcademicPerformanceHistory/ TermPerformance/TermInfoData/EndDate

Optional

The end date of the term.


[Terms]LastDay


AcademicPerformanceHistory/ TermPerformance/TermInfoData/Description

Optional

A brief description of the current term.


[Terms]Description


AcademicPerformanceHistory/ TermPerformance/TermInfoData/TermCode

Optional

The code to describe the current term.


[Terms]Code


AcademicPerformanceHistory/ TermPerformance/TermInfoData/TermSpan

Optional

The duration of the current term.


Terms


OtherCodeList, OtherCode, value




Terms


OtherCodeList, OtherCode, codeset




 

StateProvince

AcademicPerformanceHistory/ TermPerformance/GradeLevelWhenTaken

Optional

Student's grade level during the term.


Students


OtherCodeList, OtherCode, value




Students


OtherCodeList, OtherCode, codeset




 

StateProvince

AcademicPerformanceHistory/ TermPerformance/CreditsAttempted

Optional

The number of credits attempted.


StoredGrades


AcademicPerformanceHistory/ TermPerformance/CreditsEarned

Optional

The number of credits earned.


StoredGrades


AcademicPerformanceHistory/ TermPerformance/GPACreditsAttempted

Optional

The number of GPA credits attempted.


StoredGrades


AcademicPerformanceHistory/ TermPerformance/GPACreditsEarned

Optional

The number of GPA credits attempted.


StoredGrades


AcademicPerformanceHistory/ TermPerformance/GPAGradePoints

Optional

The number of GPA points received.


StoredGrades