ESS Discipline Data Collection Report

The ESS Discipline Data Report (previously called the AZ Safe and Drug Free report) generates incident data for submission to the state. The report is run at the school level, as opposed to district-wide.

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.

Incident Selection

The report selects records based on the following criteria:

At least one offender must be defined for each incident.
At least one behavior must be defined for each offender.
At least one action must be associated with each behavior.
At least one reporter must be defined for each incident (reporters should not be assigned any actions or behaviors).
Reportable incident data is limited by the Reporting Method selected on the Edit School page (Start Page > District Setup > Schools/School Info > Edit School):

All Data With SAIS ID – All incident data is reported, including the student’s SAIS ID.
All Data without SAIS ID – All incident data is reported, excluding the student’s SAIS ID.
Mandatory Data With SAIS ID – Only mandatory incidents are reported, including the student’s SAIS ID.
Mandatory Data Without SAIS ID – Only mandatory incidents are reported, excluding the student’s SAIS ID.

Note: A mandatory incident is any incident involving bodily injury and/or a mandatory action and/or a mandatory violation. Mandatory actions include all actions in the “Removal” category, such as expulsion or suspension. See the Appendix for a list of mandatory violations.

ESS Discipline Data Collection does not include any incidents with non-reportable Action Codes. Only incidents involving a 'Removal', or incidents involving 'Actions with Due Process' are included.
When running the ESS Discipline Data Collection report, incidents are included that fall into the 'Removal' or 'Actions with Due Process' category. Incidents with all other Action Types are not included in the output.
- Actions within Due Process ^
  - Appeal Review^
  - Board Review^
  - Disciplinary Hearing^
  - IEP Team Meeting^
  - Manifestation Determination^
  - Placement Review Committee^
- Removal ^
  - Expulsion With Service
  - Expulsion Without Service^
  - In School Suspension- Long Term With Services^
  - In School Suspension- Long Term Without Services^
  - In School Suspension- Short Term With Services^
  - In School Suspension- Short Term Without Services^
  - Out Of School Suspension- Long Term With Services^
  - Out Of School Suspension- L-Term Without Services^
  - Out Of School Suspension- S-Term With Services^
  - Out Of School Suspension- S-Term Without Services^
  - Removal By H.O. - Likely Injury To Self Or Other^
  - Unilateral Removal to Interim Alt Ed Setting^
  - Reassignment To A Different Class^
  - Reassignment To Another School Within District^

Report Input

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

Field	Description
Current Selection 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 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.
Start Date	First day of the reporting period used for the report.
End Date	Last day of the reporting period used for the report.
Transaction Type	Choose one of the following from the pop-up menu: Add Delete Replace All
Report Only SPED Students	Check this box to only include SPED students in the report output. Note: Starting in the 2018-19 school year, only incidents for SPED students are required to be reported.

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.

Note: The tables and fields used to store incident data are not accessible via Direct Database Export (DDE) or Direct Database Access (DDA).

