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

This is a great thread. Thank you to everyone for contributing. I added a few elements as well that I hope you find helpful. I work at a multi school district and added elements to account for multiple locations, meeting dates, and disability codes/descriptions. 


General Student info Entry Date, Last IEP, Ann-Date, Tri-Date, Exit Date


LIST STU CSE LOC STU.SC LOC.NM STU.ID STU.CID STU.LN STU.FN STU.GR CSE.ED CSE.LI CSE.AD CSE.TA CSE.XD IF CSE.LI # " " 

 

Disability 1, 2, and 3 by code with Entry Date, Last IEP, Annual Date, Tri-Date, and Exit date


LIST STU CSE LOC STU.SC LOC.NM STU.ID STU.CID STU.LN STU.FN STU.GR CSE.DI CSE.DI2 CSE.DI3 CSE.ED CSE.LI CSE.AD CSE.TA CSE.XD IF CSE.LI # " " 

 

Disability 1, 2, and 3 by code with Entry Date, Last IEP, Annual Date, Tri-Date, Exit date, and disability code descriptions


LIST STU CSE LOC STU.SC LOC.NM STU.ID STU.CID STU.LN STU.FN STU.GR CSE.DI CSE.DI? CSE.DI2 CSE.DI2? CSE.DI3 CSE.DI3? CSE.ED CSE.LI CSE.AD CSE.TA CSE.XD IF CSE.LI # " " 

Login to post a comment