Special Education Table 9A Extract (Pennsylvania) [.2215 and previous]

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

Search Terms: Special Education Extracts

The Table 9A Extract reports students who have disabilities and are subject to disciplinary removal from July 1 to June 30, by student. This is a count of the following:

  • Unilateral Removal to an Interim Alternative Education Setting by School Personnel
  • Removals to an Interim Alternative Educational Setting Based on a Hearing Officer Determination Regarding Likely Injury
  • Out-of-School Suspensions or Expulsions
  • In-School Suspensions
  • Disciplinary Removals

Special Education Table 9A Extract

Report Logic

In order to be included in the report, students must have a behavior resolution with a State Code of one of the following:

  • S3: In School Suspension
  • S4: Out-of-School suspension
  • S5: Expulsion less than one calendar year
  • S6: Expulsion more than one year
  • S7: Expulsion more than one calendar year
  • S8: Special Ed student removed to interim alternative education setting by school personnel
  • S9: Special Ed student removed to interim alternative education setting by due process hearing officer

The Resolution's number of removal days must be at least .5 of the instructional day minutes to be included. This is recorded in the Duration in School Days field on the Resolution editor. If this field is not populated, the calculation uses the Resolution Start Date to the Resolution End date. If the resolution meets the value of .5 instructional days or more, it is counted as a 1 in the report.

Students must have the following set on their Enrollment Special Ed Editor:

  • Special Ed Status of Y: Yes, has IEP and a Service Exit Date that is blank, on or after the Behavior Incident Date; OR
  • Special Ed Status of E: Exited and a Service Exit Date that is blank, on or after the Behavior Incident Date.

Report Editor

Field

Description

Extract Type

Determines the type of Extract being generated. For this extract, select Table 9A Extract.

Effective DateIndicates 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 Table 9A Extract

  1. Select the Table 9A 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 9a Extract - State Format (CSV) 

Table 9A Extract - HTML Format

Report Layout

Element Name

Description

Location

IU

This value is the same as the second and third digits of the State District Number.


Numeric, 2 digits

System Administration > Resources > School > Alt 

School Number, State School Number


School.altNumber

School.number

District of Resident AUN

Reports the state district number.

Numeric, 9 digits
System Administration > Resources > District Information > State District Number

District.number

PASecure ID

Reports the student's State ID.

Numeric, 9 digits
Census > People > Demographics > Person Information > State ID

Person.stateID

Last Name

Reports the student's last name.

Alphanumeric, 255 characters
Census > People > Demographics > Last Name

Identity.lastName

First Name

Reports the student's first name.

Alphanumeric, 255 characters
Census > People > Demographics > First Name

Identity.firstName

Middle Name

Reports the student's middle name.

Alphanumeric, 30 characters
Census > People > Demographics > Middle Name

Identity.middleName
Birth DateReports the student's date of birth.

Date field, 10 characters (MM/DD/YYYY)


Census > People > Demographics > Birth Date

Identity.birthDate
GenderReports the student's gender.

Alphanumeric, 1 character (M or F)


Census > People > Demographics > Gender

Identity.gender
Ethnic BackgroundReports the student's race/ethnicity.

Numeric, 1 digit
Census > People > Identities > Race/Ethnicity

Identity.raceEthnicity
LEP

Reports the student's EL status as of the date of the behavior incident.

  • Reports 01 when the EL Program Status is EL or Exited EL and the EL exit date is after 10/01 of the calendar year selected and the EL exit date is after the effective date chosen on the report editor.
  • Reports 03 when the EL Status is Exited EL land the EL Exit date is on or before 10/01 of the selected calendar year.
  • Reports 03 when the EL Status is Exited EL and the effective date chosen on the report editor is on or before the 1st Year Monitoring date from the EL detail record.
  • Reports 04 when the EL Status is Exited EL and the effective date chosen on the report editor is after the 1st Year Monitoring Date and on or before 2nd Year Monitoring date from the EL detail record.
  • Reports 05 when the EL Program Exit Date is before 10/01/2014.
  • Reports 05 when the EL Program Exit Date is on or after 10/01/2014 and the Effective Date chosen on the report editor is on or before the 4 year Monitoring Date.
  • Reports 06 when the EL Program Status is EL and SLIFE checkbox is marked.
  • Reports 07 when the EL Program Status is Exited EL and the EL Program Exit Date is on or before the 3rd Year Monitoring Date from the EL Detail Record, but after the 2nd Year Monitoring Date.
  • Reports 08 when the EL Program Status is Exited EL and the EL Program Exit Date and the Effective Date chosen on the report editor is on or before the 4th year Monitoring Date from the EL Detail Record, but after the 3rd year monitoring date  from the EL Detail Record.
  • Reports 99 (default) when there is no EL Record.

