Tool Search: Combined Incident Reporting
Combined Incident Reporting gathers information related to violations of school policies, state or federal statutes or regulations. Four behavior reports collect information about behavior incidents, offenders, actions and victims.
See the Combined Incident Reporting article for directions for generating the extract.
Combined Incident Reporting Editor
Report Logic
Reports all Behavior Resolutions where the following are true:
- The related incident date is on or after the first instructional day of the selected calendar.
- The related incident date is on or before the Effective Date (from the extract editor).
Students are NOT included if
- their enrollment record is marked as State Exclude;
- their enrollment record is marked as No Show;
- their Grade Level of enrollment is marked as State Exclude; or
- their Calendar of enrollment is marked as State Exclude.
Report Example
Actions Report Example (HTML)
Actions Report Layout
Element Name | Description | Type, Format and Length | Campus Database | Campus Location |
|---|---|---|---|---|
Action_Num | A unique number that identifies this action. | Numeric, long | Calculated, not dynamically stored. | Not dynamically stored. |
Incident_Num | The number that uniquely identifies the incident for which this is a consequence. | Numeric, 10 digits | BehaviorEvent.eventID | Student Information > General > Behavior Tab > Behavior Event > Event ID |
Perp_IDNUM | The number that links the offender to the incident. | Numeric, long | BehaviorEvent.eventID | Student Information > General > Behavior Tab > Behavior Event > Event ID |
PSID | The school's ID number with the prefix "PS." For example if the school ID is 001, PS001 is reported. | Numeric, 5 digits | School.number | System Administration > Resources > School > School Detail > State School Number |
Action_Type | The resolution taken by the school/district. See the following Resolution Codes table for values. | Numeric, 2 digits | BehaviorResolution.code AND BehaviorResolution.name | Behavior > Behavior Management > New Resolution > Resolution |
Action_Start_Date | The date the action commenced. | Date field, 10 characters | BehaviorResolution.discAssignDate | Behavior > Behavior Management > New Resolution > Resolution Start Date |
Action_End_Date | The final date of the action. | Date field, 10 characters | BehaviorResolution.endDate | Behavior > Behavior Management > New Resolution > Resolution End Date |
Other_Desc | A description of the action if 15 - Other is the Action Type. | Alphanumeric, 100 characters | BehaviorResolution.comments | Behavior > Behavior Management > New Resolution > Resolution Details |
Susp_Red | This field reports blank. | N/A | N/A | N/A |
Susp_Length | The number of school days missed due to an out of school suspension. | Numeric, long | BehaviorResolution.discAssignDate | Behavior > Behavior Management > New Resolution > Resolution Start and End Date |
Resolution Codes
Code | Name |
|---|---|
2 | Conference/Warning to Student |
3 | Conference/Warning to Student/Parents/Guardian |
4 | Detention |
5 | Expulsion |
6 | No Finding (Hazing/Harassment Only) |
10 | Suspension-In School |
11 | Suspension-Out of School |
12 | Seclusionary Timeout |
13 | Unilateral Removal Interim Alternative Setting |
14 | No Action Taken |
15 | Other |
16 | Bus Suspension |
1 | Community Service (01) |
7 | Physical Restraint (07) |
8 | Referral to Alternative Program (08) |
9 | Restorative Conferencing (09) |
17 | Student Referred to SAP (17) |
