StudentAcademicRecord Object

Element Name

Description

[Table]Field

Notes

@RefID

The GUID of this record.

N/A

Handled by the SIF Agent.

@SIF_RefID

The GUID of the associated object, either StudentRecordExchange or StudentPersonal

N/A

Handled by the SIF Agent.

@SIF_RefObject

The associated object type.

N/A

Handled by the SIF Agent. Either StudentRecordExchange or StudentPersonal.

ReportingDate

The date this record was prepared.

N/A

Handled by the SIF Agent.

StudentSchoolEnrollmentData/

@SchoolAttendedRefID

References the school of record for the student.

N/A

Handled by the SIF Agent.

StudentSchoolEnrollmentData/GradeLevel

The student’s grade or academic level.

N/A

N/A

StudentSchoolEnrollmentData/GradeLevel/Code

The SIF code indicating the student’s grade level.

[Students]Grade_Level

The PowerSchool value is translated to the appropriate SIF code.

StudentSchoolEnrollmentData/GradeLevel/

OtherCodeList

N/A

N/A

N/A

StudentSchoolEnrollmentData/GradeLevel/

OtherCodeList/OtherCode @

Describes the OtherCode element content as either a state/province code, a local code, other code, or text string.

[Students]Grade_Level

Valid Values:

StateProvince

Local

Other

Text

DistrictEntryDate

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

[Students]DistrictEntryDate

N/A

SchoolAttendanceHistory

Chronology of schools attended in the student's academic career, including the current school if enrolled.

N/A

N/A

SchoolAttendanceHistory/SchoolAttended

@RefID

Id used internally to StudentAcademicRecord to avoid duplication of school-related data.

N/A

Handled by the SIF Agent.

SchoolAttendanceHistory/SchoolAttended/

LEAInfoData

Collects elements of interest from LEAInfo.

N/A

N/A

SchoolAttendanceHistory/SchoolAttended/

LEAInfoData/LocalID

The LEA number.

[Prefs]Value where Name = DistrictNumber

N/A

SchoolAttendanceHistory/SchoolAttended/

LEAInfoData/StateProvinceID

The state or province of the LEA.

[Prefs]Value where Name = DistrictNumber

N/A

SchoolAttendanceHistory/SchoolAttended/

LEAInfoData/LEAName

The LEA name.

[Prefs]Value where Name = DistrictName

N/A

SchoolAttendanceHistory/SchoolAttended/

SchoolInfoData

Collects elements of interest from SchoolInfo.

N/A

N/A

SchoolAttendanceHistory/SchoolAttended/

SchoolInfoData/LocalID

The local ID of the school.

[Schools]School_Number

N/A

SchoolAttendanceHistory/SchoolAttended/

SchoolInfoData/StateProvinceID

The state ID of the school.

[Schools]SIF_StatePrID

N/A

SchoolAttendanceHistory/SchoolAttended/

SchoolInfoData/SchoolName

The name of the school.

[StoredGrades]SchoolName

N/A

SchoolAttendanceHistory/SchoolAttended/

SchoolInfoData/SchoolContactList

List of contact persons associated with the school.

N/A

N/A

SchoolAttendanceHistory/SchoolAttended/

SchoolInfoData/SchoolContactList/

SchoolContact

Information on contact persons for this school.

N/A

N/A

SchoolAttendanceHistory/SchoolAttended/

SchoolInfoData/SchoolContactList/

SchoolContact/ContactInfo

Information on contact persons for this school.

N/A

N/A

SchoolAttendanceHistory/SchoolAttended/

SchoolInfoData/SchoolContactList/

SchoolContact/ContactInfo/Name @ Type

SIF type of contact

N/A

Always ‘04’

SchoolAttendanceHistory/SchoolAttended/

SchoolInfoData/SchoolContactList/

SchoolContact/ContactInfo/Name/LastName

Last name of the contact.

[Schools]Principal

[Schools]AsstPrincipal

N/A

SchoolAttendanceHistory/SchoolAttended/

SchoolInfoData/SchoolContactList/

SchoolContact/ContactInfo/Name/FirstName

First name of the contact.

[Schools]Principal

[Schools]AsstPrincipal

N/A

SchoolAttendanceHistory/SchoolAttended/

SchoolInfoData/SchoolContactList/

SchoolContact/ContactInfo/Name/MiddleName

Middle name of the contact.

[Schools]Principal

[Schools]AsstPrincipal

N/A

SchoolAttendanceHistory/SchoolAttended/

SchoolInfoData/SchoolContactList/

SchoolContact/ContactInfo/PositionTitle

The contact person's position title.

[Schools]Principal

