Tool Search: PIMS Extracts
The Incident Offender Infraction Template connects an incident and the offender to an infraction. If multiple infractions apply to the incident/offender, multiple records are submitted, one per infraction. If the offender is unknown, the template cannot be submitted.
See the PIMS Reporting article for additional PIMS Reporting information.
Report Logic
Only students assigned a Role of Offender report.
Only behavior incidents that are marked as Submitted, In Progress or Complete report. Behavior incidents that are in Draft status do not report.
Reports all matching students from that school for the selected calendar. Students report even if they are enrolled in a different calendar and the calendar in which they are enrolled is not selected on the extract editor. Reports all associated behavior data from an incident that happened in a selected calendar. Incident and incident related reports are not included in the report population if the calendar selected in the extract editor is not the calendar in which the incident was documented. Incidents and students involved in incidents do not report in calendars marked as Exclude (System Administration > Calendar > Calendar > Exclude).
Generate the Incident Offender Infraction Template
- Select Incident Offender Infraction Template from the Extract Type from the dropdown list.
- Enter the Start Date of the extract in mmddyy format or use the calendar icon to select a date.
- Enter the Effective Date of the extract in mmddyy format or use the calendar icon to select a date.
- Select the Format of the extract.
- If desired, select an Ad hoc Filter to return only those students included in that filter.
- Select the appropriate Calendar(s) from which to include data on the extract.
- Click the Generate Extract button or the Submit to Batch button, if available. The extract displays in the selected format.
Incident Offender Infraction Template - HTML Format
Incident Offender Infraction Template - CSV Format
Report Layout
| Element | Description | Campus Interface |
|---|---|---|
| Submitting District Code | State District Number Numeric, 9 digits | District Information > District Detail > State District Number District.districtNumber |
| Incident ID | Reports the identification number assigned to the behavior event. Numeric, 30 digits | Behavior > Behavior Event > Event ID BehaviorEvent.eventID |
| Offender ID | Reports the student's State ID Number. Numeric, 20 digits | Demographics > Person Identifiers > State ID Person.stateID |
| Infraction Code | Reports the infraction code of the offender.
Values A or C only report when the associated State Resolution is S3 - S9. If resolution is not S3-S9, the A or C incident does not report. Alphanumeric, 2 digits | Behavior Management > Events and Participants > Event Details > Event Type BehaviorEvent.name |
| School Year Date | Reports the end date of the school year. Date field, 10 characters, 20XX-06-30 | Calendar Information > Calendar Info > End Date Calendar.endDate |
| Field 6 | Does not report. | N/A |
| Infraction Comment | Reports the comment regarding the nature of the infraction. This is a required field when the Infraction Code is 16.
Alphanumeric, 500 characters | Behavior Management > Events and Participants > Participant Details > Comments BehaviorEvent.Comment |
Previous Versions
PIMS Incident Offender Infraction Template (Pennsylvania) [.2243 and previous]
