Table 9A

Contents

Introduction

The Table 9A is a PennData Report for Children with Disabilities, who were subject to disciplinary removal from their educational setting. Data is extracted from Incident Management Tables for this report.

Selection Criteria

Selection criteria determine which database records are used in the report. Refer to selection criteria for analysis when the report does not return the correct records.

Student Selection

The student is not excluded from state reporting.
The school is not excluded from state reporting.
The student’s entry date must be between 0701xxxx and 0630xxxx (with xxxx representing the school year).
The incident involved must fall during the selected school year.
The student’s exit date must be after 0701xxxx of the next school year.
The student must be identified as LEP 01, 03, 04, 05, 06, 07, 08 or 99.
The student must be SPED with challenge type not null.

Report Input

For help with report generation and navigation, see How to Find and Generate a Report.

Field	Description
Select Schools	Indicate which schools to include in the report by selecting from the following options: If sub-districts are not enabled: Select Multiple Schools – Select the schools for which you want to run the report. Includes all student records associated with the selected schools that meet the selection criteria. All Schools (default) – Run the report for all schools. Includes all student records on the PowerSchool server that meet the selection criteria If sub-districts are enabled: Select Sub-district - Select the sub-district for which you want to run the report. Select Multiple Schools – Select the schools for which you want to run the report. Includes all student records associated with the selected schools that meet the selection criteria. All Schools in selected sub-district (default) – Run the report for all schools in the selected sub-district. Includes all student records on the PowerSchool server that meet the selection criteria. If run at the school level, the report includes all records associated with the current school that meet the selection criteria. To change the current school, click School at the top of the page and choose the appropriate school from the list.
Students to Include	Indicate which students to include in the report by selecting one of the following options: The selected [number] students only – Run the report for students in the current selection. All students – Run the report for all students in the current school or district that meet the selection criteria. Note: If running the report for a single student, or group of students, select the students prior to running report.
Select School Year	Select the appropriate school year for the report from the dropdown menu.
Field Delimiter	Select tab, comma, or pipe as the field delimiter between the fields in the output.
Include Header Labels in output file?	Choose Yes or No to indicate whether to include column headings in the extract file. Including column headers provides a heading for each type of data extracted in the report.
Scheduling	Run Now Schedule

Back to Top

Report Output

Each of the fields displayed in the output of the report are described below. See Understanding the Report Output Table for a definition of each column in the table.

