Spreadsheet: 11fe4fc9-e945-4105-8d4f-4423861a93aa
Sheet: 2012 DIRS File Layout

Field Category | Field and/or Heading (as displayed in DIRS) | Field (as displayed in reports or column headings) | [NAME] (batch loads) | Field Values | Field Value Descriptions | Format | Length | Req or Cndtl | Comments | Applicable to School Record | Applicable to Incident Record | Applicable to Offender Record | Applicable to Victim Record | Applicable to Weapon Record | Applicable to Disciplinary Action Record | Field Row Last Changed Date
Incident | Cost to school incurred by this event | costToProperty | costToProperty | 1 | $0 | Number | 1 | R | Required to select one. | N | Y | N | N | N | N | 2009-12-02 00:00:00
Incident | Cost to school incurred by this event | costToProperty | costToProperty | 2 | $1 - $500 | Number | 1 | R | Required to select one. | N | Y | N | N | N | N | 2009-12-02 00:00:00
Incident | Cost to school incurred by this event | costToProperty | costToProperty | 3 | Over $500 | Number | 1 | R | Required to select one. | N | Y | N | N | N | N | 2009-12-02 00:00:00
Incident | External Reference ID | externalRefNum | externalIncidentId |  | External Reference Number |  |  | C | Only appears for batch uploaded documents, indicating the local reference number of the document | N | Y | N | N | N | N | 2009-05-29 00:00:00
Incident | Date of Incident | incidentDate | incidentDate |  | Date the incident occurred | Date | 8 | R | Date the incident occurred.  [NAME]-DD | N | Y | N | N | N | N | 2011-12-07 00:00:00
Incident | Location of Incident. Selection: Classroom | incidentLocation | incidentLocation | 1 | Classroom | [NAME] | 2 | R | Required to select all which apply to incident. | N | Y | N | N | N | N | 2009-12-02 00:00:00
Incident | Location of Incident. Selection: Hallway | incidentLocation | incidentLocation | 2 | Hallway | [NAME] | 2 | R | Required to select all which apply to incident. | N | Y | N | N | N | N | 2009-12-02 00:00:00
Incident | Location of Incident. Selection: Locker | incidentLocation | incidentLocation | 3 | Locker | [NAME] | 2 | R | Required to select all which apply to incident. | N | Y | N | N | N | N | 2009-12-02 00:00:00
Incident | Location of Incident. Selection: Restroom | incidentLocation | incidentLocation | 4 | Restroom | [NAME] | 2 | R | Required to select all which apply to incident. | N | Y | N | N | N | N | 2009-12-02 00:00:00
Incident | Location of Incident. Selection: Other indoor area | incidentLocation | incidentLocation | 5 | Other indoor area | [NAME] | 2 | R | Required to select all which apply to incident. | N | Y | N | N | N | N | 2009-12-02 00:00:00
Incident | Location of Incident. Selection: School Bus | incidentLocation | incidentLocation | 6 | School Bus | [NAME] | 2 | R | Required to select all which apply to incident. | N | Y | N | N | N | N | 2009-12-02 00:00:00
Incident | Location of Incident. Selection: Parking lot | incidentLocation | incidentLocation | 7 | Parking Lot | [NAME] | 2 | R | Required to select all which apply to incident. | N | Y | N | N | N | N | 2009-12-02 00:00:00
Incident | Location of Incident. Selection: Other outdoor area (on campus) | incidentLocation | incidentLocation | 8 | Other outdoor area (on campus) | [NAME] | 2 | R | Required to select all which apply to incident. | N | Y | N | N | N | N | 2009-12-02 00:00:00
Incident | Location of Incident. Selection: Off campus | incidentLocation | incidentLocation | 9 | Off campus | [NAME] | 2 | R | Required to select all which apply to incident. | N | Y | N | N | N | N | 2009-12-02 00:00:00
Incident | Time of Incident | timeOfIncident | timeOfIncident | 1 | During School Hours | Number | 1 | R | Required to select one. | N | Y | N | N | N | N | 2009-12-02 00:00:00
Incident | Time of Incident | timeOfIncident | timeOfIncident | 2 | Outside of School Hours | Number | 1 | R | Required to select one. | N | Y | N | N | N | N | 2009-12-02 00:00:00
Incident | Did this incident involve a dangerous weapon? | wasDangerousWeaponInvolved | Non applicable in XML | Y or N | Indicator whether a dangerous weapon was involved in the incident | [NAME] | 1 | C | If there were no known offenders, did this incident involve a dangerous weapon? | N | Y | N | N | N | N | 2010-11-10 00:00:00
Incident - Offender/Victim | Medical costs to victim incurred by this event | costToVictim | costToVictim | 1 | $0 | Number | 1 | C | Indicates the cost this victim incurred as a result of this incident.  Required to select one if at least one victim is identified. | N | N | N | Y | N | N | 2011-12-12 00:00:00
Incident - Offender/Victim | Medical costs to victim incurred by this event | costToVictim | costToVictim | 2 | $1 - $500 | Number | 1 | C | Indicates the cost this victim incurred as a result of this incident.  Required to select one if at least one victim is identified. | N | N | N | Y | N | N | 2011-12-12 00:00:00
Incident - Offender/Victim | Medical costs to victim incurred by this event | costToVictim | costToVictim | 3 | Over $500 | Number | 1 | C | Indicates the cost this victim incurred as a result of this incident.  Required to select one if at least one victim is identified. | N | N | N | Y | N | N | 2011-12-12 00:00:00
Incident - Offender/Victim | Date of Birth | Date of Birth | Non applicable in XML | MARSS | Date of Birth | Date | 8 | C | Only displayed as part of offender or victim search and identification.  [NAME]: YYYY-MM-DD | N | Y | Y | Y | N | Y | 2011-12-07 00:00:00
Incident - Offender/Victim | Did injury occur to this victim? | didInjuryOccur | didInjuryOccur | Y or N | Indicator whether an injury occurred related to the incident | [NAME] | 1 | C | Indicates if this victim was injured during the incident. Required if at least one victim is identified. | N | N | N | Y | N | N | 2011-12-12 00:00:00
Incident - Offender/Victim | Grade | Grade | Non applicable in XML | MARSS | Grade | [NAME] | 2 | C | Only displayed as part of offender or victim search and identification. | N | Y | Y | Y | N | Y | 2010-05-24 00:00:00
Incident - Offender/Victim | MARSS Number | marssNumber | marssNumber | MARSS | Student identification number submitted via MARSS for the enrolled offender/victim | [NAME] | 13 | C | MARSS number must be a valid number of a student offender or victim enrolled in the submitting school on the date of the incident.  Conditionally required for victim checkbox is selected for "There are victims enrolled or employed in this school." and victimType is 1.  MARSS number is also conditionally required when offender checkbox is selected for There are offenders enrolled in this school. | N | N | Y | Y | Y | Y | 2010-11-10 00:00:00
Incident - Offender/Victim | Estimated victim count | multipleVictimCount | victimCount |  | numeric count |  |  | C | Required when victim type is 5. | N | N | N | Y | N | N | 2011-12-12 00:00:00
Incident - Offender/Victim | Name | Name | Non applicable in XML | MARSS | Name | [NAME] |  | C | Only displayed as part of offender or victim search and identification. | N | Y | Y | Y | N | Y | 2010-05-24 00:00:00
Incident - Offender/Victim | Identify the number of offender(s) not enrolled. | numUnknownOffenders | numberUnknownOffenders |  | Number of unknown offenders | Number | 2 | C | Required if offenders not enrolled was selected.  Indicates the number of offenders involved in this incident who are not currently enrolled at this school. | N | Y | N | N | N | N | 2010-11-10 00:00:00
Incident - Offender/Victim | Identify the number of unenrolled victim(s). | numUnknownVictims | numberUnknownVictims |  | Number of unknown victims | Number | 2 | C | Required if victims not enrolled at this school was selected.  Indicates the number of victims involved in this incident who are not currently enrolled at this school. | N | Y | N | N | N | N | 2010-11-10 00:00:00
Incident - Offender/Victim | Select type of victim.  Radio button: Student (MARSS information known) | victimType | victimType | 1 | Student (MARSS information known) | [NAME] | 1 | C | Required to select one if an enrolled or employed victim was selected. Incidents must identify victim (known and victim type, or as unknown) for offender activities of: assault, harrassment, bullying, hazing, cyber bullying, homicide or robbery. Incidents may identify victim (known and victim type, or as unknown) for other offender activities. | N | N | N | Y | N | N | 2011-12-12 00:00:00
Incident - Offender/Victim | Select type of victim.  Radio button: Teacher | victimType | victimType | 2 | Teacher | [NAME] | 1 | C | Required to select one if an enrolled or employed victim was selected. Incidents must identify victim (known and victim type, or as unknown) for offender activities of: assault, harrassment, bullying, hazing, cyber bullying, homicide or robbery. Incidents may identify victim (known and victim type, or as unknown) for other offender activities. | N | N | N | Y | N | N | 2011-12-12 00:00:00
Incident - Offender/Victim | Select type of victim.  Radio button: District Employee | victimType | victimType | 3 | District Employee | [NAME] | 1 | C | Required to select one if an enrolled or employed victim was selected. Incidents must identify victim (known and victim type, or as unknown) for offender activities of: assault, harrassment, bullying, hazing, cyber bullying, homicide or robbery. Incidents may identify victim (known and victim type, or as unknown) for other offender activities. | N | N | N | Y | N | N | 2011-12-12 00:00:00
Incident - Offender/Victim | Select type of victim.  Radio button: Student (MARSS information unknown) | victimType | victimType | 4 | Student (MARSS information unknown) | [NAME] | 1 | C | Required to select one if an enrolled or employed victim was selected. Incidents must identify victim (known and victim type, or as unknown) for offender activities of: assault, harrassment, bullying, hazing, cyber bullying, homicide or robbery. Incidents may identify victim (known and victim type, or as unknown) for other offender activities. | N | N | N | Y | N | N | 2011-12-12 00:00:00
Incident - Offender/Victim | Select type of victim.  Radio button: Multiple (i.e.: bus, class, schoolwide) | victimType | victimType | 5 | Multiple (i.e.: bus, class, schoolwide) | [NAME] | 1 | C | Required to select one if an enrolled or employed victim was selected. Incidents must identify victim (known and victim type, or as unknown) for offender activities of: assault, harrassment, bullying, hazing, cyber bullying, homicide or robbery. Incidents may identify victim (known and victim type, or as unknown) for other offender activities. | N | N | N | Y | N | N | 2011-12-12 00:00:00
Incident - Offender/Victim | Was the injury a serious bodily injury under federal law? | wasSeriousBodilyInjury | wasSeriousBodilyInjury | Y or N | Was it a serious bodily injury? | [NAME] | 1 | C | Required when Did injury occur to this victim=Y. | N | Y | N | Y | N | N | 2009-12-02 00:00:00
Incident - Offender/Victim | Checkbox: There are offenders enrolled in this school. |  | Non applicable in XML |  | At least one offender involved in incident was enrolled at the school at the date of incident. | [NAME] | 1 | C | Required if an offender is enrolled in the school. | N | Y | Y | N | N | Y | 2010-05-24 00:00:00
Incident - Offender/Victim | Checkbox: There are offenders not enrolled in this school. |  | Non applicable in XML |  | At least one offender involved in incident was not enrolled at the school at the date of incident. | [NAME] | 1 | C | Required if an offender is not enrolled in the school. | N | Y | Y | N | N | Y | 2010-05-24 00:00:00
Incident - Offender/Victim | Checkbox: There are victims enrolled or employed in this school. |  | Non applicable in XML |  | At least one victim in the incident was enrolled or employed at the school at the date of incident. | [NAME] | 1 | C | Required if a victim is enrolled or employed by the school. | N | Y | N | Y | N | N | 2011-12-12 00:00:00
Incident - Offender/Victim | Checkbox: There are victims not enrolled in this school. |  | Non applicable in XML |  | At least one victim in the incident was not enrolled at the school at the date of incident. | [NAME] | 1 | C | Required is a victim is not enrolled in the school. | N | Y | N | Y | N | N | 2010-05-24 00:00:00
Incident - Offender Activity | Select the drug(s) that were involved. Checkbox: Amphetamines | drugType | drugType | 1 | Amphetamines | [NAME] | 2 | C | Requires one to multiple selections if offenderActivity is 13. | N | N | Y | N | N | N | 2009-12-02 00:00:00
Incident - Offender Activity | Select the drug(s) that were involved. Checkbox: Crack/Cocaine | drugType | drugType | 2 | Crack/Cocaine | [NAME] | 2 | C | Requires one to multiple selections if offenderActivity is 13. | N | N | Y | N | N | N | 2009-12-02 00:00:00
Incident - Offender Activity | Select the drug(s) that were involved. Checkbox: Ecstasy/MDMA | drugType | drugType | 3 | Ecstasy/MDMA | [NAME] | 2 | C | Requires one to multiple selections if offenderActivity is 13. | N | N | Y | N | N | N | 2009-12-02 00:00:00
Incident - Offender Activity | Select the drug(s) that were involved. Checkbox: Inhalants | drugType | drugType | 4 | Inhalants | [NAME] | 2 | C | Requires one to multiple selections if offenderActivity is 13. | N | N | Y | N | N | N | 2009-12-02 00:00:00
Incident - Offender Activity | Select the drug(s) that were involved. Checkbox: LSD/Psychedelics | drugType | drugType | 5 | LSD/Psychedelics | [NAME] | 2 | C | Requires one to multiple selections if offenderActivity is 13. | N | N | Y | N | N | N | 2009-12-02 00:00:00
Incident - Offender Activity | Select the drug(s) that were involved. Checkbox: [NAME] | drugType | drugType | 6 | [NAME] | [NAME] | 2 | C | Requires one to multiple selections if offenderActivity is 13. | N | N | Y | N | N | N | 2009-12-02 00:00:00
Incident - Offender Activity | Select the drug(s) that were involved. Checkbox: Methamphetamines | drugType | drugType | 7 | Methamphetamines | [NAME] | 2 | C | Requires one to multiple selections if offenderActivity is 13. | N | N | Y | N | N | N | 2009-12-02 00:00:00
Incident - Offender Activity | Select the drug(s) that were involved. Checkbox: Other | drugType | drugType | 8 | Other | [NAME] | 2 | C | Requires one to multiple selections if offenderActivity is 13. | N | N | Y | N | N | N | 2009-12-02 00:00:00
Incident - Offender Activity | Description | drugTypeOtherDescription | drugTypeOtherDescription |  | Description for other drug type (not found in drug type selection list) | [NAME] | 600 | C | Required if offenderActivity is 13 and drugType is 8. | N | Y | Y | N | Y | N | 2009-12-02 00:00:00
Incident - Offender Activity | Checkbox: Alcohol | incidentType | offenderActivity | 1 | Alcohol | [NAME] | 2 | R | Per enrolled offender, required to identify one to multiple offender activities per incident. | N | N | Y | N | N | N | 2009-12-02 00:00:00
Incident - Offender Activity | Checkbox: Arson | incidentType | offenderActivity | 2 | [NAME] | [NAME] | 2 | R | Per enrolled offender, required to identify one to multiple offender activities per incident. | N | N | Y | N | N | N | 2009-12-02 00:00:00
Incident - Offender Activity | Checkbox: Assault | incidentType | offenderActivity | 3 | Assault | [NAME] | 2 | R | Per enrolled offender, required to identify one to multiple offender activities per incident.  Must identify at least one victim for this offender activity. | N | N | Y | N | N | N | 2011-12-12 00:00:00
Incident - Offender Activity | Checkbox: Bomb | incidentType | offenderActivity | 4 | Bomb | [NAME] | 2 | R | Per enrolled offender, required to identify one to multiple offender activities per incident. | N | N | Y | N | N | N | 2009-12-02 00:00:00
Incident - Offender Activity | Checkbox: Bomb Threat | incidentType | offenderActivity | 5 | Bomb threat | [NAME] | 2 | R | Per enrolled offender, required to identify one to multiple offender activities per incident. | N | N | Y | N | N | N | 2009-12-02 00:00:00
Incident - Offender Activity | Checkbox: Controlled Substances (prescription) | incidentType | offenderActivity | 6 | Controlled Substances (prescription) | [NAME] | 2 | R | Per enrolled offender, required to identify one to multiple offender activities per incident. | N | N | Y | N | N | N | 2009-12-02 00:00:00
Incident - Offender Activity | Checkbox: Computer | incidentType | offenderActivity | 7 | Computer | [NAME] | 2 | R | Per enrolled offender, required to identify one to multiple offender activities per incident. | N | N | Y | N | N | N | 2009-12-02 00:00:00
Incident - Offender Activity | Checkbox: Disruptive/Disorderly Conduct/Insubordination | incidentType | offenderActivity | 8 | Disruptive/Disorderly Conduct/Insubordination | [NAME] | 2 | R | Per enrolled offender, required to identify one to multiple offender activities per incident. | N | N | Y | N | N | N | 2009-12-02 00:00:00
Incident - Offender Activity | Checkbox: Extortion | incidentType | offenderActivity | 9 | Extortion | [NAME] | 2 | R | Per enrolled offender, required to identify one to multiple offender activities per incident. | N | N | Y | N | N | N | 2009-12-02 00:00:00
Incident - Offender Activity | Checkbox: Fighting | incidentType | offenderActivity | 10 | Fighting | [NAME] | 2 | R | Per enrolled offender, required to identify one to multiple offender activities per incident.  [NAME] identification for fighting incidents is optional, since in some incidents, district may determine district to determine dual offender versus offender-victim situations. | N | N | Y | N | N | N | 2011-12-19 00:00:00
Incident - Offender Activity | Checkbox: Gang Activity | incidentType | offenderActivity | 11 | Gang Activity | [NAME] | 2 | R | Per enrolled offender, required to identify one to multiple offender activities per incident. | N | N | Y | N | N | N | 2009-12-02 00:00:00
Incident - Offender Activity | Checkbox: Harassment | incidentType | offenderActivity | 12 | Harassment | [NAME] | 2 | R | Per enrolled offender, required to identify one to multiple offender activities per incident.  Must identify at least one victim for this offender activity. | N | N | Y | N | N | N | 2011-12-12 00:00:00
Incident - Offender Activity | Checkbox: Illegal Drugs | incidentType | offenderActivity | 13 | Illegal Drugs | [NAME] | 2 | R | Per enrolled offender, required to identify one to multiple offender activities per incident. | N | N | Y | N | N | N | 2009-12-02 00:00:00
Incident - Offender Activity | Checkbox: Over-the-Counter Medications against school policy | incidentType | offenderActivity | 14 | Over-the-Counter Medications against school policy | [NAME] | 2 | R | Per enrolled offender, required to identify one to multiple offender activities per incident. | N | N | Y | N | N | N | 2009-12-02 00:00:00
Incident - Offender Activity | Checkbox: Pyrotechnics | incidentType | offenderActivity | 15 | Pyrotechnics | [NAME] | 2 | R | Per enrolled offender, required to identify one to multiple offender activities per incident. | N | N | Y | N | N | N | 2009-12-02 00:00:00
Incident - Offender Activity | Checkbox: Terroristic Threats | incidentType | offenderActivity | 16 | Terroristic Threats | [NAME] | 2 | R | Per enrolled offender, required to identify one to multiple offender activities per incident. | N | N | Y | N | N | N | 2009-12-02 00:00:00
Incident - Offender Activity | Checkbox: Theft | incidentType | offenderActivity | 17 | Theft | [NAME] | 2 | R | Per enrolled offender, required to identify one to multiple offender activities per incident. | N | N | Y | N | N | N | 2009-12-02 00:00:00
Incident - Offender Activity | Checkbox: Threat/Intimidation | incidentType | offenderActivity | 18 | Threat/Intimidation | [NAME] | 2 | R | Per enrolled offender, required to identify one to multiple offender activities per incident. | N | N | Y | N | N | N | 2009-12-02 00:00:00
Incident - Offender Activity | Checkbox: Tobacco | incidentType | offenderActivity | 19 | Tobacco | [NAME] | 2 | R | Per enrolled offender, required to identify one to multiple offender activities per incident. | N | N | Y | N | N | N | 2009-12-02 00:00:00
Incident - Offender Activity | Checkbox: Vandalism/Property Related | incidentType | offenderActivity | 20 | Vandalism/Property Related | [NAME] | 2 | R | Per enrolled offender, required to identify one to multiple offender activities per incident. | N | N | Y | N | N | N | 2009-12-02 00:00:00
Incident - Offender Activity | Checkbox: Verbal Abuse | incidentType | offenderActivity | 21 | Verbal Abuse | [NAME] | 2 | R | Per enrolled offender, required to identify one to multiple offender activities per incident. | N | N | Y | N | N | N | 2009-12-02 00:00:00
Incident - Offender Activity | Checkbox: Weapon | incidentType | offenderActivity | 22 | Weapon | [NAME] | 2 | R | Per enrolled offender, required to identify one to multiple offender activities per incident. | N | N | Y | N | N | N | 2009-12-02 00:00:00
Incident - Offender Activity | Checkbox: Other | incidentType | offenderActivity | 23 | Other | [NAME] | 2 | R | Per enrolled offender, required to identify one to multiple offender activities per incident. | N | N | Y | N | N | N | 2009-12-02 00:00:00
Incident - Offender Activity | Checkbox: Attendance | incidentType | offenderActivity | 24 | Attendance | [NAME] | 2 | R | Per enrolled offender, required to identify one to multiple offender activities per incident. | N | N | Y | N | N | N | 2009-12-02 00:00:00
Incident - Offender Activity | Checkbox: Bullying (all forms except cyber bullying) | incidentType | offenderActivity | 25 | Bullying (all forms except cyber bullying) | [NAME] | 2 | R | Per enrolled offender, required to identify one to multiple offender activities per incident.  Must identify at least one victim for this offender activity. | N | N | Y | N | N | N | 2011-12-12 00:00:00
Incident - Offender Activity | Checkbox: Hazing | incidentType | offenderActivity | 26 | Hazing | [NAME] | 2 | R | Per enrolled offender, required to identify one to multiple offender activities per incident.  Must identify at least one victim for this offender activity. | N | N | Y | N | N | N | 2011-12-12 00:00:00
Incident - Offender Activity | Checkbox: [NAME] | incidentType | offenderActivity | 27 | [NAME] | [NAME] | 2 | R | Per enrolled offender, required to identify one to multiple offender activities per incident.  Must identify at least one victim for this offender activity. | N | N | Y | N | N | N | 2011-12-12 00:00:00
Incident - Offender Activity | Checkbox: Homicide | incidentType | offenderActivity | 28 | Homicide | [NAME] | 2 | R | Per enrolled offender, required to identify one to multiple offender activities per incident.  Must identify at least one victim for this offender activity. | N | N | Y | N | N | N | 2011-12-12 00:00:00
Incident - Offender Activity | Checkbox: Robbery (using force) | incidentType | offenderActivity | 29 | Robbery (using force) | [NAME] | 2 | R | Per enrolled offender, required to identify one to multiple offender activities per incident.  Must identify at least one victim for this offender activity. | N | N | Y | N | N | N | 2011-12-12 00:00:00
Incident - Offender Activity | Was the gun cased? | isGunCased | isGunCased | Y or N | Indicator whether the gun was cased | [NAME] | 1 | C | Required if weaponType is 1 or 2. | N | N | N | N | Y | N | 2010-11-10 00:00:00
Incident - Offender Activity | Was the gun in the trunk of the vehicle? | isGunInTrunk | isGunInTrunk | Y or N | Indicator whether the gun was in the trunk | [NAME] | 1 | C | Required if weaponType is 1 or 2. | N | N | N | N | Y | N | 2010-11-10 00:00:00
Incident - Offender Activity | Was the gun loaded? | isGunLoaded | isGunLoaded | Y or N | Indicator whether the gun was loaded | [NAME] | 1 | C | Required if weaponType is 1 or 2. | N | N | N | N | Y | N | 2010-11-10 00:00:00
Incident - Offender Activity | Add button or [NAME]: Number of ___s involved: | numWeapons | numberWeaponsInvolved |  | Number of weapons involved | Number | 2 | C | The number of weapons for a specific weapon type involved in an incident.  As an example if the weaponType is Knife, this number would tell us how many knives this offender had during this incident.  Use the [NAME] button to increment for long gun or hand gun or the text box to enter the number for other weapon types. | N | N | N | N | Y | N | 2010-11-10 00:00:00
Incident - Offender Activity | Radio button: Physical assault | offenseType | offenseType | 1 | Physical Assault | [NAME] | 2 | C | Requires one selection if offenderActivity is 3. | N | N | Y | N | N | N | 2009-12-02 00:00:00
Incident - Offender Activity | Radio button: Sexual assault | offenseType | offenseType | 2 | Sexual Assault | [NAME] | 2 | C | Requires one selection if offenderActivity is 3. | N | N | Y | N | N | N | 2009-12-02 00:00:00
Incident - Offender Activity | Radio button: Sexual | offenseType | offenseType | 3 | Sexual | [NAME] | 2 | C | Requires one selection if offenderActivity is 12. | N | N | Y | N | N | N | 2009-12-02 00:00:00
Incident - Offender Activity | Radio button: Non-sexual | offenseType | offenseType | 4 | Non-sexual | [NAME] | 2 | C | Requires one selection if offenderActivity is 12. | N | N | Y | N | N | N | 2009-12-02 00:00:00
Incident - Offender Activity | Radio button: Possession/Use | offenseType | offenseType | 5 | Possession/Use | [NAME] | 2 | C | Requires one selection if offenderActivity is 1, 6, or 13. | N | N | Y | N | N | N | 2009-12-02 00:00:00
Incident - Offender Activity | Radio button: Solicitation/Sale | offenseType | offenseType | 6 | Solicitation/Sale | [NAME] | 2 | C | Requires one selection if offenderActivity is 1, 6, or 13. | N | N | Y | N | N | N | 2009-12-02 00:00:00
Incident - Offender Activity | Radio [NAME]: with Accelerant | offenseType | offenseType | 7 | With Accelerant | [NAME] | 2 | C | Requires one selection if offenderActivity is 2. | N | N | Y | N | N | N | 2011-07-27 00:00:00
Incident - Offender Activity | Radio [NAME]: without Accelerant | offenseType | offenseType | 8 | Without Accelerant | [NAME] | 2 | C | Requires one selection if offenderActivity is 2. | N | N | Y | N | N | N | 2011-07-27 00:00:00
Incident - Offender Activity | Is this considered dangerous by  federal statute? | wasUsedAsADangerousWeaponFed | wasUsedAsADangerousWeaponFed | Y or N | Meets federal statute of dangerous weapons? | [NAME] | 1 | C | Required if offenderActivity is 2 and with [NAME] is selected, or if offenderActivity is 15, or if offender Activity is 22 and weaponType is 3, 6, 9, 11, 12, 13, 14 or 15. | N | Y | N | N | Y | N | 2010-05-24 00:00:00
Incident - Offender Activity | Is this considered dangerous by  state statute? | wasUsedAsADangerousWeaponState | wasUsedAsADangerousWeaponState | Y or N | Meets state statute of dangerous weapons? | [NAME] | 1 | C | Required if offenderActivity is 2 and with [NAME] is selected, or if offenderActivity is 15, or if offender Activity is 22 and weaponType is 3, 6, 9, 11, 12, 13, 14 or 15. | N | Y | N | N | Y | N | 2010-05-24 00:00:00
Incident - Offender Activity | Checkbox: Long Gun | weaponType | weaponType | 1 | Long Gun | [NAME] | 2 | C | Requires one to multiple selections if offenderActivity is 22. | N | N | N | N | Y | N | 2009-12-02 00:00:00
Incident - Offender Activity | Checkbox: Hand Gun | weaponType | weaponType | 2 | Hand Gun | [NAME] | 2 | C | Requires one to multiple selections if offenderActivity is 22. | N | N | N | N | Y | N | 2009-12-02 00:00:00
Incident - Offender Activity | Checkbox: Pellet/BB/Air Gun | weaponType | weaponType | 3 | Pellet/BB/Air Gun | [NAME] | 2 | C | Requires one to multiple selections if offenderActivity is 22. | N | N | N | N | Y | N | 2009-12-02 00:00:00
Incident - Offender Activity | Checkbox: Paintball Gun | weaponType | weaponType | 4 | Paintball Gun | [NAME] | 2 | C | Requires one to multiple selections if offenderActivity is 22. | N | N | N | N | Y | N | 2009-12-02 00:00:00
Incident - Offender Activity | Checkbox: Replica/Toy Gun | weaponType | weaponType | 5 | Replica/Toy Gun | [NAME] | 2 | C | Requires one to multiple selections if offenderActivity is 22. | N | N | N | N | Y | N | 2009-12-02 00:00:00
Incident - Offender Activity | Checkbox: Knife | weaponType | weaponType | 6 | Knife | [NAME] | 2 | C | Requires one to multiple selections if offenderActivity is 22. | N | N | N | N | Y | N | 2009-12-02 00:00:00
Incident - Offender Activity | Checkbox: Blunt Object (ex: numchucks or nunchaku, chains) | weaponType | weaponType | 9 | Blunt Object (ex: numchucks or nunchaku, chains) | [NAME] | 2 | C | Requires one to multiple selections if offenderActivity is 22. | N | N | N | N | Y | N | 2009-12-02 00:00:00
Incident - Offender Activity | Checkbox: Pocketknife less than 2 1/2 inches | weaponType | weaponType | 11 | Pocketknife less than 2 1/2 inches | [NAME] | 2 | C | Requires one to multiple selections if offenderActivity is 22. | N | N | N | N | Y | N | 2009-12-02 00:00:00
Incident - Offender Activity | Checkbox: Pocketknife 2 1/2 inches or greater | weaponType | weaponType | 12 | Pocketknife 2 1/2 inches or greater | [NAME] | 2 | C | Requires one to multiple selections if offenderActivity is 22. | N | N | N | N | Y | N | 2009-12-02 00:00:00
Incident - Offender Activity | Checkbox: Sharp Object - not a knife or pocketknife (ex: razor blade, chinese star) | weaponType | weaponType | 13 | Sharp Object | [NAME] | 2 | C | Requires one to multiple selections if offenderActivity is 22. | N | N | N | N | Y | N | 2010-05-24 00:00:00
Incident - Offender Activity | Checkbox: Mace/Noxious Substance | weaponType | weaponType | 14 | Mace/Noxious Substance | [NAME] | 2 | C | Requires one to multiple selections if offenderActivity is 22. | N | N | N | N | Y | N | 2010-05-24 00:00:00
Incident - Offender Activity | Checkbox: Stun Guns/Taser Gun | weaponType | weaponType | 15 | [NAME] Gun | [NAME] | 2 | C | Requires one to multiple selections if offenderActivity is 22. | N | N | N | N | Y | N | 2010-05-24 00:00:00
Disciplinary Action | The student was suspended from school for more than 5 days.  Select the educational setting that was provided.  Radio button: Enrollment in an area learning center | aesType | aesType | 1 | Enrollment in an area learning center | [NAME] | 2 | C | Required if disciplinaryActionType is 2, 3, 5, or 6, and numDays is more than 5. | N | N | N | N | N | Y | 2009-05-29 00:00:00
Disciplinary Action | The student was suspended from school for more than 5 days.  Select the educational setting that was provided.  Radio button: Enrollment in another district | aesType | aesType | 2 | Enrollment in another district | [NAME] | 2 | C | Required if disciplinaryActionType is 2, 3, 5, or 6, and numDays is more than 5. | N | N | N | N | N | Y | 2009-05-29 00:00:00
Disciplinary Action | The student was suspended from school for more than 5 days.  Select the educational setting that was provided.  Radio button: Homebound Instruction (at home or at a neutral site) | aesType | aesType | 3 | Homebound instruction (at home or at a neutral site) | [NAME] | 2 | C | Required if disciplinaryActionType is 2, 3, 5, or 6, and numDays is more than 5. | N | N | N | N | N | Y | 2009-05-29 00:00:00
Disciplinary Action | The student was suspended from school for more than 5 days.  Select the educational setting that was provided.  Radio button: Tele-teaching (electronic media, on-line teaching) | aesType | aesType | 4 | Tele-teaching (electronic media, on-line teaching) | [NAME] | 2 | C | Required if disciplinaryActionType is 2, 3, 5, or 6, and numDays is more than 5. | N | N | N | N | N | Y | 2009-05-29 00:00:00
Disciplinary Action | The student was suspended from school for more than 5 days.  Select the educational setting that was provided.  Radio button: Supervised homework (ongoing contact between teacher and student to monitor progress) | aesType | aesType | 5 | Supervised homework (ongoing contact between teacher and student to monitor progress) | [NAME] | 2 | C | Required if disciplinaryActionType is 2, 3, 5, or 6, and numDays is more than 5. | N | N | N | N | N | Y | 2009-05-29 00:00:00
Disciplinary Action | The student was suspended from school for more than 5 days.  Select the educational setting that was provided.  Radio button: Independent study | aesType | aesType | 6 | Independent study | [NAME] | 2 | C | Required if disciplinaryActionType is 2, 3, 5, or 6, and numDays is more than 5. | N | N | N | N | N | Y | 2009-05-29 00:00:00
Disciplinary Action | The student was suspended from school for more than 5 days.  Select the educational setting that was provided.  Radio button: Special tutoring | aesType | aesType | 7 | Special tutoring | [NAME] | 2 | C | Required if disciplinaryActionType is 2, 3, 5, or 6, and numDays is more than 5. | N | N | N | N | N | Y | 2009-05-29 00:00:00
Disciplinary Action | The student was suspended from school for more than 5 days.  Select the educational setting that was provided.  Radio button: District-run program for out of school suspensions | aesType | aesType | 8 | District-run program for out of school suspensions | [NAME] | 2 | C | Required if disciplinaryActionType is 2, 3, 5, or 6, and numDays is more than 5. | N | N | N | N | N | Y | 2009-05-29 00:00:00
Disciplinary Action | The student was suspended from school for more than 5 days.  Select the educational setting that was provided.  Radio button: Other | aesType | aesType | 9 | Other | [NAME] | 2 | C | Required if disciplinaryActionType is 2, 3, 5, or 6, and numDays is more than 5. | N | N | N | N | N | Y | 2009-05-29 00:00:00
Disciplinary Action | The student was suspended from school for more than 5 days.  Select the educational setting that was provided.  Radio button: Modified Curriculum | aesType | aesType | 10 | Modified Curriculum | [NAME] | 2 | C | Required if disciplinaryActionType is 2, 3, 5, or 6, and numDays is more than 5. | N | N | N | N | N | Y | 2009-05-29 00:00:00
Disciplinary Action | The student was suspended from school for more than 5 days.  Select the educational setting that was provided.  Radio button: Modified Instruction | aesType | aesType | 11 | Modified Instruction | [NAME] | 2 | C | Required if disciplinaryActionType is 2, 3, 5, or 6, and numDays is more than 5. | N | N | N | N | N | Y | 2009-05-29 00:00:00
Disciplinary Action | The student was suspended from school for more than 5 days.  Select the educational setting that was provided.  Radio button: Instruction through electronic media | aesType | aesType | 12 | Instruction through electronic media | [NAME] | 2 | C | Required if disciplinaryActionType is 2, 3, 5, or 6, and numDays is more than 5. | N | N | N | N | N | Y | 2009-05-29 00:00:00
Disciplinary Action | The student was suspended from school for more than 5 days.  Select the educational setting that was provided.  Radio button: Special education services | aesType | aesType | 13 | Special Education services | [NAME] | 2 | C | Required if disciplinaryActionType is 2, 3, 5, or 6, and numDays is more than 5. | N | N | N | N | N | Y | 2009-05-29 00:00:00
Disciplinary Action | Did the expulsion reduction result in student returning before the end of the school year? | didReturnBeforeEndSchoolYear | didReturnBeforeEndSchoolYear | Y or N | Did student return before the end of the school year? | [NAME] | 1 | C | Required when Did the Student return to school prior to the end date on the school board resolution = Y. | N | N | N | N | N | Y | 2009-12-02 00:00:00
Disciplinary Action | Removal from Educational Setting radio button: In-school Suspension | disciplinaryActionType | disciplinaryActionType | 1 | In-school Suspension | [NAME] | 2 | C | Available selection only if offender was Special Education on date of incident.  [NAME] one to multiple disciplinary actions per offender per respective incident, limited to one instance of each type per incident. Maximum value = 15 SCHOOL days. | N | N | N | N | N | Y | 2010-03-12 00:00:00
Disciplinary Action | Removal from Educational Setting radio button: Out-of-school Suspension | disciplinaryActionType | disciplinaryActionType | 2 | Out-of-school Suspension | [NAME] | 2 | R | Required to identify one to multiple disciplinary actions per enrolled offender per respective incident, limited to one instance of each type per incident.  Maximum value = 15 SCHOOL days. | N | N | N | N | N | Y | 2010-03-12 00:00:00
Disciplinary Action | Removal from Educational Setting radio button: Expulsion | disciplinaryActionType | disciplinaryActionType | 3 | Expulsion from the school setting | [NAME] | 2 | R | Required to identify one to multiple disciplinary actions per enrolled offender per respective incident, limited to one instance of each type per incident.  Minimum value = 5 SCHOOL days. | N | N | N | N | N | Y | 2010-03-12 00:00:00
Disciplinary Action | Removal from Educational Setting radio button: Exclusion | disciplinaryActionType | disciplinaryActionType | 4 | Exclusion from the school setting | [NAME] | 2 | R | Required to identify one to multiple disciplinary actions per enrolled offender per respective incident, limited to one instance of each type per incident.  Minimum value = 5 SCHOOL days. | N | N | N | N | N | Y | 2010-03-12 00:00:00
Disciplinary Action | Removal from Educational Setting radio button: Unilateral Removal to an Alternative Educational Setting | disciplinaryActionType | disciplinaryActionType | 5 | Unilateral Removal to an Alternative Educational Setting | [NAME] | 2 | C | Required if offenderActivity is 3 (and victim is identified with serious bodily injury), 6 (and Offense Type=6) or 10 (and victim is identified with serious bodily injury) or 13 or 22 (and is considered dangerous by federal definition) or 26 (and victim is identified with serious bodily injury) or 28.  Available selection only if enrolled offender was Special Education on date of incident. Identify one to multiple disciplinary actions per enrolled offender per respective incident, limited to one instance of each type per incident. | N | N | N | N | N | Y | 2010-03-12 00:00:00
Disciplinary Action | Removal from Educational Setting radio button: Removal by hearing officer on determination of likely injury | disciplinaryActionType | disciplinaryActionType | 6 | Removal by hearing officer on determination of likely injury | [NAME] | 2 | C | Available selection only if offender was Special Education on date of incident.  [NAME] one to multiple disciplinary actions per enrolled offender per respective incident, limited to one instance of each type per incident. | N | N | N | N | N | Y | 2010-03-12 00:00:00
Disciplinary Action | Transfer or Withdrawal: Radio button: [NAME] | disciplinaryActionType | disciplinaryActionType | 7 | Administrative Transfer | [NAME] | 2 | R | Required to identify one to multiple disciplinary actions per enrolled offender per respective incident, limited to one instance of each type per incident. | N | N | N | N | N | Y | 2010-03-12 00:00:00
Disciplinary Action | Transfer or Withdrawal: Radio button: Offender requested to transfer within district | disciplinaryActionType | disciplinaryActionType | 8 | Offender requested to transfer within district | [NAME] | 2 | R | Required to identify one to multiple disciplinary actions per enrolled offender per respective incident, limited to one instance of each type per incident. | N | N | N | N | N | Y | 2010-03-12 00:00:00
Disciplinary Action | Transfer or Withdrawal: Radio button: Offender requested to transfer to another district | disciplinaryActionType | disciplinaryActionType | 9 | Offender requested to transfer to another district | [NAME] | 2 | R | Required to identify one to multiple disciplinary actions per enrolled offender per respective incident, limited to one instance of each type per incident. | N | N | N | N | N | Y | 2010-03-12 00:00:00
Disciplinary Action | Transfer or Withdrawal: Radio button: Offender withdrew from school | disciplinaryActionType | disciplinaryActionType | 10 | Offender withdrew from school | [NAME] | 2 | R | Required to identify one to multiple disciplinary actions per enrolled offender per respective incident, limited to one instance of each type per incident. | N | N | N | N | N | Y | 2010-03-12 00:00:00
Disciplinary Action | Transfer or Withdrawal: Radio button: No school response | disciplinaryActionType | disciplinaryActionType | 11 | No school response | [NAME] | 2 | R | Required to identify one to multiple disciplinary actions per enrolled offender per respective incident, limited to one instance of each type per incident. | N | N | N | N | N | Y | 2010-03-12 00:00:00
Disciplinary Action | End date | endDate | endDate |  | End date | Date | 8 | C | Required if disciplinaryActionType is 3 or 4.  Date the expulsion or exclusion ended (as found on the school board resolution).  [NAME]-DD | N | N | N | N | N | Y | 2011-12-07 00:00:00
Disciplinary Action | Explanation for no response by the school. | noResponseExplanation | noResponseExplanation |  | Explanation for instances of no school disciplinary action | [NAME] | 600 | C | Required if disciplinaryActionType is 11. | N | N | N | N | N | Y | 2009-12-02 00:00:00
Disciplinary Action | Enter the number of whole or half SCHOOl days (.5, 1, 1.5, etc.) | numDays | numDays |  | number of SCHOOL days (not to exceed 15 SCHOOL days for disciplinary action = 1 or 2, not to exceed 45 SCHOOL days for disciplinary action = 5 or 6, else not to exceed SCHOOL days resulting in one calendar year) | Number | 5 | C | Required if disciplinaryActionType is 1, 2, 3, 4, 5, or 6.  Number of whole or half SCHOOL days the student was removed from the classroom (with minimum value for expulsion or exclusion being 1 SCHOOL day, other disciplinary actions SPED offenders minimum being .5, else minimum being 1).  Format 999.9 | N | N | N | N | N | Y | 2010-03-12 00:00:00
Disciplinary Action | Number of SCHOOL days by which expulsion was reduced | numDaysExpulsionReduced | numDaysExpulsionReduced |  | Number of days the expulsion was reduced from the original school board resolution | [NAME] | 1 | C | Required when Did the Student return to school prior to the end date on the school board resolution = Y. | N | N | N | N | N | Y | 2009-12-02 00:00:00
Disciplinary Action | Start date | startDate | startDate |  | Start date | Date | 8 | C | Required if disciplinaryActionType is 3 or 4.  Date the expulsion or exclusion began (as found on the school board resolution).  [NAME]-DD | N | N | N | N | N | Y | 2011-12-07 00:00:00
Disciplinary Action | Does this exclusion go through the end of the current school year? | wasDAThroughYear | wasDAThroughYear | Y or N | Exclusion through year end? | [NAME] | 1 | C | Required if disciplinaryActionType is 4.  [NAME] whether the exclusion was through the end of the school year. | N | N | N | N | N | Y | 2009-12-02 00:00:00
Disciplinary Action | Does this expulsion go through the end of the current school year and/or into the following school year? | wasDAThroughYear | wasDAThroughYear | Y or N | Expulsion through year end and/or into next? | [NAME] | 1 | C | Required if disciplinaryActionType is 3.  [NAME] whether the removal was through the end of the school year. | N | N | N | N | N | Y | 2009-12-02 00:00:00
Disciplinary Action | Did the Student return to school prior to the end date on the school board resolution? | wasExpulsionModified | wasExpulsionModified | Y or N | Expulsion modified? | [NAME] | 1 | C | Required if disciplinaryActionType is 3.  [NAME] whether the expulsion was modified. | N | N | N | N | N | Y | 2009-12-02 00:00:00
Disciplinary Action | Was the offender referred to law enforcement? | wasReferredLawEnforcement | wasReferredLawEnforcement | Y or N | Indicator if the offender was referred to law enforcement | [NAME] | 1 | R | Required if an enrolled offender is identified. | N | N | Y | N | N | N | 2010-11-10 00:00:00
Disciplinary Action | Was the offender under another current suspension or expulsion at the time of the incident? | wasUnderCurrentSuspension | wasUnderCurrentSuspension | Y or N | Indicator if the offender was under a current suspension at the time of the incident | [NAME] | 1 | R | Required if an enrolled offender is identified. | N | N | Y | N | N | N | 2010-11-10 00:00:00
School Information | Checkbox: Anti-Bullying/Anti-Intimidation Policy (includes cyber bullying) | antiBullyingPolicy | antiBullyingPolicy | Y or N | Indicator that the school enforces an anti bullying policy | [NAME] | 1 | R | Indicates whether the school has an anti-bullying/anti-intimidation policy in place. | Y | N | N | N | N | N | 2010-11-10 00:00:00
School Information | Checkbox: Anti-Violence Policy | antiViolencePolicy | antiViolencePolicy | Y or N | Indicator that the school enforces an anti violence policy | [NAME] | 1 | R | Indicates whether the school has an anti-violence policy in place. | Y | N | N | N | N | N | 2010-11-10 00:00:00
School Information | Checkbox: Crisis Plan | crisisPlan | crisisPlan | Y or N | Indicator that the school has a crisis plan in place | [NAME] | 1 | R | Indicates whether the school has a crisis plan in place. | Y | N | N | N | N | N | 2010-11-10 00:00:00
School Information | Checkbox: Alcohol/Drug Education | drugEducation | drugEducation | Y or N | Indicator that the school has a drug education program in place | [NAME] | 1 | R | Indicates whether the school has alcohol/drug education in place. | Y | N | N | N | N | N | 2010-11-10 00:00:00
School Information | Checkbox: Total Number of Habitual Truants in your school | habitualTruants | habitualTruants |  | Number of habitual truant students at the school | Number | 3 | R | Number of habitual truants this school had during the preceding year as defined in Minn. Stat. § 260C.007, [NAME]. 19. | Y | N | N | N | N | N | 2009-12-02 00:00:00
School Information | Checkbox: Safety Plan | safetyPlan | safetyPlan | Y or N | Indicator that the school has a safety plan in place | [NAME] | 1 | R | Indicates whether the school has a safety plan in place. | Y | N | N | N | N | N | 2010-11-10 00:00:00
School Information | School Safety Specialist's email address | safetySpecialist | safetySpecialist |  | Email address of the school safety specialist at the school | [NAME] | 75 | R | [NAME] of the school safety specialist.  Used for communication. | Y | N | N | N | N | N | 2009-12-02 00:00:00
School Information | Checkbox: Zero/No Tolerance Policy | zeroTolerancePolicy | zeroTolerancePolicy | Y or N | Indicator that the school enforces a zero tolerance policy | [NAME] | 1 | R | Indicates whether the school has a zero/no tolerance policy in place. | Y | N | N | N | N | N | 2010-11-10 00:00:00
Systematic | Four digit number in Choose the district selections | districtNumber | districtNumber |  | District number | [NAME] | 4 | R | Incident district number. Must be a valid, active district. | Y | N | N | N | N | N | 2010-11-10 00:00:00
Systematic | Two digit number in Choose the district selections | districtType | districtType |  | District type | [NAME] | 2 | R | Incident district type. Must be a valid, active district type for the district. | Y | N | N | N | N | N | 2010-11-10 00:00:00
Systematic | Incident Number | IncidentId | dirsIncidentId |  | Incident Number | Number | 5 | R | Systematically assigned by MDE | N | Y | Y | Y | Y | Y | 2009-12-02 00:00:00
Systematic | Three digit number in Choose the School selections | schoolNumber | schoolNumber |  | School number | [NAME] | 3 | R | Incident school number.  Must be a valid, active school for the district. | Y | Y | N | N | N | N | 2010-11-10 00:00:00
Systematic - Batch Only | systematically computed | Non-Applicable in Database | schoolList |  | XML batch upload use only | Number |  | R |  | Y | N | N | N | N | N | 2010-05-24 00:00:00
Systematic - Batch Only | systematically computed | Non-Applicable in Database | incidentList |  | XML batch upload use only | Number |  | R |  | N | Y | N | N | N | N | 2010-05-24 00:00:00
Systematic - Batch Only | systematically computed | Non-Applicable in Database | incidentLocationList |  | XML batch upload use only | Number |  | R |  | N | Y | N | N | N | N | 2010-05-24 00:00:00
Systematic - Batch Only | systematically computed | Non-Applicable in Database | offenderList |  | XML batch upload use only | Number |  | R |  | N | N | Y | N | N | N | 2010-05-24 00:00:00
Systematic - Batch Only | systematically computed | Non-Applicable in Database | offenderActivityList |  | XML batch upload use only | Number |  | R |  | N | N | Y | N | N | N | 2010-05-24 00:00:00
Systematic - Batch Only | systematically computed | Non-Applicable in Database | weaponList |  | XML batch upload use only | Number |  | C |  | N | N | N | N | Y | N | 2010-05-24 00:00:00
Systematic - Batch Only | systematically computed | Non-Applicable in Database | drugTypeList |  | XML batch upload use only | Number |  | C |  | N | N | Y | N | N | N | 2010-05-24 00:00:00
Systematic - Batch Only | systematically computed | Non-Applicable in Database | disciplinaryActionList |  | XML batch upload use only | Number |  | R |  | N | N | N | N | N | Y | 2010-05-24 00:00:00
Systematic - Batch Only | systematically computed | Non-Applicable in Database | victimList |  | XML batch upload use only | Number |  | C |  | N | N | N | Y | N | N | 2010-05-24 00:00:00
Systematic - Batch Only | systematically computed | Non-Applicable in Database | school |  | XML batch upload use only, record indicator |  |  | R |  | Y | N | N | N | N | N | 2010-05-24 00:00:00
Systematic - Batch Only | systematically computed | Non-Applicable in Database | incident |  | XML batch upload use only, record indicator |  |  | R |  | N | Y | N | N | N | N | 2010-05-24 00:00:00
Systematic - Batch Only | systematically computed | Non-Applicable in Database | offender |  | XML batch upload use only, record indicator |  |  | R |  | N | N | Y | N | N | N | 2010-05-24 00:00:00
Systematic - Batch Only | systematically computed | Non-Applicable in Database | weapon |  | XML batch upload use only, record indicator |  |  | R |  | N | N | N | N | Y | N | 2010-05-24 00:00:00
Systematic - Batch Only | systematically computed | Non-Applicable in Database | victim |  | XML batch upload use only, record indicator |  |  | R |  | N | N | N | Y | N | N | 2010-05-24 00:00:00
Systematic - Batch Only | systematically computed | Non-Applicable in Database | disciplinaryAction |  | XML batch upload use only, record indicator |  |  | R |  | N | N | N | N | N | Y | 2010-05-24 00:00:00
Systematic | Create Date | createDate | createDate |  | Create Date |  |  | R | Incident create/submit date.  [NAME]:  YYYY-MM-DD | N | Y | N | N | N | N | 2011-12-07 00:00:00
Systematic - Batch Only | systematically computed | Non-Applicable in Database | wasDangerousWeaponWithNoOffender |  | XML batch upload use only |  |  | O | Used to report dangerous weapon incidents with no offender | N | Y | N | N | N | N | 2010-05-24 00:00:00
Systematic - Batch Only | systematically computed | Non-Applicable in Database | wDWIActivityList |  | XML batch upload use only |  |  | O | Used to report dangerous weapon incidents with no offender | N | Y | N | N | N | N | 2010-05-24 00:00:00
Systematic - Batch Only | systematically computed | Non-Applicable in Database | wDWIActivityType |  | XML batch upload use only |  |  | O | Used to report dangerous weapon incidents with no offender | N | Y | N | N | N | N | 2010-05-24 00:00:00
Systematic - Batch Only | systematically computed | Non-Applicable in Database | offenderActivityType |  | XML batch upload use only |  |  | O | Used to report dangerous weapon incidents with no offender | N | Y | N | N | N | N | 2010-05-24 00:00:00