Skip to content

Latest commit

 

History

History
85 lines (76 loc) · 3.4 KB

README.md

File metadata and controls

85 lines (76 loc) · 3.4 KB

VINE Data Layouts

Case Record:

CA Case record
locn_code Court’s 4-character location code
court_type court type (D = district, J = justice)
party_num court assigned internal party number
case_num court assigned 9-digit case number
first_name defendant first name
last_name defendant last name
disp_date case disposition date
disp_code case disposition code
bail_amt bail amount set on the case
blank field -- may eventually send the defendants SSN
birth_date defendant’s birth date
race_code race code of the defendant
gender gender of the defendant
disposition descry description of the case disposition code
booking_num booking number of the defendant.

Court Event Record:

CE indicates Court Event Record
locn_code court’s 4-character location code
court_type court type (D = district, J = justice)
party_num court assigned internal party number
case_num court assigned 9-digit case number
first_name defendant first name
last_name defendant last name
appear_date scheduled appearance date
time scheduled appearance time
hearing_code code for the type of hearing
room courtroom
int_case_num courts internal case number
create_datetime datetime the event was scheduled
cancel_datetime datetime the event was cancelled (if not null)
cancel_reason reason for cancellation

Charge Record:

CH indicates Charge Record
locn_code court’s 4-character location code
court_type court type (D = district, J = justice)
party_num court assigned internal party number
case_num court assigned 9-digit case number
viol_code statute code for the violation
severity severity of the violation (F1, MA, etc.)
seq charge sequence on the case
amt_due total fine amount due on the case
jdmt_code disposition of the charge
case_type case type
offense descr description of the charge
viol_datetime datetime of violation (only the date should be considered good)
arrest_date arrest date
jdmt_date date of disposition of the charge
judgment descr description of the disposition of the charge

Calendar Delete Record:

DE indicates a Calendar Delete record (in case clerks delete, rather than just cancel an event)
locn_code court’s 4-character location code
court_type court type (D = district, J = justice)
case_num court assigned 9-digit case number
appear_date appearance date of the event to be deleted
hearing_code hearing code of the event to be deleted.

Judge Record:

JU indicates a judge record. (These are NOT sent to Appriss!!!)
locn_code court’s 4-character location code
court_type court type (D)
party_num court assigned internal party number
case_num court assigned 9-digit case number
appear_date scheduled appearance date
time scheduled appearance time
hearing_code code for the type of hearing
create_datetime datetime the event was scheduled
judge_id court assigned internal judge id
first_name judge first name
last_name judge last name