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.

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