[Schools]AsstPrincipal

Set to Principal or Assistant Principal based on which field the name came from.

SchoolAttendanceHistory/SchoolAttended/

SchoolInfoData/SchoolContactList/

SchoolContact/ContactInfo/Address

Information regarding the school address.

N/A

N/A

SchoolAttendanceHistory/SchoolAttended/

SchoolInfoData/SchoolContactList/

SchoolContact/ContactInfo/Address @ Type

SIF type of address.

N/A

Always ‘0765’

SchoolAttendanceHistory/SchoolAttended/

SchoolInfoData/SchoolContactList/

SchoolContact/ContactInfo/Address/Street

Information regarding the physical address of the school.

N/A

N/A

SchoolAttendanceHistory/SchoolAttended/

SchoolInfoData/SchoolContactList/

SchoolContact/ContactInfo/Address/Street/Line 1

The address of the school.

[Schools]SchoolAddress

N/A

SchoolAttendanceHistory/SchoolAttended/

SchoolInfoData/SchoolContactList/

SchoolContact/ContactInfo/Address/City

The city of the school.

[Schools]SchoolCity

N/A

SchoolAttendanceHistory/SchoolAttended/

SchoolInfoData/SchoolContactList/

SchoolContact/ContactInfo/Address/County

The county of the school.

[Schools]CountyName

N/A

SchoolAttendanceHistory/SchoolAttended/

SchoolInfoData/SchoolContactList/

SchoolContact/ContactInfo/Address/StateProvince

The state or province of the school.

[Schools]SchoolState

N/A

SchoolAttendanceHistory/SchoolAttended/

SchoolInfoData/SchoolContactList/

SchoolContact/ContactInfo/Address/Country

The country of the school.

Note: This value defaults to US.

[Schools]SchoolCountry

N/A

SchoolAttendanceHistory/SchoolAttended/

SchoolInfoData/SchoolContactList/

SchoolContact/ContactInfo/Address/PostalCode

The zip code of the school.

[Schools]SchoolZip

N/A

SchoolAttendanceHistory/SchoolAttended/

SchoolInfoData/SchoolContactList/

SchoolContact/ContactInfo/EmailList

Email information in list form.

N/A

N/A

SchoolAttendanceHistory/SchoolAttended/

SchoolInfoData/SchoolContactList/

SchoolContact/ContactInfo/EmailList/

Email @ ‘Primary’

The email address of the assistant principal or principal.

[Schools]PrincipalEmail

[Schools]AsstPrincipalEmail

N/A

SchoolAttendanceHistory/SchoolAttended/

SchoolInfoData/SchoolContactList/

SchoolContact/ContactInfo/PhoneNumberList

Contact phone number information in list form.

N/A

N/A

SchoolInfoData/SchoolContactList/

SchoolContact/ContactInfo/PhoneNumberList/

PhoneNumber @ Type

The SIF code indicating the type of phone number.

N/A

Always ‘0096’

SchoolAttendanceHistory/SchoolAttended/

SchoolInfoData/SchoolContactList/

SchoolContact/ContactInfo/PhoneNumberList/PhoneNumber/Number

The phone number of the assistant principal or principal.

[Schools]PrincipalPhone

[Schools]AsstPrincipalPhone

N/A

SchoolAttendanceHistory/SchoolAttended/

SchoolInfoData/SchoolContactList/

SchoolContact/ContactInfo/GradeLevels

List of grade levels at the school.

N/A

N/A

SchoolAttendanceHistory/SchoolAttended/

SchoolInfoData/SchoolContactList/

SchoolContact/ContactInfo/GradeLevels/

GradeLevel

The specific grade levels taught at the school.

[Schools]Low_Grade

[Schools]High_Grade

Derived by the SIF Agent.

SchoolAttendanceHistory/SchoolAttended/

MarkingSystems

Marking systems/grading tables used by the school.

N/A

N/A

SchoolAttendanceHistory/SchoolAttended/

MarkingSystems @ RefID

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

N/A

Handled by the SIF Agent.

SchoolAttendanceHistory/SchoolAttended/

MarkingSystems/MarkValueInfoData/Name

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

[GradeScaleName]Name

N/A

SchoolAttendanceHistory/SchoolAttended/

MarkingSystems/MarkValueInfoData/Letter

Indicates whether a letter Mark is accepted.

N/A

N/A

SchoolAttendanceHistory/SchoolAttended/

MarkingSystems/MarkValueInfoData/Letter/

ValidMark

List of specific valid letter Marks.

N/A

N/A

SchoolAttendanceHistory/SchoolAttended/

MarkingSystems/MarkValueInfoData /Letter/ValidMark/Code

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

