To query all tagged SPED (Special Education) students currently in the system, one of the following methods can be used:
Method 1: Using the CSE Table:
- This query lists students (STU) with their school code (SC), student ID (ID), name (NM), grade (GR), and disability indicator (DI) from the CSE table.
- The condition
CSE.DI > 0 AND CSE.XD = NULL
ensures that only students with a disability indicator greater than 0 and no exit date are included.
LIST STU CSE STU.SC STU.ID STU.NM STU.GR CSE.DI IF CSE.DI > 0 AND CSE.XD = NULL
Method 2: Using the Extended Fields
- This query lists students (STU) with their school code (SC), student ID (ID), name (NM), grade (GR), and special education status (SPECIALED).
- The condition
SPECIALED = YES
ensures that only students tagged as special education in the Extended Field are included.
LIST STU SC ID NM GR SPECIALED IF SPECIALED = YES