Mass SEVIS adjudication method

Discuss your wish list items. Someone might have an alternate solution or you can get others to help support your cause.
Post Reply
Bryant
Posts: 28
Joined: Mon Nov 04, 2019 12:21 am

Mass SEVIS adjudication method

Post by Bryant »

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.

LeoC
Posts: 2
Joined: Tue Jun 30, 2020 3:13 am

Re: Mass SEVIS adjudication method

Post by LeoC »

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.

Post Reply