Statewide nibrs rms technical Document September 2016 LexisNexis Indiana State Police

Statewide NIBRS RMS Technical Document

September 2016

LexisNexis

Indiana State Police

Contents

Contents 2

Document Version Change Details 4

Overview 5

SFTP Submissions 6

Notifications 6

Data Elements 7

XML Schema 46

Sample XML 118

Validation Rules 136

Appendix A: State Codes 166

Appendix B: County Codes 170

Appendix C: City Codes 174

Appendix D: Method Codes 395

Appendix E: Street Suffix 406

Appendix F: Gun Makes 414

Appendix G: Vehicle Makes 501

Appendix H: Vehicle Models 526

Appendix I: Other Drug Types 696

Appendix J: Firearm Calibers 709

Appendix K: Property Types 712

Appendix L: Violation/Offense Codes 716

Document Version Change Details

Document Version	Change Description	Date
1.0	Initial Release	09/30/2016

Overview

The purpose of this document is to provide the necessary information to submit crime reports into the statewide crime repository as well as submit NIBRS data to the FBI. Details include the submission methods, XML Schema, XML examples, code values, and validation rules.

Submissions will be sent to the statewide crime repository through file uploads to a SFTP. Once files are uploaded, automated processed will move these files and upload the data into ARIES.

SFTP Submissions

Submissions will be made to the ARIES SFTP. To gain access and credentials to this SFTP, please email the ARIES support team at [e-mail]. Additionally, you may call the support team during business hours at 866-495-4206.

A specific folder for the submission of your data will be provided to you. No other submitter will be able to view your submissions.

Notifications

Notifications can be configured to be sent out if there is a problem with importing a crime report into the statewide repository. Notifications are sent via email and can be configured by contacting ARIES support at [e-mail] or 866-495-4206.

There are two types of notifications that will be sent:

• 
  Invalid XML: If a file is sent to the state repository and cannot be imported due to the file not fitting the XML schema provided, an email will be generated and sent to the address provided by the agency. The email will detail the technical reasons for why the XML could not be imported.
  
• 
  If the crime report can be imported, but contains critical errors in the data, a notification can be sent with a list of what needs to be corrected. The agency may either send in a correction based on what is listed as needing to be updated or log into the ARIES web portal and correct the report there.
  

Data Elements

Below is a list of fields contained within the Crime Repository. Note the following expected formats for XML data submissions:

• 
  Dates (YYYY-MM-DD)
  
• 
  Integers range from -999,999,999 to 999,999,999
  
• 
  If not otherwise specified, the max length of a string is 9,999,999,999,999,999,999,999,999,999 characters.
  

