Hello - Does anyone have suggestions for a quick query that identifies if a student has an IEP (of any type) or not? Ideally this would be something like
LIST STU [other tables] ID NM GR [field which signifies IEP or not]
I realize this may vary some based on how a district's SpEd data is managed (ours is imported through SIRAS), but I'm happy to hear some default/stock Aeries answers to know how the system is "supposed" to behave.
I used to run this query to find the date of the last IEP
LIST STU CSE STU.ID STU.LN STU.FN STU.GR CSE.LI IF CSE.LI # " "
Thank you! That was exactly what I needed! CSE.LI is perfect! Thank you!
I would add the CSE.ED and CSE.XD to see who has exited the Special Ed program.
LIST STU CSE STU.ID STU.LN STU.FN STU.GR CSE.LI CSE.ED CSE.XD IF CSE.LI # " "
Even though a child is no longer receiving special education services, the SPED record exists and the exit date will be needed in the query to know who these kids are.