Tool Search: DIRS Extract
The Disciplinary Incident Reporting System (DIRS) extract reports information about behavior data including suspensions, expulsions, and weapons.
DIRS Extract EditorReport 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 can submit 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 with a Start Date on or before extract editor Start Date and End Date is null or after extract End Date, report "1".
| System Administration > Resources > School > School Policy > Policy schoolPolicy.policy |
| Anti-Violence Policy | Indicates if the school has an Anti-Violence policy in place. If a policy record exists with a value of 03 with a Start Date on or before extract editor Start Date and End Date is null or after extract End Date, report "1".
| System Administration > Resources > School > School Policy > Policy schoolPolicy.policy |
| Drug Education | Indicates if the school has an Alcohol/Drug Education policy in place. If a policy record exists with a value of 06 with a Start Date on or before extract editor Start Date and End Date is null or after extract End Date, report "1".
| System Administration > Resources > School > School Policy > Policy schoolPolicy.policy |
| Zero Tolerance Policy | Indicates if the school has a Zero/No Tolerance policy in place. If a policy record exists with a value of 02 with a Start Date on or before extract editor Start Date and End Date is null or after extract End Date, report "1".
| System Administration > Resources > School > School Policy > Policy schoolPolicy.policy |
| Anti-Bullying Policy | Indicates if the school has a Anti-Bullying/Anti-Intimidation policy in place. If a policy record exists with a value of 04 with a Start Date on or before extract editor Start Date and End Date is null or after extract End Date, report "1".
| 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 with a Start Date on or before extract editor Start Date and End Date is null or after extract End Date, report "1".
| System Administration > Resources > School > School Policy > Policy schoolPolicy.policy |
| Discipline Complaint Procedure | Indicates that the school implements a discipline complaint procedure. If a policy record exists with a value of 07 with a Start Date on or before extract editor Start Date and End Date is null or after extract End Date, report "1".
| System Administration > Resources > School > School Policies Tab > 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 Office > Behavior Management > Incident > Date of Incident BehaviorIncident.date |
| Time of Incident | The time the incident took place. Numeric | Behavior Office > Behavior Management > Incident > Context BehaviorIncident.context |
| Cost to Property | The cost the school incurred by this event.
Numeric | Behavior Office > Behavior Management > Incident > Damages |
| Incident Location | Reports the total number of locations listed. | |
| Incident Location | The location of the incident Numeric | Behavior Office > Behavior Management > Incident > Location BehaviorIncident.location |
| Number of Unknown Offenders | The total number of unknown offenders. Numeric | Behavior Office > 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. Report "1" if a previous Behavior Resolution record exists for the reported Offender when Role = Offender with a Resolution Type = 1 or 2 and Resolution End Date of previous record is null or > Date of Incident being reported.
| Behavior Office > Behavior Management > Resolution Calculated |
| Was Referred Law Enforcement | Indicates if the Offender was referred to law enforcement. If checked, report "1" when Role = Offender. If unchecked, report "0". | Behavior Office > Behavior Management > Resolution > Referred to Law Enforcement BehaviorResolution.lawEnforcement |
| Was Arrested Law Enforcement | Indicates if the offender was Arrested by Law Enforcement. Reports Yes or No based on whether the student's behavior resolution has been flagged as an arrest was made. If "Arrest Made" is checked, report "1". If "Arrest Made" is unchecked, report "0". | Behavior Office > Behavior Management > Resolution > Arrest Made BehaviorResolution.arrestMade |
| Reasonable Force Used | Indicates whether reasonable force was used to correct or restrain the student. 1. Report '1':
2. Otherwise, report '0' if unchecked and role = offender. | Behavior Office > Behavior Management > Event and Participant Details > Participant Details > Reasonable Force Used behaviorRole.reasonableForce |
| Reasonable Force Role | Indicates the role of the adult who implemented reasonable force. Report value selected:.
| Behavior Office > Behavior Management > Event and Participant Details > Participant Details > Reasonable Force Role behaviorRole.reasonableForceRole |
| 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 Office > 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, 4, 6, 12, 13, or 15. Alphanumeric | Behavior Office > 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 or 0 and Role is Offender. Alphanumeric | Behavior Office > 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 or 0 and Role is Offender. Numeric | Behavior Office > 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 = 02 or 03 and Role = Offender, report "1". Otherwise, report "0". Alphanumeric | Behavior Office > 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. | Behavior Office > 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 Office > 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 = 01, 03, 05, or 07 and Role = Offender, report "1". Otherwise, report "0". | Behavior Office > 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 = 02, 03, 06, or 07 and Role = Offender, report "1". Otherwise, report "0". | Behavior Office > 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 = 04, 05, 06, or 07 and Role = Offender, report "1". Otherwise, report "0". | Behavior Office > 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 Office > Behavior Management > Incident > Participant > Drug Type BehaviorDrug.drugType |
| Drug Type Other Description | Description for other drug type (not found in drug type selection list).
| Behavior Office > Behavior Management > Event and Participant Details > Participant Details > Drug Description BehaviorDrug.drugDescription |
| Incident Type Other Description | A brief description of student activities and incident. Report if role = offender and offenderActivityType = 23 | Behavior > Behavior Management > Event and Participant Details > Participant Details > Details |
| Disciplinary Action | Reports a Disciplinary Action record when the following conditions are met:
| |
| 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 Office > Behavior Management > Incident > Resolution > Resolution Type BehaviorResolution.stateResCode |
| No Response Explanation | Explanation for instances of no school disciplinary action. When Behavior Resolution Type state code = 11 or 13, report Details. Otherwise, do not report. | Behavior Office > Behavior Management > Incident > Resolution > Details BehaviorResolution.details |
| Was DAT Through Year | Indicates if the expulsion lasted through the end of the current school year. Report "1" when Behavior Resolution Type state code = 3, Role = Offender, and Relationship to School = 1 or 4. Otherwise, report "0". If Behavior Resolution Type state code <> 3, do not report. | Behavior Office > Behavior Management > Incident > Resolution > Resolution Type Calculated |
| Num Days | Enter the number of whole or half School days (.5, 1, 1.5, etc.) If Behavior Resolution Type state code = 1, 2, 3, 4, 5, or 6, report the value in Duration in School Days. Otherwise, do not report. | Behavior Office > Behavior Management > Resolution Details > Duration in School Days |
| Start Date | Start Date of resolution. Report the Start Date of the reported Behavior Resolution when Resolution Type state code = 3 or 4; otherwise, do not report. Date | Behavior Office > Behavior Management > Incident > Resolution > Resolution Start Date BehaviorResolution.startDate |
| End Date | End Date of the resolution. Report the End Date of the reported Behavior Resolution when Resolution Type state code = 3 or 4. Otherwise, do not report. Date | Behavior Office > 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. Report "1" if Behavior Resolution Type state code = 3 and Number Days Reduced is populated. Otherwise report "0". If Behavior Resolution Type state code <> 3, do not report element. | Behavior Office > 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 Office > 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. Report "1" if the Behavior Resolution End Date < school year End Date and wasExpulsionModified = 1. Otherwise, report "0". If wasExpulsionModified = 0, do not report. | Behavior Office > 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 Office > 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 Office > Behavior Management > Incident > Resolution > Details BehaviorResolution.details |
| Non-Exclusionary Discipline Type | Identified Non-Exclusionary discipline (NED) alternative interventions. Report the code selected for the Behavior Resolution where Role = Offender and the Behavior Resolution Type = 3, 4, or 15. | Behavior Office > Behavior Management > Resolution Details > Non-Exclusionary Discipline Type customBehaviorResolution.intervention |
| Non-Exclusionary Discipline Explanation | Specific interventions implemented for the student for the incident. When Behavior Resolution Type state code = 3, 4 or 15, report Details. Otherwise, do not report. | Behavior Office > Behavior Management > Resolution Details > 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 Office > 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 Office > 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 Office > 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 Office > 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. Report "1" if Injury = 2, 3, or 4 when Role = Victim. Otherwise, report "0". | Behavior Office > Behavior Management > Incident > Participant > Injury BehaviorRole.injury |
| Was Serious Bodily Injury | Indicates if injury qualified as serious bodily injury based on federal law. Report "1" if Injury = 4 when Role = Victim. Otherwise, report "0". | Behavior Office > 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 Office > 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 Office > Behavior Management > Participant > Cost to Victim BehaviorRole.cost |
| Reasonable Force Used Victim | Indicates whether reasonable force was used to correct or restrain an enrolled student victim.
| Behavior Office > Behavior Management > Event and Participant Details > Participant Details > Reasonable Force Used behaviorRole.reasonableForce |
| Reasonable Force Role Victim | Indicates the role of the adult who implemented reasonable force on the enrolled student victim. Report value selected:
| Behavior Office > Behavior Management > Event and Participant Details > Participant Details > Reasonable Force Role behaviorRole.reasonableForceRole |
| Physical Assault State | Are you reporting this incident to fulfill your requirement to report assault of a district employee as set forth under Minn Stat 121A.53. Note: Required if VictimType = Teacher or District Employee, offenderActivity (event) = assault and offenseType = Physical Assault OR offenderActivity = 2, 4, 22, or 28. When physicalAssualt = true, report "1". Otherwise, report "0". | Behavior Office > Behavior Management > Incident > Participant > Physical Assault of District Employee BehaviorRole.physicalAssaultOfEmployee |