Element	Type	Description	XML Path	Valid values
Incident Level
AgencyORI	string (7)	Agency ORI	Incident/AgencyORI	7 digit ORI value excluding the prefix of IN
AttachmentTypeCde	string (2)	Type of attachment	Incident/Attachments/Attachment/AttachmentTypeCde	01 - DEATH CERTIFICATE 02 - DIAGRAM 03 - OTHER 04 - PHOTOS 05 - VIDEO 06 - TOXICOLOGY REPORTS 07 - WITNESS STATEMENTS
Content	string	Attachment	Incident/Attachments/Attachment/Content
FullFileName	string (100)	Attachment file name	Incident/Attachments/Attachment/FullFileName
HowReportedCde	string (2)	Indicates how the incident was reported	Incident/HowReportedCde	01 - PHONE 02 - OTHER AGENCY 03 - IN PERSON 04 - RADIO 05 - MAIL 06 - IN VIEW 07 - BY INVESTIGATION 08 - INFORMANT 09 - TELETYPE 10 - OTHER 11 - WEB
IncidentDte	date	Indicates the start date of the incident	Incident/IncidentDte
IncidentEndDte	date	Indicates the end date of the incident	Incident/IncidentEndDte
IncidentEndTime	string (4)	Indicates the time the incident ended	Incident/IncidentEndTime	Military time ex. (1330)
IncidentOwnerBadgeNumber	string (8)	Indicates the badge number of the officer	Incident/IncidentOwnerBadgeNumber
IncidentTime	string (4)	Indicates the start time of the incident	Incident/IncidentTime	Military time ex. (1330)
LocalCodeCaseNumber	string (50)	Local case number	Incident/LocalCodeCaseNumber
NarrativeTxt	string	Narrative description of the case	Incident/Narratives/Narrative/NarrativeTxt
NarrativeTypeCde	string (2)	Indicates the type of narrative	Incident/Narratives/Narrative/NarrativeTxt/NarrativeTypeCde	00 - NIBRS SYNOPSIS 01 - GENERAL 02 - POST ARREST CITATION 10 - NIBRS INVESTIGATION
ReportedDte	date	Indicates the date the crime was reported	Incident/ReportedDte
SecondaryReportID	string (50)	Indicates if there is a second report	Incident/SecondaryReportID
TimeCleared	string (4)	Indicates the time the officer cleared the scene	Incident/TimeCleared	Military time ex. (1330)
TimeDispatched	string (4)	Indicates the time the officer was dispatched	Incident/TimeDispatched	Military time ex. (1330)
TimeReceived	string (4)	Indicates the time the officer received	Incident/TimeReceived	Military time ex. (1330)
TimeArrived	string (4)	Indicates the time the officer arrived	Incident/TimeArrived	Military time ex. (1330)
MethodCodeID	integer	Identifies the Method of Operation record	Incident/MethodsOfOperations/MethodsOfOperation	See Appendix D
Crime Level
CaseChargedStatusCde	string (2)	Indicates the Clearance Type	Incident/Crime/CaseChargedStatusCde	C - CLEARED BY ARREST E - EXCEPTIONALLY CLEARED S - SUMMONED/CITED T - TIME CLOSED
CaseClosedDte	date	Date case was closed	Incident/Crime/CaseClosedDte
CaseExceptionallyClearedCde	string (2)	Cleared Exceptionally is used to indicate whether or not the incident is cleared by exceptional means. In a multiple-offense incident, the exceptional clearance of one offense clears the entire incident. An incident cannot be cleared exceptionally if it was previously or concurrently cleared by an arrest.	Incident/Crime/CaseExceptionallyClearedCde	A - DEATH B - PROSECUTION DECLINED C - EXTRADITION DECLINED D - REFUSED TO COOP E - JUV NO CUSTODY F - ADULT IN CUSTODY G - TRANSFERRED TO FEDERAL COURT
CaseExceptionallyClearedDte	integer	Date the case was exceptionally cleared	Incident/Crime/CaseExceptionallyClearedDte
CaseStatusCde	string (2)	Current status of the case	Incident/Crime/CaseStatusCde	A - OPEN I - CLOSED U - UNFOUNDED N - INACTIVE
HaveOffenderInfo	boolean	Indicates if there is an offender	Incident/Crime/HaveOffenderInfo	1 - TRUE 0 - FALSE
HaveWitnesses	boolean	Indicates if there is a witness	Incident/Crime/HaveWitnesses	1 - TRUE 0 - FALSE
JuvenileInvolved	boolean	Indicates if a juvenile was involved	Incident/Crime/JuvenileInvolved	1 - TRUE 0 - FALSE
ASCFCde	string (2)	Indicates whether each offense in the incident was attempted or completed	Incident/Crime/Offenses/Offense/ASCFCde	00 - NA 01 - ATTEMPT 02 - COMPLETED
BiasMotivationCde	string (2)	Indicates the bias motivation for the incident	Incident/Crime/Offenses/Offense/BiasMotivationCde	11 - ANTI-WHITE 12 - ANTI-BLACK OR AFRICAN AMERICAN 13 - ANTI-AMERICAN INDIAN OR ALASKA NATIVE 14 - ANTI-ASIAN 15 - ANTI-MULTIPLE RACES, GROUP 21 - ANTI-JEWISH 22 - ANTI-CATHOLIC 23 - ANTI-PROTESTANT 24 - ANTI-ISLAMIC (MOSLEM) 25 - ANTI-OTHER RELIGION 26 - ANTI-MULTI-RELIGIOUS GROUP 27 - ANTI-ATHEIST/AGNOSTIC 32 - ANTI-HISPANIC OR LATINO 33 - ANTI-OTHER RACE/ETHNICITY 41 - ANTI-MALE HOMOSEXUAL (GAY) 42 - ANTI-FEMALE HOMOSEXUAL (LESBIAN) 43 - ANTI-HOMOSEXUAL (GAYS AND LESBIANS) 44 - ANTI-HETEROSEXUAL 45 - ANTI-BISEXUAL 51 - ANTI-PHYSICAL DISABILITY 52 - ANTI-MENTAL DISABILITY 88 - NONE (NO BIAS) 99 - UNKNOWN (MOTIVATION NOT KNOWN) 28 - ANTI-MORMON 29 - ANTI-JEHOVAH'S WITNESS 81 - ANTI-EASTERN ORTHODOX 82 - ANTI-OTHER CHRISTIAN 83 - ANTI-BUDDHIST 84 - ANTI-HINDU 85 - ANTI-SIKH 16 - ANTI-NATIVE HAWAIIAN OR OTHER PACIFIC ISLANDER 31 - ANTI-ARAB 61 - ANTI-MALE 62 - ANTI-FEMALE 71 - ANTI-TRANSGENDER 72 - ANTI-GENDER NON-CONFORMING
BiasMotivationCde2	string (2)	Indicates the second bias motivation for the incident	Incident/Crime/Offenses/Offense/BiasMotivationCde2	11 - ANTI-WHITE 12 - ANTI-BLACK OR AFRICAN AMERICAN 13 - ANTI-AMERICAN INDIAN OR ALASKA NATIVE 14 - ANTI-ASIAN 15 - ANTI-MULTIPLE RACES, GROUP 21 - ANTI-JEWISH 22 - ANTI-CATHOLIC 23 - ANTI-PROTESTANT 24 - ANTI-ISLAMIC (MOSLEM) 25 - ANTI-OTHER RELIGION 26 - ANTI-MULTI-RELIGIOUS GROUP 27 - ANTI-ATHEIST/AGNOSTIC 32 - ANTI-HISPANIC OR LATINO 33 - ANTI-OTHER RACE/ETHNICITY 41 - ANTI-MALE HOMOSEXUAL (GAY) 42 - ANTI-FEMALE HOMOSEXUAL (LESBIAN) 43 - ANTI-HOMOSEXUAL (GAYS AND LESBIANS) 44 - ANTI-HETEROSEXUAL 45 - ANTI-BISEXUAL 51 - ANTI-PHYSICAL DISABILITY 52 - ANTI-MENTAL DISABILITY 88 - NONE (NO BIAS) 99 - UNKNOWN (MOTIVATION NOT KNOWN) 28 - ANTI-MORMON 29 - ANTI-JEHOVAH'S WITNESS 81 - ANTI-EASTERN ORTHODOX 82 - ANTI-OTHER CHRISTIAN 83 - ANTI-BUDDHIST 84 - ANTI-HINDU 85 - ANTI-SIKH 16 - ANTI-NATIVE HAWAIIAN OR OTHER PACIFIC ISLANDER 31 - ANTI-ARAB 61 - ANTI-MALE 62 - ANTI-FEMALE 71 - ANTI-TRANSGENDER 72 - ANTI-GENDER NON-CONFORMING
BiasMotivationCde3	string (2)	Indicates the third bias motivation for the incident	Incident/Crime/Offenses/Offense/BiasMotivationCde3	11 - ANTI-WHITE 12 - ANTI-BLACK OR AFRICAN AMERICAN 13 - ANTI-AMERICAN INDIAN OR ALASKA NATIVE 14 - ANTI-ASIAN 15 - ANTI-MULTIPLE RACES, GROUP 21 - ANTI-JEWISH 22 - ANTI-CATHOLIC 23 - ANTI-PROTESTANT 24 - ANTI-ISLAMIC (MOSLEM) 25 - ANTI-OTHER RELIGION 26 - ANTI-MULTI-RELIGIOUS GROUP 27 - ANTI-ATHEIST/AGNOSTIC 32 - ANTI-HISPANIC OR LATINO 33 - ANTI-OTHER RACE/ETHNICITY 41 - ANTI-MALE HOMOSEXUAL (GAY) 42 - ANTI-FEMALE HOMOSEXUAL (LESBIAN) 43 - ANTI-HOMOSEXUAL (GAYS AND LESBIANS) 44 - ANTI-HETEROSEXUAL 45 - ANTI-BISEXUAL 51 - ANTI-PHYSICAL DISABILITY 52 - ANTI-MENTAL DISABILITY 88 - NONE (NO BIAS) 99 - UNKNOWN (MOTIVATION NOT KNOWN) 28 - ANTI-MORMON 29 - ANTI-JEHOVAH'S WITNESS 81 - ANTI-EASTERN ORTHODOX 82 - ANTI-OTHER CHRISTIAN 83 - ANTI-BUDDHIST 84 - ANTI-HINDU 85 - ANTI-SIKH 16 - ANTI-NATIVE HAWAIIAN OR OTHER PACIFIC ISLANDER 31 - ANTI-ARAB 61 - ANTI-MALE 62 - ANTI-FEMALE 71 - ANTI-TRANSGENDER 72 - ANTI-GENDER NON-CONFORMING
BiasMotivationCde4	string (2)	Indicates the forth bias motivation for the incident	Incident/Crime/Offenses/Offense/BiasMotivationCde4	11 - ANTI-WHITE 12 - ANTI-BLACK OR AFRICAN AMERICAN 13 - ANTI-AMERICAN INDIAN OR ALASKA NATIVE 14 - ANTI-ASIAN 15 - ANTI-MULTIPLE RACES, GROUP 21 - ANTI-JEWISH 22 - ANTI-CATHOLIC 23 - ANTI-PROTESTANT 24 - ANTI-ISLAMIC (MOSLEM) 25 - ANTI-OTHER RELIGION 26 - ANTI-MULTI-RELIGIOUS GROUP 27 - ANTI-ATHEIST/AGNOSTIC 32 - ANTI-HISPANIC OR LATINO 33 - ANTI-OTHER RACE/ETHNICITY 41 - ANTI-MALE HOMOSEXUAL (GAY) 42 - ANTI-FEMALE HOMOSEXUAL (LESBIAN) 43 - ANTI-HOMOSEXUAL (GAYS AND LESBIANS) 44 - ANTI-HETEROSEXUAL 45 - ANTI-BISEXUAL 51 - ANTI-PHYSICAL DISABILITY 52 - ANTI-MENTAL DISABILITY 88 - NONE (NO BIAS) 99 - UNKNOWN (MOTIVATION NOT KNOWN) 28 - ANTI-MORMON 29 - ANTI-JEHOVAH'S WITNESS 81 - ANTI-EASTERN ORTHODOX 82 - ANTI-OTHER CHRISTIAN 83 - ANTI-BUDDHIST 84 - ANTI-HINDU 85 - ANTI-SIKH 16 - ANTI-NATIVE HAWAIIAN OR OTHER PACIFIC ISLANDER 31 - ANTI-ARAB 61 - ANTI-MALE 62 - ANTI-FEMALE 71 - ANTI-TRANSGENDER 72 - ANTI-GENDER NON-CONFORMING
BiasMotivationCde5	string (2)	Indicates the fifth bias motivation for the incident	Incident/Crime/Offenses/Offense/BiasMotivationCde5	11 - ANTI-WHITE 12 - ANTI-BLACK OR AFRICAN AMERICAN 13 - ANTI-AMERICAN INDIAN OR ALASKA NATIVE 14 - ANTI-ASIAN 15 - ANTI-MULTIPLE RACES, GROUP 21 - ANTI-JEWISH 22 - ANTI-CATHOLIC 23 - ANTI-PROTESTANT 24 - ANTI-ISLAMIC (MOSLEM) 25 - ANTI-OTHER RELIGION 26 - ANTI-MULTI-RELIGIOUS GROUP 27 - ANTI-ATHEIST/AGNOSTIC 32 - ANTI-HISPANIC OR LATINO 33 - ANTI-OTHER RACE/ETHNICITY 41 - ANTI-MALE HOMOSEXUAL (GAY) 42 - ANTI-FEMALE HOMOSEXUAL (LESBIAN) 43 - ANTI-HOMOSEXUAL (GAYS AND LESBIANS) 44 - ANTI-HETEROSEXUAL 45 - ANTI-BISEXUAL 51 - ANTI-PHYSICAL DISABILITY 52 - ANTI-MENTAL DISABILITY 88 - NONE (NO BIAS) 99 - UNKNOWN (MOTIVATION NOT KNOWN) 28 - ANTI-MORMON 29 - ANTI-JEHOVAH'S WITNESS 81 - ANTI-EASTERN ORTHODOX 82 - ANTI-OTHER CHRISTIAN 83 - ANTI-BUDDHIST 84 - ANTI-HINDU 85 - ANTI-SIKH 16 - ANTI-NATIVE HAWAIIAN OR OTHER PACIFIC ISLANDER 31 - ANTI-ARAB 61 - ANTI-MALE 62 - ANTI-FEMALE 71 - ANTI-TRANSGENDER 72 - ANTI-GENDER NON-CONFORMING
BurglaryOnlyForceCde	string (2)	Indicates whether forcible entry was used for a burglary	Incident/Crime/Offenses/Offense/BurglaryOnlyForceCde	01 - FORCIBLE ENTRY 02 - NO FORCE
CargoTheft	boolean	Indicates whether there was a cargo theft	Incident/Crime/Offenses/Offense/CargoTheft	1 - TRUE 0 - FALSE
ClassCde	string (1)	Indicates the class of the offense	Incident/Crime/Offenses/Offense/ClassCde	1 – 1 2 – 2 3 – 3 4 – 4 5 – 5 6 – 6
Counts	integer	Indicates the number of counts for the offense	Incident/Crime/Offenses/Offense/Counts
CourtOrderCountyCde	string (3)	County where the court order originated	Incident/Crime/Offenses/Offense/CourtOrderCountyCde	See Appendix B
CourtOrderExists	boolean	Indicates if a court order exists for this offense	Incident/Crime/Offenses/Offense/CourtOrderExists	1 - TRUE 0 - FALSE
CourtOrderNumber	string (25)	Indicates the court order number	Incident/Crime/Offenses/Offense/CourtOrderNumber
CourtOrderTypeCde	string (1)	Indicate the type of court order	Incident/Crime/Offenses/Offense/CourtOrderTypeCde	1 - DOMESTIC VIOLENCE ORDER 2 - EMERGENCY PROTECTIVE ORDER 3 - BOND RESTRICTIONS OR OTHER COURT ORDER 4 - RESTRAINING ORDER
CriminalActivityCde	string (1)	Indicates the type of criminal activity	Incident/Crime/Offenses/Offense/CriminalActivities/CriminalActivity/CriminalActivityCde	B - BUYING/RECEIVING C - CULTIVATING/MANUFACTURING/PUBLISHING D - DISTRIBUTING/SELLING E - EXPLOITING CHILDREN O - OPERATING/PROMOTING/ASSISTING P - POSSESSING/CONCEALING T - TRANSPORTING/TRANSMITTING/IMPORTING U - USING/CONSUMING
DegreeCde	string (1)	Indicates the degree of the offense	Incident/Crime/Offenses/Offense/DegreeCde	F - FELONY M - MISDEMEANOR O - OTHER T - TECHNICAL V - VIOLATION
GangInfoCde	string (1)	Indicates the type of gang	Incident/Crime/Offenses/Offense/GangInfoes/GangInfo/GangInfoCde	G - OTHER GANG J - JUVENILE GANG N - NONE/UNKNOWN
IsCityOrdinance	boolean	Indicates if the offense is based on a city ordinance	Incident/Crime/Offenses/Offense/IsCityOrdinance	1 - TRUE 0 - FALSE
IsCountyOrdinance	boolean	Indicates if the offense is based on a county ordiance	Incident/Crime/Offenses/Offense/IsCountyOrdinance	1 - TRUE 0 - FALSE
LocalOffenseDescription	string (75)	Description of the local offense	Incident/Crime/Offenses/Offense/LocalOffenseDescription
LocalStatute	string (25)	Local statute number	Incident/Crime/Offenses/Offense/LocalStatute
LocationTypeCde	string (2)	Indicates the type of location for the Offense	Incident/Crime/Offenses/Offense/LocationTypeCde	1 - AIR/BUS/TRAIN TERMINAL 2 - BANK/SAVINGS AND LOAN 3 - BAR/NIGHTCLUB 4 - CHURCH/SYNAGOGUE/TEMPLE 5 - COMMERCIAL/OFFICE BUILDING 6 - CONSTRUCTION SITE 7 - CONVENIENCE STORE 8 - DEPARTMENT/DISCOUNT STORE 9 - DRUG STORE/DOCTOR’S OFFICE/HOSPITAL 10 - FIELD/WOODS 11 - GOVERNMENT/PUBLIC BUILDING 12 - GROCERY/SUPERMARKET 13 - HIGHWAY/ROAD/ALLEY/STREET/SIDEWALK 14 - HOTEL/MOTEL/ETC. 15 - JAIL/PRISON/PENITENTIARY/CORRECTIONS FACILITY 16 - LAKE/WATERWAY 17 - LIQUOR STORE 18 - PARKING LOT/GARAGE 19 - RENTAL STORAGE FACILITY 20 - RESIDENCE/HOME 21 - RESTAURANT (INCLUDES CAFETERIA) 22 - SCHOOL/COLLEGE (INCLUDES UNIVERSITY) 23 - SERVICE/GAS STATION 24 - SPECIALTY STORE 25 - OTHER/UNKNOWN 37 - ABANDONED/CONDEMNED STRUCTURE 38 - AMUSEMENT PARK 39 - ARENA/STADIUM/FAIRGROUNDS/COLISEUM 40 - ATM SEPARATE FROM BANK 41 - AUTO DEALERSHIP NEW/USED 42 - CAMP/CAMPGROUND 44 - DAYCARE FACILITY 45 - DOCK/WHARF/FREIGHT/MODAL TERMINAL 46 - FARM FACILITY 47 - GAMBLING FACILITY/CASINO/RACE 48 - INDUSTRIAL SITE 49 - MILITARY INSTALLATION 50 - PARK/PLAYGROUND 51 - REST AREA 52 - SCHOOL-COLLEGE/UNIVERSITY 53 - SCHOOL-ELEMENTARY/SECONDARY 54 - SHELTER-MISSION/HOMELESS 55 - SHOPPING MALL 56 - TRIBAL LANDS
OffenderIsEmployee	boolean	Indicates whether the offender was an employee	Incident/Crime/Offenses/Offense/OffenderIsEmployee	1 - TRUE 0 - FALSE
WeaponInvolvedCde	string (3)	Indicates the type of weapon involved with the offense	Incident/Crime/Offenses/Offense/Offense_WeaponsInvolved/Offense_WeaponsInvolved/WeaponInvolvedCde	11 - FIREARM (TYPE UNKNOWN) 12 - HANDGUN 13 - RIFLE 14 - SHOTGUN 15 - OTHER FIREARM 20 - KNIFE/CUTTING INSTRUMENT 30 - BLUNT OBJECT(CLUB, HAMMER, ETC) 35 - MOTOR VEHICLE 40 - PERSONAL WEAPONS 45 - PRYING TOOL 50 - POISON 60 - EXPLOSIVES 65 - FIRE/INCENDIARY DEVICE 70 - NARCOTICS/DRUGS/SLEEPING PILLS 85 - ASPHIYXIATION 90 - OTHER 95 - UNKNOWN
RelatedToCde	string (2)	Indicates if the offender is suspected of using Alcohol, Drugs, or Computers in relation to the criminal activity	Incident/Crime/Offenses/Offense/OffenseRelatedToes/OffenseRelatedTo/RelatedToCde	01 - ALCOHOL 02 - DRUG 03 - COMPUTER 98 - UNKNOWN
OnCampus	boolean	Indicates if the offense was on a school campus	Incident/Crime/Offenses/Offense/OnCampus	1 - TRUE 0 - FALSE
VictimID	integer	Indicates the specified victim	Incident/Crime/Offenses/Offense/Person_VictimOffensePair/Person_VictimOffensePair/VictimID
Premises	boolean	Indicates if the offense was on school premises	Incident/Crime/Offenses/Offense/Premises	1 - TRUE 0 - FALSE
SchoolFunction	boolean	Indicates if the offense was during a school function	Incident/Crime/Offenses/Offense/SchoolFunction	1 - TRUE 0 - FALSE
SchoolName	string (200)	Indicates the school name	Incident/Crime/Offenses/Offense/SchoolName
SchoolTypeCde	string (1)	Indicates the type of school	Incident/Crime/Offenses/Offense/SchoolTypeCde	1 - PRE-SCHOOL/DAYCARE 2 - ELEMENTARY SCHOOL 3 - MIDDLE SCHOOL 4 - HIGH SCHOOL 5 - COMBINED (I.E. K-12) 6 - UNIVERSITY/COLLEGE 7 - TECHNICAL SCHOOL 8 - SCHOOL BUS
ViolCde	string (10)	The violation code for the offense	Incident/Crime/Offenses/Offense/ViolCde	See Appendix L
OffenseTimeEstimated	boolean	Indicates the estimated time of the offense	Incident/Crime/OffenseTimeEstimated	1 - TRUE 0 - FALSE
PropertyInvolved	boolean	Indicates if there was property involved in the incident	Incident/Crime/PropertyInvolved	1 - TRUE 0 - FALSE
ProsecutorContactedDte	date	The date the prosecutor was contacted	Incident/Crime/ProsecutorContactedDte
ProsecutorName	string (55)	The name of the prosecutor	Incident/Crime/ProsecutorName
RecoveredPropertyOrEvidence	boolean	Indicates if property or evidence were recovered	Incident/Crime/RecoveredPropertyOrEvidence	1 - TRUE 0 - FALSE
TotalArrestees	integer	Number of arrestees for the incident	Incident/Crime/TotalArrestees
TotalOffenders	integer	Number of offenders for the incident	Incident/Crime/TotalOffenders
TotalOffenses	integer	Number of offenses for the incident	Incident/Crime/TotalOffenses
TotalVictims	integer	Number of victims for the incident	Incident/Crime/TotalVictims
TotalWitnesses	integer	Number of witnesses for the incident	Incident/Crime/TotalWitnesses