Harvey Ruvin - Clerk of the Courts - Miami-Dade County, Florida

TRAFFIC PUBLIC ACCESS FOLDER DESCRIPTION

The Clerk of the Courts provides a daily file containing all traffic case information processed by the court the previous day. This file can be downloaded by the interested parties from the County’s site.

Traffic extracts are in the form of ASCII text files in which records are delimited by a caret (^) and have a variable length. The extract files contain the following record structure:

Table of Contents

Daily Files 

Monthly Files

Weekly Files

 

Daily Files

Accident Citations File Structure (File Definition)

File Name:          Dly_all_accident.txt            

Run Frequency:  Daily

Description:       This is a listing of all citations issued as a result of an accident and it is updated daily.

Sample File:       Dly-all-accident.xls

 

Field Name

Field  Description

Comment

Case Number

CHAR(9)

 

Issue Date

DATE(8)

Format ccyymmdd

First Name

CHAR(12)

 

Mid Initial

CHAR(1)

 

Last Name

CHAR(15)

 

Address

CHAR(30)

 

Apt

CHAR(5)

 

City

CHAR(16)

 

State

CHAR(2)

 

Zip Code

CHAR(9)

 

Dob

DATE(8)

Format ccyymmdd

Race

CHAR(25)

 

Sex

CHAR(6)

 

Driver’s License Number

CHAR(15)

 

Municipality                            

CHAR(3)

 

Filler

CHAR(1)

 

Municipality Description

CHAR(25)

 

Zone

CHAR(2)

 

Filler

CHAR(1)

Value ‘-‘

Zone Description  

CHAR(25)

 

Violation Code

CHAR(20)

 

Violation Description

CHAR(30)

 

Unlawful Speed

NUMERIC

Format 999

Case Action Code

CHAR(2)

Case Action Values:

01  To Be Paid

02  To Be Set For Court

03  Set For Court

04   Reset For Court

05  Cont Set Jury Trial

06  Cont Set Trial

07  Cont Set Arraignment

08  Cont Set Report

09   Bw/Iw Delinquent D6

10   Delinquent Warning

11  D6 To Tallahasse

13  Cont Set Pre-Trial

15  Closed           

20  To Be Reset Court

26  Bench Warrant / Dls

29  Inactive Bw/Dls

33  Compliance Warning

37  Arrest Warrant

38  Diversion Program

39  D6/DP

42  Viol Probation Warrant

51  Pending Review

96  Attend Ts 2x In 12 Month

97  Attend Ts 5x In Lifetime

98  Ineligible 4hrs Reas

99  Defnt Fail Pts Assed

Filler

CHAR(1)

Value ‘-‘

Case Action Code Description

CHAR(25)

 

Dui Flag

CHAR(7)

 

Defense Attorney Last Name

CHAR(30)

 

Defense Attorney First Name

CHAR(12)

 

Hearing Date

DATE(8)

Format ccyymmdd

Balance Due

NUMERIC

Format 9999999.99

Juvenile Flag

CHAR(12)

 

Entered Date

DATE(8)

Format ccyymmdd

Accident Flag

CHAR(8)

Accident flag values:

D      Damages

F       Fatality

I        Injury

N       No

S       Serious

Y      Yes

No Comply Code

CHAR(1)

 

Filler

CHAR(1)

Value ‘-‘

No Comply Code Description

CHAR(25)

 

Penalty Assessed

NUMERIC

Format 9999999.99

Penalty Paid

NUMERIC

Format 9999999.99

Speed Limit

NUMERIC

Format 999

 

 

 

Bench Warrant and Delinquent Cases File Structure (File Definition)

File Name:          Trfbwy.txt          

Run Frequency:  Daily

Description:       Extract bench warrant cases (07 and 37) and delinquent cases (10)

Sample File:       Trfbwy.xls

 

Field Name

Field  Description

Comment

Drl Num         

CHAR(15)

 

Drl Lname         

CHAR(15)

 

Drl Fname         

CHAR(12)

 

Drl Race          

CHAR(1)

 

Case Number       

CHAR(9)

 

Case Street 

CHAR(30)

 

Case Unit         

CHAR(5)

 

Case Apt          

CHAR(5)

 

Case City         

CHAR(15)

 

Case State        

CHAR(2)

 

Case Zip

CHAR(9)

 

Issue Date        

DATE(8)

Format mmddyyyy

Case Violation    

CHAR(20)

 

Unlawful Speed       

NUMERIC

Format 999

Acc Flag

CHAR(1)

Accident flag values:

D      Damages

F       Fatality

I        Injury

N      No

S       Serious

Y      Yes

Case Action       

CHAR(2)

Case Action Values:

01  To Be Paid

02  To Be Set For Court

03  Set For Court

04   Reset For Court

05  Cont Set Jury Trial

06  Cont Set Trial

07  Cont Set Arraignment

08  Cont Set Report

09   Bw/Iw Delinquent D6

10   Delinquent Warning

11  D6 To Tallahasse

13  Cont Set Pre-Trial

15  Closed

20  To Be Reset Court

26  Bench Warrant / Dls

29  Inactive Bw/Dls

33  Compliance Warning

37  Arrest Warrant

38  Diversion Program

39  D6/Dp

42  Viol Probation Warrant

51  Pending Review

96  Attend Ts 2x In 12 Month

97  Attend Ts 5x In Lifetime

98  Ineligible 4hrs Reas

99  Defnt Fail Pts Assed

Dui Flag          

CHAR(1)

 

Court Date        

DATE(8)

Format mmddyyyy

Defn Atty         

CHAR(4)

 

 

 

 

Central Division Violations File Structure (File Definition)

File Name:          Dwlsnvdlcent.txt                 

Run Frequency:  Daily

Description:       Extract specific violations for Central Division only

Sample File:       Dwlsnvdlcent.xls

 

Field Name

Field  Description

Comment

Drv Lic          

CHAR(15)

 

Case             

CHAR(7)

 

Last Name        

CHAR(30)

 

First Name       

CHAR(12)

 

Middle Name        

CHAR(12)

 

DOB              

DATE(8)

Format mmddyyyy

Division         

CHAR(5)

Division Values Are: CENT, CGAB, HIA, MBCH, NDJC, SDJC 

Address

CHAR(30)

 

Addr Apt         

CHAR(5)

 

Addr City        

CHAR(15)

 

Addr State

CHAR(2)

 

Addr Zip         

CHAR(9)

 

Ids Num          

NUMERIC

Format 9999999, Only For Criminal Cases If The Person Gets Arrested. If So, This Number Is Generated In The Criminal Justice System And Traffic Receives This Number In The Nightly Batch Processing.

 

Criminal Citations File Structure (File Definition)

File Name:          Dly_all_criminal.txt            

Run Frequency:  Daily

