Tool Search: Safe Schools - Historical
The Safe Schools Report provides a summary of behavior events and resolutions for the selected calendar(s). Included in the report is information on violence, weapon, controlled substance and bullying data. Additionally, information from the report will allow evaluations of prevention programs.
This report is used to verify district Safe School data which after district verification, the data is pulled by the Kentucky Department of Education (KDE) on July 1st from the state data warehouse. This data is then provided to the Kentucky Center for School Safety (KCSS) and the Office of Education Accountability.
Click here to access the standard Safe Schools Report.
Safe School - Historical Report EditorSelection Criteria
Student data is reported when the following criteria is met:
- Behavior data for student offenders and participants when the event is associated with select Law or Board Violation codes, regardless of the resolution OR
- Behavior data for student offenders and participants assigned a state-coded resolution (SSP1, SSP2, SSP3, SSP5, SSP7, SSP8, INSR).
A behavior referral must be submitted and in a status of "In Progress" or "Complete" in order to be included in the extract and the error/warning report.
A qualifying behavior incident must have a current student designated as the Offender or Participant.
Behavior incident data without a current student entered as the role of offender or participant added via the Behavior Management tool will not be included on the the report.
Report Logic
Student data included on the Safe Schools Report is based on Student Behavior information. Specific details on the Behavior Management editor and the Behavior Resolution editor, and how to enter behavior information are located on the Behavior Management Tool and Student Behavior page.
- Students who are marked as State Exclude via enrollment, calendar or grade level will not be listed in this report.
- Events with Board Violations or Law Violations linked to violence, weapons, controlled substances or bullying will pull in the extract under sub-reports SS1 - SS4, regardless of their resolution.
Events with Board Violations or Law Violations not tracked in sub-reports SS1-SS4 will pull in the extract under sub-report SS5 if the event contains one of the following state-approved resolution codes:
Resolutions with one of these State Resolution Codes must contain a Start Date, Start Time, End Date, End Time and End Date in order to report.
- SSP1: Expelled, Receiving Services
- SSP2: Expelled, Not Receiving Services
- SSP3: Out of School Suspension
- SSP5: Corporal Punishment
- SSP7: Restraint
- SSP8: Seclusion
- IAES 1: IAES Unilateral Removal by School Personnel
- IAES 2: IAES Removal by Hearing Officer
- INSR: In-School Removal
The Safe Schools report will report Events associated with Unknown Persons. These individuals will be identifiable by the word Unknown in their name. It is up to districts to name the unknown persons consistently.
For guidance on Board Violations and Law Violations, see the Behavior Editors (Kentucky) page.
Generating the Report
- Select the Format in which the report should be generated. The State Format (CSV) is the only available option.
- Enter the Date Range. Only data within this date range within the selected calendar(s) is reported.
- To generate all sub-reports, mark the All Reports checkbox. To generate specific sub-reports, mark each sub-report checkbox (SS1, SS2, SS3A, SS3B, SS3C, SS4, SS5). See the Understanding Safe Schools Sub-Reports section for more information.
- Mark the Active Special Ed on 12/1 of Reporting Year checkbox to only report students with a qualifying safe schools event who were considered active Special Education on Dec 1st of the reporting year (optional).
- Select which Grade(s) will report data OR select an Ad Hoc Filter.
- Select the Calendar(s) to include in the extract.
- To generate the extract immediately, select the Run Extract button. Once the report has been generated and opened, users will be presented with an HTML Validation Report detailing any Warnings and Errors within the extract. Errors indicate problematic data that will not pull on the report. Warnings indicate potentially problematic data that will pull in the extract. After addressing any errors or warnings select the Click Here button to generate the State Format (CSV) file.
To schedule when the report will generate and reduce the performance impact generating the report may have on your system, select the Submit to Batch button. You can access the State Format (CSV) report in the Batch Queue List at the bottom of the Safe Schools editor.
Image 2: Example of the Safe School Report - CSV Format
Understanding Safe School Sub-Reports
The following describes each Safe School sub-report option, see the Law Violation and Board Violation Code tables below for a complete list of which codes initiate which sub-report:
When all or multiple sub-reports are generated together, the report will sort by district, then school, then the Law or Board Violation codes for sub-report SS1, then SS2, then SS3A, then SS3B, then SS3C, then SS4, and finally SS5.
- SS1: Assault or Violence
- SS2: Possession of Guns or other Deadly Weapons
- SS3A: Possession/Use or Distribution of Drugs
- SS3B: Possession/Use or Distribution of Alcohol
- SS3C: Possession/Use or Distribution of Tobacco Products
- SS4: Bullying or Harassment
- SS5: Resolutions of Suspension, Expulsion, Corporal Punishment not reported in SS1-SS4
SS1: Assault or Violence
This sub-report indicates all behavior events where the student committed a law violation related to assault or violence (regardless of resolution).
- Only behavior events with one of the following Law Violation codes is reported:
- 11: Criminal Homicide
- 20: Forcible Rape
- 30: Robbery
- 75: Kidnapping
- 90: Arson
- 172: Statutory Rape
- 174: Sexual Assault (unwanted touching in a sexual manner)
- 175: Sexual Offenses, Other
- 301: 1st Degree Assault
- 302: 2nd Degree Assault
- 303: 3rd Degree Assault
- 304: 4th Degree Assault
- 305: Menacing
- 306: Felony Wanton Endangerment
- 307: Misdemeanor Wanton Endangerment
- 308: Felony Criminal Abuse
- 309: Misdemeanor Criminal Abuse
- 310: Terroristic Threat
- 320: Terroristic – Bomb
- 330: Terroristic-Ch/Bio/Nuc
- 360: Abuse of Teacher
- 2003: IAES for Injury – SPED only
SS2: Possession of Guns or other Deadly Weapons
This sub-report indicates all behavior events where the student committed a law violation related to the possession of a deadly weapon.
- Only behavior events with one of the following Law Violation codes is reported:
- 151: Weapon – Handgun
- 152: Weapon – Riffle
- 153: Weapon/Other Firearm
- 154: Weapon – Other
- 2000: IAES for Weapon – SPED only
SS3A: Possession/Use or Distribution of Drugs
This sub-report indicates all behavior events where the student committed a law violation or board violation related to the possession/use or distribution of a drug.
- Only behavior events with one of the following Law Violation codes is reported:
- 1801: Other Drug Possession and Use
- 1802: Other Drug Distribution
- 1821: Marijuana/Hashish Possession and Use
- 1822: Marijuana/Hashish Distribution
- 1831: Hallucinogenic Possession and Use
- 1832: Hallucinogenic Distribution
- 1841: Amphetamines Possess and Use
- 1842: Amphetamines Distribution
- 1851: Barbiturates Possession and Use
- 1852: Barbiturates Distribution
- 1861: Heroin Possession and Use
- 1862: Heroin Distribution
- 1871: Cocaine/Crack Possession and Use
- 1872: Cocaine/Crack Distribution
- 1881: Prescription Drugs Possession and Use
- 1882: Prescription Drugs Distribution
- 1891: Inhalant Possess and Use
- 1892: Inhalant Distribution
- 1901: Synthetic Drugs Possession and Use
- 1902: Synthetic Drugs Distribution
- 2001: IAES for Drugs – SPED only
- All Board Violations related to drugs are reported, regardless of resolution.
- 1014: Look-alike drug possession, distribution
SS3B: Possession/Use or Distribution of Alcohol
This sub-report indicates all behavior events where the student committed a law violation or board violation related to the possession/use or distribution of alcohol.
- All Law Violation codes related to alcohol are reported, regardless of resolution:
- 210: DUI
- 230: Under Influence
- 1811: Alcohol Possession and Use
- 1812: Alcohol Distribution
SS3C: Possession/Use or Distribution of Tobacco Products
This sub-report indicates all behavior events where the student committed a law violation or board violation related to the possession/use or distribution of tobacco products.
- All Board Violation codes related to tobacco products are reported, regardless of resolution:
- 9001: Smoking
- 9002: Chewing
- 9003: Tobacco – Other
- 9004: Alternative Nicotine Product
- 9005: Vapor Product
SS4: Bullying or Harassment
This sub-report indicates all behavior events where the student committed a law or board violation related to bullying or harassment.
- Only behavior events with one of the following Law Violation codes is reported:
- 340: Felony Stalking
- 341: Misdemeanor Stalking
- 350: Harassing Communications
- 370: Harassment
- Also, all behavior events with one of the following Board Violation codes is reported:
- 8001: Bullying
- 8002: Harassment (deprecated in Release Pack .1729)
- 8003: Threatening Staff
- 8004: Verbal Abuse
- 8006: Threatening another Student
SS5: State Resolutions not reported in SS1 - SS4
This sub-report indicates all behavior events where the student committed a law or board violation, not reported in sub-reports SS1-SS4 and has a State Resolution of SSP1, SSP2, SSP3, SSP5, SSP7, SSP8, INSR, IAES1 or IAES2.
- Only behavior events with one of the following Law Violation codes is reported: 50, 60, 70, 80, 95, 100, 110, 120, 130, 140, 160, 171, 190, 240, 260 or 280.
- Also, all behavior events with one of the following Board Violation codes is reported: 40, 60, 70, 110, 998, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1009, 1010, 1011, 1012, 1013, 1015, 1016, 1017, 1018, 1019, 2001, 2002, 5001, 5002, 5003 or 5004.
Validation Checks
Validations are included when users generate the report.
The report will generate in the State Format (CSV). An HTML validation page listing errors and warnings will appear first, with the option of selecting a Click Here button to display the actual report.
- Errors - Indicate problematic data that will not pull on the report.
- Warnings - Indicate potentially problematic data that will pull in the extract.
To go directly to a specific error or warning, select the hyperlink within the Error/Warning Table of Contents (see Image 3).
To generate all error/warning information into a CSV file, click the Export to CSV button (see Image 3).
Image 3: Error/Warning Table of Contents
Understanding Safe School Errors
The following is a list of errors that can appear when generating the report:
- Error 1: Resolutions - Missing End Dates and/or End Times
- Error 2: State Resolutions without a Law or Board Violation
- Error 3: Events without a Participant
- Error 4: Student has a Resolution Connected with a Behavior Incident Date outside of their Enrollment
Error 1: Resolutions - Missing Start/End Dates and/or Start/End Times
ER01: The following students have state resolutions without a start/end date and/or time. These behavior events will not pull on the report.
This error will appear any time a student has a State Resolution (SSP1, SSP2, SSP3, SSP5, SSP7, SSP8, INSR, IAES1 or IAES2) without a resolution start date/end date and/or start time/end time. Below is an example of reported error data.
| School | Incident Title | Incident Date | Incident Time | Referral Name | Status | State ID | Last Name | First Name | Grade | Event ID | Resolution ID | Res Start Date | Res Start Time | Res End Date | Res End Time | Resolution State Code |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Middle School | Disorderly Conduct | 02/04/2013 | 9:20 AM | Admin, System | IP | 1212121212 | Bluegrass | Kenny | 06 | 555870 | 579847 | 02/04/2013 | 8:54 AM | SSP1 |
Error 2: State Resolutions without a Law or Board Violation
ER02: The following students have a state resolution and the event does not have a law or board violation selected. These behavior events will not pull on the report.
This error will appear any time a student has a State Resolution (SSP1, SSP2, SSP3, SSP5, SSP7, SSP8 or INSR) and no selection of a Law or Board Violation. Below is an example of reported error data.
| School | Incident Title | Incident Date | Incident Time | Referral Name | Status | State ID | Last Name | First Name | Grade | Event ID | Event Type | Resolution ID | Resolution Type | Resolution State Code |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Middle School | Disorderly Conduct | 02/04/2013 | 9:25 AM | Admin, System | IP | 1212121212 | Bluegrass | Kenny | 06 | 555871 | 01B Skipping Class | 579848 | SSP1 Expelled, Receiving Services | SSP1 |
Error 3: Events without a Participant
ER03: The following events do not have a participant selected. These behavior events will not pull on the report.
This error will appear any time an event with a qualifying Law or Board Violation exists without a participant.
Below is an example of reported error data.
| School | Incident Title | Incident Date | Incident Time | Referral Name | Status | Event ID | Event Type |
|---|---|---|---|---|---|---|---|
| Middle School | Disorderly Conduct | 02/04/2013 | 7:59 AM | Admin, System | IP | 555872 | 08B Chewing Tobacco |
Error 4: Behavior Incident Date outside of Selected Calendar(s) Enrollments(s)
ER04: Student has a resolution connected with a Behavior Incident Date outside of the selected calendar(s) enrollment(s).
This error will appear for students with a qualifying behavior event, outside of any active selected calendar(s) enrollment, that had a resolution within their enrollment.
This error is expected if the school the student was enrolled in as of the incident date was not selected in the extract editor. If the error persists after running the report against the entire district, the error should be investigated.
A Safe School qualifying behavior event is one the meets the following logic:
- The Incident Date is not within an enrollment and the event has a Law or Board Violation Code which reports in sub-reports SS1-SS4 OR
- The Incident Date is not within an enrollment, the event has a Law or Board Violation Code not reported in sub-reports SS1-SS4 and a State Resolution of INSR, SSP1, SSP2, SSP3, SSP5, SSP7 or SSP8.
| School | Incident Title | Incident Date | Incident Time | Referral Name | Status | State ID | Last Name | First Name | Grade | Event ID | Event Type | Resolution ID | Resolution Type | Resolution End Date | Resolution State Code |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Middle School | Disorderly Conduct | 2/11/2013 | 9:15 AM | Admin, System | IP | 1212121212 | Bluegrass | Kenny | 06 | 12/12/2012 | 14B Bullying | 579777 | SSP3: Suspension | 03/13/2013 | SSP3 |
Understanding Safe School Warnings
The following is a list of warnings that can appear when generating the report:
- Warning 1: Out of School Suspension/Attendance Dates and/or Times Inconsistent
- Warning 2: Restraint or Seclusion Resolution without a Corresponding Behavior Response
- Warning 3: Student Behavior Resolution Date Not Within a District Enrollment
- Warning 5: Restraint or Seclusion Behavior Response without a Corresponding Resolution
Warning 1: Out of School Suspension/Attendance Dates and/or Times Inconsistent
WA01: Suspension/Attendance Dates and/or Times are Inconsistent. These events will pull on the report.
This warning will appear for students who received a state resolution of Out of School Suspension (SSP3) and are not marked absent using the 'S' state attendance code for every minute of the SSP3 behavior resolution. Days not marked as both Instructional and Attendance are ignored.
Below is an example of reported warning data.
This warning will not appear for State Editions of Campus because Attendance data is not synced to the State Edition. Events that appear within Warning 1 at the District level will pull on the Safe Schools CSV report in State Edition.
| School | Incident Title | Incident Date | Incident Time | Referral Name | Status | State ID | Last Name | First Name | Grade | Event ID | Event Type | Resolution ID | Resolution Type | Res Start Date | Res Start Time | Res End Date | Res End Time |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Middle School | Disorderly Conduct | 9/11/2013 | 9:23 AM | Admin, System | IP | 1212121212 | Bluegrass | Kenny | 06 | 555874 | 01B Skipping Class | 579849 | SSP3 Out of School Suspension | 9/12/2013 | 9:17 AM |
Warning 2: Restraint or Seclusion Resolution without a Corresponding Behavior Response
WA02: The following students have a behavior resolution of SSP7: Restraint or SSP8: Seclusion without a corresponding Behavior Response of Restraint or Seclusion. These behavior events will pull on the report.
This warning will appear for students who have a Behavior Resolution of SSP7: Restraint or SSP8: Seclusion without a Corresponding Behavior Response of Restraint or Seclusion.
- Only Resolution Types mapped to a state code of SSP7 or SSP8 can trigger this warning.
- The event cannot also have a Response Type mapped to a state code of SSP7 or SSP8 in order to trigger the error.
- Response State Code can return blank
| School | Incident Title | Incident Date | Incident Time | Referral Name | Status | State ID | Last Name | First Name | Event ID | Event Type | Resolution ID | Resolution State Code | Resolution State Code |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Middle School | Disorderly Conduct | 2/11/2013 | 7:59 AM | Admin, System | IP | 1212121212 | Bluegrass | Kenny | 555876 | 09L: Mooning | 579777 | SSP8 |
Warning 3: Student Behavior Resolution Date Not Within a District Enrollment
WA03: Student behavior resolution start date is not within a district enrollment. These events will pull on the report.
This warning will appear for students who have a behavior event within the current enrollment that is linked to a behavior resolution outside of their enrollment start and end dates within the district.
Below is an example of reported warning data.
| School | Incident Title | Incident Date | Incident Time | Referral Name | Status | State ID | Last Name | First Name | Grade | Event ID | Event Type | Resolution ID | Resolution Type | Res Start Date | Res Start Time | Res End Date | Res End Time | Resolution State Code |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Middle School | Disorderly Conduct | 2/11/2013 | 7:59 AM | Admin, System | IP | 1212121212 | Bluegrass | Kenny | 06 | 555876 | 08B Chewing Tobacco | 579850 | Office Time Out | 12/12/2012 | 12:04 PM |
Warning 5: Restraint or Seclusion Behavior Response without a Corresponding Resolution
WA05: The following students have a behavior response of Restraint or Seclusion without a corresponding State Resolution of SSP7: Restraint or SSP8: Seclusion. These behavior events will pull on the report. on the report.
This warning is a list of all students who have a Behavior Response of Restraint or Seclusion without a Corresponding State Resolution of SSP7: Restraint or SSP8: Seclusion.
- Incidents must have a Response Type mapped to a state code of SSP7 or SSP8 to trigger this warning.
- If the Response Type is mapped to a state code of SSP7, the incident must have a Resolution Type mapped to the state code of SSP7 to not appear on this warning and pull into the report.
- If the Response Type is mapped to a state code of SSP8, the incident must have a Resolution Type mapped to the state code of SSP8 to not appear on this warning and pull into the report.
| School | Incident Title | Incident Date | Incident Time | Submitted By | Status | State ID | Last Name | First Name | Event ID | Event Type | Resolution State Code | Response State Code |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Middle School | Disorderly Conduct | 2/11/2013 | 8:15 AM | Tom, Johnson | IP | 1212121212 | Bluegrass | Kenny | 555877 | 09L: Mooning | SSP3 | SSP7 |
Report Layout
The extract is sorted by district number, then school number, then sub-report, then law violation code, then board violation code, then student ID.
Element Name | Description | Type, Format and Length | Campus Database | Campus Interface |
|---|---|---|---|---|
District Number | Identifies the district's unique identification number. | Numeric, 3 digits | District.number | System Administration > Resources > District Information > State District Number |
| District Name | The reporting student's district name. | Text | District.name | System Administration > Resources > District Information > Name |
School Number | Identifies the school's unique identification number. | Numeric, 3 digits | School.number | System Administration > Resources > School > School Detail > Location Number |
| School Name | The reporting student's school name. | Text | School.name | System Administration > Resources > School > Name |
State Student ID | Identifies the ten-digit state-assigned student identification number of the offender/participant connected with the event. | Numeric, 10 digits | Person.stateID | Census > People > Demographics > Person Identifiers > State ID |
State Grade | Identifies the student's State Grade code of enrollment. | Alphanumeric, 3 digits | Gradelevel.stateGrade | Census > People > Enrollments > Grade Student Information > General > Enrollments > Grade |
Last Name | Identifies the student's last name. | Alphanumeric, 30 characters | Identity.lastName | Census > People > Demographics > Person Information > Last Name |
First Name | Identifies the student's first name. | Alphanumeric, 30 characters | Identity.firstName | Census > People > Demographics > Person Information > First Name |
Gender ID | Indicates the student's gender. | Text, 1 character | Identity.gender | Census > People > Demographics > Person Information > Gender |
Date of Birth | Identifies Student's date of birth. | Date field, 10 characters | Identity.birthdate | Census > People > Demographics > Person Information > Birth Date |
Race ID | Indicates the student's federally designated race/ethnicity.
If Race ID is blank/null, report blank. | Text Output code and description | Identity.raceEthnicityFed | Census > People > Identity > Race/Ethnicity |
Economic Status | Identifies whether the student is approved to receive free or reduced meals on the day of the reported incident.
| Text Output code and description | POSEligibility.eligibility | FRAM > Eligibility > Eligibility |
Active Special Education | Indicates whether the student had an active, locked IEP on December 1st of the reporting year. If December 1 falls on a weekend, the IEP needs to have been active and locked on the Friday previous to December 1 (November 29th or November 30th). | Numeric, 1 digit | Calculated field Logic looks for an active Plan record | Student Information > Special Education > Documents > IEP > Education Plan > Start Date, End Date |
| Primary Disability | Reports students Primary Disability as indicated on student’s active, locked IEP on Dec. 1 of the reporting year. If Active Special Education = Yes; populate Primary Disability based on the value selected on their IEP:
| Text. 2-3 characters | Calculated Field Logic checks for a locked, active IEP record as of December 1st of the reporting year. Primary Disability is reported from that IEP. | Student Information > Special Ed > Documents Student Information > Special Ed > Documents > IEP > Enrollment Status >Primary Disability |
| English Learner (EL) | Reports students EL status of the offender/participant. Eligible EL records must meet the following criteria:
| Output Y or N | Calculated Field | Student Information > Program Participation > English Learners (EL) > EL > Program Status Student Information > Program Participation > English Learners (EL) > EL Accommodations > Type |
| Program 504 | Reports students indicated as Program 504. | Output Y or N | Enrollment.section504 | Student Information > General > Enrollment > State Reporting Fields > 504 |
Incident ID | Identifies the unique ID associated with the behavior incident. | Numeric, 6 digits | BehaviorIncident. | Behavior > Behavior Management Tool > Incident |
Incident Date | Identifies the date of the behavior incident. | Date field, 10 characters | BehaviorIncident. | Behavior > Behavior Management Tool > Date |
Incident Time | Identifies the time the incident occurred. | Time field, 5 characters | BeahviorIncident. | Behavior > Behavior Management Tool > Incident > Time |
| Context | The context for the behavior incident. The Context code is reported:
| Alphanumeric, 2 characters | BehaviorIncident. context | Behavior > Behavior Management Tool > Incident > Context |
| Event Location | The location of the behavior incident. The Location code is reported:
| Text Code and description | BehaviorIncident. location | Behavior > Behavior Management Tool > Incident > Location |
Event ID | Identifies the unique behavior event ID. | Numeric, 5 digits | BehaviorEvent.eventID | Behavior > Behavior Management Tool > Incident > Event ID |
| Role | Reports the role assigned to the student in the behavior event. O = Offender | Alpha, 1 character | BehaviorRole.role | Behavior > Behavior Management Tool > Incident > Event > Role |
Board Violation Code | Identifies the numeric code and description assigned to the chosen board violation. See Board Violation Codes for options. | Text Code and description | BehaviorEvent. | Behavior > Behavior Management Tool > Incident > Event > Board Violation |
Law Violation Code | Identifies the numeric code and description assigned to the chosen law violation. See Law Violation Codes for options. | Text Code and description | BehaviorEvent. | Behavior > Behavior Management Tool > Incident > Event > Law Violation |
Call to Police | Indicates police were called as a result of the event. | Numeric, 1 digit | BehaviorEvent. | Behavior > Behavior Management Tool > Incident > Event > Call to Police |
Arrest | Indicates an arrest was made as a result of the event. | Numeric, 1 digit | BehaviorRole.arrest | Behavior > Behavior Management Tool > Incident > Event > Participant > Arrest |
Charges | Indicates charges were filed as a result of the event. | Numeric, 1 digit | BehaviorRole.charge | Behavior > Behavior Management Tool > Incident > Event > Charges Filed |
Gang Related | Indicates the event was gang-related. | Numeric, 1 digit | BehaviorEvent. | Behavior > Behavior Management Tool > Incident > Event > Gang Related |
Civil Proceedings | Indicates the event caused a civil proceeding to occur. | Numeric, 1 digit | BehaviorRole. | Behavior > Behavior Management Tool > Incident > Event > Participant > Civil Proceedings |
| School Resource Office | Indicates whether or not a School Resource Office (SRO) was involved in the behavior event. 1 : Yes | Numeric, 1 digit | BehaviorEvent. schoolResourceOfficer | Behavior > Behavior Management Tool > Incident > Event > School Resource Officer |
| Court Designated Worker | Indicates whether or not a Court Designed Worker reported the behavior event. 1 : Yes | Numeric, 1 digit | BehaviorEvent. courtDesignatedWorker | Behavior > Behavior Management Tool > Incident Event > Court Designated Worker |
| Harassment Type | Reports the type of harassment for events where the law or board violation is classified as harassment.
| Output Code and Description | BehaviorHarassment. harassmentType | Behavior > Behavior Management Tool > Incident > Event > Participant > Harassment Type |
Resolution State Code | Indicates the code associated with the resolution. The event will only be reported if resolution is one of the following:
Reports blank if State Resolution Code is null. | Text Code and description | BehaviorResType. | Behavior > Behavior Management Tool > Incident > Resolution > State Code |
| Resolution Type | The local district resolution type. If Resolution Type is blank/null, a blank value is reported. | Text | BehaviorResType. resolutionName | Behavior > Behavior Management Tool > Incident > Resolution > Resolution Type |
Resolution Start Date | Identifies the date the resolution began. | Date field, 10 characters | BehaviorResolution. | Behavior > Behavior Management Tool > Incident > Resolution > Resolution Start Date |
Resolution Start Time | Identifies the time the resolution began. | Time field, 5 characters | BehaviorResolution. | Behavior > Behavior Management Tool > Incident > Resolution > Resolution Start Time |
Resolution End Date | Identifies the date the resolution ended and the student returned to school (if applicable). | Date field, 10 characters | BehaviorResolution. | Behavior > Behavior Management Tool > Incident > Resolution > Resolution End Date |
Resolution End Time | Identifies the time the resolution ended and the student returned to school (if applicable). | Time field, 5 characters | BehaviorResolution. | Behavior > Behavior Management Tool > Incident > Resolution > Resolution End Time |
| Resolution Length in School Days | Indicates the length of the behavior resolution in school days. This field is calculated based on the resolution start date and end dates compared to school days in the calendar. Each date that contains any portion of the resolution will count as a date. Whole numbers only with a maximum of 3 digits. A value entered in the Duration in School Days field in the behavior resolution does not overrule the calculated value. | Numeric, 3 digits | Calculated, not dynamically stored | N/A |
| Sub-Report | Indicates which Safe Schools sub-report the event qualifies for.
| Alphanumeric, 3 characters | Calculated field based on Safe Schools selection criteria. | N/A |
| Distinct Count | This field reports a value of 1 for first row where the State ID/Event ID combination is unique. Subsequent rows where State ID/Event ID combination is duplicated reports a value of 0. | Numeric, 1 digit 1 or 0 | Calculated | N/A |
Law Violation Codes
Sub-report colors only serve to help users easily identify which codes apply to which sub-reports.
Code | Description | Sub-Report |
|---|---|---|
11 | Criminal Homicide | SS1 |
20 | Forcible Rape | SS1 |
30 | Robbery | SS1 |
50 | Burglary | SS5 |
60 | Larceny – Theft | SS5 |
70 | Motor Vehicle Theft | SS5 |
| 75 | Kidnapping | SS1 |
| 80 | Destruction of Property | SS5 |
90 | Arson | SS1 |
| 95 | Trespassing | SS5 |
100 | Forgery | SS5 |
110 | Fraud | SS5 |
120 | Embezzlement | SS5 |
130 | Stolen Property | SS5 |
| 140 | Vandalism | SS5 |
| 151 | Weapon - Handgun | SS2 |
152 | Weapon – Riffle | SS2 |
153 | Weapon/Other Firearm | SS2 |
154 | Weapon – Other | SS2 |
160 | Prostitution | SS5 |
171 | Indecent Exposure | SS5 |
172 | Statutory Rape | SS1 |
174 | Sexual Assault (unwanted touching in a sexual manner) | SS1 |
| 175 | Sexual Offenses, Other | SS1 |
190 | Gambling | SS5 |
210 | DUI | SS3B |
230 | Under Influence | SS3B |
240 | Disorderly Conduct | SS5 |
260 | Other | SS5 |
280 | Loitering | SS5 |
301 | 1st Degree Assault | SS1 |
302 | 2nd Degree Assault | SS1 |
303 | 3rd Degree Assault | SS1 |
304 | 4th Degree Assault | SS1 |
305 | Menacing | SS1 |
306 | Felony Wanton Endangerment | SS1 |
307 | Misdemeanor Wanton Endangerment | SS1 |
308 | Felony Criminal Abuse | SS1 |
309 | Misdemeanor Criminal Abuse | SS1 |
310 | Terroristic Threat | SS1 |
320 | Terroristic – Bomb | SS1 |
330 | Terroristic-Ch/Bio/Nuc | SS1 |
340 | Felony Stalking | SS4 |
341 | Misdemeanor Stalking | SS4 |
350 | Harassing Communications | SS4 |
| 360 | Abuse of a Teacher | SS1 |
1801 | Other Drug Possession and Use | SS3A |
1802 | Other Drug Distribution | SS3A |
1811 | Alcohol Possession and Use | SS3B |
1812 | Alcohol Distribution | SS3B |
1821 | Marijuana/Hashish Possession and Use | SS3A |
1822 | Marijuana Use | SS3A |
1831 | Hallucinogenic Possession and Use | SS3A |
1832 | Hallucinogenic Distribution | SS3A |
1841 | Amphetamines Possess and Use | SS3A |
1842 | Amphetamines Distribution | SS3A |
1851 | Barbiturates Possession and Use | SS3A |
1852 | Barbiturates Distribution | SS3A |
1861 | Heroin Possession and Use | SS3A |
1862 | Heroin Distribution | SS3A |
1871 | Cocaine/Crack Possession and Use | SS3A |
1872 | Cocaine/Crack Distribution | SS3A |
1881 | Prescription Drugs Possession and Use | SS3A |
1882 | Prescription Drugs Distribution | SS3A |
1891 | Inhalant Possess and Use | SS3A |
1892 | Inhalant Distribution | SS3A |
| 1901 | Synthetic Drugs Possession and Use | SS3A |
| 1902 | Synthetic Drugs Distribution | SS3A |
| 2000 | IAES for Weapon - SPED Only | SS2 |
| 2001 | IAES for Drugs - SPED Only | SS3A |
| 2003 | IAES for Injury - SPED Only | SS1 |
Board Violation Codes
Sub-report colors only serve to help users easily identify which codes apply to which sub-reports.
Code | Description | Sub-Report |
|---|---|---|
40 | Failure to Attend Detention | SS5 |
60 | Inappropriate Sexual Behavior | SS5 |
70 | Profanity or Vulgarity | SS5 |
110 | Dangerous Instruments (carrying or use) | SS5 |
998 | Other | SS5 |
1001 | Cheating | SS5 |
1002 | Dress Code Violation ( Deprecated) | SS5 |
1003 | Leaving Campus | SS5 |
1004 | Skipping Class | SS5 |
1005 | Skipping School | SS5 |
1006 | Tardy to Class | SS5 |
1007 | Truancy | SS5 |
1008 | Signing Parent/Staff Note | SS5 |
1009 | Stealing | SS5 |
1010 | Failure to Follow Staff Instructions | SS5 |
| 1011 | Disrespectful Behavior | SS5 |
| 1012 | Inappropriate Use of Districts or School Technology | SS5 |
| 1013 | Violation of Personal Electronic/Telecommunication Device | SS5 |
| 1014 | Look-alike Drug Possession, Distribution | SS3A |
2001 | Disruptive Behavior | SS5 |
2002 | Bus Disturbance | SS5 |
5001 | Fighting – Student to Student (physical aggression) | SS5 |
5002 | Fighting – Student to Staff (physical aggression) | SS5 |
5003 | Fighting – Student to Other (physical aggression) | SS5 |
| 5004 | Self-Endangerment | SS5 |
8001 | Bullying | SS4 |
8002 | Harassment (deprecated in Release Pack .1729) | SS4 |
8003 | Threatening Staff | SS4 |
8004 | Verbal Abuse | SS4 |
| 8006 | Threatening another Student | SS4 |
9001 | Smoking | SS3C |
9002 | Chewing | SS3C |
9003 | Tobacco – Other | SS3C |
| 9004 | Alternative Nicotine Product | SS3C |
| 9005 | Vapor Product | SS3C |
