Haugen Expiration Job

Every month Haugen sends us a list of users whose course has expired and in order to ensure they no longer have access to the course, we delete their CourseMill Person External Account record.

The file provided by Haugen should include the Person ID and the Course, although strictly speaking only the Person ID is required, the course simply provides us a means to verify if the course is marked as expired on our end, but this is not necessarily required.

In order to complete the job you’ll do the following steps:

1. Copy the person IDs from the provided Haugen file.
   1. Make sure to concatenate a comma after each Person ID as this will be the hardcoded list of person IDs to pass into the query.
2. Paste the list of Person IDs into the marked section on the Haugen Expired Webusers.sql script
3. Run the Haugen Expired Webusers.sql
4. Copy the output column “OutputID”. This is the Person External Account Id plus a comma so you can use it in the Delete script to ensure only the appropriate records are deleted.
5. Paste the OutputID list into the marked section in the Delete From Person External Accounts.sql script.
6. Run Delete From Person External Accounts.sql
   1. If the number of affected rows is correct, run the commit statement, if not, run the rollback statement and review for problems.
7. Respond to the Haugen email informing the team that the data has been removed from the AHIMA side.