Safe Schools (Kentucky) [.2211 - 2307]

PATH: KY State Reporting > Safe Schools 

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.

The aggregate reports provide schools and districts with aggregate counts of behavior incidents by type, location and context, count of behavior resolutions, and legal sanctions.

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.

Image 1: Safe Schools Editor

Selection 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 State Event 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.

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. 
  • The report will pull incidents that match selection criteria when they have a status of 'In Progress' or 'Complete' in the Behavior Management tool.
  • The report will report incidents/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.
  • 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
    • INDR: In-District Removal
    • INSR: In-School Removal
  • For the Aggregate Reports - If no qualifying data exist, produce a row with zero counts at all levels. 
    • Do not report a row for schools without a calendar in the reporting year.
    • Do not report a row for grade levels not offered in the school’s calendars.
  • Aggregate Report output file when run in the Kentucky State Edition will exclude the Kentucky Tech System district (#777).
  • A Behavior Response of Restraint or Seclusion must include a State Mapped Resolution of SSP7: Restraint or SSP8: Seclusion to appear in the extract.

Generating the Report

  1. Select the Extract Type:
    • Detail - This report provides a summary of behavior events and resolutions for the selected calendar(s).
    • Aggregate School Level - This report details aggregate Safe Schools data for the entire school.
    • Aggregate District Level - This report details aggregate Safe Schools data for the entire district.
    • Aggregate State Level - This report details aggregate Safe Schools data for the entire state. Note: This option is only available in the Kentucky State Edition of Infinite Campus.
  2. Select the Format in which the report should be generated. The State Format (CSV) is the only available option.
  3. Enter the Date Range. Only data within this date range within the selected calendar(s) is reported.
  4. 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.
  5. Mark the Active Special Ed at Time of Incident checkbox to only report students with a qualifying safe schools event who were considered active Special Education at the time of the incident (optional).
  6. Select which Grade(s) will report data OR select an Ad Hoc Filter.
  7. Select the Calendar(s) to include in the extract.
  8. 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.
  9. 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. 

    Submit to Batch will bypass the HTML Validation Report which contains the Warnings and Errors that may be present within the data.

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 State Event Codes table 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 State Event 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: Other Events Resulting in State Resolutions  

SS1: Assault or Violence 

This sub-report indicates all behavior events where the student committed a State Event code Mapping related to assault or violence (regardless of resolution).

  • Only behavior events with one of the following State Event Code Mappings is reported: 
    • V01: 1st Degree Assault
    • V02: 2nd Degree Assault
    • V03: 3rd Degree Assault
    • V04: 4th Degree Assault
    • V05: Abuse of a Teacher
    • V06: Arson
    • V07: Criminal Abuse
    • V08: Homicide
    • V09: Kidnapping
    • V10: Menacing
    • V11: Rape
    • V12: Robbery/Theft
    • V13: Sexual Assault
    • V14: Sexual Offense (non-touch)
    • V15: Terroristic - Bomb
    • V16: Terroristic Threat
    • V17: Terroristic-Chem/Bio/Nuc
    • V18: Wanton Endangerment

SS2: Possession of Guns or other Deadly Weapons

This sub-report indicates all behavior events where the student committed a State Event Code related to the possession of a deadly weapon (regardless of resolution).

  • Only behavior events with one of the following State Event Code Mappings is reported:
    • W01: Weapon Possession
    • W02: Weapon Distribution
    • W03: Weapon Use

SS3A: Possession/Use or Distribution of Drugs

This sub-report indicates all behavior events where the student committed a State Event Code related to the possession, use, or distribution of a drug (regardless of resolution).

  • Only behavior events with one of the following State Event Code Mappings is reported: 
    • D01: Drug Distribution
    • D02: Drug Possession
    • D03: Drug Use

SS3B: Possession/Use or Distribution of Alcohol

This sub-report indicates all behavior events where the student committed a State Event Code related to the possession, use, or distribution of alcohol (regardless of resolution).

  • Only behavior events with one of the following State Event Code Mappings is reported: 
    • A01: Alcohol Distribution
    • A02: Alcohol Possession
    • A03: Alcohol Use

SS3C: Possession/Use or Distribution of Tobacco Products

This sub-report indicates all behavior events where the student committed a State Event Code related to the possession, use, or distribution of tobacco products.

  • Only behavior events with one of the following State Event Code Mappings is reported: 
    • T01: Tobacco Distribution
    • T02: Tobacco Possession
    • T03: Tobacco Use

SS4: Bullying or Harassment

This sub-report indicates all behavior events where the student committed a State Event Code related to bullying or harassment.

  • Only behavior events with one of the following State Event Code Mappings is reported: 
    • H01: Bullying
    • H02: Harassing Communications
    • H03: Harassment
    • H04: Stalking
    • H05: Threatening another Student
    • H06: Threatening Staff
    • H07: Verbal Abuse

SS5: Other Events Resulting in State Resolutions

This sub-report indicates all behavior events not reported in sub-reports SS1-SS4 and have a State Resolution of SSP1, SSP2, SSP3, SSP5, SSP7, SSP8, INDR, INSR, IAES1 or IAES2.

  • Only behavior events with one of the following State Event Code Mappings is reported:
    • N01: Academic Cheating/Plagiarism
    • N02: Attendance Policy Violation
    • N03: Burglary
    • N04: Bus Rule Violation
    • N05: Dangerous Instrument Possession
    • N06: Destruction of Property
    • N07: Disorderly Conduct
    • N08: Disrespectful Behavior
    • N09: Disruptive Behavior
    • N10: Dress Code Incident
    • N11: Drug Paraphernalia Violation
    • N12: Failure to Attend Detention
    • N13: Fighting - Student to Other (physical aggression)
    • N14: Fighting - Student to Staff (physical aggression)
    • N15: Fighting - Student to Student (physical aggression)
    • N16: Forgery
    • N17: Fraud
    • N18: Gambling
    • N19: Insubordination
    • N20: Leaving Campus
    • N21: Loitering
    • N22: Motor Vehicle Theft
    • N99: No State Violation
    • N23: Out of Area Violation
    • N24: Possession of Stolen Property
    • N25: Profanity or Vulgarity
    • N26: Self-Endangerment
    • N27: Skipping Class
    • N28: Skipping School
    • N29: Tardy to Class
    • N30: Theft/Stealing
    • N31: Trespassing
    • N32: Truancy
    • N33: Vandalism
    • N34: Violation of District Acceptable Use Policy
    • N35: Violation of Personal Electronic/Telecommunication Device Policy

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. 

Submit to Batch will bypass the HTML Validation Report detailing the Errors and Warnings within 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 State Event Code 
  • Error 3: Events without a Participant
  • Error 4: Behavior Incident Date outside of Selected Calendar(s) Enrollments(s)
  • Error 5: Suspension Attendance without a Corresponding SSP3 Resolution
  • Error 6: Restraint or Seclusion Behavior Response without a Corresponding Resolution

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, INDR, 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.

Image 4: Example of Error 1

Error 2: State Resolutions without a State Event Code

ER02: The following students have a state resolution and the event does not have a state event code. 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, INDR, INSR, IAES1 or IAES2) associated with an Event Type not mapped to a State Event Code. Below is an example of reported error data.

