Tool Search: Special Education Extracts
Table 3 Extract reports the number of related service personnel (in FTE) employed or contracted to work with children with disabilities, ages 3-21 by LEA across the entire district. Staff who have the same assignment in multiple schools are counted with each assignment; Staff who have different assignments in the same school or different schools are counted with each assignment.
Special Education Table 3 Extract
Report Logic
The report looks at the staff person's District Assignment Title and the District Assignment Type to return a count of Certified and Non-certificate Special Education Teachers, ages 6-21. This information is found on the District Assignment editor.
The Title needs to be set to the following in the Title's Attribute Dictionary Standard Code column. See the Report Layout below for the specific row in which each title reports.
- 200: Audiologist
- 201: Speech-Language Pathologists
- 202: Interpreter
- 203: Psychologist
- 204: Occupational Therapists
- 205: Physical Therapists
- 206: Physical Education Teacher and Therapeutic Recreation Specialists
- 207: Social Workers
- 208: Medical/Nursing Service Staff
- 209: Counselors and Rehabilitation Counselors
- 210: Orientation and Mobility Specialists
The Type can be 01: Administrative, 02: Certified, or 03: Classified. The report counts each one of these types.
The End Date field needs to be unpopulated, meaning the staff person's assignment is active and current, or the End Date can be on or after the entered Effective Date on the report editor.
District Assignment Editor - Title and Type
District Assignment Title Standard Codes
When the Staff Title Standard Code = 200 through 210, logic looks at the dictionary detail Employment Type Standard Code for a value of 01 to determine the qualified/certified staff (see image above) count. When the staff's type standard code does not = 01, staff are included in the non qualified/certified count.
Attribute Dictionary Detail for Employment Type
Report Editor
Field | Description |
|---|---|
Extract Type | Determines the type of Extract being generated. For this extract, select Table 3 Extract. |
Effective Date | Indicates the date to use to determine active district assignment information. |
| Format | Determines how the extract generates. Extracts can be generated in State Format (comma delimited) or HTML. Use the HTML format for reviewing and verifying data prior to submission to the state. Use the State Format for submitting the data to the Department of Education. |
| Report Generation | To generate the report immediately, use the Generate Extract option. To choose when the report generates, use the Submit to Batch option. Submit to Batch is useful when generating the report for several calendars or for larger amounts of data being reported. See the Batch Queue article for more information. |
Generate the Report
- Select the Table 3 Extract from the Extract Type dropdown.
- Enter the desired Effective Date.
- Select the Format of the extract.
- Click the Generate Extract button or the Submit to Batch button, if available. The extract displays in the selected format.
Table 3 Extract - HTML Format
Report Layout
| Element Name | Description | Campus Application |
|---|---|---|
| Row 1 | Provides a count of staff with a Title of Audiologist (code 200) | |
| LEA Number | Reports the district number of the school. Numeric, 9 digits | District Information > State District Number District.number |
| Certified Staff | Counts the total number of staff assigned a District Assignment type that has a Standard Code value of 01 and assigned a Title of Audiologist with a Standard Code of 200. The Assignment End Date is not populated or on or after the entered Effective Date. Numeric, 3 digits | District Assignment > Type = 01 District Assignment > Title = Audiologist (200) EmploymentAssignment.type |
| Not Certified Staff | Counts the total number of staff assigned a District Assignment type that has a Standard Code value that is not 01 and assigned a Title of Audiologist with a Standard Code of 200. The Assignment End Date is not populated or on or after the entered Effective Date. Numeric, 3 digits | District Assignment > Type <> 01 District Assignment > Title = Audiologist (200) EmploymentAssignment.type |
| Row 2 | Provides a count of staff with a Title of Speech-Language Pathologist (code 201) | |
| LEA Number | Reports the district number of the school. Numeric, 9 digits | District Information > State District Number District.number |
| Certified Staff | Counts the total number of staff assigned a District Assignment type that has a Standard Code value of 01 and assigned a Title of Speech-Language Pathologist with a Standard Code of 201. The Assignment End Date is not populated or on or after the entered Effective Date. Numeric, 3 digits | District Assignment > Type = 01 District Assignment > Title = Speech-Language Pathologist (code 201) EmploymentAssignment.type |
| Not Certified Staff | Counts the total number of staff assigned a District Assignment type that has a Standard Code value that is not 01 and assigned a Title of Speech-Language Pathologist with a Standard Code of 201. The Assignment End Date is not populated or on or after the entered Effective Date. Numeric, 3 digits | District Assignment > Type <> 01 District Assignment > Title = Speech-Language Pathologist (code 201) Employment Assignment.type |
| Row 3 | Provides a count of staff with a Title of Interpreter (code 202) | |
| LEA Number | Reports the district number of the school. Numeric, 9 digits | District Information > State District Number District.number |
| Certified Staff | Counts the total number of staff assigned a District Assignment type that has a Standard Code value of 01 and assigned a Title of Interpreter with a Standard Code of 202. The Assignment End Date is not populated or on or after the entered Effective Date. Numeric, 3 digits | District Assignment > Type = 01 District Assignment > Title = Interpreter (code 202) EmploymentAssignment.type |
| Not Certified Staff | Counts the total number of staff assigned a District Assignment type that has a Standard Code value that is not 01 and assigned a Title of Interpreter with a Standard Code of 202. The Assignment End Date is not populated or on or after the entered Effective Date. Numeric, 3 digits | District Assignment > Type <> 01 District Assignment > Title = Interpreter (code 202) EmploymentAssignment.type |
| Row 4 | Provides a count of staff with a Title of Psychologist (code 203) | |
| LEA Number | Reports the district number of the school. Numeric, 9 digits | District Information > State District Number District.number |
| Certified Staff | Counts the total number of staff assigned a District Assignment type that has a Standard Code value of 01 and assigned a Title of Psychologist with a Standard Code of 203. The Assignment End Date is not populated or on or after the entered Effective Date. Numeric, 3 digits | District Assignment > Type = 01 District Assignment > Title = Psychologist (code 203) EmploymentAssignment.type |
| Not Certified Staff | Counts the total number of staff assigned a District Assignment type that has a Standard Code value that is not 01 and assigned a Title of Psychologist with a Standard Code of 203. The Assignment End Date is not populated or on or after the entered Effective Date. Numeric, 3 digits | District Assignment > Type <> 01 District Assignment > Title = Psychologist (code 203) EmploymentAssignment.type |
| Row 5 | Provides a count of staff with a Title of Occupational Therapists (code 204) | |
| LEA Number | Reports the district number of the school. Numeric, 9 digits | District Information > State District Number District.number |
| Certified Staff | Counts the total number of staff assigned a District Assignment type that has a Standard Code value of 01 and assigned a Title of Occupational Therapist with a Standard Code of 204. The Assignment End Date is not populated or on or after the entered Effective Date. Numeric, 3 digits | District Assignment > Type = 01 District Assignment > Title = Occupational Therapist (code 204) EmploymentAssignment.type |
| Not Certified Staff | Counts the total number of staff assigned a District Assignment type that has a Standard Code value that is not 01 and assigned a Title of Occupational Therapist with a Standard Code of 204. The Assignment End Date is not populated or on or after the entered Effective Date. Numeric, 3 digits | District Assignment > Type <> 01 District Assignment > Title = Occupational Therapist (code 204) EmploymentAssignment.type |
| Row 6 | Provides a count of staff with a Title of Physical Therapist (code 205) | |
| LEA Number | Reports the district number of the school. Numeric, 9 digits | District Information > State District Number District.number |
| Certified Staff | Counts the total number of staff assigned a District Assignment type that has a Standard Code value of 01 and assigned a Title of Physical Therapist with a Standard Code of 205. The Assignment End Date is not populated or on or after the entered Effective Date. Numeric, 3 digits | District Assignment > Type = 01 District Assignment > Title = Physical Therapist (code 205) EmploymentAssignment.type |
| Not Certified Staff | Counts the total number of staff assigned a District Assignment type that has a Standard Code value that is not 01 and assigned a Title of Physical Therapist with a Standard Code of 205. The Assignment End Date is not populated or on or after the entered Effective Date. Numeric, 3 digits | District Assignment > Type District Assignment > Title = Physical Therapist (code 205) EmploymentAssignment.type |
| Row 7 | Provides a count of staff with a Title of Physical Education Teacher and Recreation and Therapeutic Recreation Specialist (code 206) | |
| LEA Number | Reports the district number of the school. Numeric, 9 digits | District Information > State District Number District.number |
| Certified Staff | Counts the total number of staff assigned a District Assignment type that has a Standard Code value of 01 and assigned a Title of Physical Education Teacher and Recreation and Therapeutic Recreation Specialist with a Standard Code of 206. The Assignment End Date is not populated or on or after the entered Effective Date. Numeric, 3 digits | District Assignment > Type = 01 District Assignment > Title = Physical Education Teacher and Recreation and Therapeutic Recreation Specialist (code 206) EmploymentAssignment.type |
| Not Certified Staff | Counts the total number of staff assigned a District Assignment type that has a Standard Code value that is not 01 and assigned a Title of Physical Education Teacher and Recreation and Therapeutic Recreation Specialist with a Standard Code of 206. The Assignment End Date is not populated or on or after the entered Effective Date. Numeric, 3 digits | District Assignment > Type <> 01 District Assignment > Title = Physical Education Teacher and Recreation and Therapeutic Recreation Specialist (code 206) EmploymentAssignment.type |
| Row 8 | Provides a count of staff with a Title of Social Worker (code 207) | |
| LEA Number | Reports the district number of the school. Numeric, 9 digits | District Information > State District Number District.number |
| Certified Staff | Counts the total number of staff assigned a District Assignment type that has a Standard Code value of 01 and assigned a Title of Social Worker with a Standard Code of 207. The Assignment End Date is not populated or on or after the entered Effective Date. Numeric, 3 digits | District Assignment > Type District Assignment > Title = Social Worker (code 207) EmploymentAssignment.type |
| Not Certified Staff | Counts the total number of staff assigned a District Assignment type that has a Standard Code value that is not 01 and assigned a Title of Social Worker with a Standard Code of 207. The Assignment End Date is not populated or on or after the entered Effective Date. Numeric, 3 digits | District Assignment > Type <> 01 District Assignment > Title = Social Worker (code 207) EmploymentAssignment.type |
| Row 9 | Provides a count of staff with a Title of Medical/Nursing Service Staff (code 208) | |
| LEA Number | Reports the district number of the school. Numeric, 9 digits | District Information > State District Number District.number |
| Certified Staff | Counts the total number of staff assigned a District Assignment type that has a Standard Code value of 01 and assigned a Title of Medical/Nursing Service Staff with a Standard Code of 208. The Assignment End Date is not populated or on or after the entered Effective Date. Numeric, 3 digits | District Assignment > Type = 01 District Assignment > Title = Medical/Nursing Service Staff (code 208) EmploymentAssignment.type |
| Not Certified Staff | Counts the total number of staff assigned a District Assignment type that has a Standard Code value that is not 01 and assigned a Title of Medical/Nursing Service Staff with a Standard Code of 208. The Assignment End Date is not populated or on or after the entered Effective Date. Numeric, 3 digits | District Assignment > Type <> 01 District Assignment > Title = Medical/Nursing Service Staff (code 208) EmploymentAssignment.type |
| Row 10 | Provides a count of staff with a Title of Counselors and Rehabilitation Counselors (code 209) | |
| LEA Number | Reports the district number of the school. Numeric, 9 digits | District Information > State District Number District.number |
| Certified Staff | Counts the total number of staff assigned a District Assignment type that has a Standard Code value of 01 and assigned a Title of Counselors and Rehabilitation Counselors with a Standard Code of 209. The Assignment End Date is not populated or on or after the entered Effective Date. Numeric, 3 digits | District Assignment > Type = 01 District Assignment > Title = Counselors and Rehabilitation Counselors (code 209) EmploymentAssignment.type |
| Not Certified Staff | Counts the total number of staff assigned a District Assignment type that has a Standard Code value that is not 01 and assigned a Title of Counselors and Rehabilitation Counselors with a Standard Code of 209. The Assignment End Date is not populated or on or after the entered Effective Date. Numeric, 3 digits | District Assignment > Type <> 01 District Assignment > Title = Counselors and Rehabilitation Counselors (code 209) EmploymentAssignment.type |
| Row 11 | Provides a count of staff with a Title of Orientation and Mobility Specialists (code 210) | |
| LEA Number | Reports the district number of the school. Numeric, 9 digits | District Information > State District Number District.number |
| Certified Staff | Counts the total number of staff assigned a District Assignment type that has a Standard Code value of 01 and assigned a Title of Orientation and Mobility Specialists with a Standard Code with a code of 210. The Assignment End Date is not populated or on or after the entered Effective Date. Numeric, 3 digits | District Assignment > Type = 01 District Assignment > Title = Orientation and Mobility Specialists (code 210) EmploymentAssignment.type |
| Not Certified Staff | Counts the total number of staff assigned a District Assignment type that has a Standard Code value that is not 01 and assigned a Title of Counselors and Rehabilitation Counselors with a Standard Code of 210. The Assignment End Date is not populated or on or after the entered Effective Date. Numeric, 3 digits | District Assignment > Type <> 01 District Assignment > Title = Orientation and Mobility Specialists (code 210) EmploymentAssignment.type |
