View to be used as the holding place for the Exchange Visitor add site of activity block in the map for the XML file sent to SEVIS
Implementation/DBA Data:
Not implemented in this database
View Text
SELECT DISTINCT PERS.BATCH_ID BATCH_ID , PERS.PERSON_ID PERSON_ID FROM IGS_SV_PERSONS PERS WHERE PERS.RECORD_STATUS = 'N' AND EXISTS ( SELECT 1 FROM IGS_SV_BTCH_SUMMARY SOASUMM WHERE SOASUMM.PERSON_ID = PERS.PERSON_ID AND SOASUMM.BATCH_ID = PERS.BATCH_ID AND SOASUMM.TAG_CODE = 'SV_SOA' AND SOASUMM.ADM_ACTION_CODE = 'SEND' )