Image 5: Example of Error 2

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.

 

Image 6: Example of Error 3

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 IAES1, IAES2, INDR, INSR, SSP1, SSP2, SSP3, SSP5, SSP7 or SSP8.

Image 7: Example of Error 4

Error 5: Suspension Attendance without a Corresponding SSP3 Resolution

ER05: Suspension Attendance exists outside of an SSP3 Resolution. These events will not pull on the report.

This error will appear for students with Suspension Attendance records outside of an SSP3 resolution time period. 

  • This includes a list of students who have a state attendance code of 'S: Suspension' in their attendance tab and do not have a corresponding SSP3 Resolution for the entire time of their suspension attendance.
  • This error will appear if the student has an 'S: Suspension' attendance outside of an SSP3 resolution time period. 

Image 8: Example of Error 5

Error 6: Restraint or Seclusion Behavior Response without a Corresponding Resolution

ER06: The following students are missing either a Behavior Response of Restraint or Seclusion or their corresponding State Resolutions of SSP7 or SSP8. These behavior events will not pull on the report.

This error will appear any time a student has 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 error.
    • If the Response Type is mapped to a state code of SSP7, the incident must not have a Resolution Type mapped to the state code of SSP7 to appear in this error.
    • If the Response Type is mapped to a state code of SSP8, the incident must not have a Resolution Type mapped to the state code of SSP8 to appear in this error.

This error will appear any time a student has a State Resolution of SSP7: Restraint or SSP8: Seclusion without a Corresponding Behavior Response of Restraint or Seclusion.

  • Incidents must have a State Resolution Type mapped to a state code of SSP7 or SSP8 to trigger this error.
    • If the Resolution Type is mapped to a state code of SSP7, the incident must not have a Response Type mapped to the state code of SSP7 to appear in this error.
    • If the Resolution Type is mapped to a state code of SSP8, the incident must not have a Response Type mapped to the state code of SSP8 to appear in this error.

Image 9: Example of Error 6

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

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 and the resolution time period does not overlap a shortened day in the calendar.

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.

SchoolIncident TitleIncident DateReferral NameStatusState IDLast NameFirst NameGradeEvent IDEvent TypeResolution IDResolution TypeRes Start DateRes Start TimeRes End DateRes End TimeSuspension Attendance Start DateSuspension Attendance Start TimeSuspension Attendance End DateSuspension Attendance End Time
Middle SchoolDisorderly Conduct9/11/2013Admin, SystemIP1212121212BluegrassKenny0655587401B Skipping Class579849SSP3 Out of School Suspension9/12/20139:17 AM

9/12/20139:20 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
SchoolIncident TitleIncident DateReferral NameStatusState IDLast NameFirst NameEvent IDEvent TypeResolution IDResolution State CodeResolution State Code
Middle SchoolDisorderly Conduct2/11/2013Admin, SystemIP1212121212BluegrassKenny55587609L: Mooning579777 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. Resolutions that are not state-mapped will not trigger a warning. 

Below is an example of reported warning data.

SchoolIncident TitleIncident DateReferral NameStatusState IDLast NameFirst NameGradeEvent IDEvent TypeResolution IDResolution TypeRes Start DateRes Start TimeRes End DateRes End TimeResolution State Code
Middle SchoolDisorderly Conduct2/11/2013Admin, SystemIP1212121212BluegrassKenny0655587608B Chewing Tobacco579850Office Time Out12/12/201212:04 PM   SSP3

Detail 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 NameDescriptionLocation
School Year

The academic year of the reporting behavior data.

Logic concatenates the calendar start year and end year.

Calendar.StartYear

Calendar.EndYear 

District Number

Identifies the district's unique identification number.

System Administration > Resources > District Information > State District Number


District.number

District NameThe reporting student's district name.System Administration > Resources > District Information > Name

District.name

School Number

Identifies the school's unique identification number.

System Administration > Resources > School > School Detail > Location Number


School.number

School NameThe reporting student's school name.System Administration > Resources > School > Name

School.name
State ClassificationThe school's classification.System Administration > Resources > School > State Classification

School.stateClassification

State Student ID

Identifies the ten-digit state-assigned student identification number of the offender/participant connected with the event.

Census > People > Demographics > Person Identifiers > State ID


Person.stateID

State Grade

Identifies the student's State Grade code of enrollment.

Census > People > Enrollments > Grade

Student Information > General > Enrollments > Grade


Gradelevel.stateGrade

Last Name

Identifies the student's last name.

Census > People > Demographics > Person Information > Last Name


Identity.lastName

First Name

Identifies the student's first name.

Census > People > Demographics > Person Information > First Name


