group and local entity subject should be handled correctly in grouper_members table

I think we are having a problem with the subject source for groups where the subject_identifier0 is not getting populated.  Is that because usdu doesnt run on groups?  Not that that is the answer, but maybe it might help some things?  Thoughts?

Groups that exist, and are in the members table, but the subject_identifier0 is not populated

select * from grouper_members gm where subject_source = 'g:gsa' and subject_identifier0 is null 

and exists (select 1 from grouper_groups gg where gm.subject_id = gg.id)

2. Groups that exist, and are in the members table, but the subject_identifier0 is not correct

select * from grouper_members gm where subject_source = 'g:gsa' and subject_identifier0 is not null 

and not exists (select 1 from grouper_groups gg where gm.subject_id = gg.id and gg.name = gm.subject_identifier0)

and exists (select 1 from grouper_groups gg where gm.subject_id = gg.id);

3. grouper_members entries for groups that have the same subject_identifer0 (note: I dont see any of these at Penn, but heres the query)

select * from grouper_members gm where subject_source = 'g:gsa' and gm.subject_identifier0 is not null 

and exists (select 1 from grouper_members gm2 where gm2.subject_source = 'g:gsa' and gm.id != gm2.id and gm.subject_identifier0 = gm2.subject_identifier0 );

4. groups which are in members table, where the group is deleted, but the members entry is still listed as resolvable

select * from grouper_members gm where subject_source = 'g:gsa' and subject_resolution_resolvable = 'T'

and not exists (select 1 from grouper_groups gg where gg.id = gm.subject_id);