[GradeScaleItem]Name

N/A

SchoolAttendanceHistory/SchoolAttended/

MarkingSystems @ RefID/Letter/ValidMark/

NumericEquivalent

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

[GradeScaleItem]Grade_Points

N/A

SchoolAttendanceHistory/SchoolAttended/

MarkingSystems @ RefID/Letter/ValidMark/

Description

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

[GardeScaleItem]Description

N/A

EnrollmentHistory

Collects elements of interest from StudentSchoolEnrollment.

N/A

N/A

EnrollmentHistory/StudentSchoolEnrollmentData/

@ SchoolAttendedRefID

Reference to SchoolAttended.

N/A

Handled by the SIF Agent.

EnrollmentHistory/StudentSchoolEnrollmentData/

SchoolYear

School year to which the information pertains.

N/A

Derived by the SIF Agent.

EnrollmentHistory/StudentSchoolEnrollmentData/

EntryDate

Entry date of the student.

[Students]EntryDate

[ReEnrollments]EntryDate

N/A

EnrollmentHistory/StudentSchoolEnrollmentData/

ExitDate

Exit date of the student.

[Students]ExitDate

[ReEnrollments]ExitDate

N/A

EnrollmentHistory/StudentSchoolEnrollmentData/

EntryType

Data pertaining to the type of entry for the enrollment.

N/A

N/A

EnrollmentHistory/StudentSchoolEnrollmentData/

EntryType/Code

The SIF code indicating the type of entry for this enrollment.

[Students]EntryCode

[ReEnrollments]EntryCode

The PowerSchool value is translated to the appropriate SIF code.

EnrollmentHistory/StudentSchoolEnrollmentData/

EntryType/OtherCodeList

N/A

N/A

N/A

EnrollmentHistory/StudentSchoolEnrollmentData/

EntryType/OtherCodeList/OtherCode @

Describes the OtherCode element content as either a state/province code, a local code, other code, or text string.

[Students]EntryCode

[ReEnrollments]EntryCode

Valid Values:

StateProvince

Local

Other

Text

EnrollmentHistory/StudentSchoolEnrollmentData/

GradeLevel

Grade or academic level of student.

N/A

N/A

EnrollmentHistory/StudentSchoolEnrollmentData/

GradeLevel/Code

The SIF code representing the grade level.

[Students]Grade_Level

[ReEnrollments]Grade_Level

The PowerSchool value is translated to the appropriate SIF code.

EnrollmentHistory/StudentSchoolEnrollmentData/

GradeLevel/OtherCodeList

N/A

N/A

N/A

EnrollmentHistory/StudentSchoolEnrollmentData/

GradeLevel/OtherCodeList/OtherCode @

Describes the OtherCode element content as either a state/province code, a local code, other code, or text string.

[Students]Grade_Level

[ReEnrollments]Grade_Level

Valid Values:

StateProvince

Local

Other

Text

EnrollmentHistory/StudentSchoolEnrollmentData/

ExitType

Data pertaining to the type of exit for the enrollment.

N/A

N/A

EnrollmentHistory/StudentSchoolEnrollmentData/ExitType/Code

The SIF code indicating the type of exit for this enrollment.

[Students]ExitCode

[ReEnrollments]ExitCode

The PowerSchool value is translated to the appropriate SIF code.

EnrollmentHistory/StudentSchoolEnrollmentData/ExitType/OtherCodeList

N/A

N/A

N/A

EnrollmentHistory/StudentSchoolEnrollmentData/ExitType/OtherCodeList/OtherCode @

Describes the OtherCode element content as either a state/province code, a local code, other code, or text string.

[Students]ExitCode

[ReEnrollments]ExitCode

Valid Values:

StateProvince

Local

Other

Text

CurrentCourseActivity

Conveys a student's current coursework along with mid-term marks if applicable.

N/A

N/A

CurrentCourseActivity/TermInfoData @

SchoolAttendedRefID

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

N/A

Handled by the SIF Agent.

CurrentCourseActivity/TermInfoData/SchoolYear

School year of the course taken.

[Terms]YearID

YearID + 1991

CurrentCourseActivity/TermInfoData/StartDate

Start date of the term.

[Terms]FirstDay

N/A

CurrentCourseActivity/TermInfoData/EndDate

End date of the term.

[Terms]LastDay

N/A

CurrentCourseActivity/TermInfoData/Description

Description of the term.

[Terms]Name

N/A

CurrentCourseActivity/TermInfoData/TermCode

Abbreviation of the term.

[Terms]Abbreviation

N/A

CurrentCourseActivity/TermInfoData/Track

Student’s track, if any.

