Student Groups

I am newer to PS and I am trying to find out how to find active student groups for a student. The table I initially was using until I realized the table logic was PS_STDNT_GRPS. My issue is that I did not realize all entries in this table are NOT just active groups, they are just records associated with the student. I am pulling up students marked as 'dual credit' in the PS_STDNT_GRPS table, but finding out they are no longer part of the group once I find the corresponding 'inactive' record for said group on the PS_STDNT_GRPS_HIST table. How