Item #	Data Element	Description	[Table]FieldName	Field Type	Field Length
1	IU	Intermediate Unit Number Enter the IU Number that most of your student population is reported under	[S_PA_SCH_X]IU_Number	Numeric	9
2	District of Residence AUN	The 9 digit AUN number.	[Students]DistrictofResidence If sub-districts are enabled: [CST_SubDistricts]Subdistrict_Number	Numeric	9
3	PA SecureID	The PA SecureID assigned to the student. This field is extracted from Start Page > Student > State/Province - PA > PA SecureID.	[Students]State_StudentNumber	Alpha-numeric	10
4	Last Name	The last name of the student. This field is extracted from Start Page > Student > Demographics.	[Students]Last_Name	Alpha-numeric	60
5	First Name	The first name of the student. This field is extracted from Start Page > Student > Demographics.	[StudentsFirst_Name]	Alpha-numeric	60
6	Middle Name or Initial	The middle name of the student. Note: Whenever possible, this is to be the FULL middle name, not just the middle initial.	[Students]Middle_Name	Alpha-numeric	60
7	Birth Date	The student’s birth date. This field is extracted from Start Page > Student > Demographics.	[Students]DOB	Numeric	10
8	Gender	The student’s gender. This field is extracted from Start Page > Student > Demographics.	[Students]Gender	String	1
9	Ethnic Background	The student’s ethnic background using given ethnic codes.	[StudentRace]Race	Alpha-numeric	2
10	LEP	The student’s EL program status. Valid values: 99 - never EL 01 - current EL, not LIFE 03 - former EL, exited, and in 1st year of monitoring 04 - former EL, exited, and in 2nd year of monitoring 05 - former EL, exited, and no longer monitored 06 - current EL, LIFE (Limited or Interrupted Formal Education) 07 - former EL, exited, and in 3rd year of monitoring 08 - former EL, exited, and in 4th year of monitoring This field is extracted from Start Page > Student > State/Province - PA > Student Info tab.	[Students.S_PA_STU_X]LEP_ELL_Status_Code [Reenrollments.S_PA_REN_X]LEP_ELL_Status_Code	Alpha-numeric	2
11	Grade	The student’s grade level.	When Special Education IEP Indicator = ‘Y’: If [S_PA_STU_X/S_PA_REN_X]State_Grade_code exists then State_Grade_code else [Students/Reenrollments]Grade_level When Special Education IEP Indicator is not ‘Y’: If [Students]Grade_level <= 0 then If [S_PA_STU_X/S_PA_REN_X]State_Grade_code exists then State_Grade_code else null If [Students/Reenrollments]Grade_level > 0 then Grade_level [Students]PA_GradeCode or [Students]Grade_level	String	1
12	Disability Category	The student’s primary disability/challenge type. This field is extracted from Start Page > Student > State/Province - PA > Student Info tab.	[Students]PA_Challenge_Type [S_PA_STU_X]Challenge_Type_Code	Alpha-numeric	4
1. Unilateral Removals to an Interim Alternative Educational Setting by School Personnel
13	1A. Yes/No (Y/N)	Yes or No to indicate if the student was removed unilaterally to an interim alternative educational setting by school personnel.	This data counts all incidents where the student receives an Action of S8.	String	1
14	1B. Number of Removals for Drugs	The number of times a student has been removed for drug use or possession.	This data counts all incidents where the student receives an Action of S8 and had a Behavior of 47 or 48.	Numeric	10
15	1C. Number of Removals for Weapons	The number of times a student has been removed for weapon use or possession.	This data counts all incidents where the student receives an Action of S8 and had a Behavior of 39, 40, 41, 42, 43, 44, 45, or 46.	Numeric	10
16	1D. Number of Removals for Serious Bodily Injury	The number of times a student has been removed for causing serious bodily injury.	This data counts all incidents where the student receives an Action of S8 and had a Behavior of SBI.	Numeric	10
2. Removals to an Interim Alternative Educational Setting Based on a Hearing Officer Determination Regarding Likely Injury
17	Yes/No (Y/N)	Yes or No to indicate if the student was removed to an interim alternative educational setting based on a hearing officer determination.	This data counts all incidents where the student receives an Action of S9 and had a behavior of SBI^.	String	1
3. Out-of-School Suspension/Expulsions
18	3A. Totaling 10 Days or Less Yes/No (Y/N)	Yes or No to indicate if the student was suspended from school for ten days or less.	This data counts all incidents where the student receives an Action of S4 or S5 and the duration of the incident. If student received an Action of S6 or S7 then 'N'. OR If number of days suspended is <= 10 with Action of S4 or S5 then 'Y' else 'N'.	String	1
19	3B. Totaling > 10 Days – Yes/No (Y/N)	Yes or No to indicate if the student was suspended for ten days or more, or expelled.	This data counts all incidents where the student receives an Action of S4, S5, S6, and/or S7 and the duration of the incident. If student received an Action of S6 or S7 then 'Y'. OR If number of days suspended is > 10 with an Action of S4 or S5 then 'Y' else 'N'.	String	1
4. In -School Suspensions
20	4A. Totaling 10 Days or Les Yes/No (Y/N)	Yes or No to indicate if the student was suspended in school for ten days or less.	This data counts all incidents where the student receives an Action of S3 and the duration of the incident.	String	1
21	4B. Totaling > 10 Days – Yes/No (Y/N)	Yes or No to indicate if the student was suspended in school for ten days or more.	This data counts all incidents where the student receives an Action of S3 and the duration of the incident.	String	1
5. Disciplinary Removals
22	5A. Total Disciplinary Removals	The number of times a student has been removed for disciplinary reasons.	This data counts all incidents where the student receives an Action of S3, S4, S5, S6, S7, S8 and/or S9.	Numeric	10
23	5B. Totaling 1 Day Yes/No (Y/N)	The number of times a student has been removed for one day.	This data counts all incidents where the student receives an Action of S3, S4, S5, S6, S7, S8 and/or S9, and the duration of each.	String	1
24	5C. Totaling 2-10 days Yes/No (Y/N)	The number of times a student has been removed for two to ten days.	This data counts all incidents where the student receives an Action of S3, S4, S5, S6, S7, S8 and/or S9, and the duration of each.	String	1
25	5D. Totaling > 10 days Yes/No (Y/N)	The number of times a student has been removed for more than ten days.	This data counts all incidents where the student receives an Action of S3, S4, S5, S6, S7, S8 and/or S9, and the duration of each.	String	1

Back to Top