[Students]Track

N/A

CurrentCourseActivity/TermInfoData/TermSpan

Collects elements of interest from TermInfo.

N/A

N/A

CurrentCourseActivity/TermInfoData/TermSpan/

Code

The code indicating the span of the term.

[Terms]Portion

The PowerSchool field value is translated to the appropriate SIF code.

CurrentCourseActivity/TermInfoData/TermSpan/

OtherCodeList

N/A

N/A

N/A

CurrentCourseActivity/TermInfoData/TermSpan/

OtherCodeList @

Describes the OtherCode element content as either a state/province code, a local code, other code, or text string.

[Terms]Portion

Valid Values:

StateProvince

Local

Other

Text

CurrentCourseActivity

Conveys a student's current coursework along with mid-term marks if applicable.

N/A

N/A

CurrentCourseActivity/Courses/

Courses being taken.

N/A

N/A

CurrentCourseActivity/Courses/Course

Course being taken.

N/A

N/A

CurrentCourseActivity/Courses/Course/

SchoolAttendedRefID

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.

N/A

Handled by the SIF Agent.

CurrentCourseActivity/Courses/Course/

SchoolCourseInfoData

Collects elements of interest from SchoolCourseInfo.

N/A

N/A

CurrentCourseActivity/Courses/Course/

SchoolCourseInfoData/CourseCode

Course number of the course.

[CC]Course_Number

N/A

CurrentCourseActivity/Courses/Course/

SchoolCourseInfoData/StateCourseCode

State code of the course

[Courses]Alt_Course_Number

N/A

CurrentCourseActivity/Courses/Course/

SchoolCourseInfoData/DistrictCourseCode

District code of the course.

[CC]Course_NUmber

N/A

CurrentCourseActivity/Courses/Course/

SchoolCourseInfoData/NationalCourseCode

National Code of the course.

[Courses]Code

N/A

CurrentCourseActivity/Courses/Course/

SchoolCourseInfoData/SubjectAreaList

A list of subject areas.

N/A

N/A

CurrentCourseActivity/Courses/Course/

SchoolCourseInfoData/SubjectAreaList/SubjectArea

Subject matter.

N/A

N/A

CurrentCourseActivity/Courses/Course/

SchoolCourseInfoData/SubjectAreaList/SubjectArea/Code

SIF code of the subject matter.

[Courses]Sched_CourseSubjectAreaCode

The PowerSchool value is translated to the appropriate SIF value.

CurrentCourseActivity/Courses/Course/

SchoolCourseInfoData/SubjectAreaList/SubjectArea/OtherCodeList

N/A

N/A

N/A

CurrentCourseActivity/Courses/Course/

SchoolCourseInfoData/SubjectAreaList/SubjectArea/OtherCode @

Describes the OtherCode element content as either a state/province code, a local code, other code, or text string.

[Courses]Sched_CourseSubjectAreaCode

Valid Values:

StateProvince

Local

Other

Text

CurrentCourseActivity/Courses/Course/

SchoolCourseInfoData/CourseTitle

Name of the course.

[Courses]Course_Name

N/A

CurrentCourseActivity/Courses/Course/

SchoolCourseInfoData/Description

Description of the course.

Note: This value is entered on the Edit Course page via PowerScheduler, or can be imported.

[Courses]Sched_FullCatalogDescription

N/A

CurrentCourseActivity/Courses/Course/

SchoolCourseInfoData/Department

Department of the course.

[Courses]Sched_Department

N/A

CurrentCourseActivity/Courses/Course/

StartDate

Date the course section started.

[Terms]FirstDay

N/A

CurrentCourseActivity/Courses/Course/

EndDay

Date the course section ended.

[Terms]LastDay

N/A

CurrentCourseActivity/Courses/Course/

MarkingPeriod

Collects elements of interest about the marking period.

N/A

N/A

CurrentCourseActivity/Courses/Course/

MarkingPeriod/TermInfoData

Information related to the span of time associated with the marking period.

N/A

N/A

CurrentCourseActivity/Courses/Course/

MarkingPeriod/TermInfoData/StartDate

Start date of the term the course section is taught in.

[Terms]FirstDay

N/A

CurrentCourseActivity/Courses/Course/

MarkingPeriod/TermInfoData/EndDate

End date of the term the course section is taught in.

[Terms]LastDay

N/A

CurrentCourseActivity/Courses/Course/

MarkingPeriod/TermInfoData/Description

Description of the term the course section is taught in.

[Terms]Name

N/A

CurrentCourseActivity/Courses/Course/

MarkingPeriod/TermInfoData/TermCode

Term abbreviation for the term the course section is taught in.