Identity.firstName

Gender ID

Indicates the student's gender.

M = Male
F = Female

Census > People > Demographics > Person Information > Gender


Identity.gender

Race ID

Indicates the student's federally designated race/ethnicity. 

  • 1: Hispanic/Latino
  • 2: American Indian or Alaskan Native
  • 3: Asian
  • 4: Black or African American
  • 5: Native Hawaiian or Other Pacific Islander
  • 6: White
  • 7: Two or More Races

If Race ID is blank/null, report blank.

Census > People > Identity > Race/Ethnicity


Identity.raceEthnicityFed

Economic Status

Identifies whether the student is approved to receive free or reduced meals on the day of the reported incident.

  • A = Non-reimbursable
  • F = Free
  • R = Reduced
  • S = Paid
  • If no FRAM Eligibility record exists with a date range which includes the incident date, a value of S is reported.

FRAM > Eligibility > Eligibility


POSEligibility.eligibility

Active Special Education

Indicates whether the student had an active, locked IEP as of the day of the incident.

1 = Yes 
2 = No (default value) 

A student is considered active in Special Education in this report if they have an active, locked IEP as of the date of the incident.

Student Information > Special Education > Documents > IEP > Education Plan > Start Date, End Date


Calculated field


Logic checks for a locked, active IEP record, not a particular field.


Eligible SPED Records
If…Person has at least one record in the Plan table where  typeID has planType.module = ‘specialed’ AND  plan.locked = 1

AND (plan.startDate <= incident date AND (plan.endDate >= incident date OR plan.endDate is NULL))

AND Plan.disability1 is NOT NULL AND

PlanState.specialEdStatus is NOT NULL AND

PlanState.specialEdSetting is NOT NULL
Primary Disability

Reports students Primary Disability as indicated on student’s active, locked IEP on the date the incident occurred. 

If Active Special Education = Yes; populate Primary Disability based on the value selected on their IEP:

  • 1: Mild Mental Disability = MMD
  • 2: Functional Mental Disability = FMD
  • 4: Hearing Impaired = HI
  • 5: Speech Language = SL
  • 6: Visually Impaired = VI
  • 7: Emotional Behavior Disability = EBD
  • 8: Orthopedically Impaired = OI
  • 9 Other Health Impaired = OHI
  • 10: Specific Learning Disability = SLD
  • 11: Deaf Blind = DB
  • 12: Multiple Disabilities = MD
  • 13: Autism = AUT
  • 14: Traumatic Brain Injury = TBI
  • 15: Developmentally Delayed = DD

Student Information > Special Ed > Documents

Student Information > Special Ed > Documents > IEP > Enrollment Status > Primary Disability


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.

English Learner (EL)

Reports students EL status of the offender/participant.

Eligible EL records must meet the following criteria:

  • Home Primary Language <> 0400 OR <> NULL AND
  • Person has at least one record in the LEP table where programStatus = ‘LEP’ AND exitDate = NULL OR >= ’incident date’ AND
  • Person has at least one record in the LepService table where lepServiceTypeID <> NULL AND
  • LepService startDate <= ‘incident date’ AND
  • LepService endDate = NULL OR >= ‘incident date’ AND
  • Person has at least one record in the LepAccomodationType table where type = ‘I’ AND
  • LepAccommodation.startDate <= ‘incident’ AND
  • LepAccommodation.endDate = NULL OR >= ‘incident date’

Student Information > Program Participation > English Learners (EL) > EL > Program Status

Student Information > Program Participation > English Learners (EL) > EL Accommodations > Type



Calculated Field
Program 504Reports students indicated as Program 504.Student Information > General > Enrollment > State Reporting Fields > 504

Enrollment.section504
Homeless Status

Indicates if the student is identified as homeless.


Report Y, if any homeless record from the same district overlaps the incident date,

Else report N

Student Information > General > Program Participation > Homeless


Homeless.StartDate

Homeless.EndDate

Homeless.DistrictID

Foster Care

Reports if student was in Foster Care at the time of the incident.


Report Y, if any foster care record from the same district overlaps the incident date,

Else report N

Student Information > General > Program Participation > Foster Care


FosterCare.StartDate

FosterCare.EndDate

FosterCare.DisrictID

Gifted and Talented

Reports if student was Gifted & Talented at the time of the incident. 

Primary Talent Pool (Category = 12) is only valid for grades 00-03.

  • Report Y, if any gifted record from the same district overlaps the incident date AND
  • (State Grade (DE.7) is 00-03 and Category = 12) OR 
  • (State Grade (DE.7) is 04-12 and Category <> 12),
  • Else report N

Student Information > General > Program Participation > Gifted & Talented


giftedstatusKY.StartDate

giftedstatusKY.EndDate

giftedstatusKY.Category

giftedstatusKY.DisrictID

Migrant

Reports if student was Migrant at the time of the incident.

  • Report Y, if any migrant record from the same district overlaps the incident date,
  • Else report N

Student Information > General > Program Participation > Migrant


Migrant. lastQualifyingArrivalDate

Migrant. eligibilityExpirationDate

Migrant.DisrictID
Military Connected

Reports if student was Military Connected at the time of the incident.

  • Report Y, If the student has at least one record in the v_StudentMilitaryConnectionsSummary table overlaps the incident date AND Status like ‘%active duty,%’,
  • Else report N

Census > People > Military Connections


V_StudentMilitary
ConnectionsSummary.StartDate

V_StudentMilitary
ConnectionsSummary.EndDate

V_StudentMilitary
ConnectionsSummary.DisrictID

Incident ID

Identifies the unique ID associated with the behavior incident.

Behavior > Behavior Management Tool > Incident


BehaviorIncident.
incidentID

Incident Date

Identifies the date of the behavior incident.

Behavior > Behavior Management Tool > Date


BehaviorIncident.
incidentDate

Incident Time

Identifies the time the incident occurred.

Behavior > Behavior Management Tool > Incident > Time


