International Software Forum

Create a way to mass update client records (complete I-20 program record, Archive OPT) using a list of SEVIS IDs.
One possible solution: use a custom report with the list of IDs being copied in to a search field.

Hi Bryant,
Here's a method I developed. Before you run the script on your server, MAKE SURE YOU RUN IT ON THE TEST SERVER FIRST. Check to make sure it worked. Then when you're comfortable you can run it on the production server.
1. Isolate the records that were completed for a change of status approved
2. Export these SEVIS numbers
---a. Convert into a text list with each number in single quotes and separated by a comma
---b. ‘sevis1’, ‘sevis2’, ‘sevis3’…
3. In sunapsis, check the alerts F-1 Multiple Active SEVIS Programs and J-1 Multiple Active SEVIS Programs
---a. Resolve these alerts before continuing
4. In SQL Server, run the scripts
UPDATE sevisI20Program
SET status = 'C'
WHERE sevisid IN ('list', 'of', 'sevis', 'ids')
AND status = 'A'

UPDATE sevisI20OPT
SET status = 'ARCHIVED'
WHERE sevisid IN ('sevis nums')
AND status = 'APPROVED'
AND completionType = 03

UPDATE sevisI20OPT
SET status = 'ARCHIVED'
WHERE sevisid IN ('sevis nums')
AND status = 'PENDING'
AND completionType = 03

5. Email the students to let them know that their records have been completed.

What the scripts do is look at all the students in the list of SEVIS numbers, and if they have an active I-20 with that number, it changes the status to completed. Same for the OPT parts, except it goes from Approved or Pending to Archived.