Support

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!

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

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.