Incident Management Query

Introduction

This report generates the Incident Management tables for the Discipline data entered for the students. You can use this report to verify the entered Discipline data and if something is not getting published the records can be checked against the defined publishing logic. The publishing logic for the Discipline data can be found in the ESS Discipline Data Collection Reports.

Selection Criteria

The student must not be excluded from the state reporting.
The school in which the student is enrolled or the discipline record is associated must not be excluded from the State Reporting.

Report Input

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

Field	Description
Select Schools	Select one or more schools.
Students to Include	Choose one of the following from the pop-up menu: The selected x students only – Run the report for students in the current selection. All Students (default) – 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 runningreport.
Incident Start Date	Select to include the incidents recorded from this date.
Incident End Date	Select to include the incidents recorded until this date.
Incident Type	Select type of incident for the report: Teacher Referral State Reportable Non-State Reportable
Action Code	Choose to list specific action codes associated with the incident. All action codes are selected by default.
Output Type	Select CSV or TXT format.
Include the dobule quotes (“ “)	Choose Yes to enclose each report output value within double quotation marks. No is selected by default.

Report Output

Each of the fields displayed in the output of the report is described. Refer to Understanding the Report Output Table for a definition of each column in the table.

Field	Description	[Table]Field Name
Incident ID	The ID number assigned to the incident when it is created.	[Incident]Incident_ID
Incident School	The school number where the incident occured.	[Incident]School_Number
Incident Type	Identifies the type of incident.	[Incident_LU_Code]Code_Type=incidenttypecode [Incident_LU_Code]Incident_Category
Incident Title	Identifies the title of the incident.	[Incidents]Incident_Title
Incident Date	Date the incident occurred.	[Incident_Detail]Incident_TS truncated to display only the date.
Incident Description	The description of the incident.	[Incident]Incident_Detail_Desc
Reporter Last Name	The reporting staff’s last name.	[Users]Last_Name
Reporter Firt Name	The reporting staff’s first name.	[Users]First_Name
Reporter Middle Name	The reporting staff’s middle name.	[Users]Middle_Name
Staff Unique ID	The teacher's ID.	[usrx]state_uniqueid
STN (State_StudentNumber)	The student’s state identification number. This is only populated when the participant is a student.	[Students]State_StudentNumber
Student Number	The student number .	[Students]Student_Number
Student Last Name	The student's name in the last name.	[StudentCoreFields]PSCore_Legal_Last_Name [Students]Last_Name
Student First Name	The student's name in the first name.	[StudentCoreFields]PSCore_Legal_First_Name [Students]First_Name
Student Middle Name	The student's name in the middle name.	[StudentCoreFields]PSCore_Legal_Middle_Name [Students]Middle_Name
Grade Level	The student’s grade level.	[Students]Grade_Level
School ID	Identifies the School Number for the student’s enrollment.	[Incidents]School_Number
Behavior	Indicates whether this was the primary behavior for the incident.	[Incident_Detail]Primary_Indicator
Gang Related	Indicates whether it was a gang-related incident.	[Incident_LU_Code]incident_category='Gang Related^'
Hate Related	Indicates whether it was a hate-related incident.	[Incident_LU_Code]incident_category='Hate Related^'
Responsible School Number	The Responsible School Organization ID associated with the SEORA Records	[sch_x]EntityID [sch]alternate_school_number [ren_x]EntityID_Ovr
Action Code	Action Code identifying the consequences taken for the incident.	[Incident_LU_Code]Code_Type=actioncode [Incident_LU_Code]State_Aggregate_RPT_Code
Action Taken Detail	The details recorded about the incident.	[Incident_Action]Action_Resolved_Desc
Discipline Date	The start date of the action plan.	[Incident_Action]action_plan_begin_dt
Assigned Duration	The assigned length of the disciplinary action.	[Incident_Action]Duration_Assigned
Actual Duration	The actual time served for the action taken.	[Incident_Action]Duration Actual
Parent Declined Services	If the parent has declined SPED services for the student.	[Incident_LU_Code]incident_category='Parent Declined Services^'
Services Provided		[Incident_LU_Code]incident_category='Services Provided^'