BeahviorIncident.
timestamp

Context

The context for the behavior incident.

The Context code is reported:

  • SS: School sponsored event, during school hours
  • SN: School sponsored event, not during school hours
  • NS: Non-school sponsored event, during school hours
  • NN: Non-school sponsored event, not during school hours
Behavior > Behavior Management Tool > Incident > Context

BehaviorIncident.
context
Event Location

The location of the behavior incident.

The Location code is reported:

  • SSL1: Classroom 
  • SSL2: Bus 
  • SSL3: Hallway/Stairwell 
  • SSL4: Cafeteria 
  • SSL5: Campus Grounds 
  • SSL6: Off-Campus 
  • SSL7: Restroom 
  • SSL8: Gymnasium
  • SSL9: Office
  • SSL10: Athletic Field
  • SSL11: Playground
  • SSL12: Field Trip
  • SSL13: Other
Behavior > Behavior Management Tool > Incident > Location

BehaviorIncident.
location

Event ID

Identifies the unique behavior event ID.

Behavior > Behavior Management Tool > Incident > Event ID


BehaviorEvent.eventID

Role

Reports the role assigned to the student in the behavior event.

O = Offender
P = Participant 

Behavior > Behavior Management Tool > Incident > Event > Role

BehaviorRole.role
State Event Code MappingIndicates the State Event Code (Mapping) aligned to the behavior event.Behavior Management >  > Event  > Event Type > State Event Code (Mapping)

Behavior.stateEventCode

Call to Police

Indicates police were called as a result of the event.

1: Yes
0: No or Null

Behavior > Behavior Management Tool > Incident > Event > Call to Police


BehaviorEvent.
policeNotified

Arrest

Indicates an arrest was made as a result of the event.

1: Yes
0: No or Null

Behavior > Behavior Management Tool > Incident > Event > Participant > Arrest


BehaviorRole.arrest

Charges

Indicates charges were filed as a result of the event.

1: Yes
0: No or Null

Behavior > Behavior Management Tool > Incident > Event > Charges Filed


BehaviorRole.charge

Gang Related

Indicates the event was gang-related.

1: Yes
0: No or Null

Behavior > Behavior Management Tool > Incident > Event > Gang Related


BehaviorEvent.
gangRelated

Civil Proceedings

Indicates the event caused a civil proceeding to occur.

1: Yes
0: No or Null

Behavior > Behavior Management Tool > Incident > Event > Participant > Civil Proceedings


BehaviorRole.
civilProceedings

School Resource Office

Indicates whether or not a School Resource Office (SRO) was involved in the behavior event.

1 : Yes
0 : No or Null

Behavior > Behavior Management Tool > Incident > Event > School Resource Officer

BehaviorEvent.
schoolResourceOfficer
Court Designated Worker

Indicates whether or not a Court Designed Worker reported the behavior event.

1 : Yes  
0 : Not checked or Null

Behavior > Behavior Management Tool > Incident Event > Court Designated Worker

BehaviorEvent.
courtDesignatedWorker
Harassment Type

Reports the type of harassment for events where the law or board violation is classified as harassment.

  • 01: Color
  • 02: Disability
  • 03: National Origin
  • 04: Race
  • 05: Religion
  • 06: Sex
  • 07: Sexual Orientation
  • 08: Other
Behavior > Behavior Management Tool > Incident > Event > Participant > Harassment Type

BehaviorHarassment.
harassmentType
Drug Type

Indicates the type of drug associated with the event when the State Event Code (Mapping) is classified as Drug.

Logic reports the selected Drug Type description:

  • 01: Alcohol
  • 17: Amphetamines
  • 20: Barbiturate
  • 04: Cocaine/Crack
  • 05: Hallucinogens
  • 06: Heroin (Opioids)
  • 07: Inhalant
  • 09: Marijuana/Hashish
  • 11: Methamphetamine
  • 23: Nicotine Vapor Products
  • 12: Prescription Drugs
  • 14: Steroids (Anabolic)
  • 22: Synthetic Drug
  • 15: Tobacco/Nicotine Product
  • 16: Over-the-Counter Drugs
  • 21: Look alike Drug
  • 19: None (for participants w/o drug)

Behavior > Behavior Management > Incident > Event > Participant > Drug Type


BehaviorDrug.drugType

Weapon Type

Indicates the type of weapon associated with the event when the State Event Code (Mapping) is classified as Weapon.

Logic reports the selected Weapon Type description:

  • 01: Handgun
  • 02: Shotgun/Rifle
  • 03: Pellet/BB/Air Gun
  • 04: Paintball Gun
  • 05: Replica/Toy Gun
  • 07: Stun Gun/Taser Gun
  • 08: Knife: blade length less than 2.5 inches
  • 09: Knife: blade length 2.5 inches or greater
  • 11: Blunt object
  • 12: Other object
  • 13: Noxious substance
  • 14: Substance used as weapon
  • 15: Destructive device (e.g. bomb, grenade, etc…)
  • 18: None (for participants w/o weapon)
Behavior > Behavior Management Tool > Incident > Event > Participant > Weapon Type

BehaviorWeapon.weaponType

Resolution State Code

Indicates the code associated with the resolution. The event will only be reported if resolution is one of the following:

  • SSP1 : Expelled, Receiving Services
  • SSP2: Expelled, Not Receiving Services
  • SSP3: Out of School Suspension
  • SSP5: Corporal Punishment
  • SSP7: Restraint
  • SSP8: Seclusion
  • IAES1: IAES Unilateral Removal by School Personnel
  • IAES2: IAES Removal by Hearing Officer
  • INSR: In School Removal

Reports blank if State Resolution Code is null.


If a student has multiple state resolution codes for a single event, report a row for each state resolution.

Behavior > Behavior Incident Manager Tool > Incident > Resolution > State Resolution Code Mapping


BehaviorResType.
stateResCode 

