Database Tables

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.