Numeric, 2 digits

Student Information > Program Participation > English Learners (EL) > Program Status

LEP.programStatus
GradeReports the student's state grade of enrollment as of the behavior incident date.

Alphanumeric, 3 characters
Student Information > General > Enrollments > Grade

Enrollment.grade
Disability CategoryReports the student's Primary Disability as of the behavior incident date.

Alphanumeric, 3 characters
Student Information > General > Enrollments > Special Ed Fields > Primary Disability

Enrollment.disability
Primary Placement Type

Indicates a student placed in a residential facility or group home in the same state by a non-educational agency.  


Reports a value of Y when the IEP Plan Header field of 'Was this student agency placed?' is marked, or when the Student Status field on the student's enrollment record is R: Court/Agency Placed. 


Otherwise, reports a value of N. 


Alphabetic, 1 character (Y or N)

Student Information > Special Education > Documents > IEP Form > Plan Header > Was this student agency placed? = Y


SEPlan.initiated


Student Information > General > Enrollments > State Reporting Fields > Student Status = R: Court/Agency Placed


Enrollment.studentStatus

Unilateral Removals to an Interim Alternative Educational Setting by School Personnel

Indicates whether the student was removed from the school and placed in another setting.


Reports a value of Y when the assigned Behavior Resolution State Code is S8: Special Ed student removed to interim alt ed setting by school personnel and is within the date range of Effective Date to the first instructional day of the school year.


Otherwise, reports a value of N.


Alphanumeric, 1 character (Y or N)

Behavior > Behavior Management > Events and Participants > Resolution Details > Resolution


Behavior > Admin > Resolution Types > State Resolution Code = S8


BehaviorResolution.stateResCode

Unilateral Removals to an Interim Alternative Educational Setting by School Personnel - Number of Removals for Drugs

Indicates whether the student was removed from the school and placed in another setting due to drugs.


Reports a count for every incident where the student is assigned a Behavior Resolution State Code is S8: Special Ed student removed to interim alt ed setting by school personnel AND the State Event Classification is set to Drugs.


If there is no matching incident, reports a count of 0.


Numeric, 3 digits

Behavior > Behavior Management > Events and Participants > Resolution Details > Resolution


Behavior > Admin > Resolution Types > Behavior Resolution Type Details > State Resolution Code = S8

BehaviorResolution.stateResCode


Behavior > Admin > Event Types > Behavior Event Type Detail > Classification = Drug


BehaviorType.classification


Unilateral Removals to an Interim Alternative Educational Setting by School Personnel - Number of Removals for Weapons

Indicates whether the student was removed from the school and placed in another setting due to weapons.


Reports a a count for every incident where the student is assigned a Behavior Resolution State Code is S8: Special Ed student removed to interim alt ed setting by school personnel AND the State Event Classification is set to Weapon.


If there is no matching incident, reports a count of 0.


Numeric, 3 digits

Behavior > Behavior Management > Events and Participants > Resolution Details > Resolution


Behavior > Admin > Resolution Types > Behavior Resolution Type Details > State Resolution Code = S8


BehaviorResolution.stateResCode


Behavior > Admin > Event Types > Behavior Event Type Detail > Classification = Weapon


BehaviorType. classification

Unilateral Removals to an Interim Alternative Educational Setting by School Personnel - Number of Removals for Serious Bodily Injury

Indicates whether the student was removed from the school and placed in another setting due to serious bodily injury.