Resolution TypeThe local district resolution type. If Resolution Type is blank/null, a blank value is reported.Behavior > Behavior Management Tool > Incident > Resolution > Resolution Type

BehaviorResType.
resolutionName

Resolution Start Date

Identifies the date the resolution began.

Behavior > Behavior Management Tool > Incident > Resolution > Resolution Start Date


BehaviorResolution.
timestamp

Resolution Start Time

Identifies the time the resolution began.

Behavior > Behavior Management Tool > Incident > Resolution > Resolution Start Time


BehaviorResolution.
timestamp

Resolution End Date

Identifies the date the resolution ended and the student returned to school (if applicable).

Behavior > Behavior Management Tool > Incident > Resolution > Resolution End Date


BehaviorResolution.
endtimestamp

Resolution End Time

Identifies the time the resolution ended and the student returned to school (if applicable).

Behavior > Behavior Management Tool > Incident > Resolution > Resolution End Time


BehaviorResolution.
endtimestamp

Resolution Length

The length of the behavior resolution tied to a state code, based on the start and end dates as compared to school days in the calendar.

The Resolution Length is calculated by comparing each day of the behavior resolution to the corresponding day in the calendar and determining how much of the day was missed during the resolution to a 10th of a day. 

Multi-day resolutions are summed together and displayed as the resolution length to a tenth of a day.

The calendar day must be marked as both School Day and Instructional in order to be counted. 

A number entered in the Duration in School Days field does NOT overrule the calculated value reported in this field.

State Resolutions that will calculated Resolution Length include:

  • INSR
  • SSP1
  • SSP2
  • SSP3
  • SSP5
  • IAES1
  • IAES2
  • SSP7
  • SSP8
Not dynamically stored
IAES Removal ReasonThe reason for the student's removal.

Display description only.

  • Drug Offenses
  • Dangerous Weapons
  • Serious Bodily Injury

Report ‘Serious Bodily Injury’ for resolutions with a Resolution State Code of IAES2.

Behavior > Behavior Management Tool > Incident > Resolution > IAES Removal Reason

BehaviorResolution.
removalReason
Sub-Report 

Indicates which Safe Schools sub-report the event qualifies for.

  • 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: Other Events Resulting in State Resolutions
Calculated field based on Safe Schools selection criteria.
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.

Calculated

Aggregate Report Layout (School, District, and State Level)

The Aggregate Report details aggregate Safe Schools data for an entire school, district, or state and only includes schools with state classifications of A1-A6, B1, B2, C2 and D1.

State level aggregation is only available in the Kentucky State Edition of Infinite Campus.

Element Name

Description

Campus UI and Database

ACAD_YR

The academic year of reporting behavior data. 

Logic concatenates the calendar start year and end year.

Calendar.startYear

Calendar.endYear

DISTRICT_
SCHOOL_NUMBER

The district and school reporting data, represented by their District and School Number concatenated into a 6 digit number.

The first 3 digits represent the school number, the last 3 digits represent the district number. A value of 999000 represents the state aggregation. 

District.number

School.number


System Administration > Resources > District Information > Number

System Administration > Resources > School > Number

DISTRICT_NAME

Name of the district where the behavior data was recorded. 

This field reports blank for the state aggregation. 

District.name

System Administration > Resources > District Information > Name

SCHOOL_NAME

Name of the school where the behavior data was recorded. 

This field reports blank for the state aggregation. 

School.name

System Administration > Resources > School > Name

TABLE

Table name for method by which data is being reported.

Options include:

  • Behavior Events
  • Discipline-Resolutions
  • Legal Sanctions
  • Behavior Events by Grade Level
  • Behavior Events by Location
  • Behavior Events by Context
N/A

CATEGORY

Category names specific to the table of data.

See the Categories section for a detailed list and description of all available categories.

N/A

TOTAL_STUDENTS

Reports a count by table/category for offender/participants.

Counts 1 for each student.

Calculated

TOTAL_EVENTS

Reports a count by table/category for offender/participants.

Count 1 for each event or resolution.

Calculated

ETH_WHITE

Reports a count by table/category of white offender/participants.

Counts 1 for each offender/participant with a Race of 6. 

Calculated

Census > People > Identity > Race/Ethnicity

ETH_ BLACK

Reports a count by table/category of black/african american offender/participants.

Counts 1 for each offender/participant with a Race of 4. 

Calculated

Census > People > Identity > Race/Ethnicity

ETH_HISPANIC

 

Reports a count by table/category of white non-Hispanic offender/participants.

Counts 1 for each offender/participant with a Race of 1. 

Calculated

Census > People > Identity > Race/Ethnicity

ETH_ASIAN

Reports a count by table/category of asian offender/participants.

Counts 1 for each offender/participant with a Race of 3. 

Calculated

Census > People > Identity > Race/Ethnicity

ETH_ALASKAN

Reports a count by table/category of alaskan offender/participants.

Counts 1 for each offender/participant with a Race of 2. 

Calculated

Census > People > Identity > Race/Ethnicity

ETH_PACIFIC

Reports a count by table/category of pacific islander offender/participants.

Counts 1 for each offender/participant with a Race of 5. 

Calculated

Census > People > Identity > Race/Ethnicity

ETH_MULTI

Reports a count by table/category of mutli-race offender/participants.

Counts 1 for each offender/participant with a Race of 7. 

Calculated

Census > People > Identity > Race/Ethnicity

GEN_MALE

Reports a count by table/category of male offender/participants.Calculated

Census > People > Identity > Race/Ethnicity

GEN_FEMALE

Reports a count by table/category of female offender/participants.Census > People > Demographics > Gender

ECONOMIC_
DISADVANTAGED

Reports a count by table/category of socially economically disadvantaged offender/participants.

Logic counts 1 for each student with an Economic Status of F or R. 

Calculated

FRAM > Eligibility > Eligibility

STUDENT_
WITH_DISABILITIES

Reports a count by table/category of active special education disability offender/participants with locked, active IEP.

Logic counts 1 for each student with an active Special Ed of Y.

