PS_STDNT_GRPS Table
I am working on an issue with a student's groups. Student was in group 'HS' for example, effective dated 05/01/2019, status as ACTIVE. Second entry for this student on group HS is effective dated 04/01/2020, status as INACTIVE. When I query the PS_STDNT_GRPS table for this student, the HS group still appears. Maybe I am not understanding the use of this table correctly, but I thought it was supposed to show active student groups? Why is it showing me an inactive student group for this student? I am expecting a simple answer but I couldn't seem to find anything to