Description:       This is a listing of all criminal traffic violations entered daily.

Sample File:       Dly-all-criminal.xls

  

Field Name

Field  Description

Comment

Case Number

CHAR(9)

 

Issue Date

DATE(8)

Format ccyymmdd

First Name

CHAR(12)

 

Mid Initial

CHAR(1)

 

Last Name

CHAR(15)

 

Address

CHAR(30)

 

Apt

CHAR(5)

 

City

CHAR(16)

 

State

CHAR(2)

 

Zip Code

CHAR(9)

 

Dob

DATE(8)

Format ccyymmdd

Race

CHAR(25)

 

Sex

CHAR(6)

 

Driver’s License Number

CHAR(15)

 

Municipality                            

CHAR(3)

 

Filler

CHAR(1)

 

Municipality Description

CHAR(25)

 

Zone

CHAR(2)

 

Filler

CHAR(1)

Value ‘-‘

Zone Description  

CHAR(25)

 

Violation Code

CHAR(20)

 

Violation Description

CHAR(30)

 

Unlawful Speed

NUMERIC

Format 999

Case Action Code

CHAR(2)

Case Action Values:

01  To Be Paid

02  To Be Set For Court

03  Set For Court

04   Reset For Court

05  Cont Set Jury Trial

06  Cont Set Trial

07  Cont Set Arraignment

08  Cont Set Report

09   Bw/Iw Delinquent D6

10   Delinquent Warning

11  D6 To Tallahasse

13  Cont Set Pre-Trial

15  Closed                       

20  To Be Reset Court

26  Bench Warrant / Dls

29  Inactive Bw/Dls

33  Compliance Warning

37  Arrest Warrant

38  Diversion Program

39  D6/DP

42  Viol Probation Warrant

51  Pending Review

96  Attend Ts 2x In 12 Month

97  Attend Ts 5x In Lifetime

98  Ineligible 4hrs Reas

99  Defnt Fail Pts Assed

Filler

CHAR(1)

Value ‘-‘

Case Action Code Description

CHAR(25)

 

Dui Flag

CHAR(7)

 

Defense Attorney Last Name

CHAR(30)

 

Defense Attorney First Name

CHAR(12)

 

Hearing Date

DATE(8)

Format ccyymmdd

Balance Due

NUMERIC

Format 9999999.99

Juvenile Flag

CHAR(12)

 

Entered Date

DATE(8)

Format ccyymmdd

Accident Flag

CHAR(8)

Accident flag values:

D      Damages

F       Fatality

I        Injury

N      No

S       Serious

Y      Yes

No Comply Code

CHAR(1)

 

Filler

CHAR(1)

Value ‘-‘

No Comply Code Description

CHAR(25)

 

Penalty Assessed

NUMERIC

Format 9999999.99

Penalty Paid

NUMERIC

Format 9999999.99

Speed Limit

NUMERIC

Format 999

 

Court Attorney Calendars File Structure (File Definition)

File Name:          Trafattycldr.txt, Trafattycld1.txt, Trafattycld2.txt, Trafattycld3.txt, Trafattycld4.txt, Trafattycld5.txt           

Run Frequency:  Daily

Description:       Court Attorney Calendars

Sample File:       Trafattycld1.xls

 

Field Name

Field  Description

Comment

Atny Hrg Type                

CHAR(2)

 

Hrg Abbr                

CHAR(13)

 

Hrg Day                 

CHAR(10)

 

Hrg Month               

CHAR(10)

 

Hrg Date

DATE(8)

Format ccyymmdd

Hrg Time             

CHAR(8)

Format HH:MM XX, Where XX Is AM Or PM

Loc Name                

CHAR(20)

 

Loc Abbrev              

CHAR(6)

 

Loc Address               

CHAR(20)

 

Loc Floor And Room

CHAR(5)

Format xx-xx

Judge Name                  

CHAR(25)

 

Set Date            

DATE(8)

 

Set Time            

NUMERIC

Format 999999

Case Number1            

CHAR(7)

 

Filler               

CHAR(1)

 

Open Paren          

CHAR(1)

 

Case Type           

CHAR(1)

Case Type:

 

I = Infraction

M = Mandatory

C = Criminal

Close Paren         

CHAR(1)

 

Filler               

CHAR(1)

 

Case Number2            

CHAR(7)

 

Filler               

CHAR(1)

 

Open Paren          

CHAR(1)

 

Case Type           

CHAR(1)

Case Type:

 

I = Infraction

M = Mandatory

C = Criminal

Close Paren         

CHAR(1)

 

Filler               

CHAR(1)

 

Case Number3            

CHAR(7)

 

Filler               

CHAR(1)

 

Open Paren          

CHAR(1)

 

Case Type           

CHAR(1)

Case Type:

 

I = Infraction

M = Mandatory

C = Criminal

Close Paren         

CHAR(1)

 

Filler               

CHAR(1)

 

Case Number4            

CHAR(7)

 

Filler               

CHAR(1)

 

Open Paren          

CHAR(1)

 

Case Type           

CHAR(1)

Case Type:

 

I = Infraction

M = Mandatory

C = Criminal

Close Paren         

CHAR(1)

 

Filler               

CHAR(1)

 

Case Number5            

CHAR(7)

 

Filler               

CHAR(1)

 

Open Paren          

CHAR(1)

 

Case Type           

CHAR(1)

Case Type:

 

I = Infraction

M = Mandatory

C = Criminal

Close Paren         

CHAR(1)

 

Filler               

CHAR(1)

 

Case Number6            

CHAR(7)

 

Filler               

CHAR(1)

 

Open Paren          

CHAR(1)

 

Case Type           

CHAR(1)

Case Type:

 

I = Infraction

M = Mandatory

C = Criminal

Close Paren         

CHAR(1)

 

Filler               

CHAR(1)

 

Case Number7            

CHAR(7)

 

Filler               

CHAR(1)

 

Open Paren          

CHAR(1)

 

Case Type           

CHAR(1)

Case Type:

 

I = Infraction

M = Mandatory

C = Criminal

Close Paren         

CHAR(1)

 

Filler               

CHAR(1)

 

Case Number8            

CHAR(7)

 

Filler               

CHAR(1)

 

Open Paren          

CHAR(1)

 

Case Type           

CHAR(1)

Case Type:

 

I = Infraction

M = Mandatory

C = Criminal

Close Paren         

CHAR(1)

 

Filler               

CHAR(1)

 

Recipient Title             

CHAR(17)

 

Code                        

NUMERIC

Format 99999

Atty Last Name                

CHAR(30)

 

Atty First Name               

CHAR(12)

 

Atty Middle Name

CHAR(12)

 

Atty Address

CHAR(34)

 

Atty City                     

CHAR(15)

 

Atty State

CHAR(2)

 

Atty Zip                      

