Removing “Ready for Resubmission” from Greenrain Messenger

Step 1: You will receive the list of Claim ID’s from the customer in the email or MS Teams.

GHIP2000840 - NEURON-JAN2022-IP-1 – 1

GHIP2000842 - NEURON-JAN2022-IP-1 – 2

GHIP2000893 - NEURON-JAN2022-IP-1 – 5

GHIP2000872 - NEURON IP JAN 2022 4 – 4

GHIP2000874 - NEURON IP JAN 2022 5 – 2

GHIP2000910 - NEURON IP JAN 2022 13 – 2

GHIP2000953 - NEURON IP JAN 2022 14 – 1

GHIP2000961 - NEURON IP JAN 2022 14 – 2

GHIP2000906 - NEURON IP JAN 2022 16 – 1

Step 2: Create a SQL Update command using all the claim ID’s as below:

Update O_Claim set Status = 8 where ID IN (‘GHIP2000840 - NEURON-JAN2022-IP-1 – 1’,’ GHIP2000842 - NEURON-JAN2022-IP-1 – 2’,’GHIP2000893 - NEURON-JAN2022-IP-1 – 5’,’ GHIP2000872 - NEURON IP JAN 2022 4 – 4’,’GHIP2000874 - NEURON IP JAN 2022 5 – 2’,’ GHIP2000910 - NEURON IP JAN 2022 13 – 2’,’GHIP2000953 - NEURON IP JAN 2022 14 – 1’,’ GHIP2000961 - NEURON IP JAN 2022 14 – 2’,’GHIP2000906 - NEURON IP JAN 2022 16 – 1’)

Here in this example, we have Status = 8, updates the claim status and it will be removed from the database.

Step 3: Connect to customer via anydesk and then connect to the Greenrain database via SQL Server Management Studio (SSMS).

Step 4: When prompted, select windows authentication to connect to the database.

Step 5: From the left menu of the database, expand Facility Database and then select the O_Claim table.

Step 6: From the top, click “New Query”, and paste the query created above.

Step 7: Click “Execute” from the top menu bar. You will see a message at the bottom with a message as “9 rows updated successfully”.

NOTE: Here the number of rows depends on the number of claim ID’s sent by the customer or the number of claim ID’s in the query.

Step 8: Inform the customer to check this in Greenrain Messenger with the filter as “Ready for Submission”.

They should see as a message “No matching records found”.