Student Academic Record

RefId

Required

Unique academic-record identifier.

Academic-record staging RefId

SIF_RefId

Required

StudentPersonal reference.

Student RefId staging value

SIF_RefObject

Required

Referenced object type.

Calculated constant StudentPersonal

ReportingDate

Required

Academic-record reporting date.

Academic-record staging date

StudentSchoolEnrollmentData/SchoolAttendedRefId

Optional

School attended reference.

Historical enrollment school RefId

StudentSchoolEnrollmentData/GradeLevel/Code/value

Optional

Grade level.

Iowa grade-level descriptor

Enrollment grade level

StudentSchoolEnrollmentData/GradeLevel/OtherCode/value

Optional

Local grade level.

Enrollment grade level

StudentSchoolEnrollmentData/GradeLevel/OtherCode/Codeset

Optional

Grade-level codeset.

StateProvince

Calculated codeset

SchoolAttendanceHistory/SchoolAttended/RefId

Optional

Historical school reference.

[Schools]DCID converted to SchoolInfo RefId

SchoolAttendanceHistory/SchoolAttended/LEAInfoData

Optional

Historical LEA name and identifiers.

[Prefs] and historical school data

SchoolAttendanceHistory/SchoolAttended/SchoolInfoData

Optional

Historical school information.

[Schools]Name, School_Number, SIF_StatePrId, address, phone, and fax fields

SchoolAttendanceHistory/SchoolAttended/MarkingSystems/MarkValueInfoData

Optional

Historical grade-scale information.

[GradeScaleItem] and grade-scale staging queries

CurrentCourseActivity/TermInfoData

Optional

Current term information.

[Terms] current-term fields

CurrentCourseActivity/Courses/Course/StartDate, EndDate

Optional

Current course dates.

Course enrollment staging

CurrentCourseActivity/Courses/Course/SchoolAttendedRefId

Optional

School where the current course is offered.

School RefId

CurrentCourseActivity/Courses/Course/SchoolCourseInfoData

Optional

Current course information.

[Courses]Course_Number, Course_Name, state and national course fields

CurrentCourseActivity/Courses/Course/MarkingPeriod

Optional

Current marking period and grade information.

[Terms], grade-scale, and mark staging

CurrentCourseActivity/Courses/Course/CourseCreditsAttempted

Optional

Current course credits attempted.

Stored-grade/course-credit staging

CourseHistory/Term/TermInfoData

Optional

Historical term information.

[Terms]FirstDay, LastDay, YearID, and term-span data

CourseHistory/Term/Courses/Course/SchoolCourseInfoData

Optional

Historical course information.

[Courses]Course_Number, state course, subject area, and course title fields

CourseHistory/Term/Courses/Course/StartDate, EndDate

Optional

Historical course dates.

Historical course staging

CourseHistory/Term/Courses/Course/SIF_ExtendedElements

Optional

Historical course extensions.

Course extension fields such as CommonCourseNumber and SectionProvider

CourseHistory/Term/Courses/Course/MarkingPeriods

Optional

Historical marking periods.

StoredGrades, Terms, GradeScaleItem, and course history staging

CourseHistory/.../CourseCreditsAttempted

Optional

Credits attempted.

StoredGrades/course-credit staging

CourseHistory/.../CourseCreditsEarned

Optional

Credits earned.

StoredGrades/course-credit staging

CourseHistory/.../DaysAbsent

Optional

Course-related absence days.

Attendance/course history aggregation

AcademicPerformanceSummary/CumulativeGPA

Optional

Nonweighted cumulative GPA.

Iowa class-rank/GPA staging

AcademicPerformanceSummary/ClassRank

Optional

Nonweighted class rank.

Iowa class-rank staging

AcademicPerformanceSummary/ClassTotalNumber

Optional

Total class size.

Iowa class-rank staging

AcademicPerformanceSummary/GraduationDate

Optional

Graduation date.

[S_IA_STU_X]HS_Graduation_Date

AcademicPerformanceSummary/GraduationDiplomaType

Optional

Diploma type.

Iowa diploma codes

[S_IA_STU_X]Diploma_Type

SIF_ExtendedElements/.../DiplomaType

Optional

Extended diploma type.

Iowa diploma staging

SIF_ExtendedElements/.../MaximumGPA

Optional

Maximum GPA.

Iowa school/student GPA staging

SIF_ExtendedElements/.../CumulativeWeightedGPA

Optional

Weighted cumulative GPA.

Iowa class-rank/GPA staging

SIF_ExtendedElements/.../WeightedClassRank

Optional

Weighted class rank.

Iowa class-rank/GPA staging