[Terms]Abbreviation

N/A

CurrentCourseActivity/Courses/Course/

MarkingPeriod/TermInfoData/Track

Track of the course section.

[Students]Track

N/A

CurrentCourseActivity/Courses/Course/

MarkingPeriod/TermInfoData/TermSpan

Code for session type.

N/A

N/A

CurrentCourseActivity/Courses/Course/

MarkingPeriod/TermInfoData/TermSpan/Code

SIF code of the course section session type.

[Terms]Portion

The PowerSchool value is translated to the appropriate SIF code.

CurrentCourseActivity/Courses/Course/

MarkingPeriod/TermInfoData/TermSpan/

OtherCodeList

N/A

N/A

N/A

CurrentCourseActivity/Courses/Course/

MarkingPeriod/TermInfoData/TermSpan/

OtherCodeList @

Describes the OtherCode element content as either a state/province code, a local code, other code, or text string.

[Terms]Portion

Valid Values:

StateProvince

Local

Other

Text

CurrentCourseActivity/Courses/Course/

MarkingPeriod/GradeLevelWhenTaken

Student's grade level at time of course.

N/A

N/A

CurrentCourseActivity/Courses/Course/

MarkingPeriod/GradeLevelWhenTaken/Code

Grade level of the student taking the course section.

[Students]Grade_Level

The PowerSchool value is translated to the appropriate SIF code.

CurrentCourseActivity/Courses/Course/

MarkingPeriod/GradeLevelWhenTaken/

OtherCodeList

N/A

N/A

N/A

CurrentCourseActivity/Courses/Course/

MarkingPeriod/GradeLevelWhenTaken/

OtherCodeList @

Describes the OtherCode element content as a state/province code, a local code, other code, or text string.

[Students]Grade_Level

Valid Values:

StateProvince

Local

Other

Text

CurrentCourseActivity/Courses/Course/

MarkingPeriod/CourseCreditsAttempted

Number of course credits attempted.

[Courses]Credit_Hours

N/A

CourseHistory

Conveys the coursework completed performance and attendance information for a student's academic career.

N/A

N/A

CourseHistory/Term

Time spans by which courses are grouped.

N/A

N/A

CourseHistory/Term/TermInfoData @

SchoolAttendedRefID

Reference to the school of record for the time span (see SchoolAttended).

N/A

Handled by the SIF Agent.

CourseHistory/Term/TermInfoData/SchoolYear

School year that pertains to the record.

[Terms]YearID

N/A

CourseHistory/Term/TermInfoData/StartDate

Start date of the term that pertains to the record.

[Terms]FirstDay

N/A

CourseHistory/Term/TermInfoData/EndDate

End date of the term that the record pertains to.

[Terms]LastDay

N/A

CourseHistory/Term/TermInfoData/Description

Description of the term that the record pertains to.

[Terms]Name

N/A

CourseHistory/Term/TermInfoData/TermCode

Code that describes the term that pertains to the record.

[Terms]Abbreviation

N/A

CourseHistory/Term/TermInfoData/Track

The track the student was on during this time period.

[Students]Track

[ReEnrollments]Track

N/A

CourseHistory/Term/TermInfoData/TermSpan/

Code for session type.

N/A

N/A

CourseHistory/Term/TermInfoData/TermSpan/Code

SIF code of session type to which this record relates to.

[Terms]Portion

The PowerSchool value is translated to the appropriate SIF code.

CourseHistory/Term/TermInfoData/TermSpan/

OtherCodeList

N/A

N/A

N/A

CourseHistory/Term/TermInfoData/TermSpan/

OtherCodeList/ @

Describes the OtherCode element content as a state/province code, a local code, other code, or text string.

[Terms]Portion

Valid Values:

StateProvince

Local

Other

Text

CourseHistory/Term/Courses

Courses that were taken.

N/A

N/A

CourseHistory/Term/Courses/Course

Course that was taken.

N/A

N/A

CourseHistory/Term/Courses/Course/

SchoolAttendedRefID

Reference to the school where the course was taken (see SchoolAttended).

N/A

Handled by the SIF Agent.

CourseHistory/Term/Courses/Course/

SchoolCourseInfoData

Collects elements of interest from SchoolCourseInfo.

N/A

N/A

CourseHistory/Term/Courses/Course/

SchoolCourseInfoData/CourseCode

Course number to which this data pertains.

[Courses]Course_Number

N/A

CourseHistory/Term/Courses/Course/

SchoolCourseInfoData/StateCourseCode

State code for the course to which this data pertains.

[Courses]Alt_Course_Number

N/A

CourseHistory/Term/Courses/Course/

