Skip to content

Instantly share code, notes, and snippets.

@lgstianwen
lgstianwen / ESE
Last active August 29, 2015 14:06
Special needs code
id code name
C OI Orthopedically Impaired
F SI Speech Impaired
G LI Language Impaired
H DHH Deaf or Hard of Hearing
I VI Vi
J E/BD Emotional/Behavioral Disability
K SLD Specific Learning Disability
L L Gifted
@lgstianwen
lgstianwen / Qualified Student
Last active August 29, 2015 14:06
ACR Rule ID = 317
GradeLevel equals '09' AND
Magnet doesn not equal 'IB' AND
PrimExceptCode does not equal 'P' AND
PrimExceptCode doesn not equal 'J' AND
PrimExceptCode doesn not equal 'W' AND
FCATMathScore greater than '0' AND
FCATMathScore less than or equal to '0225';
SELECT DISTINCT magnet.student_id
FROM student_attribute as magnet