S_AL_SpecEdPersonnel_S (ver 20.8.2.0)
This stand-alone table is used for reporting PowerSchool Special Programs data to the state ODS.
| Column Name | Version | Data Type | Description |
|---|---|---|---|
| ApprovalDate | 20.8.2.0 | Date | SnapShot Approval date |
| Audiologists | 20.8.2.0 | Number(11,0) | Audiologists |
| CounselorsRehab | 20.8.2.0 | Number(11,0) | Counselors / Rehab |
| District | 20.8.2.0 | Varchar2(100) | District Name |
| DistrictID | 20.8.2.0 | Varchar2(15) | District number |
| Interpreters | 20.8.2.0 | Number(11,0) | Interpreters |
| MedicalNursing | 20.8.2.0 | Number(11,0) | Medical / Nursing |
| Mobility | 20.8.2.0 | Number(11,0) | Mobility |
| OccupaTherap | 20.8.2.0 | Number(11,0) | Occupational Therapists |
| Orientation | 20.8.2.0 | Number(11,0) | Orientation |
| Para3to5NotQual | 20.8.2.0 | Number(11,0) | Paraprofessionals Ages 3-5 Not Qualified |
| Para3to5Qual | 20.8.2.0 | Number(11,0) | Paraprofessionals Ages 3-5 Qualified |
| Para6to21NotQual | 20.8.2.0 | Number(11,0) | Paraprofessionals Ages 6-21 Not Qualified |
| Para6to21Qual | 20.8.2.0 | Number(11,0) | Paraprofessionals Ages 6-21 Qualified |
| PhysEdRecTeachers | 20.8.2.0 | Number(11,0) | Physical Education / Rec Teachers |
| PhysicalTherap | 20.8.2.0 | Number(11,0) | Physical Therapists |
| ProjectionYear | 20.8.2.0 | Number(11,0) | Projected Special Education Personnel Data year |
| Psychologists | 20.8.2.0 | Number(11,0) | Psychologists |
| SocialWorkers | 20.8.2.0 | Number(11,0) | Social Workers |
| SpEd3to5Cert | 20.8.2.0 | Number(11,0) | Spec Ed Teachers Ages 3-5 who meet the applicable State certification and licensure requirements |
| SpEd3to5NotCert | 20.8.2.0 | Number(11,0) | Spec Ed Teachers Ages 3-5 who do not meet the applicable State certification and licensure requirements |
| SpEd6to21Cert | 20.8.2.0 | Number(11,0) | Spec Ed Teachers Ages 6-21 who meet the applicable State certification and licensure requirements |
| SpEd6to21NotCert | 20.8.2.0 | Number(11,0) | Spec Ed Teachers Ages 6-21 who do not meet the applicable State certification and licensure requirements |
| SpeechLangPath | 20.8.2.0 | Number(11,0) | Speech Language Pathologists |