CHAR(9)

 

Sounding Flag               

CHAR(1)

 

Other Hrg Date

DATE(10)

Format mmddyyyy

Other Hrg Time

CHAR(8)

Format HH:MM XX, Where XX Is AM Or PM

Other Hrg Ctrm

CHAR(5)

 

Filler

CHAR(10)

 

Defendant Name

CHAR(46)

 

 

Custom Surety Bond Cases File Structure (File Definition)

File Name:          Bondasis.txt                

Run Frequency:  Daily

Description:       Custom File

Sample File:       Bondasis.xls

 

Field Name

Field  Description

Comment

Case Number         

CHAR(9)

 

First Name      

CHAR(12)

 

Middle Initial    

CHAR(12)

 

Last Name

CHAR(30)

 

Bond Comp Id     

CHAR(2)

 

Bond Receipt     

CHAR(13)

 

Bond Issue Date    

DATE(8)

Format ccyymmdd

Bond Forf Rec Dt 

DATE(8)

Format ccyymmdd

Vacate Date      

DATE(8)

Format ccyymmdd

Dischg Date      

DATE(8)

Format ccyymmdd

Forf Remt Estr Dt

DATE(8)

Format ccyymmdd

Forf Remt Est Amt

NUMERIC

Format 999999999

Bond Forf Est Dt 

DATE(8)

Format ccyymmdd

Bond Number        

NUMERIC

Format 99999

Bond Type        

CHAR(1)

Bond Type:

S-Surety

C-Cash

Bond Action      

CHAR(2)

Bond Action:

00-Bond Action Vary by Case

01-Active (Open) (Reopen)

02-Inactive

03-Ready for Refund (Cash)

04-Refunded

05-Estreated/forfeited

06-Set aside/vacate

07-Surrendered

08-Delete invalid bond

09-surety cleared/discharge

10-Estreature Deleted

11-Surety Paid

Bond Surr Date   

DATE(8)

Format ccyymmdd

Bond Amount      

NUMERIC

Format 9999999.99

Last Court Date  

DATE(8)

Format ccyymmdd

Judgement Disp

CHAR(2)

 

 

Custom Traffic Disposition Case File Structure (File Definition)

File Name:          Trafdispmalo.txt                  

Run Frequency:  Daily

Description:       Custom File

Sample File:       Trafdispmalo.xls

 

Field Name

Field  Description

Comment

Case             

CHAR(9)

 

Issue     

DATE(8)

Format ccyymmdd

Judge     

NUMERIC

Format 99999

Assd       

NUMERIC

Format 99999.99

Disp  

CHAR(2)

Case Disposition:

01 Guilty

02 Not Guilty

03 Dismissed

04 Nolle-Pros

05 Withhold Adjdctn

06 Trans Cnty/Criminal

07 Trans Circ/Criminal

08 Trans Circ/Juv

09 Trans Circ/Appeal

10 Estr/Forfeit Bond

11 Dismissed Officer

12 Dismissed Civ-Wit

13 Dismissed Off/Civ

14 Dismissed Sao

15 Dismissed Speedy

16 Dismissed Complied

17 Dismissed Wrong Statute

18 Dismissed No Witness Lis

19 Dismissed Defective Cita

20 Dismissed Officer Reques

21 Dismissed No Civilian Wi

22 Dismissed Toll Violation

Case Stat            

CHAR(3)

 

Violation 

CHAR(20)

 

Last Name            

CHAR(30)

 

First Name           

CHAR(12)

 

Middle Name          

CHAR(12)

 

Address           

CHAR(30)

 

Unit                

CHAR(5)

 

Apt             

CHAR(5)

 

City

CHAR(15)

 

State                

CHAR(2)

 

Zip              

CHAR(9)

 

DOB        

DATE(8)

Format ccyymmdd

Drl               

CHAR(15)

 

Rehab     

CHAR(1)

 

Race                 

CHAR(1)

 

Sex        

CHAR(1)

 

Accident  

CHAR(1)

Accident flag values:

D      Damages

F       Fatality

I        Injury

N      No

S       Serious

Y      Yes

Rehab Pgm            

CHAR(2)

90- 4 Hrs Traffic School, Voluntary

91- 8 Hrs Traffic School, Voluntary

92- 12 Hrs Traffic School, Voluntary

93- 4 Hrs Traffic School, Court Ordered

94- 8 Hrs Traffic School, Court Ordered

95- 12 Hrs Traffic School, Court Ordered

10- High Risk

Attn Flag            

CHAR(1)

 

Atty Id 1

CHAR(5) 

 

Atty Id 2            

CHAR(5) 

 

Penalty Due Date     

DATE(8) 

Format ccyymmdd

 

 

 

Custom Traffic Disposition by Attorney File Structure (File Definition)

File Name:          Trafdispatty.Txt          

Run Frequency:  Daily

Description:       Custom file

Sample File:       Trafdispatty.xls

 

 

Field Name

Field  Description

Comment

Case             

CHAR(9)

 

Issue     

DATE(8)

Format ccyymmdd

Judge     

NUMERIC

Format 99999

Assd       

NUMERIC(7,2)

Format 9999999.99

Disp  

CHAR(2)

Case Disposition:

 

01   Guilty

02   Not Guilty

03   Dismissed

04   Nolle-Pros

05   Withhold Adjdctn

06   Trans Cnty/Criminal

07   Trans Circ/Criminal

08   Trans Circ/Juv

09   Trans Circ/Appeal

10   Estr/Forfeit Bond

11   Dismissed Officer

12   Dismissed Civ-Wit

13   Dismissed Off/Civ

14   Dismissed Sao

15   Dismissed Speedy

16   Dismissed Complied

17   Dismissed Wrong Statute

18   Dismissed No Witness Lis

19   Dismissed Defective Cita

20   Dismissed Officer Reques

21   Dismissed No Civilian Wi

22   Dismissed Toll Violation

Case Stat            

CHAR(3)

 

Violation 

CHAR(20)

 

Last Name            

CHAR(30)

 

First Name           

CHAR(12)

 

Middle Name          

CHAR(12)

 

Address           

CHAR(30)

 

Unit              

CHAR(5)

 

Apt             

CHAR(5)

 

City

CHAR(15)

 

State                

CHAR(2)

 

Zip              

CHAR(9)

 

DOB        

DATE(8)

Format ccyymmdd

Drl               

CHAR(15)

 

Rehab     

CHAR(1)

 

Race                 

CHAR(1)

 

Sex        

CHAR(1)

 

Accident  

CHAR(1)

Accident flag values:

D      Damages

F       Fatality

I        Injury

N       No

S       Serious

Y      Yes

Rehab Pgm            

CHAR(2)

90- 4 Hrs Traffic School, Voluntary

91- 8 Hrs Traffic School, Voluntary