Reports a a count for every incident where the student is assigned a Behavior Resolution State Code is S8: Special Ed student removed to interim alt ed setting by school personnel AND the Participant Details Injury value is 4: Serious Bodily Injury.


If there is no matching incident, reports a count of 0.


Numeric, 3 digits

Behavior > Behavior Management > Events and Participants > Resolution Details > Resolution


Behavior > Admin > Resolution Types > Behavior Resolution Type Details > State Resolution Code = S8


BehaviorResolution.stateResCode


Behavior > Behavior Management > Events and Participants > Participant Details > Injury = 4: Serious Bodily Injury


BehaviorEvent.injury

Removals to an Interim Alternative Educational Setting Based on a Hearing Officer Determination Regarding Likely Injury

Indicates whether the student was removed from the school and placed in another setting due to an  injury.


Reports a value of Y when the assigned Behavior Resolution State Code is S8: Special Ed student removed to interim alt ed setting by school personnel AND the Participant Details Injury value is 2: Minor Injury, 3: Major Injury, or 4: Serious Bodily Injury.


Otherwise, reports a value of N.


Alphanumeric, 1 character (Y or N)

Behavior > Behavior Management > Events and Participants > Resolution Details > Resolution


Behavior > Admin > Resolution Types > Behavior Resolution Type Details > State Resolution Code = S8


BehaviorResolution.stateResCode


Behavior > Behavior Management > Events and Participants > Participant Details > Injury = 2: Minor Injury, 3: Major Injury, or 4: Serious Bodily Injury


BehaviorEvent.injury

Out-of-School Suspension Expulsions Totaling 10 Days or Less

Indicates the student was suspended out of school or expelled for 10 or less days. A duration of .5 is equal to 1 day.


Reports a value of Y when the Behavior Resolution Code is mapped to one of the following state codes as of the entered Effective Date on the report editor and the Length of Removal is less than 11 days:

  • S4: Out-of-School Suspension
  • S5: Expulsion - less than one calendar year
  • S6: Expulsion - one calendar year
  • S7: Expulsion - more than one calendar year

This field reports from the Duration in School Days field. If there is no value in that field, a calculation using the Resolution Start Date minus the Resolution End Date is used.


Otherwise, reports a value of N.


When this field reports a value of Y, field 20 must report a value of N.


Alphanumeric, 1 character (Y or N)

Behavior > Admin > Resolution Types > Behavior Resolution Type Details > State Resolution Code = S4, S5, S6 or S7


BehaviorResolution.stateResCode


Behavior > Behavior Management > Events and Participants > Resolution Details > Duration in School Days, Resolution Start Date, Resolution End Date


BehaviorResolution.schoolDaysDuration


Out-of-School Suspension Expulsions Totaling More Than 10 Days

Indicates the student was suspended out of school or expelled for 11 or more days. A duration of .5 is equal to 1 day.


Reports a value of Y when the student has a behavior resolutions that is mapped to one of the following state codes that totals 11 or more days and the Length of Removal is 11 days or more:

  • S4: Out-of-School Suspension
  • S5: Expulsion - less than one calendar year
  • S6: Expulsion - one calendar year
  • S7: Expulsion - more than one calendar year

This field reports from the Duration in School Days field. If there is no value in that field, a calculation using the Resolution Start Date minus the Resolution End Date is used.


Otherwise, reports a value of N.


When this field reports a value of Y, field 19 must report a value of N.


Alphanumeric, 1 character (Y or N)

Behavior > Admin > Resolution Types > Behavior Resolution Type Details > State Resolution Code = S4, S5, S6 or S7


BehaviorResolution.stateResCode


Behavior > Behavior Management > Events and Participants > Resolution Details > Duration in School Days, Resolution Start Date, Resolution End Date


BehaviorResolution.schoolDaysDuration

In-School Suspensions Totaling 10 Days Or Less

Indicates the student was suspended in school for 10 or less days. A duration of .5 is equal to 1 day.


Reports a value of Y when the student has a behavior resolution that is mapped to state code S3: In-School Suspension and the Length of Removal is less than 11 days.


