Start a new topic

Query to Identify students with IEPs?

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.  


Thanks!


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.

Thank you!  That was exactly what I needed!  CSE.LI is perfect!  Thank you!

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

Login to post a comment