92- 12 Hrs Traffic School, Voluntary

93- 4 Hrs Traffic School, Court Ordered

94- 8 Hrs Traffic School, Court Ordered

95- 12 Hrs Traffic School, Court Ordered

10- High Risk

Attn Flag            

CHAR(1)

 

Atty Id 1

CHAR(5) 

 

Atty Id 2            

CHAR(5) 

 

Penalty Due Date     

DATE(8) 

Format ccyymmdd

 

Defendants Ordered to Attend Traffic School File Structure (File Definition)

File Name:          Mandate.txt                

Run Frequency:  Daily

Description:       File of defendants ordered to attend traffic school. 

Sample File:       Mandate.xls

 

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         

Field Name

Field  Description

Comment

Case Number             

CHAR(9)

 

Last Name                   

CHAR(30)

 

First Name                  

CHAR(12)

 

Middle Initial

CHAR(12)

 

Address                 

CHAR(30)

 

Unit                    

CHAR(5)

 

Apt                     

CHAR(5)

 

City                    

CHAR(15)

 

State                   

CHAR(2)

 

Zip

CHAR(9)

 

Driver’s License                    

CHAR(15)

 

DOB                     

DATE(8)

Format mmddyyyy

Race                    

CHAR(1)

 

Sex                     

CHAR(1)

 

Disp                    

CHAR(2)

 

Hours                   

CHAR(2)

 

Violation               

CHAR(20)

 

Assd                    

NUMERIC

Format 99999.99

Due Date                

DATE(8)

Format mmddyyyy

    

Driving while License Suspended/No Valid Driver’s License Citations File Structure (File Definition)

File Name:          Dwlsusp.txt                

Run Frequency:  Daily

Description:       Daily listing of citations entered for these violations:  Driving while license suspended/no valid driver’s license.

Sample File:       Dwlsusp.xls

 

Field Name

Field  Description

Comment

Driver’s License Number

CHAR(15)

 

Last Name

CHAR(15)

 

First Name

CHAR(12)

 

Race

CHAR(1)

 

Case Number

CHAR(9)

 

Address

CHAR(40)

 

City

CHAR(15)

 

State

CHAR(2)

 

Zip Code

CHAR(9)

 

Iss Date

DATE(8)

Format mmddyyyy

Viol

CHAR(20)

 

Speed

CHAR(3)

 

Acc Flag

CHAR(1)

Accident flag values:

D      Damages

F      Fatality

I       Injury

N      No

S      Serious

Y      Yes

Action

CHAR(2)

Case Action Values:

01  To Be Paid

02  To Be Set For Court

03  Set For Court

04   Reset For Court

05  Cont Set Jury Trial

06  Cont Set Trial

07  Cont Set Arraignment

08  Cont Set Report

09   Bw/Iw Delinquent D6

10   Delinquent Warning

11  D6 To Tallahasse

13  Cont Set Pre-Trial

15  Closed

20  To Be Reset Court

26  Bench Warrant / Dls

29  Inactive Bw/Dls

33  Compliance Warning

37  Arrest Warrant

38  Diversion Program

39  D6/DP

42  Viol Probation Warrant

51  Pending Review

96  Attend Ts 2x In 12 Month

97  Attend Ts 5x In Lifetime

98  Ineligible 4hrs Reas

99  Defnt Fail Pts Assed

DUI Flag

CHAR(1)

 

Crt Date

DATE

Format mmddyyyy

 

DUI Citations File Structure (File Definition)

File Name:          Dly_All_DUI.txt                  

Run Frequency:  Daily

Description:       This is a listing of daily DUI citations issued.

Sample File:       Dly-all-DUI.xls

 

Field Name

Field  Description

Comment

Case Number

CHAR(9)

 

Issue Date

DATE(8)

Format ccyymmdd

First Name

CHAR(12)

 

Mid Initial

CHAR(1)

 

Last Name

CHAR(15)

 

Address

CHAR(30)

 

Apt

CHAR(5)

 

City

CHAR(16)

 

State

CHAR(2)

 

Zip Code

CHAR(9)

 

Dob

DATE(8)

Format ccyymmdd

Race

CHAR(25)

 

Sex

CHAR(6)

 

Driver’s License Number

CHAR(15)

 

Municipality                            

CHAR(3)

 

Filler

CHAR(1)

 

Municipality Description

CHAR(25)

 

Zone

CHAR(2)

 

Filler

CHAR(1)

Value ‘-‘

Zone Description  

CHAR(25)

 

Violation Code

CHAR(20)

 

Violation Description

CHAR(30)

 

Unlawful Speed

NUMERIC

Format 999

Case Action Code

CHAR(2)

Case Action Values:

01  To Be Paid

02  To Be Set For Court

03  Set For Court

04   Reset For Court

05  Cont Set Jury Trial

06  Cont Set Trial

07  Cont Set Arraignment

08  Cont Set Report

09   Bw/Iw Delinquent D6

10   Delinquent Warning

11  D6 To Tallahasse

13  Cont Set Pre-Trial

15  Closed

20  To Be Reset Court

26  Bench Warrant / Dls

29  Inactive Bw/Dls

33  Compliance Warning

37  Arrest Warrant

38  Diversion Program

39  D6/DP

42  Viol Probation Warrant

51  Pending Review

96  Attend Ts 2x In 12 Month

97  Attend Ts 5x In Lifetime

98  Ineligible 4hrs Reas

99  Defnt Fail Pts Assed

Filler

CHAR(1)

Value ‘-‘

Case Action Code Description

CHAR(25)

 

Dui Flag

CHAR(7)

 

Defense Attorney Last Name

CHAR(30)

 

Defense Attorney First Name

CHAR(12)

 

Hearing Date

DATE(8)

Format ccyymmdd

Balance Due

NUMERIC

Format 9999999.99

Juvenile Flag

CHAR(12)

 

Entered Date

DATE(8)

Format ccyymmdd

Accident Flag

CHAR(8)

Accident flag values:

D      Damages

F       Fatality

I        Injury

N       No

S       Serious

Y      Yes

No Comply Code

CHAR(1)

 

Filler

CHAR(1)

Value ‘-‘

No Comply Code Description

CHAR(25)

 

Penalty Assessed

NUMERIC

Format 9999999.99

Penalty Paid

NUMERIC

Format 9999999.99

Speed Limit

NUMERIC

Format 999

        

 

 

Fail to Comply/Agree to Appear for Uniform Traffic Citation File Structure (File Definition)

File Name:          Trafnocomply.txt                 

Run Frequency:  Daily

Description:       Extract all notices of Fail to Comply/Agree Appear for Uniform Traffic Citations.

Sample File:       Trafnocomply.xls

 

Field Name

Field  Description

Comment

Defendant Last Name  

CHAR(30)

 

Defendant First Name 

