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 Person information 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).
- Role is O1, O2, O3, O4, or O5.
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
Offenders Report Example (HTML)
Offenders Report Layout
Element Name | Description | Type, Format and Length | Campus Database | Campus Location |
|---|---|---|---|---|
Perp_IDNUM | A Unique Number for this person's inclusion in this incident. | Numeric, long | BehaviorRole.roleID | Student Information > General > Behavior > Behavior Role > Role ID |
Incident_Num | The number of this incident. | Numeric, long | BehaviorRole.eventID | Student Information > General > Behavior > Behavior Role > 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 |
Perp_LastName | The offender's last name. | Alphanumeric, 30 characters | Identity.lastName | Census > People > Demographics > Person Information > Last Name |
Perp_FirstName | The offender's first name. | Alphanumeric, 25 characters | Identity.firstName | Census > People > Demographics > Person Information > First Name |
Perp_MName | The offender's middle name. | Alphanumeric, 25 characters | Identity.middleName | Census > People > Demographics > Person Information > Middle Name |
Perp_DOB | The offender's date of birth. | Date field, 10 characters | Identity.birthDate | Census > People > Demographics > Person Information > Birth Date |
Perp_Grade | The offender's grade. | Numeric, 2 digits | Enrollment.grade | Student Information > General > Enrollments Tab > General Enrollment Information > Grade |
Perp_Gender | Indicates whether the offender is Male: M or Female: F. | Alphanumeric, 1 character | Identity.gender | Census > People > Demographics > Person Information > Gender |
Perp_Type | A number indicating the offender's role in the incident.
| Alphanumeric, 2 characters | BehaviorRole.role | Behavior > Behavior Management > New Participant/Event > Role |
Perp_Injury | A number indicating what level the injury was sustained by the offender.* 1 - No Injury
| Numeric, 1 digit | BehaviorRole.injuryCode | Behavior > Behavior Management > New Participant/Event > Injury |
Perp_IEP | A letter indicating whether the offender had an IEP: Y = Yes, N = No. | Alphanumeric, 1 character | Enrollment. specialEdStatus | Student Information > General > Enrollments > Special Ed Fields > Special Ed Status |
Perp_ID | An ID number assigned to the offender. | Alphanumeric, 15 characters | BehaviorRole.personID | Student Information > General > Behavior > Behanior Role > Person ID |
| Perp_AmindAKNat | Indicates whether the offender 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 |
| Perp_Asian | Indicates whether the offender is assigned the Asian racial status: Y = Yes, N = No. | Alphanumeric, 1 character | RaceEthnicity.code | Census > People > Demographics > Person Information > Race Ethnicity |
| Perp_Black | Indicates whether the offender 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 |
| Perp_White | Indicates whether the offender is assigned the White, Non-Hispanic racial status: Y = Yes, N = No. | Alphanumeric, 1 character | RaceEthnicity.code | Census > People > Demographics > Person Information > Race Ethnicity |
| Perp_Hispanic | Indicates whether the offender is assigned the Hispanic racial status: Y = Yes, N = No. | Alphanumeric, 1 character | RaceEthnicity.code | Census > People > Demographics > Person Information > Race Ethnicity |
| Perp_Hawaiian | Indicates whether the offender 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 |
Perp_Disability | A number indicating the offender's disability.
| Numeric, 2 digits | ActiveEnrollment.disability1 | Student Information > General > Enrollments > Special Ed fields > Primary Disability |
Perp_LEP | A number indicating the offender's LEP status: Y = Yes, N = No. | Alphanumeric, 1 character | BehaviorRole.roleID | Student Information > General > Enrollments Tab |