SchoolCourseInfoData/DistrictCourseCode

District course number to which this data pertains.

[Courses]Course_NUmber

N/A

CourseHistory/Term/Courses/Course/

SchoolCourseInfoData/NationalCourseCode

National course code for the course to which this data pertains.

[Courses]Code

N/A

CourseHistory/Term/Courses/Course/

SchoolCourseInfoData/SubjectAreaList

A list of subject areas.

N/A

N/A

CourseHistory/Term/Courses/Course/

SchoolCourseInfoData/SubjectAreaList/

SubjectArea

Subject matter.

N/A

N/A

CourseHistory/Term/Courses/Course/

SchoolCourseInfoData/SubjectAreaList/

SubjectArea/Code

SIF code indicating the subject matter.

[Courses]Sched_CourseSubjectAreaCode

The PowerSchool value is translated to the appropriate SIF code.

CourseHistory/Term/Courses/Course/

SchoolCourseInfoData/SubjectAreaList/

SubjectArea/OtherCodeList

N/A

N/A

N/A

CourseHistory/Term/Courses/Course/

SchoolCourseInfoData/SubjectAreaList/

SubjectArea/OtherCodeList/OtherCode @

Describes the OtherCode element content as a state/province code, a local code, other code, or text string.

[Courses]Sched_CourseSubjectAreaCode

Valid Values:

StateProvince

Local

Other

Text

CourseHistory/Term/Courses/Course/

SchoolCourseInfoData/CourseTitle

The course name of the course to which this data pertains.

[Courses]Course_Name

N/A

CourseHistory/Term/Courses/Course/

SchoolCourseInfoData/Description

The description of the course to which this data pertains.

[Courses]Sched_FullCatalogDescitpion.

N/A

CourseHistory/Term/Courses/Course/

SchoolCourseInfoData/Department

The department the course belongs to.

[Courses]Sched_Department

N/A

CourseHistory/Term/Courses/Course/

StartDate

Date course section started.

[Terms]FirstDay

N/A

CourseHistory/Term/Courses/Course/

EndDate

Date course section ended.

[Terms]EndDay

N/A

CourseHistory/Term/Courses/Course/

MarkingPeriods

Student performance/attendance data for each marking period.

N/A

N/A

CourseHistory/Term/Courses/Course/

MarkingPeriods/MarkingPeriod

Student performance/attendance data for a marking period.

N/A

N/A

CourseHistory/Term/Courses/Course/

MarkingPeriods/MarkingPeriod/SchoolAttendedRefID

Reference to the school where student took the course during the marking period, if different from schools above.

N/A

Handled by the SIF Agent

CourseHistory/Term/Courses/Course/

MarkingPeriods/MarkingPeriod/TermInfoData

Information related to the span of time associated with the marking period.

N/A

N/A

CourseHistory/Term/Courses/Course/

MarkingPeriods/MarkingPeriod/TermInfoData/

StartDate

The start date of the of the time span to which this data pertains.

[Terms]FirstDay

N/A

CourseHistory/Term/Courses/Course/

MarkingPeriods/MarkingPeriod/TermInfoData/

EndDate

The end date of the of the time span to which this data pertains.

[Terms]LastDay

N/A

CourseHistory/Term/Courses/Course/

MarkingPeriods/MarkingPeriod/TermInfoData/

Description

The description of the time span to which this data pertains.

[Terms]Name

N/A

CourseHistory/Term/Courses/Course/

MarkingPeriods/MarkingPeriod/TermInfoData/

TermCode

The abbreviation of the time span to which this data pertains.

[Terms]Abbreviation

N/A

CourseHistory/Term/Courses/Course/

MarkingPeriods/MarkingPeriod/TermInfoData/

Track

The track of the student during the time period to which this data pertains.

[Students]Track

[ReEnrollments]Track

N/A

CourseHistory/Term/Courses/Course/

MarkingPeriods/MarkingPeriod/TermInfoData/

TermSpan

Information on the course section session type.

N/A

N/A

CourseHistory/Term/Courses/Course/

MarkingPeriods/MarkingPeriod/TermInfoData/

TermSpan/Code

SIF code of the session type to which this record pertains.

[Terms]Portion

The PowerSchool value is translated to the appropriate SIF code

CourseHistory/Term/Courses/Course/

MarkingPeriods/MarkingPeriod/TermInfoData/

TermSpan/OtherCodeList

N/A

N/A

N/A

CourseHistory/Term/Courses/Course/

MarkingPeriods/MarkingPeriod/TermInfoData/

TermSpan/OtherCodeList/OtherCode @

Describes the OtherCode element content as a state/province code, a local code, other code, or text string.

[Terms]Portion