CHAR(12)

 

Defendant Middle Name

CHAR(12)

 

Defendant Gender        

CHAR(1)

 

Defendant DOB           

DATE(8)

Format ccyymmdd

Defendant Drl           

CHAR(15)

 

Defendant Address       

CHAR(30)

 

Defendant Unit       

CHAR(5)

 

Defendant Apt        

CHAR(5)

 

Defendant City       

CHAR(15)

 

Defendant State     

CHAR(2)

 

Defendant Zip        

CHAR(9)

 

Case                    

CHAR(7)

 

Case Type               

CHAR(1)

Case Type:

 

I = Infraction

M = Mandatory

C = Criminal

File Date               

DATE(8)

Format ccyymmdd

Statute                 

CHAR(20)

 

Statute Description    

CHAR(16)

 

Status                  

CHAR(3)

 

Status Date             

DATE(8)

Format ccyymmdd

Disposition             

CHAR(2)

Case Disposition:

 

01   Guilty

02   Not Guilty

03   Dismissed

04   Nolle-Pros

05   Withhold Adjdctn

06   Trans Cnty/Criminal

07   Trans Circ/Criminal

08   Trans Circ/Juv

09   Trans Circ/Appeal

10   Estr/Forfeit Bond

11   Dismissed Officer

12   Dismissed Civ-Wit

13   Dismissed Off/Civ

14   Dismissed Sao

15   Dismissed Speedy

16   Dismissed Complied

17   Dismissed Wrong Statute

18   Dismissed No Witness Lis

19   Dismissed Defective Cita

20   Dismissed Officer Reques

21   Dismissed No Civilian Wi

22   Dismissed Toll Violation

Fail Code               

CHAR(1)

Fail Code:

0-Failed to pay fine

1-Failed to appear

2-Failed to CPT school

3-Stop drv lic renewal

4-Uncollected check

5-Failed to comp reh prog

6-Failed to comp jail stay

7-Failed to pay fine

8-c/card chg back

No Comply Date          

DATE(8)

Format ccyymmdd

Amount Due              

NUMERIC

Format 9999999.99

Witness Ind             

CHAR(2)

 

Atty Code           

CHAR(5)

 

Atty Last Name   

CHAR(30)

 

Atty First Name  

CHAR(12)

 

Atty Middle Name

CHAR(12)

 

 

Previous Day Citations File Structure (File Definition)

File Name:          Dly_All_Citations.txt          

Run Frequency:  Daily

Description:       File Contains All Citations Entered the Previous Day.

Sample File:       Dly-all-citations.xls

 

Field Name

Field  Description

Comment

Case Number

CHAR(9)

 

Issue Date

DATE(8)

Format ccyymmdd

First Name

CHAR(12)

 

Mid Initial

CHAR(12)

 

Last Name

CHAR(15)

 

Address

CHAR(40)

 

City

CHAR(15)

 

State

CHAR(2)

 

Zip Code

CHAR(9)

 

Dob

DATE(8)

Format ccyymmdd

Race

CHAR(1)

 

Sex

CHAR(1)

 

Drl

CHAR(15)

 

Municipality

CHAR(3)

 

Zone

CHAR(3)

 

Violation Code

CHAR(10)

 

Unlawful Speed

NUMERIC

Format 999

Case Action Code

CHAR(2)

Case Action Values:

01  To Be Paid

02  To Be Set For Court

03  Set For Court

04   Reset For Court

05  Cont Set Jury Trial

06  Cont Set Trial

07  Cont Set Arraignment

08  Cont Set Report

09   Bw/Iw Delinquent D6

10   Delinquent Warning

11  D6 To Tallahasse

13  Cont Set Pre-Trial

15  Closed

20  To Be Reset Court

26  Bench Warrant / Dls

29  Inactive Bw/Dls

33  Compliance Warning

37  Arrest Warrant

38  Diversion Program

39  D6/DP

42  Viol Probation Warrant

51  Pending Review

96  Attend Ts 2x In 12 Month

97  Attend Ts 5x In Lifetime

98  Ineligible 4hrs Reas

99  Defnt Fail Pts Assed

Dui Flag

CHAR(1)

 

Defense Attorney

NUMERIC

Format 99999

Hearing Date

DATE(8)

Format ccyymmdd

Balance Due     

NUMERIC

Format 9999999.99

Juvenile Flag   

CHAR(1)

 

Entered Date      

DATE(8)

Format ccyymmdd

Accident Flag   

CHAR(1)

Accident flag values:

D      Damages

F       Fatality

I        Injury

N       No

S       Serious

Y      Yes

No Comply Code  

CHAR(1)

 

Penalty Assessed

NUMERIC

Format 9999999.99

Penalty Paid    

NUMERIC

Format 9999999.99

Speed Limit     

NUMERIC

Format 999

 

Traffic Citations for the Past Four Days File Structure (File Definition)

File Name:          Alticke1.txt, Alticke2.txt, Alticke3.txt, Alticke4.txt    

Run Frequency:  Daily

Description:       Last Four (4) Days of All Traffic Tickets That Have Been Entered.

Sample File:       Alticke1.xls

                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         

Field Name

Field  Description

Comment

Case Number             

CHAR(9)

 

Issue Date              

DATE(8)

Format ccyymmdd

Name First              

CHAR(12)

 

Name Middle   

CHAR(1)

 

Name Last               

CHAR(15)

 

Address

CHAR(30)

 

Address Unit            

CHAR(5)

 

Address Apt             

CHAR(5)

 

City             

CHAR(16)

 

State             

CHAR(2)

 

Zip 

CHAR(9)

 

Birth Date              

DATE(8)

Format ccyymmdd

Race            

CHAR(1)

 

Sex       

CHAR(1)

 

Driver License          

CHAR(15)

 

Muni

NUMERIC

Format 999

Zone      

CHAR(2)

 

Violation Code          

CHAR(20)

 

Unlaw Speed             

NUMERIC

Format 999

Auto Set Date           

DATE(8)

Format ccyymmdd

Case Action     

CHAR(2)

Case Action Values:

01  To Be Paid

02  To Be Set For Court

03  Set For Court

04   Reset For Court

05  Cont Set Jury Trial

06  Cont Set Trial

07  Cont Set Arraignment

08  Cont Set Report

09   Bw/Iw Delinquent D6

10   Delinquent Warning

11  D6 To Tallahasse

13  Cont Set Pre-Trial

15  Closed

20  To Be Reset Court

26  Bench Warrant / Dls

29  Inactive Bw/Dls

33  Compliance Warning

37  Arrest Warrant

38  Diversion Program

39  D6/Dp

42  Viol Probation Warrant

51  Pending Review

96  Attend Ts 2x In 12 Month

97  Attend Ts 5x In Lifetime

98  Ineligible 4hrs Reas

