Classic View: PA State Reporting > PIMS Extracts > Incident Offender Infraction Template
Search Terms: 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 Effective Date of the extract in mmddyy format or use the calendar icon to select a date.
- Enter the Prior Reporting 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 Template - CSV Format
Report Layout
| Element | Description | Type, Format and Length | Campus Database | Campus Interface |
|---|---|---|---|---|
| Submitting District Code | State District Number |
Numeric, 9 digits |
District.district Number |
System Administration > Resources > District Information > State District Number |
| Incident ID | Reports the identification number assigned to the behavior event. | Numeric, 30 digits | BehaviorEvent. eventID | Student Information > General > Behavior > Behavior Event > Event ID |
| Offender ID | Reports the student's State ID Number. | Numeric, 20 digits | Person.stateID | Census > People > Demographics > Person Identifiers > State ID |
| 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 | BehaviorEvent.name | Behavior > Behavior Management > Events and Participants > Event Details > Event Type |
| School Year Date | Reports the end date of the school year. | Date field, 10 characters 20XX-06-30 |
Calendar.endDate | System Administration > Calendar > Calendar > Calendar Info > End Date |
| Weapon Count | If weapons are involved, reports the total number of weapons for the offender and incident. This is a required field when the Infraction Code is between 39 and 46, or 54. Reports a value of 1 of the Infraction Code field is not populated. |
Numeric, 2 digits | BehaviorEvent. weaponCode | Behavior > Behavior Management > Events and Participants > Weapon |
| 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 | BehaviorEvent. Comment | Behavior > Behavior Management > Events and Participants > Participant Details > Comments |
