The following information does not apply to the Enterprise Edition of CrimeStar RMS.
CrimeStar stores data in a series of database tables commonly referred to as DBF files. Because of many special pointers and inter-relationships that are created and maintained by CrimeStar it is important the changes to the data be made via the CrimeStar application software rather than through the use of any other tool. Failure to use CrimeStar software to make modifications and changes to the CrimeStar data files may cause irreparable damage to your data. Although it is highly recommended that CrimeStar be used to manipulate your data the data files can be modified using other programs or tools that are capable of working with DBF type data files.
The CrimeStar database consists of two primary elements. The database container and the database tables. The database container holds information about all the database tables that are part of the database. The database container consists of the following 3 files.
Crmstr00.dbc
Crmstr00.dcx
Crmstr00.dct
Database tables consist of at least 1 and as many as 3 different files for each table. The files will all have the same prefix or root name but will have a different file suffix as follows.
RootName.DBF table data fields
RootName.CDX table index
RootName.FPT table’s associated text, narrative or imbedded binary such as a photo.
Periodically users may have a need to provide their database files to someone else. When copying a database table to another computer or to a diskette it is important to be sure to copy all the files with the same root name and the database container files shown above. Failure to do so may prohibit you from properly accessing the database table.
CrimeStar data tables are named crmstrnn where nn refers to a unique number. Each of these files hold different and unique information that is referenced by various modules. In the event that you should need to reference a CrimeStar data file the following chart should prove helpful.
crmstr01.dbf Indices master record counters (Not Synchronized)
crmstr02.dbf Accident Module
crmstr03.dbf Accident Names
crmstr04.dbf Accident Vehicles
crmstr05.dbf Master Vehicle Index Module
crmstr06.dbf BOL Module
crmstr07.dbf Master Location Index
crmstr08.dbf Citation Module
crmstr09.dbf Citation Violation Module
crmstr10.dbf Master Name Index Alias Names
crmstr11.dbf Firearm Registration Module
crmstr12.dbf Firearm Registration Weapons
crmstr13.dbf Incident Module
crmstr14.dbf Incident Module Names
crmstr15.dbf Incident Module Vehicles
crmstr16.dbf Incident Module Tracking
crmstr17.dbf Master Name Index Module
crmstr18.dbf System Configuration ( System selections, etc.) (Not Synchronized)
crmstr19.dbf Master Name Address History
crmstr20.dbf Booking Module
crmstr21.dbf Login Table
crmstr22.dbf Master Name Involvement’s
crmstr23.dbf Property & Evidence Module
crmstr24.dbf Property & Evidence Tracking
crmstr25.dbf Pawn Module
crmstr26.dbf Master Vehicle Index Involvements
crmstr27.dbf Warrants Module
crmstr28.dbf Warrant Tracking
crmstr29.dbf Community Policing Module Problem File
crmstr30.dbf Registrants Module
crmstr31.dbf Field Interview Module
crmstr32.dbf Reserved (Not Synchronized)
crmstr33.dbf Calls For Service Module
crmstr34.dbf Calls For Service Units
crmstr35.dbf Master Code Types (Not Synchronized)
crmstr36.dbf Master Codes Table ("Other Codes")
crmstr37.dbf Incident Module Supplements
crmstr38.dbf Booking Module Charges
crmstr39.dbf Booking Module Custody Log
crmstr40.dbf Master Offense Codes ( "Violation / Offense Codes")
crmstr41.dbf Investigative Alerts
crmstr42.dbf Investigative Alert Notifications
crmstr43.dbf Master Name Index Photo File
crmstr44.dbf Geofile Streets
crmstr45.dbf Geofile Segments
crmstr46.dbf Geofile Premise
crmstr47.dbf Community Policing Problem Action File
crmstr48.dbf Personnel Module
crmstr49.dbf Incident Module Diagram
crmstr50.dbf Confidential Funds Voucher
crmstr51.dbf Daily Activity Log
crmstr52.dbf Key Inventory Add-on
crmstr53.dbf Key Status
crmstr54.dbf Alarm Response
crmstr55.dbf Property Photos
crmstr56.dbf NIBRS Supplement Table
crmstr57.dbf Master System Configuration #2 (Not Synchronized)
crmstr58.dbf Bicycle Registration
crmstr59.dbf Daily Activity Hours & Vehicle Info
crmstr60.dbf Training
crmstr61.dbf MNI Associates
crmstr62.dbf Case Management
crmstr63.dbf Case List
crmstr64.dbf Cash Box
crmstr65.dbf Personnel - Equipment
crmstr66.dbf Gang Confirmation
crmstr67.dbf Master Location Index Involvements
crmstr68.dbf Kickback Messages
crmstr69.dbf Pawn Serialized Property Items
crmstr70.dbf Diminutive Names
crmstr71.dbf Community Policing Problem Photos
crmstr72.dbf NIBRS – Admin file
crmstr73.dbf NIBRS – Property File
crmstr74.dbf Accident Supplements
crmstr75.dbf Master System Configuration #3 (Not Synchronized)
crmstr76.dbf Geofile Premise Photos
crmstr77.dbf NIBRS Victim Records
crmstr78.dbf NIBRS Offender Records
crmstr79.dbf NIBRS Arrestee Records
crmstr80.dbf NIBRS Group ‘B’ Offenses
crmstr81.dbf Animal License
crmstr82.dbf Animal Impounds
crmstr83.dbf Profiling (Subject)
crmstr84.dbf Jail Medical
crmstr85.dbf Jail Medical Activities Log
crmstr86.dbf Jail Visitor Log
crmstr87.dbf Jail Court Info
crmstr88.dbf Jail Court Dates
crmstr89.dbf Jail Commissary Activity
crmstr90.dbf Jail Commissary Inventory
crmstr91.dbf Jail Meals
crmstr92.dbf Jail Housing Inventory
crmstr93.dbf Jail Inmate Medication
crmstr94.dbf Jail Authorized Visitors
crmstr95.dbf Civil Documents
crmstr96.dbf Civil Document Names
crmstr97.dbf Photo Lineups
crmstr98.dbf CAD Active Events (Not Synchronized)
crmstr99.dbf CAD Active Units (Not Synchronized)
crmstr100.dbf Jail Classification
crmstr101.dbf Email
crmstr102.dbf Department Asset Inventory
crmstr103.dbf Court Payment Names
crmstr104.dbf Court Payment History
crmstr105.dbf Jail Tracking / Movement
crmstr106.dbf Document Archive
crmstr107.dbf User Login History Log
crmstr108.dbf Vehicle Maintenance
crmstr109.dbf Vehicle Maintenance History
crmstr110.dbf E911 Message Queue (Not Synchronized)
crmstr111.dbf Reserved (synch keys)
crmstr112.dbf Accident Photos
crmstr113.dbf CAD Call Defaults (Not Synchronized)
crmstr114.dbf CAD Scheduled Events (Not Synchronized)
crmstr115.dbf CAD Unit Assignments (Not Synchronized)
crmstr116.dbf CAD Dispatch Log (Not Synchronized)
crmstr117.dbf Print Audit Log
crmstr118.dbf Jail Enemy List
crmstr119.dbf Login Groups
crmstr120.dbf CAD SMS Addresses (Not Synchronized)
crmstr121.dbf CAD SMS Groups (Not Synchronized)
crmstr122.dbf CAD/CFS Tow Log (Not Synchronized)
crmstr123.dbf CAD Unit Defaults (Not Synchronized)
crmstr124.dbf Reserved (used password log encoded)
crmstr125.dbf Transaction Update/Change Audit Log
crmstr126.dbf UCR LE Employees
crmstr127.dbf Record View/Recall audit log.
Copyright © Crimestar Corporation 2010 - 2015 All Rights Reserved.