99  Defnt Fail Pts Assed

Dui Flag        

CHAR(1)

 

Defense Attorney

NUMERIC

Format 99999

Court Date      

DATE(8)

Format ccyymmdd

Balance Due     

NUMERIC

Format 999999.99

Juvenile Flag   

CHAR(1)

 

Enter Date      

DATE(8)

Format ccyymmdd

Accident Flag   

CHAR(1)

Accident flag values:

D      Damages

F       Fatality

I        Injury

N      No

S       Serious

Y      Yes

No Comply Code  

CHAR(1)

 

Penalty Assessed

NUMERIC

Format 99999.99

Penalty Paid    

NUMERIC

Format 99999.99

Speed Limit     

NUMERIC

Format 999

Open Cases      

NUMERIC

Format 999

Case Type       

CHAR(1)

Case Type:

 

I = Infraction

M = Mandatory

C = Criminal

Previous Disp   

CHAR(1)

 

 

 

 

Traffic Disposition File Structure (File Definition)

File Name:          Trafdisp.txt                 

Run Frequency:  Daily

Description:       Extracts disposed cases from the previous day.

Sample File:       Trafdisp.xls

 

Field Name

Field  Description

Comment

Case           

CHAR(9)

 

Issue

NUMERIC

Format 99999999

Judge  

NUMERIC

Format 99999

Assd  

NUMERIC

Format 99999.99

Disp   

CHAR(2)

Case Disposition:

 

01   Guilty

02   Not Guilty

03   Dismissed

04   Nolle-Pros

05   Withhold Adjdctn

06   Trans Cnty/Criminal

07   Trans Circ/Criminal

08   Trans Circ/Juv

09   Trans Circ/Appeal

10   Estr/Forfeit Bond

11   Dismissed Officer

12   Dismissed Civ-Wit

13   Dismissed Off/Civ

14   Dismissed Sao

15   Dismissed Speedy

16   Dismissed Complied

17   Dismissed Wrong Statute

18   Dismissed No Witness Lis

19   Dismissed Defective Cita

20   Dismissed Officer Reques

21   Dismissed No Civilian Wi

22   Dismissed Toll Violation

Case Stat            

CHAR(3)

 

Violation

CHAR(20)

 

Last Name            

CHAR(30)

 

First Name           

CHAR(12)

 

Middle Name          

CHAR(12)

 

Address     

CHAR(30)

 

Unit

CHAR(5)

 

Apt      

CHAR(5)

 

City                 

CHAR(15)

 

State

CHAR(2)

 

Zip

CHAR(9)

 

Dob        

DATE(8)

Format mmddyyyy

Drl  

CHAR(15)

 

Rehab

CHAR(1)

 

Race    

CHAR(1)

 

Sex   

CHAR(1)

 

Accident

CHAR(1)

Accident flag values:

D      Damages

F       Fatality

I        Injury

N      No

S       Serious

Y      Yes

Rehab Pgm

CHAR(2)

90- 4 Hrs Traffic School, Voluntary

91- 8 Hrs Traffic School, Voluntary

92- 12 Hrs Traffic School, Voluntary

93- 4 Hrs Traffic School, Court Ordered

94- 8 Hrs Traffic School, Court Ordered

95- 12 Hrs Traffic School, Court Ordered

10- High Risk

Attn Flag            

CHAR(1)

 

Penalty Due Date     

DATE(8)

Format mmddyyyy

 

Traffic Infractions File Structure (File Definition)

File Name:          Trfinf.txt            

Run Frequency:  Daily

Description:       Daily listing of traffic infractions.

Sample File:       Trfinf.xls

 

Field Name

Field  Description

Comment

Driver’s License Number

CHAR(15)

 

Last Name

CHAR(15)

 

First Name

CHAR(12)

 

Race

CHAR(1)

 

Case Number

CHAR(9)

 

Address

CHAR(40)

 

City

CHAR(15)

 

State

CHAR(2)

 

Zip Code

CHAR(9)

 

Iss Date

DATE(8)

Format mmddyyyy

Viol

CHAR(20)

 

Speed

CHAR(3)

 

Acc Flag

CHAR(1)

Accident flag values:

D     Damages

F      Fatality

I       Injury

N      No

S      Serious

Y      Yes

Action

CHAR(2)

Case Action Values:

01  To Be Paid

02  To Be Set For Court

03  Set For Court

04   Reset For Court

05  Cont Set Jury Trial

06  Cont Set Trial

07  Cont Set Arraignment

08  Cont Set Report

09   Bw/Iw Delinquent D6

10   Delinquent Warning

11  D6 To Tallahasse

13  Cont Set Pre-Trial

15  Closed

20  To Be Reset Court

26  Bench Warrant / Dls

29  Inactive Bw/Dls

33  Compliance Warning

37  Arrest Warrant

38  Diversion Program

39  D6/DP

42  Viol Probation Warrant

51  Pending Review

96  Attend Ts 2x In 12 Month

97  Attend Ts 5x In Lifetime

98  Ineligible 4hrs Reas

99  Defnt Fail Pts Assed

DUI Flag

CHAR(1)

 

Crt Date

DATE

Format mmddyyyy

 

Violations by Division File Structure (File Definition)

File Name:          Dwlsnvdl.txt               

Run Frequency:  Daily

Description:       Extract specific violations for all divisions.

Sample File:       Dwlsnvdl.xls

 

Field Name

Field  Description

Comment

Drl               

CHAR(15)

 

Case             

CHAR(7)

 

Last Name            

CHAR(30)

 

First Name           

CHAR(12)

 

Middle Name          

CHAR(12)

 

DOB        

DATE(8)

Format ddmmyyyy

Division

CHAR(5)

Division Values Are: CENT, CGAB, HIA, MBCH, NDJC, SDJC 

Address           

CHAR(30)

 

Apt             

CHAR(5)

 

City

CHAR(15)

 

State                

CHAR(2)

 

Zip              

CHAR(9)

 

Ids Num

NUMERIC

Format 9999999, Only For Criminal Cases If The Person Gets Arrested. If So, This Number Is Generated In The Criminal Justice System And Traffic Receives This

 

 

Monthly Files

Custom Infractions and Criminal Traffic Cases Extraction File Structure (File Definition)

File Name:  Trfrecds.txt                  

Run Frequency:  Monthly

Description:  Custom file

Sample File:  Trfrecds.xls 

Field Name

Field  Description

Comment

Defendant Last Name  

CHAR(30)

 

Defendant First Name 

CHAR(12)

 

Defendant Middle Name

CHAR(12)

 

Defendant Gender        

CHAR(1)

 

Defendant DOB   

DATE(8)

Format ccyymmdd

Defendant Driver’s License           

CHAR(15)

 

Defendant Address       

CHAR(30)

 

Defendant Unit       

