|
|
|
|
|
|
|
Contents |
After each grade mark in the student-class table has been selected for the standardized transcript, the month and year for the grade mark are determined by one of the two following methods:
Course Completion Date: First, the existence of data in student-class.wn-cor-comp-date is checked. If data exists, that date is used for the month/year.
If the student-class.wn-cor-comp-date contains no data, the Grading Period End Date from the Grading Period table is used to determine the month/year.
Find the Grading Period End Date of the Grading Period table (grading-period.gp-end-date).
From class grading to grading-period:
For class-grading.track, class-grading.school-year, class-grading.entity-ID and class-grading.grading-period-nbr, find grading-period.track, grading-period.school-year, grading-period.entity-ID and grading-period.grading-period-nbr.
The Class-Grading table contains a separate record for each combination of grade mark and date. Additional logic is required to select the correct class-grading.grading-period-nbr in order to connect to grading-period.grading-period-nbr:
If the grade mark is a final grade, find class-grading.grading-period-nbr where class-grading.control-set-ref = 0 and class-grading.get-final = "Y". Find the corresponding grading-period.grading-period-nbr.
If the grade mark is a semester grade, find class-grading.grading-period-nbr where class-grading.control-set-ref = 0 and class-grading.get-sem = "Y". Find the corresponding grading-period.grading-period-nbr.
If the grade mark is a term grade, find class-grading.grading-period-nbr where class-grading.control-set-ref = 0 and class-grading.get-term = "Y". Find the corresponding grading-period.grading-period-nbr.
Page Updated 8/05