Calculated

Student Information > Special Ed > Documents

Student Information > Special Ed > Documents > IEP > Education Plan > Start Date & End Date

ENGLISH_LEARNER

Reports a count by table/category of English Learner offender/participants.

Logic counts 1 for each student with an English Learner (EL) of Y.

Calculated

Student Information > Program Participation > LEP > LEP > Program Status

Student Information > Program Participation > LEP > LEP Accommodations > Type

FOSTER 

Reports a count by table/category of Foster offender/participants.

Logic counts 1 for each student with a Foster Care Status of Y. 

Calculated

Student Information > General > Program Participation > Foster Care

GIFTED_AND_TALENTED

Reports a count by table/category of Gifted and Talented offender/participants.

Logic counts 1 for each student with a Gifted and Talented Status of Y.

Calculated

Student Information > General > Program Participation > Gifted and Talented

HOMELESS 

Reports a count by table/category of homeless offender/participants.

Logic counts 1 for each student with a Homeless Status of Y.

Calculated

Student Information > General > Program Participation > Homeless

MIGRANT

Reports a count by table/category of Migrant offender/participants

Logic counts 1 for each student with a Migrant Status of Y.

Calculated

Student Information > General > Program Participation > Migrant

MILITARY_CONNECTED

Reports a count by table/category of Military Connected offender/participants.

Logic counts 1 for each student with a Military Connected Status of Y. 

Calculated

Student Information > General > Program Participation > Military Connected

State Event Codes

Click here to expand...

Sub-report colors only serve to help users easily identify which codes apply to which sub-reports.

Color KeySub-Report

SS1: Assault and 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


SS4: Bullying or Harassment

SS5: Other Events Resulting in State Resolutions


Code

Description

Sub-Report

V01

1st Degree Assault

SS1

V02

2nd Degree Assault

SS1

V03

3rd Degree Assault

SS1

V04

4th Degree Assault

SS1

V05

Abuse of a Teacher

SS1

N01

Academic Cheating/PlagiarismSS5

A01

Alcohol DistributionSS3B

A02

Alcohol PossessionSS3B
A03Alcohol UseSS3B
V06ArsonSS1
N02Attendance Policy ViolationSS5
H01BullyingSS4
N03BurglarySS5
N04Bus Rule ViolationSS5
V07Criminal AbuseSS1
N05Dangerous Instrument PossessionSS5
N06Destruction of PropertySS5
N07Disorderly ConductSS5
N08Disrespectful BehaviorSS5
N09Disruptive BehaviorSS5
N10Dress Code IncidentSS5
D01Drug DistributionSS3A
N11Drug Paraphernalia ViolationSS5
D02Drug PossessionSS3A
D03Drug UseSS3A
N12Failure to Attend DetentionSS5
N13Fighting - Student to Other (physical aggression)SS5
N14Fighting - Student to Staff (physical aggression)SS5
N15Fighting - Student to Student (physical aggression)SS5
N16ForgerySS5
N17FraudSS5
N18GamblingSS5
H02Harassing CommunicationsSS4
H03HarassmentSS4
V08HomicideSS1
N19InsubordinationSS5
V09KidnappingSS1
N20Leaving CampusSS5
N21LoiteringSS5
V10MenacingSS1
N22Motor Vehicle TheftSS5
N99No State ViolationSS5
N23Out of Area ViolationSS5
N24Possession of Stolen PropertySS5
N25Profanity or VulgaritySS5
V11RapeSS1
V12Robbery/TheftSS1
N26Self-EndangermentSS5
V13Sexual AssaultSS1
V14Sexual Offense (non-touch)SS1
N27Skipping ClassSS5
N28Skipping SchoolSS5
H04StalkingSS4
N29Tardy to ClassSS5
V15Terroristic - BombSS1
V16Terroristic ThreatSS1
V17Terroristic-Chem/Bio/NucSS1
N30Theft/StealingSS5
H05Threatening another StudentSS4
H06Threatening StaffSS4
T01Tobacco DistributionSS3C
T02Tobacco PossessionSS3C
T03Tobacco UseSS3C
N31TrespassingSS5
N32TruancySS5
N33VandalismSS5
H07Verbal AbuseSS4
N34Violation of District Acceptable Use PolicySS5
N35Violation of Personal Electronic/Telecommunication Device PolicySS5
V18Wanton EndangermentSS1
W01Weapon PossessionSS2
W02Weapon DistributionSS2
W03Weapon UseSS2

Categories

Click here to expand...

Behavior Event Categories

CategoryDescription and LogicCampus PathDatabase Location

Assault, 1st degree

Reports a sum of distinct Assault, 1st Degree related behavior events by student group.

Sum of distinct count of events with State Event Code of V01

Behavior > Behavior Incident Manager Tool > Incident > Event > State Code

Calculated

Other Assault or Violence

Reports a sum of distinct of assault or violence excluding 1st degree related assault behavior events by student group.

Sum of distinct count of all events in Sub Report SS1 except for events with State Event Code of V01

Behavior > Behavior Incident Manager Tool > Incident > Event > State Code

Calculated

Weapons

Reports a sum of distinct of weapons related behavior events by student group.

Sum of distinct count of all events in Sub Report SS2

Behavior > Behavior Incident Manager Tool > Incident > Event > State Code

Calculated

Harassment (includes bullying)

Reports a sum of distinct of harassment related behavior events by student group.

Sum of distinct count of all events in Sub Report SS4

Behavior > Behavior Incident Manager Tool > Incident > Event > State Code

Calculated

Drugs

Reports a sum of distinct of drugs related behavior events by student group.

Sum of distinct count of all events in Sub Report SS3A

Behavior > Behavior Incident Manager Tool > Incident > Event > State Code

Calculated

Alcohol

Reports a sum of distinct of alcohol related behavior events by student group.

Sum of distinct count of all events in Sub Report SS3B

Behavior > Behavior Incident Manager Tool > Incident > Event > State Code