CHAR(5)

 

Defendant Apt        

CHAR(5)

 

Defendant City       

CHAR(15)

 

Defendant State      

CHAR(2)

 

Defendant Zip        

CHAR(9)

 

Case Number                    

CHAR(7)

 

Citation Number         

CHAR(7)

 

Case Type               

CHAR(1)

Case Type:

 

I = Infraction

M = Mandatory

C = Criminal

File Date               

DATE(8)

Format ccyymmdd

Offense Date            

DATE(8)

Format ccyymmdd

Offense Description     

CHAR(20)

 

Statute                 

CHAR(20)

 

Statute Description     

CHAR(16)

 

Status                  

CHAR(3)

 

Status Date             

DATE(8)

Format ccyymmdd

Disposition             

CHAR(2)

Case Disposition:

 

01   Guilty

02   Not Guilty

03   Dismissed

04   Nolle-Pros

05   Withhold Adjdctn

06   Trans Cnty/Criminal

07   Trans Circ/Criminal

08   Trans Circ/Juv

09   Trans Circ/Appeal

10   Estr/Forfeit Bond

11   Dismissed Officer

12   Dismissed Civ-Wit

13   Dismissed Off/Civ

14   Dismissed Sao

15   Dismissed Speedy

16   Dismissed Complied

17   Dismissed Wrong Statute

18   Dismissed No Witness Lis

19   Dismissed Defective Cita

20   Dismissed Officer Reques

21   Dismissed No Civilian Wi

22   Dismissed Toll Violation

Disposition Date        

DATE(8)

Format ccyymmdd

 

 

 

Custom Infractions and Criminal Traffic Cases File Structure (File Definition)

File Name:  Zachhist.txt                 

Run Frequency: Monthly

Description:  Custom file

Sample File:   Zachhist.xls 

Field Name

Field  Description

Comment

Last Name            

CHAR(30)

 

First Name           

CHAR(12)

 

Middle Name          

CHAR(12)

 

Date Of Birth        

DATE(8)

Format ccyymmdd

Driver’s License

CHAR(15)

 

Address          

CHAR(30)

 

Apt              

CHAR(5)

 

City             

CHAR(15)

 

State            

CHAR(2)

 

Zip              

CHAR(9)

 

Case Type            

CHAR(1)

Case Type:

 

I = Infraction

M = Mandatory

C = Criminal

Court Date           

DATE(8)

Format ccyymmdd

Summons Number       

CHAR(9)

 

Violation Date       

DATE(8)

Format ccyymmdd

Violation Statute    

CHAR(20)

 

Violation Description

CHAR(16)

 

Summons Issue Date

DATE(8)

Format ccyymmdd

Adjudicated Date     

DATE(8)

Format ccyymmdd

Adjudicated Description

CHAR(20)

 

Disposition  

CHAR(2)

Case Disposition:

 

01   Guilty

02   Not Guilty

03   Dismissed

04   Nolle-Pros

05   Withhold Adjdctn

06   Trans Cnty/Criminal

07   Trans Circ/Criminal

08   Trans Circ/Juv

09   Trans Circ/Appeal

10   Estr/Forfeit Bond

11   Dismissed Officer

12   Dismissed Civ-Wit

13   Dismissed Off/Civ

14   Dismissed Sao

15   Dismissed Speedy

16   Dismissed Complied

17   Dismissed Wrong Statute

18   Dismissed No Witness Lis

19   Dismissed Defective Cita

20   Dismissed Officer Request

21   Dismissed No Civilian Wi

22   Dismissed Toll Violation

Case Status          

CHAR(1)

 

 

 

 

Moving and Non-Moving Violations that Affect Driving Privileges File Structure (File Definition)

File Name:  Ballhist.txt          

Run Frequency:  Monthly

Description:  Extract Traffic cases involving moving and non-moving violations which affect driving privileges.

Sample File:  Ballhist.xls 

Field Name

Field  Description

Comment

Defendant Last Name  

CHAR(30)

 

Defendant First Name 

CHAR(12)

 

Defendant Middle Name

CHAR(12)

 

Defendant Address       

CHAR(30)

 

Defendant Unit       

CHAR(5)

 

Defendant Apt        

CHAR(5)

 

Defendant City       

CHAR(15)

 

Defendant State      

CHAR(2)

 

Defendant Zip        

CHAR(9)

 

Defendant DOB           

DATE(8)

Format ccyymmdd

Status                  

CHAR(3)

 

Statute                 

CHAR(20)

 

Statute Description   

CHAR(16)

 

Offense Date            

DATE(8)

Format ccyymmdd

Adjudication            

CHAR(2)

Adjudication:

 

01   Guilty

02   Not Guilty

03   Dismissed

04   Nolle-Pros

05   Withhold Adjdctn

06   Trans Cnty/Criminal

07   Trans Circ/Criminal

08   Trans Circ/Juv

09   Trans Circ/Appeal

10   Estr/Forfeit Bond

11   Dismissed Officer

12   Dismissed Civ-Wit

13   Dismissed Off/Civ

14   Dismissed Sao

15   Dismissed Speedy

16   Dismissed Complied

17   Dismissed Wrong Statute

18   Dismissed No Witness Lis

19   Dismissed Defective Cita

20   Dismissed Officer Request

21   Dismissed No Civilian Wi

22   Dismissed Toll Violation

Judgment Date          

DATE(8)

Format ccyymmdd

Case Number

CHAR(7)

 

Driver License          

CHAR(15)

 

 

Red Light Violations File Structure (File Definition)

File Name: Redlight.txt                 

Run Frequency:  Monthly

Description:  All Red Light Violations from the Previous Month listed by issuing agency.

Sample File:  Redlight.xls 

Field Name

Field Description

Comment

Case Agency           

NUMERIC

Format 9999

Agency Description           

CHAR(40)

 

Case Number           

CHAR(10)

 

Case Issue Date       

DATE(8)

Format ccyymmdd

Ledger Date           

DATE(8)

Format ccyymmdd

Ledger Type           

CHAR(6)

 

Ledger Amount            

NUMERIC

Format 99,999,999.99- With Zero Number Suppression And If Negative Number, A Minus Sign At The End

           

Weekly Files

Custom Traffic Infractions Case File Structure (File Definition)

File Name:  Jmweekly.txt               

Run Frequency:  Weekly

Description: Custom File

Sample File:  Jmweekly.xls 

Field Name

Field  Description

Comment

Local Case Number       

CHAR(7)

 

Uniform Case Number     

CHAR(30)

 

Citation Number         

CHAR(7)

 

Officer Agency          

NUMERIC

Format 999

Violation Date          

DATE(8)

Format ccyymmdd

Filing Date             

DATE(8)

Format ccyymmdd

Defendant Last Name  

CHAR(30)

 

