Tool Search: DIRS Extract
The Disciplinary Incident Reporting System (DIRS) extract reports information about behavior data including suspensions, expulsions, and weapons.
The DIRS extract reports behavior data.
Report Logic
Incidents
The DIRS extract reports a record per behavior Incident that meet the following requirements:
- Has a valid State Event Code mapping.
- Has a resolution mapped to a State Code.
- Has at least one participant with a Role of Offender. The Offender must have a Primary enrollment active on the Date of Incident and must have at least one resolution record mapped to a valid State Code.
- Has a Relationship to School valued of 1 or 4 selected.
- Falls within the Date Range or calendar selected in the extract editor.
If multiple events exist for an incident, the event with the lowest event code reports, indicating the most severe. Victim records are reported if the event has a State Event Code of 3, 12, 25, 26, 27, 28, 29, 31, or 32, unless the Exclude Victim Records checkbox is marked on the extract editor.
Generating the Extract
- Enter a Date Range to limit records to those with a Date of Incident on or within the range. The End Date defaults to the current date.
- A Format of XML is selected by default.
- Mark Report District Wide to generate the extract for all calendars in the current School Year.
- Mark Exclude Victim Records to exclude participants with a Role of Victim from the extract if Victim records should not be included in the extract.
- Enter a Number of Habitually Truant Students from Previous School Year to report that value in the extract. If a number is not entered in this field, a value of 000 reports and should be updated manually.
- Select an Ad hoc Filter to limit records reports.
- Select the Calendar(s) to be included in the report.
- Click the Generate Extract button to generate the report in the indicated format or Submit to Batch to schedule when the report will generate.
Users have the option of submitting an extract request to the batch queue by clicking Submit to Batch instead of Generate Extract. This process will allow larger reports to generate in the background, without disrupting the use of Campus. For more information about submitting a report to the batch queue, see the Batch Queue article.
DIRS Extract Layout
Element Name | Description & Format | Campus Location |
|---|---|---|
| District Number | The identification number of the reporting district. Numeric | System Administration > Resources > District Information > State District Number District.number |
| District Type | The code that identifies the type of school district. Numeric | System Administration > Resources > District Information > Type District.type |
| School | Reports the total count of schools in the report. | |
| School Number | The number of the school where the incident occurred. Numeric | System Administration > Resources > School > State School Number School.number |
| Safety Specialist | The email address of the school safety specialist. Alphanumeric | System Administration > Resources > School > Safety Specialist Email School.otherEmail |
| Habitual Truants | The number of habitually truant students for previous school year entered in the extract editor, or 000 if blank. Numeric | MN State Reporting > DIRS Extract > Number of Habitually Truant Students for Previous School Year Not dynamically stored |
| Safety Plan | Indicates if the school has a Safety Plan policy in place. If a policy record exists with a value of 01 that is active for the full extract Date Range, reports as true. Otherwise reports as false. Alphanumeric | System Administration > Resources > School > School Policy > Policy schoolPolicy.policy |
| Anti-Violence Policy | Indicates if the school has a Anti-Violence policy in place. If a policy record exists with a value of 03 that is active for the full extract Date Range, reports as true. Otherwise reports as false. Alphanumeric | System Administration > Resources > School > School Policy > Policy schoolPolicy.policy |
| Drug Education | Indicates if the school has a Drug Education policy in place. If a policy record exists with a value of 06 that is active for the full extract Date Range, reports as true. Otherwise reports as false. Alphanumeric | System Administration > Resources > School > School Policy > Policy schoolPolicy.policy |
| Zero Tolerance Policy | Indicates if the school has a Zero Tolerance policy in place. If a policy record exists with a value of 02 that is active for the full extract Date Range, reports as true. Otherwise reports as false. Alphanumeric | System Administration > Resources > School > School Policy > Policy schoolPolicy.policy |
| Anti-Bullying Policy | Indicates if the school has a Anti-Bullying policy in place. If a policy record exists with a value of 04 that is active for the full extract Date Range, reports as true. Otherwise reports as false. Alphanumeric | System Administration > Resources > School > School Policy > Policy schoolPolicy.policy |
| Crisis Plan | Indicates if the school has a Crisis Plan policy in place. If a policy record exists with a value of 05 that is active for the full extract Date Range, reports as true. Otherwise reports as false. Alphanumeric | System Administration > Resources > School > School Policy > Policy schoolPolicy.policy |
| Incident | Reports one behavior event per incident with a valid State Event Code mapping and a State Code mapped Resolution within the extract Date Range or school year. Must have a participant with a Role of Offender and a Relationship to School of 1 or 4. Reports the must severe (lowest Code) event. | |
| External Incident ID | The Incident ID for events with mapped State Event Codes. | Student Information > Behavior > Event > Incident Number |
| School Number | The School ID of the school reporting the incident. Alphanumeric | System Administration > Resources > School > State School Number School.number |
| Incident Date | The date the incident took place. Date | Behavior > Behavior Management > Incident > Date of Incident BehaviorIncident.date |
| Time of Incident | The time the incident took place. Numeric | Behavior > Behavior Management > Incident > Context BehaviorIncident.context |
| Cost to Property | The cost the school incurred by this event.
Numeric | Behavior > Behavior Management > Incident > Damages |
| Incident Location | Reports the total number of locations listed. | |
| Incident Location | The location of the incident Numeric | Behavior > Behavior Management > Incident > Location BehaviorIncident.location |
| Number of Unknown Offenders | The total number of unknown offenders. Numeric | Behavior > Behavior Management > Event > Number of Unknown Offenders BehaviorEvent.unknownOffenders |
| Offender | Reports the total number of offenders. Students must have a Primary enrollment active on the Date of Incident with at least one State Code mapped Resolution. | |
| MARSS Number | The state identification number of the student offender. Student must have a Role of Offender and a Relationship to School of Student Alphanumeric | Census > People > Demographics > Person Identifiers > Student State ID Person.stateID |
| Was Under Current Suspension | Indicates if the offender was suspended at the time of the incident. Reports as true if a previous Resolution record exists for the Offender in which they were an Offender with a Resolution of 1 or 2 and the Resolution End Date is null or after the Date of Incident. Otherwise reports as false. Alphanumeric | Behavior > Behavior Management > Resolution Calculated |
| Was Referred Law Enforcement | Indicates if the Offender was referred to law enforcement. Alphanumeric | Behavior > Behavior Management > Resolution > Referred to Law Enforcement BehaviorResolution.lawEnforcement |
| Was Arrested Law Enforcement | Reports as true if the Arrest Made checkbox is marked on the resolution. Otherwise reports as false. Alphanumeric | Behavior > Behavior Management > Resolution > Arrest Made BehaviorResolution.arrestMade |
| Offender Activity | Reports the total count of Offender activity records. | |
| Offender Activity Type | Reports the State Event Code of the reported incident when the participant has a Role of Offender. Alphanumeric | Behavior > Behavior Management > Event > Event Name BehaviorEvent.name |
| Offense Type | The Offense Type code. Reports if the Role is Offender and the Offender Activity Type State Event Code is 1, 2, 3, 6, 12, or 13. Alphanumeric | Behavior > Behavior Management > Participant > Offense Type BehaviorRole.motivationCode |
| Weapon | Reports the total count of weapons recorded. | |
| Weapon Type | The type of weapon used. Reports the Weapon Type if the Event Type is 22 and Role is Offender. Alphanumeric | Behavior > Behavior Management > Incident > Participant > Weapon Type BehaviorWeapon.weaponType |
| Number Weapons Involved | The number of weapons used. Reports the Weapon Type if the Event Type is 22 and Role is Offender. Numeric | Behavior > Behavior Management > Incident > Participant > Weapon Type Calculated |
| Was Used as a Dangerous Weapon State | Indicates if the weapon used meets the state statute to be a dangerous weapon. If Dangerous Weapon is 01 or 03 and Role is Offender, reports as true. Otherwise reports as false. Alphanumeric | Behavior > Behavior Management > Incident > Participant > Dangerous Weapon BehaviorWeapon.weaponCategory2 |
| Was Used as a Dangerous Weapon Fed | Indicates if the weapon used meets the federal statute to be a dangerous weapon. If Dangerous Weapon is 02 or 03 and Role is Offender, reports as true. Otherwise reports as false. Alphanumeric | Behavior > Behavior Management > Incident > Participant > Dangerous Weapon BehaviorWeapon.weaponCategory2 |
| Bullying Harassment Type | The type of harassment committed by the offending participant. Reports the Harassment Type code(s) selected on the Event with a Role of Offender. Does not report if no Harassment Type is selected. Alphanumeric | Behavior > Behavior Management > Incident > Participant > Harassment Type BehaviorHarassment.harassmentType |
| Is Gun Loaded | If a gun was part of the incident, indicates if the gun was loaded. If Weapon Status is 01, 03, 05, or 07 and Role is Offender, reports as true. Otherwise reports as false. Alphanumeric | Behavior > Behavior Management > Incident > Participant > Weapon Status BehaviorWeapon.weaponCategory |
| Is Gun Cased | If a gun was part of the incident, indicates if the gun was cased. If Weapon Status is 02, 03, 06 or 07 and Role is Offender, reports as true. Otherwise reports as false. Alphanumeric | Behavior > Behavior Management > Incident > Participant > Weapon Status BehaviorWeapon.weaponCategory |
| Is Gun in Trunk | If a gun was part of the incident, indicates if the gun was in the trunk. If Weapon Status is 04, 05, 06, or 07 and Role is Offender, reports as true. Otherwise reports as false. Alphanumeric | Behavior > Behavior Management > Incident > Participant > Weapon Status BehaviorWeapon.weaponCategory |
| Drug Type | Reports the total count of drugs reported. | |
| Drug Type | If the Event Type is 13 and Role is Offender, reports the Drug Type selected. Alphanumeric | Behavior > Behavior Management > Incident > Participant > Drug Type BehaviorDrug.drugType |
| Drug Type Other Description | Currently not reported. | N/A |
| Disciplinary Action | Reports the total count of Resolutions (Disciplinary Actions) reported. Reports the Resolution if Role is Offender, Relationship to School is 1 or 4, Event Type is state mapped, and Resolution Type State Code is 1-12 | |
| Disciplinary Action Type | Reports the State Code of the Resolution if Role is Offender, Relationship to School is 1 or 4, the Incident Event Type is mapped to a State Event Code and the Resolution is mapped to a State Resolution Code of 1-13. A value of 12 only reports if either of the following is true:
Alphanumeric | Behavior > Behavior Management > Incident > Resolution > Resolution Type BehaviorResolution.stateResCode |
| No Response Explanation | Reports Details if Behavior Resolution Type is 11, 12, or 13. Alphanumeric | Behavior > Behavior Management > Incident > Resolution > Details BehaviorResolution.details |
| Was DAT Through Year | Indicates if the expulsion lasted through the end of the current school year. If Behavior Resolution Type is 3, Role is Offender and Relationship to School is 1 or 4, reports as true. Otherwise reports as false. If Behavior Resolution Type is not 3, does not report. Alphanumeric | Behavior > Behavior Management > Incident > Resolution > Resolution Type Calculated |
| Num Days | The number of school days the Resolution lasted. If Behavior Resolution Type is 1-6 or 12, reports Total Discipline Days. Numeric | Behavior > Behavior Management > Incident > Resolution > Total Discipline Days |
| Start Date | The Start Date of the resolution if the Type was 3, 4, or 12. Date | Behavior > Behavior Management > Incident > Resolution > Resolution Start Date BehaviorResolution.startDate |
| End Date | The End Date of the resolution if the Type was 3, 4, or 12. Date | Behavior > Behavior Management > Incident > Resolution > Resolution End Date BehaviorResolution.endDate |
| Was Expulsion Modified | Indicates if the student returned to school prior to the end date on a school board resolution. If Reports as true if Type is 3 and Number of Days Reduced is entered. Otherwise reports as false. If Behavior Resolution Type is not 3, does not report. Alphanumeric | Behavior > Behavior Management > Incident > Resolution > Number of Days Reduced Calculated |
| Num Days Expulsion Reduced | The number of days the expulsion was reduced from the original resolution. If Type is 2 and the expulsion was modified, reports the Number of Days Reduced. Alphanumeric | Behavior > Behavior Management > Incident > Resolution > Number of Days Reduced |
| Did Return Before End School Year | Indicates if the student returned before the end of the school year. Reports as true if Resolution End Date is before the school year End Date and the expulsion was modified. Alphanumeric | Behavior > Behavior Management > Incident > Resolution > Resolution End Date Calculated |
| AES Type | Indicates the student was suspended from school for more than 5 days. Reports the Alternate Education Setting if Resolution Type is 2 - 6 and the Duration in School Days is greater than 5. Alphanumeric | Behavior > Behavior Management > Incident > Resolution > Alternate Education Settings BehaviorResolution.altEducationSetting |
| AES No Service Proved Explanation | Reports the Resolution Details if the Alternate Education Setting of 15 is selected, the Behavior Resolution was mapped to a state code of 2, 3, 5, or 6, and the Duration was greater than 5 days. Otherwise reports as blank. Alphanumeric | Behavior > Behavior Management > Incident > Resolution > Details BehaviorResolution.details |
| Victim | Reports the total count of victims. | |
| Victim Type | Reports the Relationship to School of the participant with a Role of Victim. Alphanumeric | Behavior > Behavior Management > Incident > Participant > Relationship to School BehaviorRole.relationshipToSchool |
| Multiple Victim Count | Reports the Total count of Number of Unknown Victims, Number of Student Victims, and Number of School Personnel Victims when Relationship to School is 2-5. Numeric | Behavior > Behavior Management > Incident > Participant > Relationship to School, Number fields Calculated |
| Estimated Victims Enrolled | Reports the Number of Student Victims entered on the event. Numeric | Behavior > Behavior Management > Incident > Event > Number of Student Victims BehaviorEvent.numbOfStuVictims |
| Estimated Victims Not Enrolled | Reports the Number of Unknown Victims entered on the event. Numeric | Behavior > Behavior Management > Incident > Event > Number of Unknown Victims BehaviorEvent.numOfNonSchVictims |
| MARSS Number | Reports the Student State ID of the participant with a Role of Victim and a Relationship to School of 1. Numeric | Census > People > Demographics > Person Identifiers > State ID Person.stateID |
| Did Injury Occurr | Indicates whether an injury occurred related to the incident. Reports as true if Injury is 2, 3, or 4 and Role is Victim. Otherwise reports as false. Alphanumeric | Behavior > Behavior Management > Incident > Participant > Injury BehaviorRole.injury |
| Was Serious Bodily Injury | Indicates if injury qualified as serious bodily injury based on federal law. Reports as true if Injury is 4 and Role is Victim. Otherwise reports as false. Alphanumeric | Behavior > Behavior Management > Incident > Participant > Injury BehaviorRole.injury |
| Aware Reporting Assault | Indicates that the reported is aware that the incident included a victim who is a district employee, but that the incident is not being reported as such based on 121A.53. To report, export fields must report as follows: Reports as 1 if the Not Reported 121A.53 checkbox is marked and either of the following are true:
If checkbox is not marked, reports as 0. Numeric | Behavior > Behavior Management > Incident > Participant > Not Reported 121A.53 BehaviorRole.notReported121A.53 |
| Cost to Victim | The medical cost to the victim incurred by the event.
Numeric | Behavior > Behavior Management > Participant > Cost to Victim BehaviorRole.cost |
| Physical Assault State | Indicates if the incident is being reported to fulfill the state statute to report assault of a district employee. Reports as true if Physical Assault of a District Employee is marked. Otherwise reports as false. Alphanumeric | Behavior > Behavior Management > Incident > Participant > Physical Assault of District Employee BehaviorRole.physicalAssaultOfEmployee |
