Wabash College: Technology

Help Desk

Knowledge Base - How to find students coded "A" on ARAC but are not pre/registered

by Alice Moore

01/11/2006 (Software)

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
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