Valid Values:

StateProvince

Local

Other

Text

CourseHistory/Term/Courses/Course/

MarkingPeriods/MarkingPeriod/GradeLevelTaken

Student's grade level at time of course.

N/A

N/A

CourseHistory/Term/Courses/Course/

MarkingPeriods/MarkingPeriod/GradeLevelTaken/Code

The grade level code of the student when they took the course section.

[StoredGrades]Grade_Level

The PowerSchool value is translated to the appropriate SIF code.

CourseHistory/Term/Courses/Course/

MarkingPeriods/MarkingPeriod/GradeLevelTaken/OtherCodeList

N/A

N/A

N/A

CourseHistory/Term/Courses/Course/

MarkingPeriods/MarkingPeriod/GradeLevelTaken/OtherCodeList/OtherCode @

Describes the OtherCode element content as a state/province code, a local code, other code, or text string.

[StoredGrades]Grade_Level

Valid Values:

StateProvince

Local

Other

Text

CourseHistory/Term/Courses/Course/

MarkingPeriods/MarkingPeriod/MarkData @ MarkValueInfoDataRefID

Reference to marking system at school of record.

N/A

Handled by the SIF Agent.

CourseHistory/Term/Courses/Course/

MarkingPeriods/MarkingPeriod/MarkData/Percentage

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

[StoredGrades]Percent

N/A

CourseHistory/Term/Courses/Course/

MarkingPeriods/MarkingPeriod/MarkData/Numeric

The raw numeric score for this mark.

[StoredGrades]GPA_Points

N/A

CourseHistory/Term/Courses/Course/

MarkingPeriods/MarkingPeriod/MarkData/Letter

The letter grade for this mark.

[StoredGrades]Grade

N/A

CourseHistory/Term/Courses/Course/

MarkingPeriods/MarkingPeriod/MarkData/

CourseCreditsAttempted

Number of course credits attempted.

[StoredGrades]PotentialCrHrs

N/A

CourseHistory/Term/Courses/Course/

MarkingPeriods/MarkingPeriod/MarkData/

CourseCreditsEarned

Number of course credits earned.

[StoredGrades]EarnedCrHrs

N/A

CourseHistory/Term/Courses/Course/

MarkingPeriods/MarkingPeriod/DaysAbsent

Number of days absent.

[StoredGrades]Absences

N/A

AcademicPerformanceHistory

Provides a summary of a student's academic performance by reporting period.

N/A

N/A

AcademicPerformanceHistory/TermPerformance

Individual term performance.

N/A

N/A

AcademicPerformanceHistory/TermPerformance/

TermInfoData

Collects elements of interest from TermInfo.

N/A

N/A

AcademicPerformanceHistory/TermPerformance/

TermInfoData/SchoolYear

The school year to which this data pertains.

[Terms]YearID

N/A

AcademicPerformanceHistory/TermPerformance/

TermInfoData/StartDate

The term start date to which this data pertains.

[Terms]FirstDay

N/A

AcademicPerformanceHistory/TermPerformance/

TermInfoData/EndDate

The term end date to which this data pertains.

[Terms]LastDay

N/A

AcademicPerformanceHistory/TermPerformance/

TermInfoData/Description

The description of the term to which this data pertains.

[Terms]Name

N/A

AcademicPerformanceHistory/TermPerformance/

TermInfoData/TermCode

The abbreviation of the term to which this data applies.

[Terms]Abbreviation

N/A

AcademicPerformanceHistory/TermPerformance/

TermInfoData/Track

The track the student was on during this term.

[Students]Track

[ReEnrollments]Track

N/A

AcademicPerformanceHistory/TermPerformance/

TermInfoData/TermSpan

Information on the course section session type.

N/A

N/A

AcademicPerformanceHistory/TermPerformance/

TermInfoData/TermSpan/Code

SIF code of the course section session type to which this record pertains.

[Terms]Portion

The PowerSchool value is translated to the appropriate SIF code.

AcademicPerformanceHistory/TermPerformance/

TermInfoData/TermSpan/OtherCodeList

N/A

N/A

N/A

AcademicPerformanceHistory/TermPerformance/

TermInfoData/TermSpan/OtherCodeList/OtherCode @

Describes the OtherCode element content as a state/province code, a local code, other code, or text string.

[Terms]Portion

Valid Values:

StateProvince

Local

Other

Text

AcademicPerformanceHistory/TermPerformance/

GradeLevelWhenTaken

Student's grade level at time.

N/A

N/A

AcademicPerformanceHistory/TermPerformance/

GradeLevelWhenTaken/Code

The SIF grade level code of the student during the term to which this data pertains.

