|Knowledge Base - How to find students coded "A" on ARAC but are not pre/registered|
|by Alice Moore|
To find students that are coded "Active" on ARAC but are not registered/pre-registerd for term specified in selection (change the term to meet your needs):
SELECT PERSON.AR WITH PAR.MISC1 LIKE A... SAVING UNIQUE @ID
SELECT STUDENTS WITH EVERY W04.STU.TERMSTAT NE '06/SP*P'
SELECT STUDENTS WITH EVERY W04.STU.TERMSTAT NE '06/SP*R'
LIST STUDENTS STU.NAME STU.CLASS BY STU.LAST.NAME