Allow for excused absence exceptions

Owned by Robert Adach, created
Feb 07, 2022
2 min read

The legacy systems allow staff to enter excused absences for up to 12 months after a candidate has registered. Unfortunately, some candidates do not take their exam until late in their registration window and their requested for an excused absense exception is approved outside this 12-month window. IT must alter the existing registration information to allow CSC to enter the excused absence, and then restore the data.

Prerequisites

  1. ACTNO that the excused absence will be applied to

  2. Access to the ASWBSQL2\ASWBSQL2\ASWB database

 Instructions

Allowing the excused absence to be added

  1. Connect to the database through SSMS

  2. Update the following script, replacing the <ACTNO> placeholder with the ACTNO provided by CSC and run the following script to confirm that the ACTNO provided is valid

  3. SELECT ACTNO, Registration Date, RegistrationExpirationDate FROM tblExam WHERE ACTNO = <ACTNO>

  4. Make note of the Registration Date value returned in the previous step within an Internal Note in Jira

  5. Update the following script, replacing the <NewRegistrationDate> placeholder, with a date within the last 11 months, and the ACTNO. Then execute the script

  6. DECLARE @ACTNO INT = <ACTNO> DECLARE @RegistrationDate = <NewRegistrationDate> UPDATE tblExam SET RegistrationDate = @RegistrationDate WHERE ACTNO = @ACTNO

  7. Inform CSC that

    1. “The registration date has been updated. Please process the excused absence and let us know when it has been completed so that we may restore the information on the ACTNO provided.

It is easiest to immediately update the script below with the original values and copy/paste the script as an internal note in Jira to make reversion of the changes easier.

Reverting changes

  1. Update the following script, replacing the <RegistrationDate> placeholder, with the original date stored in step 4 of the process above, and then execute the script

  2. DECLARE @ACTNO INT = <ACTNO> DECLARE @RegistrationDate = <RegistrationDate> UPDATE tblExam SET RegistrationDate = @RegistrationDate WHERE ACTNO = @ACTNO

 Related articles