Suspension and Expulsions Report

Introduction

The Suspensions and Expulsions extract reports student in-school suspensions, out-of-school suspensions, and expulsions for the school year.

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 report selects records from the [Students] table based on the following criteria:

Student suspension or expulsion takes place within the reporting date range.
Student is enrolled in the school for which the report is run.
- If run for the entire district, all discipline log records, including those with a schoolid of 0, are extracted.

Note: If a district has no suspensions and expulsions, the completed file will contain the header row and a “0” in the first column (AKSID).

Report Input

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

Field	Description
Select Schools	Choose one of the following: Current School Only – Includes all student records associated with the current school that meet selection criteria. To change the current school, click the School link at the top of the page and choose the appropriate school from the list. All Schools – Includes all student records on the PowerSchool server that meet selection criteria. Notes: For submission, the report must be run for all schools but, for troubleshooting purposes, can be run for a single school. The All Schools option is only available when running the report from the District Office.
Select Students	Indicate which students to include in the report by selecting one of the following options: The selected [number] students only – Run the report for selected students only. All students – Run the report for all students in the current school or district who meet the selection criteria. Note: If running the report for a single student or a group of students, select the students prior to running report.
Start Date	Enter the start date for the reporting period.
End Date	Enter the end date for the reporting period.

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	Length
1	AKSID	The Alaska Student Identification Number.	[Students]State_StudentNumber	10
2	LocalID	The locally assigned student number.	[Students]Student_Number	15
3	LastName	The student’s last name.	[Students]Last_Name	35
4	FirstName	The student’s first name.	[Students]First_Name	35
5	MiddleName	The student’s middle name.	[Students]Middle_Name	35
6	Suffix	The student’s suffix.	[S_AK_STU_X]Suffix	8
7	BirthDate	The student’s date of birth.	[Students]DOB	10
8	Gender	The student’s gender.	[Students]Gender	1
9	EthnicityID	The student’s race or ethnicity.	[Students]Sched_Ethnicity	1
10	SchoolNumber	The student’s school ID.	{Prefs}Value where [Prefs]Name = DistrictNumber [Students]SchoolID	6
11	Grade	Student’s grade level. For valid values, see the Appendix.	[Log]Grade_Level	2
12	DisabilityID	Student’s primary disability at the time of the incident. For valid values, see the Appendix. Notes: Disability codes of 15 or 16 report as 0. If the student is currently enrolled in special education but was not enrolled at the time of the incident, this field still reports as 0.	[S_AK_Log_X]Disability_Code	2
13	EL_Status	Indicates whether the student was an EL student at the time of the incident. For valid values, see the Appendix.	[S_AK_Log_X]LEPCode	1
14	IncidentDate	The date of the incident.	[S_AK_Log_X]Incident_Date	10
15	IncidentNumber	The unique ID number of the incident.	[S_AK_Log_X]Incident_Number	10
16	WeaponID	Indicates what, if any, weapon was involved in the incident. Note: Code 29 indicates the incident did not involve a weapon.	[S_AK_Log_X]Weapon_ID	2
17	OtherWeaponsDesc	If codes 24, 26 or 28 were reported for the Weapons ID, this output provides a description of the weapon.	[S_AK_Log_X]Other_Weapon_Description	35
18	NonWeaponID	Indicates the reason for the disciplinary action if a weapon was not involved. Note: Code 62, Threat of Physical Attack, reports as 10 in this field.	[S_AK_Log_X]NonWeapon_ID	2
19	OtherNonWeaponsDesc	If code 12 was reported for the Non-Weapons ID, provides a brief description of the incident.	[S_AK_Log_X]Other_NonWeapon_Description	75
20	OriginalActionID	Indicates the disciplinary action given to the student for this incident. Valid values: E - Expulsion ISS - In-school suspension S - Out-of-school suspension	[Log]Consequence	3
21	OriginalLength	Indicates the number of days the student was removed from their regular education setting for the disciplinary action. Reported in 0.5 increments with 0.5 equaling ½ day, 1.0 equaling a full day, and so on. Note: An incident coded as an expulsion must have an Original Length lasting through the end of the school year.	[Log]Discipline_DurationAssigned	5
22	DiscModified	Indicates if the expulsion or suspension, with or without services, was altered from the initial disciplinary action. Note: If DiscModified = Y, Modified Action and Actual Length must contain a value. Valid values: Y - Original action was modified N - Original action was not modified	[S_AK_Log_X]Discipline_Mod	1
23	ModifiedActionID	Indicates the final actual action if the Original Action (element number 20) was modified. Note: An incident coded as an Expulsion in Modified Action must have an Actual Length lasting through the end of the school year. If the number of days of an expulsion is reduced below this point, the Modified Action must be ISS or S. Valid values: E - Expulsion ISS - In-school suspension S - Out-of-school suspension blank	[S_AK_Log_X]Discipline_Mod_Consequence	3
24	ActualLength	Indicates the final actual length of time the student was removed from their regular educational setting if Y was entered in the Discipline Modified field . Reported in 0.5 increments with 0.5 equaling ½ day, 1.0 equaling a full day and so on. Note: This field is blank unless Discipline Modified field = Y.	[S_AK_Log_X]Discipline_Mod_Length	5
25	NumberOfVictims	Indicates the number of student victims who were injured or harmed as a direct result of the incident.	Count of S_AK_LOG_VICTIM_C records where: [S_AK_LOG_VICTIM_C]VictimType = Student [S_AK_LOG_VICTIM_C]Injured = 1	2
26	TransferRequests	Indicates the number of student victims who requested to be transferred to a new educational setting as a direct result of the incident.	[S_AK_Log_X]TransferRequest	1
27	TransferRequestsCompleted	Indicates the number of student victims who were transferred to a new educational setting as a direct result of the transfer request.	[S_AK_Log_X]TransferRequestCompleted	1
28	LawEnforcement	Indicates whether the incident was referred to off-site Law Enforcement personnel. Valid values: Y - Incident was referred to off-site law enforcement personnel. N - Incident was not referred to off-site law enforcement personnel.	[Log]Discipline_PoliceInvolvedFlag	1
29	PhysicalInjury	Indicates if one or more students, school personnel, or other persons on school grounds required professional medical attention as a result of the incident. Valid values: Y - Student inflicted physical injury to another person. N - Student did not inflict physical injury to another person.	[S_AK_Log_X]Physical_Injury	1
30	EducationalServices	Indicates whether an expelled student received educational services during the expulsion. Note: This element must be reported for any expelled student, regardless of disability status. Students with disabilities (IDEA) must receive educational services during any removal of more than 10 school days. Valid values: Y - Student receive educational services during the expulsion. N - Student did not receive educational services during the expulsion.	[S_AK_Log_X]Educational_Services	1
31	HearingOfficerRemoval	Indicates whether a student with a disability was removed from his/her current education placement to an appropriate alternative educational setting for not more than 45 school days by an impartial Special Education Due Process Hearing Officer. Note: Applies only to students with disabilities. Valid values Y - Student was removed by an impartial Special Education Due Process Hearing Office. N - Student was not removed by an impartial Special Education Due Process Hearing Office. blank	[S_AK_Log_X]Hearing_Officer_Removal	1
32	UnilateralRemoval	Indicates whether a student with a disability was removed from his/her current educational placement to an appropriate interim alternative educational setting for not more than 45 school days by school personnel (not by a hearing officer or the IEP team). Note: Applies only to students with disabilities. Valid values: Y - Student was removed by school personnel. N - Student was not removed by school personnel.	[S_AK_Log_X]Unilateral_Removal	1
33	AltEduSettingName	If either Hearing Officer Removal or Unilateral Removal = Y, indicates the name of the Interim Alternative Educational Setting that the student was removed to by the IEP team or the hearing officer.	[S_AK_Log_X]Interim_Setting	50
34	Notes	Notes that explain any special circumstances that should receive consideration.	N/A	35