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 |