Law Enforcement Software
Citation data can be exported to a simple fixed length ASCII file and an XML file to be read by other programs such as municipal court packages allowing for the importation/interface of data between Crimestar RMS and external systems that may rely upon or need the same data. A data export field is maintained within Crimestar RMS to track which records have already been exported. To re-export any specific citation record, simply recall the record and un-check the "Record Exported" field (which is controlled via the system configuration ) located on the Court Info page.
The following file format is used for Citation data SDF output.
Format : ASCII
Type : Fixed Length Fields (Structured Data Format)
Record Terminated by: Carriage Return, and Line Feed
* Extracted Data can also be written to the following file types:
1.) Crimestar XML output file
2.) Incode Version 1.0 XML output file.
SDF File Data:
FIELD NAME |
Byte Offset |
Length |
<XML TAG> |
Description/ Values |
RECORD TYPE |
1 |
1 |
|
"C"=Citation |
RECORD KEY |
2 |
15 |
<citv_index> |
Decimal Numeric |
CITATION NUMBER |
17 |
10 |
<citation_no> |
Alphanumeric |
CITATION TYPE |
27 |
1 |
<cit_type> |
Reference RMS Code Table |
OTHER NUMBER |
28 |
10 |
<other_no> |
Alphanumeric |
INCIDENT NUMBER |
38 |
10 |
<incident_no> |
Alphanumeric |
ACCIDENT NUMBER |
48 |
20 |
<accident_no> |
Alphanumeric |
VIOLATION |
68 |
20 |
<violation> |
Reference RMS Violation Code Table |
VIOLATION DESCRIPTION |
88 |
50 |
<vio_desc> |
Code Table: Description Value |
DATE OCCURRED |
138 |
10 |
<date_occurred> |
MM/DD/CCYY format |
TIME OCCURRED |
148 |
5 |
<time_occurred> |
HH:MM format |
OFFICER ID |
153 |
6 |
<officer_id> |
Reference RMS Officer Code Table |
OFFICER NAME |
159 |
60 |
<off_name> |
Code Table: Description Value |
AGENCY CODE |
219 |
6 |
<agency> |
Reference RMS Agency Code Table |
PROGRAM CODE |
225 |
2 |
<program_code> |
Reference RMS Program Code Table |
LAST NAME |
227 |
20 |
<last_name> |
Alphanumeric |
FIRST NAME |
247 |
14 |
<first_name> |
Alphanumeric |
MIDDLE NAME |
261 |
14 |
<middle_name> |
Alphanumeric |
PERSON TYPE |
275 |
1 |
<pers_type> |
Reference RMS Person Type Code Table |
DATE OF BIRTH |
276 |
10 |
<dob> |
MM/DD/CCYY format |
DRIVERS LICENSE # |
286 |
20 |
<dl_no> |
Alphanumeric |
DRIVERS LICENSE ISSUE STATE |
306 |
2 |
<dl_state> |
Reference RMS State Code Table |
ID CARD ONLY |
308 |
1 |
<id_only> |
Y/N |
ADDRESS DIGITS |
309 |
6 |
<digits> |
Alphanumeric |
ADDRESS PREFIX |
315 |
2 |
<prefix> |
Reference RMS Street Prefix Code Table |
ADDRESS STREET NAME |
317 |
30 |
<street_name> |
Alphanumeric |
ADDRESS STREET TYPE |
347 |
2 |
<street_type> |
Reference RMS Street Type Code Table |
ADDRESS STREET SUFFIX |
349 |
2 |
<suffix> |
Reference RMS Street Suffix Code Table |
ADDRESS APARTMENT |
351 |
6 |
<apartment> |
Alphanumeric |
ADDRESS CITY |
357 |
20 |
<city> |
Alphanumeric |
ADDRESS STATE |
377 |
2 |
<state> |
Reference RMS State Code Table |
ADDRESS ZIP CODE |
379 |
10 |
<zip_code> |
Alphanumeric |
SEX |
389 |
1 |
<sex> |
Reference RMS Sex Code Table |
RACE |
390 |
1 |
<race> |
Reference RMS Race Code Table |
HEIGHT |
391 |
3 |
<height> |
Numeric (9-99) |
WEIGHT |
394 |
3 |
<weight> |
Numeric |
HAIR COLOR CODE |
397 |
3 |
<hair_color> |
Reference RMS Hair Color Code Table |
EYE COLOR CODE |
400 |
3 |
<eye_color> |
Reference RMS Eye Color Code Table |
AREA CODE |
403 |
3 |
<area_code> |
Numeric (999) |
PHONE |
406 |
8 |
<phone> |
Numeric (999-9999) |
WORK AREA CODE |
414 |
3 |
<w_area_code> |
Numeric (999) |
WORK PHONE |
417 |
8 |
<w_phone> |
Numeric (999-9999) |
SOCIAL SECURITY NUMBER |
425 |
11 |
<ss_no> |
Numeric |
LOCAL ID NUMBER |
436 |
15 |
<local_no> |
Alphanumeric |
STATE ID NUMBER |
451 |
15 |
<state_no> |
Alphanumeric |
FBI ID NUMBER |
466 |
15 |
<fbi_no> |
Alphanumeric |
VEHICLE LICENSE |
481 |
8 |
<veh_license> |
Alphanumeric |
VEHICLE LICENSE ISSUE STATE |
489 |
2 |
<veh_lis> |
Reference RMS State Code Table |
VEHICLE LICENSE EXPIRES |
491 |
4 |
<veh_lic_expires> |
MMYY |
VEHICLE VIN |
495 |
30 |
<veh_vin> |
Alphanumeric |
VEHICLE TYPE CODE |
525 |
2 |
<veh_type> |
Reference RMS Vehicle Type Code Table |
VEHICLE YEAR |
527 |
4 |
<veh_year> |
Numeric |
VEHICLE MAKE |
531 |
4 |
<veh_make> |
Reference RMS Vehicle Make Code Table |
VEHICLE MODEL |
535 |
8 |
<veh_model> |
Alphanumeric |
VEHICLE STYLE |
543 |
2 |
<veh_style> |
Reference RMS Vehicle Style Code Table |
VEHICLE COLOR (PRIMARY) |
545 |
3 |
<veh_color> |
Reference RMS Vehicle Color Code Table |
VEHICLE COLOR (SECONDARY) |
548 |
3 |
<veh_color2> |
Reference RMS Vehicle Color Code Table |
VEHICLE COMMENT |
551 |
50 |
<comment> |
Alphanumeric |
VEHICLE OWNER NAME |
601 |
40 |
<owner_name> |
Alphanumeric |
VEHICLE OWNER ADDRESS |
641 |
40 |
<owner_add> |
Alphanumeric |
VEHICLE OWNER ADDRESS CITY |
681 |
20 |
<owner_city> |
Alphanumeric |
VEHICLE OWNER ADDRESS STATE |
701 |
2 |
<owner_state> |
Reference RMS State Code Table |
VEHICLE OWNER ADDR ZIP CODE |
703 |
10 |
<owner_zip> |
Alphanumeric |
VEHICLE OWNER SAME AS DRIVER |
713 |
1 |
<same_as_driver> |
Y/N |
LOCATION STREET |
714 |
40 |
<loc_street> |
Alphanumeric |
LOCATION DIGITS |
754 |
6 |
<loc_digits> |
Alphanumeric |
LOCATION PREFIX |
760 |
2 |
<loc_prefix> |
Reference RMS Street Prefix Code Table |
LOCATION STREET NAME |
762 |
30 |
<loc_street_name> |
Alphanumeric |
LOCATION STREET TYPE |
792 |
2 |
<loc_street_type> |
Reference RMS Street Type Code Table |
LOCATION SUFFIX |
794 |
2 |
<loc_suffix> |
Reference RMS Street Suffix Code Table |
LOCATION APARTMENT |
796 |
6 |
<loc_apartment> |
Alphanumeric |
LOCATION CITY |
802 |
20 |
<loc_city> |
Alphanumeric |
LOCATION COUNTY CODE |
822 |
6 |
<loc_county> |
Reference RMS County Code Table |
LOCATION STATE |
828 |
2 |
<loc_state> |
Reference RMS State Code Table |
DIRECTION OF TRAVEL |
830 |
2 |
<dot> |
Reference RMS Dir of Travel Code Table |
SPEED |
832 |
3 |
<speed> |
Numeric |
POSTED SPEED |
835 |
3 |
<p_speed> |
Numeric |
LANE NUMBER |
838 |
1 |
<lane> |
Numeric |
RADAR USED |
839 |
1 |
<radar> |
Y/N |
RADAR UNIT ID NUMBER |
840 |
10 |
<radar_id> |
Alphanumeric |
RADAR CALIBRATION DATE |
850 |
10 |
<radar_calibrated> |
MM/DD/CCYY format |
ACCIDENT INVOLVED |
860 |
1 |
<accident> |
Y/N |
LASER USED |
861 |
1 |
<laser> |
Y/N |
WEATHER CONDITIONS CODE |
862 |
4 |
<weather> |
Reference RMS Weather Code Table |
ROADWAY SURFACE CODE |
866 |
4 |
<surface> |
Reference RMS Surface Code Table |
ROADWAY CONDITIONS CODE |
870 |
4 |
<roadway> |
Reference RMS Roadway Code Table |
ROADWAY LIGHTING CODE |
874 |
4 |
<lighting> |
Reference RMS Lighting Code Table |
BEAT CODE |
878 |
6 |
<beat> |
Reference RMS Beat Code Table |
SECTOR CODE |
884 |
6 |
<sector> |
Reference RMS Sector Code Table |
DISTRICT CODE |
890 |
6 |
<district> |
Reference RMS District Code Table |
SHIFT CODE |
896 |
4 |
<shift> |
Reference RMS Shift Code Table |
COURT ID |
900 |
10 |
<court_id> |
Alphanumeric |
COURT DATE |
910 |
10 |
<court_date> |
MM/DD/CCYY format |
COURT TIME |
920 |
5 |
<court_time> |
HH:MM |
TRIAL DATE |
925 |
10 |
<trial_date> |
MM/DD/CCYY format |
TRAFFIC SCHOOL DATE |
935 |
10 |
<t_school_date> |
MM/DD/CCYY format |
TRAFFIC SCHOOL ATTENDED |
945 |
1 |
<t_school_att> |
Y/N |
JURY TRIAL |
946 |
1 |
<jury_trial> |
Y/N |
JUVENILE COURT |
947 |
1 |
<juvenile> |
Y/N |
LICENSE SUSPENDED |
948 |
1 |
<lic_susp> |
Y/N |
JAIL TIME |
949 |
10 |
<jail_time> |
Alphanumeric |
COMMUNITY SERVICE TIME |
959 |
10 |
<comm_svc_time> |
Alphanumeric |
COURT COMMENT |
969 |
50 |
<crt_comment> |
Alphanumeric |
DEFENSE ATTORNEY |
1019 |
20 |
<def_attorney> |
Alphanumeric |
DEFENSE ATTORNEY PHONE |
1039 |
14 |
<def_att_phone> |
Alphanumeric |
ASSOCIATED REFERENCE NUMBER |
1053 |
10 |
<assoc_no> |
Alphanumeric |
FINE AMOUNT |
1063 |
10 |
<fine_amnt> |
Numeric |
FINE PAID |
1073 |
1 |
<fine_paid> |
Y/N |
DOCKET NO |
1074 |
20 |
<docket_no> |
Alphanumeric |
PLEA CODE |
1094 |
2 |
<plea> |
Reference RMS Plea Code Table |
DISPOSITION CODE |
1096 |
4 |
<dispo> |
Reference RMS Dispo Code Table |
DISPOSITION DATE |
1100 |
10 |
<dispo_date> |
MM/DD/CCYY format |
DATA ENTRY OPERATOR ID |
1110 |
6 |
<ent_oper> |
Security Login Value |
UPDATE OPERATOR ID |
1116 |
6 |
<updt_oper> |
Security Login Value |
DATE ENTERED |
1122 |
10 |
<date_enter> |
MM/DD/CCYY format |
DATE LAST UPDATED |
1132 |
10 |
<date_updt> |
MM/DD/CCYY format |
CONSTRUCTION ZONE |
1142 |
1 |
<construction_zone> |
Y/N |
COMMERCIAL VEHICLE |
1143 |
1 |
<commercial_veh> |
Y/N |
HAZARDOUS MATERIALS |
1144 |
1 |
<hazmat> |
Y/N |
DRIVERS LICENSE CLASS |
1145 |
7 |
<dl_class> |
Reference RMS DL Class Code Table |
WARNING CITATION |
1152 |
1 |
<warning> |
Y/N |
OFFICER NOTES |
1153 |
200 |
<notes> |
Alpha Numeric Free Text |
See Also: Citation Import File Format