Defendant First Name 

CHAR(12)

 

Defendant Middle Name

CHAR(12)

 

Defendant Full Name          

CHAR(44)

 

Defendant Address       

CHAR(30)

 

Defendant Unit       

CHAR(5)

 

Defendant Apt

CHAR(5)

 

Defendant City      

CHAR(15)

 

Defendant State

CHAR(2)

 

Defendant Zip        

CHAR(9)

 

Defendant DOB           

DATE(8)

Format ccyymmdd

Defendant Drl           

CHAR(15)

 

Defendant Drl State   

CHAR(2)

 

Defendant Gender        

CHAR(1)

 

Defendant Race          

CHAR(1)

 

Defendant Veh Tag Nbr   

CHAR(10)

 

Defendant Veh Tag State

CHAR(2)

 

Defendant Veh Make      

CHAR(4)

 

Defendant Veh Model     

CHAR(4)

 

Defendant Veh Year      

NUMERIC

Format 99

Commercial Veh Flag     

CHAR(1)

 

State Statute Code      

NUMERIC

Format 9999

Violation Type Code     

CHAR(1)

 

Statute Description     

CHAR(16)

 

Violation County        

NUMERIC

Format 99

Violation Location      

CHAR(20)

 

Posted Speed            

NUMERIC

Format 999

Reported Speed

NUMERIC

Format 999

Propty Damage Crash Flag

CHAR(1)

Values:

D      Damages

F      Fatality

I       Injury

N      No

S      Serious

Y      Yes

Persnl Injury Crash Flag

CHAR(1)

Values:

D      Damages

F      Fatality

I       Injury

N      No

S      Serious

Y      Yes

Svperl Injury Crash Flag

CHAR(1)

Values:

D      Damages

F      Fatality

I       Injury

N      No

S      Serious

Y      Yes

Fatality Crash Flag     

CHAR(1)

Values:

D      Damages

F      Fatality

I       Injury

N      No

S      Serious

Y      Yes

Defendant Plea          

CHAR(1)

Defendant Plea:

G-Guilty

L-Nolo Contendere

N-Not Guilty

Cjs Atty Last Name   

CHAR(30)

 

Cjs Atty First Name

CHAR(12)

 

Cjs Atty Middle Name 

CHAR(12)

 

Disposition             

CHAR(2)

Case Disposition:

01   Guilty

02   Not Guilty

03   Dismissed

04   Nolle-Pros

05   Withhold Adjdctn

06   Trans Cnty/Criminal

07   Trans Circ/Criminal

08   Trans Circ/Juv

09   Trans Circ/Appeal

10   Estr/Forfeit Bond

11   Dismissed Officer

12   Dismissed Civ-Wit

13   Dismissed Off/Civ

14   Dismissed Sao

15   Dismissed Speedy

16   Dismissed Complied

17   Dismissed Wrong Statute

18   Dismissed No Witness Lis

19   Dismissed Defective Cita

20   Dismissed Officer Reques

21   Dismissed No Civilian Wi

22   Dismissed Toll Violation

Disposition Description 

CHAR(20)

 

Disposition Date        

DATE(8)

 

Amount Due              

NUMERIC

Format 99999.99

Amount Outstanding   

NUMERIC

Format 99999.99

State Statute Violated  

CHAR(20)

 

 

 

Custom Infractions and Criminal Traffic Cases Extraction File Structure (File Definition)

File Name:  Lxnxwkly.txt               

Run Frequency:  Weekly

Description:  Custom File

Sample File:  Lxnxwkly.xls 

Field Name

Field  Description

Comment

Defendant Last Name 

CHAR(30)

 

Defendant First Name

CHAR(12)

 

Defendant Middle Name

CHAR(12)

 

Defendant Gender       

CHAR(1)

 

Defendant DOB

DATE(8)

Format ccyymmdd

 

 

 

Defendant Drl           

CHAR(15)

 

Defendant Address       

CHAR(30)

 

Defendant Unit       

CHAR(5)

 

Defendant Apt        

CHAR(5)

 

Defendant City       

CHAR(15)

 

Defendant State      

CHAR(2)

 

Defendant Zip        

CHAR(9)

 

 

 

 

Case                    

CHAR(7)

 

Citation Number         

CHAR(7)

 

Case Type               

CHAR(1)

Case Type:

 

I = Infraction

M = Mandatory

C = Criminal

File Date               

DATE(8)

Format ccyymmdd

Offense Date            

DATE(8)

Format ccyymmdd

Offense Description     

CHAR(20)

 

Statute                 

CHAR(20)

 

Statute Description     

CHAR(16)

 

Status                  

CHAR(3)

 

Status Date             

DATE(8)

Format ccyymmdd

Disposition Date

DATE(8)

Format ccyymmdd

 

 

 

Moving Violations File Structure (File Definition)

File Name:  Wky_Moving_Viol.Txt                

Run Frequency:  Weekly

Description:  Weekly moving violations.

Sample File:  Wky-moving-Viol.xls 

Field Name

Field  Description

Comment

Case Number                 

CHAR(9)

 

Created Date            

DATE(8)

Format ccyymmdd

Issue Date               

DATE(8)

Format ccyymmdd

Case Type               

CHAR(1)

Case Type:

 

I = Infraction

M = Mandatory

C = Criminal

Violation

CHAR(20)

 

Violation Description

CHAR(35)

 

Violation Code

CHAR(2)

 

DOB

DATE(8)

Format ccyymmdd

Drl           

CHAR(15)

 

Last Name 

CHAR(30)

 

First Name

CHAR(12)

 

Middle Name

CHAR(12)

 

Address       

CHAR(30)

 

Apt        

CHAR(5)

 

City       

CHAR(15)

 

State      

CHAR(2)

 

Zip        

CHAR(9)

 

 

 

 

Non-Moving Violations File Structure (File Definition)

File Name:  Wky_non_moving_viol.txt         

Run Frequency:  Weekly

Description:  Weekly non-moving violations.

Sample File: Wky-non-moving-viol.xls 

Field Name

Field  Description

Comment

Case Number                 

CHAR(9)

 

Created Date            

DATE(8)

Format ccyymmdd

Issue Date               

DATE(8)

Format ccyymmdd

Case Type               

CHAR(1)

Case Type:

 

I = Infraction

M = Mandatory

C = Criminal

Violation

CHAR(20)

 

Violation Description

CHAR(35)

 

Violation Code

CHAR(2)

 

DOB

DATE(8)

Format ccyymmdd

Drl           

CHAR(15)

 

Last Name 

CHAR(30)

 

First Name

CHAR(12)

 

Middle Name

CHAR(12)

 

Address       

CHAR(30)

 

Apt        

CHAR(5)

 

City       

CHAR(15)

 

State      

CHAR(2)

 

Zip        

CHAR(9)