Calculated

Tobacco

Reports a sum of distinct of tobacco behavior events by student group.

Sum of distinct count of all events in Sub Report SS3C

Behavior > Behavior Incident Manager Tool > Incident > Event > State Code

Calculated

Other Events Resulting in State Resolutions

Reports a sum of distinct state event codes not related to assault, violence, deadly weapons, controlled substances, bullying or harassment must have a state resolution of suspension, expulsion, corporal punishment, restraint or seclusion (SSP1, SSP2, SSP3, SSP5, SSP7, SSP8, INSR, IAES1, IAES2).

Sum of distinct count of all events in Sub Report SS5 (SS5.R1)

Behavior > Behavior Incident Manager Tool > Incident > Event > State Code

Calculated

Total

Reports a sum of distinct behavior events by student group.

Sum of distinct count of all events.

Behavior > Behavior Incident Manager Tool > Incident > Event > State Code

Calculated

Discipline Resolution Categories

CategoryDescription and LogicCampus Path

Expelled, receiving services (SSP1)

Reports a sum of distinct Expelled, receiving services (SSP1) resolutions by student group.

Counts 1 for each Resolution State Code of SSP1

Behavior > Behavior Incident Manager Tool > Incident > Resolution > State Code

Expelled, not receiving services (SSP2)

Reports a sum of distinct Expelled, not receiving services (SSP2) resolutions by student group.

Counts 1 for each Resolution State Code of SSP2

Behavior > Behavior Incident Manager Tool > Incident > Resolution > State Code

Out-of-School suspensions (SSP3)

Reports a sum of distinct Out-of-School suspensions (SSP3) resolutions by student group.

Counts 1 for each Resolution State Code of SSP3

Behavior > Behavior Incident Manager Tool > Incident > Resolution > State Code

Corporal Punishment (SSP5)

Reports a sum of distinct Corporal Punishment (SSP5) resolutions by student group.

Counts 1 for each Resolution State Code of SSP5

Behavior > Behavior Incident Manager Tool > Incident > Resolution > State Code

In-School Removal (INSR) or In-District Removal (INDR) >.5

Reports a sum of distinct In-School Removal (INSR) and In-District Removal (INDR) resolutions by student group.


Only INSR/INDR resolutions with a resolution length of at least a .5 day are included.


Counts 1 for each Resolution State Code of INSR

Behavior > Behavior Incident Manager Tool > Incident > Resolution > State Code


Behavior > Behavior Incident Manager Tool > Incident > Resolution > Duration in School Days 

Restraint (SSP7)

Reports a sum of distinct Restraint (SSP7) resolutions by student group.

Counts 1 for each Resolution State Code of SSP7

Behavior > Behavior Incident Manager Tool > Incident > Resolution > State Code

Seclusion (SSP8)

Reports a sum of distinct Seclusion (SSP8) resolutions by student group.

Counts 1 for each Resolution State Code of SSP8

Behavior > Behavior Incident Manager Tool > Incident > Resolution > State Code

Unilateral Removal by School Personnel (IAES1)

Reports a sum of distinct Unilateral Removal by School Personnel (IAES1) resolutions by student group.

Counts 1 for each Resolution State Code of IAES1

Behavior > Behavior Incident Manager Tool > Incident > Resolution > State Code

Removal by Hearing Officer (IAES2)

Reports a sum of distinct Removal by Hearing Officer (IAES2) resolutions by student group.

Counts 1 for each Resolution State Code of IAES2

Behavior > Behavior Incident Manager Tool > Incident > Resolution > State Code

Total

Reports a sum of all distinct state resolutions by student group.

Counts 1 for each Resolution State Code that is not null

Behavior > Behavior Incident Manager Tool > Incident > Resolution > State Code

Legal Sanction Categories

CategoryDescription and LogicCampus Path

Arrests

Reports a sum of distinct behavior events resulting in arrests by student group.

Sum of distinct count of events with Arrest = 1.

Behavior > Behavior Management Tool > Incident > Event > Participant > Arrest

Charges

Reports a sum of distinct behavior events resulting in charges by student group.

Sum of distinct count of events with Charges = 1.

Behavior > Behavior Management Tool > Incident > Event > Charges Filed

Civil Proceedings

Reports a sum of distinct behavior events resulting in civil proceedings by student group.

Sum of distinct count of events with Civil Proceedings = 1.

Behavior > Behavior Management Tool > Incident > Event > Participant > Civil Proceedings

School Resource Officer Involvement

Reports a sum of distinct behavior events involving a School Resource Officer by student group.

Sum of distinct count of events with School Resource Officer = 1.

Behavior > Behavior Management Tool > Incident > Event > School Resource Officer

Court Designated Worker Involvement

Reports a sum of distinct behavior events involving notification of a Court Designated Worker by student group.

Sum of distinct count of events with Court Designated Worker = 1.

Behavior > Behavior Management Tool > Incident > Event > Court Designate Worker

Total

Reports a sum of distinct behavior events resulting in legal sanctions by student group.  An event only counts once per offender/participant even if multiple legal sanctions occurred.

Sum of distinct count of events with Arrest = 1, Charges = 1, Civil Proceedings = 1, School Resource Officer = 1, or Court Designated Worker = 1.


Behavior Events by Grade Level Categories

CategoryDescription and LogicCampus Path

Grade Preschool

Reports a sum of Grade Preschool offender/participant connected with the event.

Sum of distinct count of events with state grade = 97,98,99

Census > People > Enrollments > Grade

OR

Student Information > Enrollments > Grade

Grade K

Reports a sum of Grade K offender/participant connected with the event.

Sum of distinct count of events with state grade = 00

Census > People > Enrollments > Grade

OR

Student Information > Enrollments > Grade

Grade 01

Reports a sum of Grade 01 offender/participant connected with the event.

Sum of distinct count of events with state grade = 01

Census > People > Enrollments > Grade

OR

Student Information > Enrollments > Grade

