Special Education Table 3 Extract (Pennsylvania)

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.

Screenshot of the Special Education Table 3 Extract editor.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.

Screenshot of the Title and Type fields highlighed on the District Assignment tool.District Assignment Editor - Title and Type

Screenshot of the Title Standards Codes in the Attribute Dictionary.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.

Screenshot of the Employment Type Attribute Dictionary detail.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.

FormatDetermines 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

  1. Select the Table 3 Extract from the Extract Type dropdown.
  2. Enter the desired Effective Date.
  3. Select the Format of the extract.
  4. Click the Generate Extract button or the Submit to Batch button, if available. The extract displays in the selected format.

Screenshot of the Table 3 Extract HTML example.Table 3 Extract - HTML Format

Report Layout

Element NameDescriptionCampus Application
Row 1Provides a count of staff with a Title of Audiologist (code 200)
LEA NumberReports the district number of the school.

Numeric, 9 digits
District Information > State District Number

District.number
Certified StaffCounts 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 StaffCounts 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 2Provides a count of staff with a Title of Speech-Language Pathologist (code 201)
LEA NumberReports the district number of the school.

Numeric, 9 digits
District Information > State District Number

District.number
Certified StaffCounts 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 StaffCounts 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 NumberReports the district number of the school.

Numeric, 9 digits
District Information > State District Number

District.number
Certified StaffCounts 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 StaffCounts 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 NumberReports the district number of the school.

Numeric, 9 digits
District Information > State District Number

District.number
Certified StaffCounts 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 StaffCounts 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 NumberReports the district number of the school.

Numeric, 9 digits
District Information > State District Number

District.number
Certified StaffCounts 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 StaffCounts 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 NumberReports the district number of the school.

Numeric, 9 digits
District Information > State District Number

District.number
Certified StaffCounts 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 StaffCounts 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 NumberReports the district number of the school.

Numeric, 9 digits
District Information > State District Number

District.number
Certified StaffCounts 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 StaffCounts 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 NumberReports the district number of the school.

Numeric, 9 digits
District Information > State District Number

District.number
Certified StaffCounts 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 StaffCounts 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 NumberReports the district number of the school.

Numeric, 9 digits
District Information > State District Number

District.number
Certified StaffCounts 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 StaffCounts 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 NumberReports the district number of the school.

Numeric, 9 digits
District Information > State District Number

District.number
Certified StaffCounts 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 StaffCounts 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 NumberReports the district number of the school.

Numeric, 9 digits
District Information > State District Number

District.number
Certified StaffCounts 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 StaffCounts 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