Student Infraction Response - Discipline Log Entries (SFTP)

Introduction

This report can run for the school level as well as from district. When run from the school, it is run for the school running the report. When run from the district, the report can run for one, multiple, or all schools.

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

The report selects records from the [Students], [ReEnrollments], and [Log] tables based on the following criteria:

The student must not be excluded from state reporting.
The student has one or more school enrollment records in any of the selected schools that meet the following criteria.
- The enrollment record is not excluded from state reporting
- The enrollment Exit Date occurs after the report start date.
- The enrollment Entry Date occurs on or before the report end date.
- The school of enrollment is not excluded from state reporting.
The student has one or more Log Entries that meet the following criteria:
- Only Log entries Records where Student is an Offender or a victim
  - Value 'Student' must be selected in one of these two fields in the Log entries page
    - Offender
    - Victim Type
- Only log entries with Action Taken where Value is one of the following are included
  - In school Suspension (ISS)
  - Out of School Suspension (OSS)
  - IAES Removal by School Personnel
  - IAES Removal by Impartial Hearing Officer
- Only Log Entries with the start date that falls between the report start and end date range selected are included.
- All Incident types will be included
  - Only these 3 Incident types, Drugs, Weapons, or Serious Bodily Injury will be reported.
  - If any other incident type is selected on the log Entry Record, then the report will set the Response Reason as blank.
  - If the Action Taken is IAES Removal by School Personnel, then Response Reason is a required field. For any other Action Taken value, it can be left blank.
  - Exclusion: If Incident Type is other than the 3 specified above and the action taken is IAES Removal by School Personnel, the action is not reported.
- In an event where more than two reasons were associated with a response, report the most serious according to the hierarchy. The most serious is “Serious Bodily Injury” followed by “Weapons” and “Drugs.”

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. Note: The All Schools option is only available when running the report from the District Office.
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 and meets the selection criteria. All students – Run the report for all students in the current school, selected schools* 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.
Run Report with Audit Fields and Headers*
Start Date	Enter the start date for the report. The start date is the first date that extract scans for student enrollments.
End Date	Enter the end date for the report. The end date is the last date that the extract scans for student enrollments.
SFTP connections	Choose an SFTP connection from the pop-up menu to have the report output uploaded automatically. Please refer to the System Administrator portion of the PowerSchool Administrator User Guide for details on how to create an SFTP connection for use with this new report parameter.

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	[Table]FieldName	Business Rule	Req	Max Length
1	District Code	If Pref NY_CHARTER_NP = 0 then ‘NY’ concatenated with Pref NY_BEDS_CODE If Pref NY_CHARTER_NP = 1 and [S_NY_SCH_X]DistrictLocationCode is blank then ‘8’ concatenated with Pref NY_BEDS_CODE If Pref NY_CHARTER_NP = 1 and [S_NY_SCH_X]DistrictLocationCode is not blank then ‘8’ concatenated with [S_NY_SCH_X]DistrictLocationCode		Yes	20
2	Location Code	[S_NY_STU_X]LocationCode [S_NY_SCH_X]BOCESBuilding		Yes	12
3	School Year Date	[Terms]LastDay		Yes	10
4	Student ID	[Students]NY_LocalStudentID or [S_NY_STU_X]PreviousStudentNumber [Students]Student_Number Victim Type = Student OR Offender = Student	Only victims and offenders will be reported.	Yes	12
5	Response Date (REMOVAL START DATE)	Select Student, Behavior, Log Entries, Action Date [LOG]Discipline_ActionDate		Yes	10
6	Infraction Number (COUNT)	Will be Blank			3,0
7	Response Code (SUSPENSION TYPE)	Select Student, Behavior, Log Entries, Action Taken [LOG]Discipline_ActionTaken	The report displays only if one of the following 4 codes is selected: ISS OSS IAES Removal by School Personnel IAES Removal by Impartial Hearing Officer	Yes	20
8	Administrator ID	Will be Blank			12
9	Disposition Start Date	Will be Blank			10
10	Disposition End Date	Will be Blank			10
11	Event Identifier (EVENT ID)	Internal ID will be used for action [LOG]ID	A unique Event ID is created for each response.	Yes	30
12	Response Comment	Will be Blank			255
13	Response Duration (DAYS SUSPENDED)	Select Student, Behavior, Log Entries, Duration (Actual) [LOG]Discipline_DurationActual		Yes	6,2
14	Case Number	Will be Blank			20
15	Behavior Intervention Plan	Will be Blank			3
16	Summer School	Will be Blank			3
17	Special Education Indicator	Will be Blank			3
18	Regular Education Indicator	Will be Blank			3
19	Intervention Assistance Team	Will be Blank			3
20	Testing Referral	Will be Blank			3
21	ADA Status Indicator	Will be Blank			3
22	Attorney Name	Will be Blank			20
23	Hearing Date	Will be Blank			10
24	Alternate Program Status	Will be Blank			20
25	Compliance Completed	Will be Blank			3
26	Appeal Type	Will be Blank			12
27	Appeal Status	Will be Blank			20
28	Review Status	Will be Blank			20
29	Security Transaction Type	Will be Blank			12
30	Duration Shortened	Will be Blank			3
31	Alternate Response Duration	Will be Blank			6,2
32	Duration Unit of Measure Code	Will be Blank			5
33	Alternate Duration Unit of Measure Cod	Will be Blank			5
34	Received Services Indicator (DURING SUSPENSION)	[NEW FIELD] Select Student, Behavior, Log Entries, Received Services Indicator [S_NY_LOG_X]Received_Services_Indicator	Required when action is OSS, else it is blank	Yes	3
35	Response Reason	Select Student, Behavior, Log Entries, Incident Type [LOG]Discipline_IncidentType	The value can be only one of these 3 - “Serious Bodily Injury”, “Weapons” or “Drugs.” In an event where more than two reasons were associated with a response, report the most serious according to the hierarchy. The most serious is “Serious Bodily Injury” followed by “Weapons” and “Drugs.” This is a required field when action is IAES Removal by School Personnel If any other behavior is entered (e.g., Disrupting class), then this field will be blank.	Yes	20
36	SUSPENDED REMAINDER OF SCHOOL YEAR		Check if student was suspended until the last day of the school year. Use Action Taken End Date to compare. If yes, then reported ‘Yes'. If the student exits before end of the school year and is suspended until exit date, then also reported as ‘Yes’ If no, then 'No' is reported, This is a required field for Response Code OSS The number of days suspended must be greater than or equal to 10 for this to be reported as Yes.	Yes	3