Grade 02

Reports a sum of Grade 02 offender/participant connected with the event.

Sum of distinct count of events with state grade = 02

Census > People > Enrollments > Grade

OR

Student Information > Enrollments > Grade

Grade 03

Reports a sum of Grade 03 offender/participant connected with the event.

Sum of distinct count of events with state grade = 03

Census > People > Enrollments > Grade

OR

Student Information > Enrollments > Grade

Grade 04

Reports a sum of Grade 04 offender/participant connected with the event.

Sum of distinct count of events with state grade = 04

Census > People > Enrollments > Grade

OR

Student Information > Enrollments > Grade

Grade 05

Reports a sum of Grade 05 offender/participant connected with the event.

Sum of distinct count of events with state grade = 05

Census > People > Enrollments > Grade

OR

Student Information > Enrollments > Grade

Grade 06

Reports a sum of Grade 06 offender/participant connected with the event.

Sum of distinct count of events with state grade = 06

Census > People > Enrollments > Grade

OR

Student Information > Enrollments > Grade

Grade 07

Reports a sum of Grade 07 offender/participant connected with the event.

Sum of distinct count  of events with state grade = 07

Census > People > Enrollments > Grade

OR

Student Information > Enrollments > Grade

Grade 08

Reports a sum of Grade 08 offender/participant connected with the event.

Sum of distinct count (DE.48) of events with state grade (DE.7) = 08

Census > People > Enrollments > Grade

OR

Student Information > Enrollments > Grade

Grade 09

Reports a sum of Grade 09 offender/participant connected with the event.

Sum of distinct count of events with state grade = 09

Census > People > Enrollments > Grade

OR

Student Information > Enrollments > Grade

Grade 10

Reports a sum of Grade 10 offender/participant connected with the event.

Sum of distinct count of events with state grade = 10

Census > People > Enrollments > Grade

OR

Student Information > Enrollments > Grade

Grade 11

Reports a sum of Grade 11 offender/participant connected with the event.

Sum of distinct count of events with state grade = 11

Census > People > Enrollments > Grade

OR

Student Information > Enrollments > Grade

Grade 12

Reports a sum of Grade 12 offender/participant connected with the event.

Sum of distinct count of events with state grade = 12

Census > People > Enrollments > Grade

OR

Student Information > Enrollments > Grade

Grade 14

Reports a sum of Grade 14 offender/participant connected with the event.

Sum of distinct count of events with state grade = 14

Census > People > Enrollments > Grade

OR

Student Information > Enrollments > Grade

Total

Reports a sum of distinct behavior events by state grade

Sum of distinct counts of events with state grade


Behavior Events by Location Categories

CategoryDescription and LogicCampus Path

Classroom

Reports a sum of distinct behavior events occurring in the classroom by student group.

Sum of distinct count of events with Event Location = SSL1.

Behavior > Behavior Management Tool > Incident > Location

Bus

Reports a sum of distinct behavior events occurring on the bus by student group.

Sum of distinct count  of events with Event Location = SSL2.

Behavior > Behavior Management Tool > Incident > Location

Hallway/Stairwell

Reports a sum of distinct behavior events occurring in the hallway/stairwell by student group.

Sum of distinct count of events with Event Location = SSL3.

Behavior > Behavior Management Tool > Incident > Location

Cafeteria

Reports a sum of distinct behavior events occurring in the cafeteria by student group.

Sum of distinct count of events with Event Location = SSL4.

Behavior > Behavior Management Tool > Incident > Location

Campus Grounds

Reports a sum of distinct behavior events occurring on campus grounds by student group.

Sum of distinct count of events with Event Location = SSL5.

Behavior > Behavior Management Tool > Incident > Location

Restroom

Reports a sum of distinct behavior events occurring in the restroom by student group.

Sum of distinct count of events with Event Location = SSL7.

Behavior > Behavior Management Tool > Incident > Location

Gymnasium

Reports a sum of distinct behavior events occurring in the gymnasium by student group.

Sum of distinct count of events with Event Location = SSL8.

Behavior > Behavior Management Tool > Incident > Location

Playground

Reports a sum of distinct behavior events occurring on the playground by student group.

Sum of distinct count of events with Event Location = SSL11.

Behavior > Behavior Management Tool > Incident > Location

Other

Reports a sum of distinct behavior events occurring
off campus (SSL6),
in the office (SSL9),
on an athletic field (SSL10),
during a field trip (SSL12),
or at a location that is not named (other) (SSL13) by student group.

Sum of distinct count of events when Event Location is one of SSL6, SSL9, SSL10, SSL12, SSL13.

Behavior > Behavior Management Tool > Incident > Location

Total

Reports a sum of distinct behavior events occurring in all locations by student group.

Sum of distinct count of events with an Event Location.

Behavior > Behavior Management Tool > Incident > Location

Behavior Events by Context Categories

CategoryDescription and LogicCampus Path

School Sponsored Event; During School Hours

Reports a sum of distinct behavior events resulting in school sponsored event during school hours

Sum of distinct count of events with context = SS

Behavior > Behavior Management Tool > Incident > Context

School Sponsored Event; Not During School Hours

Reports a sum of distinct behavior events resulting in school sponsored event not during school hours

Sum of distinct count of events with context = SN

Behavior > Behavior Management Tool > Incident > Context

Non School Sponsored Event; During School Hours

Reports a sum of distinct behavior events resulting in non-school sponsored event during school hours

Sum of distinct count of events with context = NS

Behavior > Behavior Management Tool > Incident > Context

Non School Sponsored Event; Not During School Hours

Reports a sum of distinct behavior events resulting in non-school sponsored event not during school hours

Sum of distinct count of events with context = NN

Behavior > Behavior Management Tool > Incident > Context

Total

Reports a sum of distinct behavior events resulting in legal sanctions by student group.  An event only counts once per offender/participant even if multiple legal sanctions occurred.

Sum of distinct count of events where context is SS, SN, NS, or NN