What table will show final grades?
If I use the Overall_score_cache to get the overall mark for a student, will a mark that was changed at posting show there? If not, where do I find the posted final mark for students by course_id?
-
Posted grades are in public.student_grades. That needs to be joined by student_id, and to the section with sgpa_id (referencing public.section_grading_period_aff).
I've experienced that a section doesn't necessarily have a section_grading_period_aff record for every grading period, for instance if grades hadn't been posted for that section and grading period, or if it hadn't been viewed in the Edit Grades by Section page. Something to bear in mind when setting up your joins.
Please sign in to leave a comment.
Comments
1 comment