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 | [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 | [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 | [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 | [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 | [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 | [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 | [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 | [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 | [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 | [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 | [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 | [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 | [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 | [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 | [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. |