This is a collection of queries related to Special Education and Related that have been obtained from various sources. These queries are being provided here for the convenience of our customers. The results of each query should be verified for accuracy and carefully considered before using.

List Queries

List of students with an Active Special Education Record

Provides a list of Students, Grade, Teacher, Disability, Special Education Entry Date for students with an active IEP

LIST STU TCH IDN CSE STU.ID STU.NM STU.GR TCH.TE CSE.DI CSE.ED CSE.XD IF CSE.DI > 0 AND CSE.XD = NULL

List of 504 students with Meeting Type and Effective Date with a blank Leave Date

Provides a list of 504 Students, Grade, MeetingType, Effective Date when the Leave Date is blank

LIST STU FOF STU.ID STU.NM STU.GR FOF.MT FOF.SD FOF.ED IF FOF.SD # NULL AND FOF.ED = NULL

List of 504 students with Next Review Date

Displays a list of Students, Grade, 504 Start Date, 504 Meeting Date, 504 Review Date for active 504 Students

LIST STU FOF STU.ID STU.NM STU.GR FOF.SD FOF.MD FOF.RD IF FOF.SD # NULL AND FOF.ED = NULL

List of 504 Student Accommodations by Student

Displays a list of Students, Grade, Accommodation Code, Accommodation Description, Accommodation Details for active 504 Students

LIST STU FOF FAP STU.ID STU.NM STU.GR FAP.CD FAP.CD? FAP.AC IF FOF.SD # NULL AND FOF.ED = NULL