Disable user accounts for contacts of inactive students

When students become inactive in Aspen, their contacts remain active until you manually disable them. To easily disable user accounts for contacts associated with inactive students, you can run a query a request to find a group of records that match specific criteria at a particular time that removes inactive contacts.

To create a query to remove inactive contacts:

1. Log on to the District or Intermediate Organization view.
2. Select Admin > Users.
3. Select Options > Query.
4. Click the top-right drop-down to select Direct SQL Mode.

5. 

5. Under SELECT * FROM USER_INFO, copy and paste the following advanced query in the field:
   6. WHERE USR_PSN_OID IN (
   7. SELECT CNT_PSN_OID
   8. FROM CONTACT
   9. WHERE CNT_OID IN (
   10. SELECT CTJ_CNT_OID
   11. FROM STUDENT_CONTACT
   12. WHERE CTJ_STD_OID IN (
   13. SELECT STD_OID
   14. FROM STUDENT
   15. WHERE STD_SKL_OID NOT IN ('SKL00000000001', 'SKL00000000002', 'SKL00000000003', 'SKL00000000004', 'SKL00000000005', 'SKL00000015HA7', 'SKL0000002TyeP')
   16. )
   17. )
   18. AND CNT_OID NOT IN (
   19. SELECT CTJ_CNT_OID
   20. FROM STUDENT_CONTACT
   21. WHERE CTJ_STD_OID IN (
   22. SELECT STD_OID
   23. FROM STUDENT
   24. WHERE STD_SKL_OID IN ('SKL00000000001', 'SKL00000000002', 'SKL00000000003', 'SKL00000000004', 'SKL00000000005', 'SKL00000015HA7', 'SKL0000002TyeP')
   25. )
   26. )
   27. )
6. Click the Search based on drop-down to select All Records.
7. Click Save As.
8. In the Save As pop-up, enter a name for the query.
9. Click Save.
10. Click Search. The query can now be run from the Student tab.