Citation Export File Format     (Not Available in the Basic / 'Lite' Edition)

 

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
(Text is not limited to 200 bytes in XML output)

 

See Also:  Citation Import File Format