Deleting ASWBCentral applications

The ASWBCentral desktop system will only allow staff to delete an application if the payment has not yet been collected. As of April 1st, 2022, this is easily determined by the application status. Those applications in Not Submitted, Submitted or Payment Hold can be deleted by the staff. All others must be performed by IT.

 Instructions

1. Access the ASWBCentral database using SSMS

2. Copy and paste the following script into SSMS,

3. Update the script with the Application number provided by the team

4. Ensure the @Continue variable is set to 0 (zero) and run the script

5. If there is a result returned and

   1. the payment column value is “Yes”, go to step 7

   2. the payment column value is “No”, go to step 9

6. If there is no result returned:

   1. Set the Jira ticket to Pending status and reply to the requester with “We are unable to find an application with the ID number provided. Can you please provide the correct application number, or let us know if we should close this ticket?”

7. Update the @Continue variable in the script to 1 (one)

8. Run the script to delete the payment information from the application, and update the status so the application can be deleted by the desktop application

9. Open the ASWBCentral - Prod desktop system

10. Click on Utilities - Abort application

11. Locate the application on the list of applications shown

12. Double-click on the application to select it

13. Click “OK” to the confirmation box.

14. Once the system confirms the application has been deleted, close the Jira ticket and respond with “The application has been deleted as requested”.

 Related articles