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
- Case File Structure (File Definition)
- Docket File Structure (File Definition)
- Party File Structure (File Definition)
- Case Types Lookup Table File Structure (File Definition)
- Event Types Lookup Table File Structure (File Definition)
- Judge Section Lookup Table File Structure (File Definition)
- Party Types Lookup Table File Structure (File Definition)
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) |
|