The Student Division Master table contains the academic record for each student. The academic record consists of grade point average (GPA) information. The table has one row per student per division.
|
If a student has taken both graduate and undergraduate courses at your organization, they will have two rows on the Student Division Master table. Each row will store the GPA within its division. |
If a student has more than one Student Division Master row (a result of having taken courses in two divisions), J1 needs a way to know which row contains the student's current division. The Student Master table contains a current division column that indicates which division is current. When reports are created, you can link the Student Division Master table to the Student Master table by using the Name ID and the Current Division columns. The report will use GPA information from the current Student Division Master row.