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 # " "
Nick Laskowski
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!