[Students]Grade_Level

The PowerSchool value is translated to the appropriate SIF code.

AcademicPerformanceHistory/TermPerformance/

GradeLevelWhenTaken/OtherCodeList

N/A

N/A

N/A

AcademicPerformanceHistory/TermPerformance/

GradeLevelWhenTaken/OtherCodeList/OtherCode @

Describes the OtherCode element content as a state/province code, a local code, other code, or text string.

[Students]Grade_Level

Valid Values:

StateProvince

Local

Other

Text

AcademicPerformanceHistory/TermPerformance/

TotalCreditsAttempted

Number of credits attempted.

[StoredGrades]PotentialCrHrs

Sum of potential credit for all classes in the term.

AcademicPerformanceHistory/TermPerformance/

TotalCreditsEarned

Number of credits earned.

[StoredGrades]EarnedCrHrs

Sum of earned credit for all classes in the term.

AcademicPerformanceHistory/TermPerformance/

CumulativeGPACreditsEarned

Number of GPA credits earned.

[StoredGrades]EarnedCrHrs

Sum of earned credit for all classes in the term that count towards the GPA.

AcademicPerformanceHistory/TermPerformance/

CumulativeGradePoints

Number of GPA points received.

[StoredGrades]GPA_Points

Sum of all GPA points for the term.

AcademicPerformanceHistory/TermPerformance/

CumulativeGPA

The student’s cumulative GPA.

[ClassRank]GPA

N/A

AcademicPerformanceHistory/TermPerformance/

GPAType

The GPA type.

[ClassRank]GPAMethod

N/A

AcademicPerformanceHistory/TermPerformance/

ClassRank

The student’s class rank.

[ClassRank]Rank

N/A

AcademicPerformanceHistory/TermPerformance/

ClassTotalNumber

The total number of student’s in the class.

[ClassRank]OutOf

N/A

AcademicPerformanceHistory/TermPerformance/

DateRanked

The date the class rank was calculated.

[ClassRank]ClassRankingDate

N/A

AcademicPerformanceHistory/TermPerformance/

ProjectedGraduationDate

The projected year of graduation.

[Students]Sched_YearOfGraduation

N/A

AssessmentPerformanceHistory

Conveys a history of assessments that the student has taken throughout his/her academic career.

N/A

N/A

AssessmentPerformanceHistory/Assessment

A record of performance on an individual assessment.

N/A

N/A

AssessmentPerformanceHistory/Assessment/Name

Textual description of assessment.

[Test]Name

N/A

AssessmentPerformanceHistory/Assessment/

AdministrationDate

Date the assessment was administered.

[StudentTest]Test_Date

N/A

AssessmentPerformanceHistory/Assessment/

Level

Free-form text description of the level of the test.

[Test]Test_Type

N/A

AssessmentPerformanceHistory/Assessment/

StudentGradeLevelWhenAssessed

The student’s grade level when assessed

N/A

N/A

AssessmentPerformanceHistory/Assessment/

StudentGradeLevelWhenAssessed/Code

The SIF code representing the student’s grade level when assessed.

[StudentTest]Grade_level

The PowerSchool value is translated to the appropriate SIF value.

AssessmentPerformanceHistory/Assessment/

StudentGradeLevelWhenAssessed/OtherCodeList

N/A

N/A

N/A

AssessmentPerformanceHistory/Assessment/

StudentGradeLevelWhenAssessed/OtherCodeList/OtherCode @

Describes the OtherCode element content as a state/province code, a local code, other code, or text string.

[StudentTest]Grade_Level

Valid Values:

StateProvince

Local

Other

Text

AssessmentPerformanceHistory/Assessment/

SubtestCategory

The subtest or subject category of the assessment.

[TestScore]Name

N/A

AssessmentPerformanceHistory/Assessment/

TestScore

Test score.

[StudentTestScore]AlphaScore

[StudentTestScore]NumScore

[StudentTestScore]PercentScore

N/A

ActivityAwardHistory

Conveys award the student has received and/or activities in which s/he has been involved.

N/A

N/A

ActivityAwardHistory/ActivityAward

A record of an individual award or activity.

N/A

N/A

ActivityAwardHistory/ActivityAward/Name

The title that identifies a particular co-curricular or extra-curricular activity.

[Gen]Name

The name of the PowerSchool Activity.

WeightedGPA

The student’s cumulative weighted GPA.

Not yet implemented in the Agent.

SIF extended element.

PercentileRank

The student’s rank, in percentile form, within the class.

[ClassRank]Rank

[ClassRank]OUtOf

SIF extended element.

Calculated from the ClassRank “Outof” and “Rank” values.