Department of Highway Safety and Motor Vehicles (DHSMV)

Specifications for loading Department of Highway Safety and Motor Vehicles (DHSMV) into JuryFlex. The data is then used to update the juror master the latest juror inforamtion

Juror File Stage – External Insertion Specification

Target table: juror_file_stage

Notes:

• id is auto-generated by the database.

• source_county_id is the id provided provided by DHSMV as their county identifier.

juror_file_stage 
    ( 
        id               BIGINT NOT NULL IDENTITY, 
        dl_number        VARCHAR(60) , 
        first_name       VARCHAR(60) , 
        middle_name      VARCHAR(60) , 
        last_name        VARCHAR(60) , 
        suffix           VARCHAR(60) , 
        address_1        VARCHAR(60) , 
        address_2        VARCHAR(60) , 
        address_3        VARCHAR(60) , 
        city             VARCHAR(60) , 
        zip              VARCHAR(60) , 
        zip4             VARCHAR(60) , 
        date_of_birth    DATE, 
        race             VARCHAR(60) , 
        sex              VARCHAR(60) , 
        age              VARCHAR(60) , 
        ssn              VARCHAR(60) , 
        state            VARCHAR(60) , 
        prior_dl_number  VARCHAR(60) , 
        source_county_id INT, 
        CONSTRAINT PK_JUROR_FILE_STAGE PRIMARY KEY (id) 
    );