Data Element	XML Field	Description	[Table]FieldName	Mandatory
Header
ESSDDCData	ESSDDCData	N/A	N/A	N/A
School Incident Data
School Entity ID	schoolID	The entity ID of the school reporting the incident.		Yes
Incident
Incident ID	SMSIncidentID	The incident ID.	[Incident]IncidentID	Yes
Incident Date	incdate	The date that the incident was reported to a disciplinary authority.	[Incident]Incident_TS	Yes
Referral Date	refdate	The date that the incident was recorded.	[Incident]Created_TS	Yes
Referring Individual First Name	reffname	The first name of the person who reported the incident. Incident Role = Reporter	[Incident_Person_Role]TeacherID [Incident_Person_Role]StudentID [Incident_Person_Role]Incident_Other_Person_ID [Incident_Person_Role]role_code = 'Reporter'	Yes
Referring Individual Last Name	reflname	The last name of the person who reported the incident. Incident Role = Reporter	[Incident_Person_Role]TeacherID [Incident_Person_Role]StudentID [Incident_Person_Role]Incident_Other_Person_ID [Incident_Person_Role]role_code = 'Reporter'	Yes
Referring Individual's Phone Number	refphone	The phone number of the person who reported the incident.	[Incident_Person_Role]TeacherID [Incident_Person_Role]StudentID [Incident_Person_Role]Incident_Other_Person_ID [Teachers]school_phone [Students]homel_phone	No
Offender State Student ID	StateStudentID	The student's state assigned unique ID. Incident Role = Offender	[Incident_Person_Role]StudentID [Incident_Person_Role]role_code = 'Offender' [Students]State_StudentNumber	Yes
Violation
Violation ID	SMSViolationID	The violation identifier.	[Incident_Detail]Incident_Detail_ID	Yes
Violation Code	Violationcode	The violation code. See Behavior Codes for valid values.	Behavior Code [Incident_Detail]LU_SUB_CODE_ID	Yes
No longer collected: Primary Violation Indicator	primaryviolationind	Indicates whether this violation was the primary violation in the incident.	[Incident_Detail]Primary_Indicator [Incident_LU_SUB_CODE]Severity	No longer collected
Violation Detail 1	violationdetail1	The 1^st tier violation subcode. See subcodes in the Behavior Codes for valid values.	Behavior Code [Incident_Detail]LU_SUB_CODE_ID	Yes, based on the type of violation
Violation Detail 2	violationdetail2	The 2^nd tier violation subcode. See one of the following for valid 2^nd tier subcodes: Alcohol, Tobacco, and Other Drugs Subcodes Theft (Property) Subcodes Weapons Subcodes	Behavior Code [Incident_Detail]LU_SUB_CODE_ID	Yes, based on the type of violation
Violation Detail 3	violationdetail3	The 3^rd tier violation subcode. See Alcohol, Tobacco, and Other Drugs Subcodes for valid 3^rd tier subcodes.	Behavior Code [Incident_Detail]LU_SUB_CODE_ID	Yes, based on the type of violation
No longer collected: Free Form Text	freeformtext	Text used to describe the following violations: Other Violation of School Policies Other School Threat Other Technology Simulated Firearm Other Aggression Illicit Drug Substance represented as illicit drug Inhalant Unknown Drug Drug Paraphernalia Over the Counter Drug Prescription Drugs Other firearm Simulated firearm DEPRECATED - Other (Dangerous Items)	[Incident_Detail]Lookup_Code_Desc	No longer collected
Action
Action ID	SMSActionID	The action ID. There can be multiple actions for one incident.	[Incident_Action]Incident_Action_ID	Yes
Action Code	actioncode	The type of disciplinary action taken as a result of the incident. Note: If a student has an incident having two state reportable action codes for the same behavior, both action codes appear in the ESS DDC File as two separate records, with both records having the same behavior but different action codes. See Action Codes for valid values.	Action Code [Incident_Detail]LU_CODE_ID [Incident_Detail]LU_SUB_CODE_ID	Yes
Number of Removal/Reassignment Days	removaldays	The number of days the student is suspended/removed/reassigned on actions under Due Process. Note: The report converts removal days to removal hours in the output, multiplying Assigned Duration (Days Removed) by 6.	[Incident_Action]Duration_Assigned	Yes, based on the action
Assigned Action Start Date	startdate	The date that the action is due to begin.	[Incident_Action]Action_Plan_Begin_DT	Yes, based on the action
Assigned Action End Date	enddate	The date the action is due to end.	[Incident_Action]Action_Plan_End_DT	Yes, based on the action
Action Review Date	reviewdate	The date the action is due to be reviewed for further evaluation.	[Incident_Action_Attribute]Date_Attribute	Yes, based on the action
Scheduled Hearing/Review Date	scheudledate	The date on which the action requires hearing or review, related to actions with due process.	[Incident_Action_Attribute]Date_Attribute	Yes, based on the action
Date Action Decided	actiondecidedate	The date that the consequences to the violation was decided.	[Incident_Action]Action_Resolved_DT	Yes
Name of Place a Student Moved To	placemovedto	The name of the class, school, agency, or alternative education setting where a student was moved to.	[Incident_Action_Attribute]Text_Attribute	Yes, based on the action
Action Completed	iscompleted	Indicates whether the action has been completed.	[Incident_Action_Attribute]Is_Yes1_No0_Attribute	Yes
Action Comments	actioncomments	Optional additional comments for the incident. Truncated to 990 characters.	[Incident_Action]Action_Resolved_Desc	No
Other Action Description	otheractiondescription	The description for action code 86, Other Action.	[Incident_Detail]Lookup_Code_Desc	Yes, based on the action
Service Declined	isservicedeclined	Indicates whether service was offered to the student, but declined by the parent or student. This value is reported if the Action Code is one of the following: 105 – Expulsion With Service 103 – Out Of School Suspension – Long Term With Service 101 – Out Of School Suspension – Short Term With Services Valid values: 1 (Yes) or 0 (No)	[Incident_Action_Attribute]IS_YES1_NO0_ATTRIBUTE	Yes
Police Report #	policereportnumber	The police report number as received from the law enforcement.	[Incident_Action_Attribute]Text_Attribute	Yes, based on the action
Results of referral to law Enforcement	lawenforcementresult	The result of law enforcement involvement. See Action Attribute Codes for valid values.	Action Attribute Code [Incident_Action_Attribute]LU_CODE_SUB_CODE	Yes, if law enforcement is involved