Generation - StudentTranscript Interchange Data
Jason Hoekstra
Owned by Jason Hoekstra
This section outlines the StudentTranscript Interchange generation rules.
Input & Precursors
Standard configuration file, which includes a SchoolProfile and GradeProfile configuration data. Also depends on StudentEnrollment and EducationOrgCalendar data
Entities & Elements
Interchange-StudentTranscript.xsd contains the following entities:
- CourseTranscript
- StudentAcademicRecord
| Path | Element | Rules | Notes |
|---|---|---|---|
| CourseTranscript | CourseAttemptResult | Always "Pass" | No failing grades currently generated |
| AttemptedCredits | Equal to number of credits assigned to course divided by the number of sessions in the academic year | It's currently assumed that all courses span the entire school year (i.e., there is currently no support for single-term courses) | |
| EarnedCredits | Equal to AttemptedCredits | ||
| WhenTakenGradelevel | Will match the grade level at which the given course is offered | ||
| MethodCreditsEarned | Always "Classroom Credit" | ||
| FinalLetterGradeEarned | Always matches letter grade for student average (A-F letter grade scale) | ||
| FinalNumericGradeEarned | Random value between FinalLetterGradeEarned min and max numeric grade | ||
| CourseReference | Populated with reference to previously generated course | ||
| SchoolReference | Populated with reference to previously generated school | ||
| StudentAcademicRecordReference | Populated with reference to student academic record | ||
| StudentAcademicRecord | id | String of the format "SAR_{SessionId}_{Student.UniqueId}", where SessionId is of the format "2017-2018_Fall_Semester" | |
| CumulativeEarnedCredits | Cumulative sum of credits earned by the student since they were enrolled at their current school | ||
| StudentReference | Populated with reference to previously generated student | ||
| EducationOrganizationReference | Populated with reference to previously generated school | ||
| SchoolYear | School year for which this SAR was generated | SARs are generated for past terms starting from the first grade/term available at the student's current school up until their current school year/term. | |
| Term | School term for which this SAR was generated |