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