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.
Report Logic
- 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).
- Role is V1, V2, V3, V4 or V5.
- 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
Victims Report Layout
Element Name | Description | Type, Format and Length | Campus Database | Campus Location |
---|---|---|---|---|
Victim_IDNUM | The victim's ID number for this incident. | Numeric, long | BehaviorRole.roleID | Student Information > General > Behavior Tab > Behavior Event > Event ID |
Incident_Num | The number that uniquely identifies the behavior 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. | Alphanumeric, 5 characters | School.number | System Administration > Resources > School > School Detail > State School Number |
Victim_LastName | The victim's last name. | Alphanumeric, 50 characters | Identity.lastName | Census > People > Demographics > Person Information > Last Name |
Victim_FirstName | The victim's first name. | Alphanumeric, 50 characters | Identity.firstName | Census > People > Demographics > Person Information > First Name |
Victim_MName | The victim's middle name. | Alphanumeric, 25 characters | Identity.middleName | Census > People > Demographics > Person Information > Middle Name |
Victim_DOB | The victim's date of birth. | Date field, 10 characters | Identity.birthDate | Census > People > Demographics > Person Information > Birth Date |
Victim_Grade | The victim's grade. | Numeric, 2 digits | Enrollment.Grade | Student Information > General > Enrollments Tab > General Enrollment Information > Grade |
Victim_Gender | Indicates whether the victim is Male: M or Female: F. | Alphanumeric, 1 character | Identity.gender | Census > People > Demographics > Person Information > Gender |
Victim_AmindAKNat | Indicates whether the victim is assigned the American Indian/Alaskan Native racial status: Y = Yes, N = No. | Alphanumeric, 1 character | RaceEthnicity.code | Census > People > Demographics > Person Information > Race Ethnicity |
Victim_Asian | Indicates whether the victim is assigned the Asian racial status: Y = Yes, N = No. | Alphanumeric, 1 character | RaceEthnicity.code | Census > People > Demographics > Person Information > Race Ethnicity |
Victim_Black | Indicates whether the victim is assigned the Black, Non-Hispanic racial status racial status: Y = Yes, N = No. | Alphanumeric, 1 character | RaceEthnicity.code | Census > People > Demographics > Person Information > Race Ethnicity |
Victim_White | Indicates whether the victim is assigned the White, Non-Hispanic racial status: Y = Yes, N = No. | Alphanumeric, 1 character | RaceEthnicity.code | Census > People > Demographics > Person Information > Race Ethnicity |
Victim_Hispanic | Indicates whether the victim is assigned the Hispanic racial status: Y = Yes, N = No. | Alphanumeric, 1 character | RaceEthnicity.code | Census > People > Demographics > Person Information > Race Ethnicity |
Victim_Hawaiian | Indicates whether the victim is assigned the Hawaiian or Other Pacific Islander racial status: Y = Yes, N = No. | Alphanumeric, 1 character | RaceEthnicity.code | Census > People > Demographics > Person Information > Race Ethnicity |
Victim_Type | An indicator identifying the victim's role in the incident.
| Numeric, 1 digit | BehaviorRole.role | Behavior > Behavior Management > New Participant/Event > Role |
Victim_Injury | The level of injury sustained by the Victim.
| Numeric, 1 digit | BehaviorRole.injuryCode | Behavior > Behavior Management > New Participant/Event > Injury |
Victim_ID | Unique number assigned to the Victim. | Alphanumeric, 15 characters | BehaviorRole.personID | Student Information > General > Behavior > Behanior Role > Person ID |
Victim_Choice | Indicates whether the victim exercises their right to school choice: Y = Yes, N = No. | Alphanumeric, 1 character | Es.schoolChoice | Student Information > General > State Reporting Fields > School Choice |