Special Education Table 1 Extract (Pennsylvania)

Classic View: PA State Reporting > Special Education Extracts > Table 1 Extract 

Search Terms: Special Education Extracts

Table 1 Extract reports the number (FTE) of special education teachers and paraprofessionals (in FTE) employed or contracted to work with children with disabilities, ages 3-5 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 1 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 Paraprofessionals, ages 3-5 . This information is found on the Census > People > District Assignment editor.

  • The Title must be set to 114: Grades 3-5 Special Ed Para or 144: Elementary Special Ed Teacher in the Title's Attribute Dictionary Standard Code column.
  • 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

Attribute Dictionary Detail for Employment Title

When the Staff Title Standard Code = 114 or 144, 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 1 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 1 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.

Table 1 Extract - HTML Format

Report Layout

Element NameDescriptionLocation
Row 1Provides a count of staff with a Title of Special Education Paraprofessionals for Ages 3-5 (code 144)
LEA NumberReports the district number of the school.

Numeric, 9 digits
System Administration > Resources > 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 Special Education Paraprofessionals for ages 3-5, with a Standard Code of 144. The Assignment End Date is not populated or on or after the entered Effective Date.

Numeric, 3 digits

Census > People > District Assignment > Type = 01


Census > People > District Assignment > Title =  Special Ed Para Ages 3-5 (144)


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 Special Education Paraprofessionals for ages 3-5, with a Standard Code of 144. The Assignment End Date is not populated or on or after the entered Effective Date.

Numeric, 3 digits

Census > People > District Assignment > Type <> 01


Census > People > District Assignment > Title =  Special Ed Para Ages 3-5 (144)


EmploymentAssignment.type

Row 2Provides a count of staff with a Title of Special Education Teachers for Ages 3-5 (code 114)
LEA NumberReports the district number of the school.

Numeric, 9 digits
System Administration > Resources > 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 Special Education Teachers for ages 3-5, with a Standard Code of 114. The Assignment End Date is not populated or on or after the entered Effective Date.

Numeric, 3 digits

Census > People > District Assignment > Type = 01


Census > People > District Assignment > Title = Special Ed Teacher Ages 3-5 (114)


Employment Assignment.type

Not Certified StaffCounts the total number of staff assigned a District Assignment type that that has a Standard Code value that is not 01 and assigned a Title of Special Education Teachers for ages 3-5, with a Standard Code of 114. The Assignment End Date is not populated or on or after the entered Effective Date.

Numeric, 3 digits

Census > People > District Assignment > Type <> 01


Census > People > District Assignment > Title = Special Ed Teacher Ages 3-5 (114)


EmploymentAssignment.type