Page History

select GPG.NAME, GPF.NAME, GPG_MEMBER.NAME, GPMAV.MEMBERSHIP_START_TIME, gpmav.membership_end_time
from 
  grouper_pit_groups gpg_member,
  GROUPER_PIT_MEMBERSHIPS_ALL_V gpmav,
  grouper_pit_members gpm,
  grouper_pit_fields gpf,
  grouper_pit_groups gpg
where 
  GPMAV.MEMBER_ID = GPM.ID
  and gpf.name = 'members'
  and GPM.subject_source = 'g:gsa'
  and GPM.SUBJECT_ID = GPG_MEMBER.source_ID
  and GPG_member.NAME like 'penn:community:employee:org%'
  and GPMAV.OWNER_GROUP_ID = GPG.ID
  and GPG.NAME not like 'penn:community:employee%'
  and GPMAV.FIELD_ID = GPF.ID
  and (GPMAV.MEMBERSHIP_START_TIME is null or GPMAV.MEMBERSHIP_START_TIME < 1364270400000000)
  and (gpmav.membership_end_time is null or gpmav.membership_end_time > 1364270400000000 )

select GPG.NAME, GPF.NAME, GPM.SUBJECT_ID
from 
  GROUPER_PIT_MEMBERSHIPS_ALL_V gpmav,
  grouper_pit_fields gpf,
  grouper_pit_groups gpg,
  grouper_pit_members gpm
where 
  GPM.subject_source != 'g:gsa'
  and GPMAV.MEMBER_ID = GPM.ID
  and GPM.SUBJECT_ID not in ('10094590', '10037375', '10033223')
  and GPG.NAME like 'penn:community:employee:org:TOPU%'
  and gpg.name not like '%_rolluporg_systemOfRecordAndIncludes'
  and gpg.name not like '%systemOfRecord'
  and gpg.name not like '%_personorg'
  and gpg.name not like '%_rolluporg'
  and GPMAV.OWNER_GROUP_ID = GPG.ID
  and gpf.name = 'members'
  and GPMAV.FIELD_ID = GPF.ID
  and (GPMAV.MEMBERSHIP_START_TIME is null or GPMAV.MEMBERSHIP_START_TIME < 1364270400000000)
  and (gpmav.membership_end_time is null or gpmav.membership_end_time > 1364270400000000 )

  ;