This field reports from the Duration in School Days field. If there is no value in that field, a calculation using the Resolution Start Date minus the Resolution End Date is used.


Otherwise, reports a value of N.


When this field reports a value of Y, field 22 must report a value of N.


Alphanumeric, 1 character (Y or N)

Behavior > Admin > Resolution Types > Behavior Resolution Type Details > State Resolution Code = S3


BehaviorResolution.stateResCode


Behavior > Behavior Management > Events and Participants > Resolution Details > Duration in School Days, Resolution Start Date, Resolution End Date


BehaviorResolution.schoolDaysDuration

In-School Suspension Expulsions Totaling More Than 10 Days

Indicates the student was suspended in school for 11 or more days. A duration of .5 is equal to 1 day.


Reports a value of Y when the student has a behavior resolutions mapped to state code S3: In-School Suspension and the Length of Removal is 11 days or more.


This field reports from the Duration in School Days field. If there is no value in that field, a calculation using the Resolution Start Date minus the Resolution End Date is used.


Otherwise, reports a value of N.


When this field reports a value of Y, field 21 must report a value of N.


Alphanumeric, 1 character (Y or N)

Behavior > Admin > Resolution Types > Behavior Resolution Type Details > State Resolution Code = S3


BehaviorResolution.stateResCode


Behavior > Behavior Management > Events and Participants > Resolution Details > Duration in School Days, Resolution Start Date, Resolution End Date


BehaviorResolution.schoolDaysDuration

Total Disciplinary Removals

Reports the total number of disciplinary removals assigned to the student. 


Reports a total count for each unique behavior resolution mapped to a State Code of S3 through S9 on one behavior event up to the report generation date.


A duration of .5 is equal to 1 day.


Numeric, 3 digits

Behavior > Admin > Resolution Types > Behavior Resolution Type Details > State Resolution Code = S3-S9

BehaviorResolution.stateResCode
Disciplinary Removals Totaling 1 Day

Indicates whether the student received behavior resolutions mapped to a State Code of S3 through S9 up to the date the report was generated.


Reports a value of Y if the student was assigned a behavior resolution mapped to a State Code of S3 through S9 and the Length of Removal Total is 2 through 10.


A duration of .5 is equal to 1 day.


Otherwise, reports a value of N.


When this field reports a value of Y, fields 25 and 26 must report a value of N.


Alphanumeric, 1 character (Y or N)

Behavior > Admin > Resolution Types > Behavior Resolution Type Details > State Resolution Code = S3-S9

BehaviorResolution.stateResCode
Disciplinary Removals Totaling 2 to 10 Days

Indicates whether the student received Behavior Resolutions mapped to a State Code of S3 through S9 as of the date the report was generated for more than 2 days.


Reports a value of Y when the student has between 2 and 10 Behavior Resolutions mapped to a State Code of S3 through S9 as of the date the report was generated and the Length of Removal Total is 2 through 10. 


Reports a value of N when the student has less than 2 behavior resolutions mapped to a State Code of S3 through S9 as of the date the report was generated.


When this field reports a value of Y, fields 24 and 26 must report a value of N.


Alphanumeric, 1 character (Y or N)

Behavior > Admin > Resolution Types > Behavior Resolution Type Details > State Resolution Code = S3-S9

BehaviorResolution.stateResCode
Disciplinary Removals Totaling More Than 10 Days

Indicates whether the student received a Behavior Resolution mapped to a State Code of S3 through S9 as of the date the report was generated for more than 10 days.


Reports a value of Y when the student has 11 or more behavior resolutions mapped to a State Code of S3 through S9 as of the date the report was generated and the Length of Removal Total is 2 through 10. 


Reports a value of N when the student has less than 11 behavior resolutions mapped to a State Code of S3 through S9 as of the date the report was generated.


When this field reports a value of Y, fields 24 and 25 must report a value of N.


Alphanumeric, 1 character (Y or N)

Behavior > Admin > Resolution Types > Behavior Resolution Type Details > State Resolution Code = S3-S9

BehaviorResolution.stateResCode