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

FAMILY PUBLIC ACCESS FOLDER DESCRIPTION

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

Family 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

 

DAILY FILES

 

Case File Structure (File Definition)

File Name:  Case.exp

Run Frequency:  Daily

Description:  Contains basic case information.  For historical information retention, all case information must be overlapped by the new file where the “case id” or “case number” matches the old one. In other words, a full refresh of the case must be performed by the customer.

Sample File:  Family Case-exp.xls

Field Description

Field Type

Description

Case ID

NUMBER(11)

Unique key of the case (ie. 1654210)

Case Number

CHAR(30)

Local case number (ie. 2007-025360-FC-04)

Filing Date

DATE(10)

Filing date of the case

Style 

CHAR(300)

Style of the case (ie. Ramos Raul vs. Hugh Grant)

Case Type Code

CHAR(20)

Case type code (old action code in SIVA)

Judge Code

CHAR(20)

Judge code of the case (ie. 00182)

Section Code

CHAR(20)

Family section of the case (ie. FC17)

State Case Number

CHAR(30)

State case number

Companion Case

CHAR(30)

Companion case

Disposition Date

DATE(10)

Date case was disposed

 

Docket File Structure (File Definition)

File Name:  Dockets.exp

Run Frequency:  Daily

Description:  Contains list of dockets filed or entered the previous day

Sample File:  Family Dockets-exp.xls

Field Description

Field Type

Description

Event ID

NUMBER(11)

Unique key for a docket

Case ID      

NUMBER(11)

Foreign key to the case

Case Number

CHAR(30)

Local case number (ie. 2007-025360-FC-04)

Event Date

DATE(10)

Docket date

Docket Code

CHAR(20)

Docket code (ie. FJUD)

Description

CHAR(100)

Docket description

Book

CHAR(20)

Recording book number

Page

CHAR(30)

Recording page

Event Type

CHAR(1)

(E=Event, J=Judgment, H=Hearing, S=Service)

 

Party File Structure (File Definition)

File Name:  Parties.exp

Run Frequency:  Daily

Description:   Contains party information for cases filed the previous day, but it may also include parties added to cases the previous day.  Also include parties where the case was updated the previous day.

Sample File:   Family Parties-exp.xls

Field Description

Field Type

Description

Party ID

NUMBER(11)

Unique key for a party in Odyssey

Case ID      

NUMBER(11)

Foreign key to the case

Case Number

CHAR(30)

Local case number (ie. 2007-025360-FC-04)

Party Name

CHAR(180)

Party name (LName, FName MName)

Party Type

CHAR(20)

Party type code (ie. PE=Petitioner RE=Respondent)

Bar Number

CHAR(20)

Attorney bar number

Attorney Name

CHAR(180)

Attorney name of the party (LName, FName MName)

Disposition Code

CHAR(20)

Event code that triggered the disposition

Disposition Date

CHAR(10)

Date case was disposed

Address 1

CHAR (64)

Address line 1

Address 2

CHAR (64)

Address line 2

Address 3

CHAR (64)

Address line 3

Address 4

CHAR (64)

Address line 4

City

CHAR (64)

City

State

CHAR (2)

State abbreviation

Zip

CHAR (10)

Zip Code

 

Case Types Lookup Table File Structure (File Definition)

File Name: CaseType.exp

Run Frequency:  Daily

Description:  Contains the definition of the case type code

Sample File:  Family Case Type-exp.xls 

Field Description

Field Type

Description

Case Type ID

NUMBER(11)

Unique key for a case type in the system

Case Type Code

CHAR(20)

Case type user code (ie. DOM)

Description

CHAR(100)

Case type description

Creation Date

DATE(10)

Creation Date

Obsolete Date

DATE(10)

Obsolete Date

   

Event Types Lookup Table File Structure (File Definition)

File Name: Events.exp

Run Frequency:  Daily

Description:  Contains the definition of the docket/event code.  Information is sorted by Event Definition (E, H, J and S) and Event Type ID. Keep in mind that the “Event Type Code” could be the same among different Event Definitions.

Sample File:  Family Events-exp.xls

Field Description

Field Type

Description

Event Type ID

NUMBER(11)

Unique key for an event type in the system

Event Type Code

CHAR(20)

Event type user code (ie. NOTI, FJUD)

Description

CHAR(100)

Event type description

Creation Date

DATE(10)

Creation Date

Obsolete Date

DATE(10)

Obsolete Date

Event Definition

CHAR(1)

(E=Event, J=Judgment, H=Hearing, S=Service)

  

Judge Section Lookup Table File Structure (File Definition)

File Name: Judges.exp

Run Frequency:  Daily

Description:  Contains the translation of the judicial section to Judge’s Name.  Since the user code is unique for the entire record set (table), developers can match the judge and/or section assigned to a case based on the Judge Code or Section Code fields of the Case table.

Sample File:  Family Judges-exp.xls 

Field Description

Field Type

Description

Judge/Sec ID

NUMBER(11)

Unique key for a judge or section in the system

Judge/Sec Code

CHAR(20)

Judge or Section user code (ie. DOM)

Judge/Sec Description

CHAR(100)

Judge or Section description

Creation Date

DATE(10)

Creation Date

Obsolete Date

DATE(10)

Obsolete Date

 

Party Types Lookup Table File Structure (File Definition)

File Name: PartyType.exp

Run Frequency:  Daily

Description:  Contains the definition of the party types

Sample File: Family Party Type-exp.xls

Field Description

Field Type

Description

Party Type ID

NUMBER(11)

Unique key for a party type in the system

Party Type Code

CHAR(20)

Party type user code (ie. DOM)

Party Type Description

CHAR(100)

Party type description

Creation Date

DATE(10)

Creation Date

Obsolete Date

DATE(10)

Obsolete Date

 

MONTHLY FILES

 

Monthly Probate File Structure (File Definition) 

File Name:  PRMOESTCCYYMM.txt

Run Frequency:  Monthly

Description:  All parties for all probate cases filed the previous month. 

Sample File:  PRMOESTCCYYMM.xls

Field Description

Field Type

Description

Case Number

VARCHAR(30)

Local case number (ie. 2016-000391-CP-02)

Filing Date

DATE(8)

Format CCYY-MM-DD

Case Type Description

VARCHAR(100)

 

Party Type

VARCHAR(100)

 

Party Name - Full

VARCHAR(300)

Party name (LName, FName MName)

Party Name – First Name

VARCHAR(40)

 

Party Name – Last Name

VARCHAR(200)

 

Date of Death

DATE(8)

Format CCYY-MM-DD

Party Address - Street

VARCHAR(144)

 

Party Address - City

VARCHAR(64)

 

Party Address - Street

CHAR(2)

 

Party Address - Zip

VARCHAR(10)

 

Attorney Bar Number For Party

VARCHAR(20)

 

Attorney Full Name

VARCHAR(300)

 

Attorney Address - Street

VARCHAR(266)

 

Attorney Address – City

VARCHAR(64)

 

Attorney Address – State

VARCHAR(2)

 

Attorney Address - Zip

VARCHAR(10)