What table will show final grades?

Comments

1 comment

  • Avatar
    Casey Mirch

    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.