Bureau of Vital Statistics (BVS)

Specifications for loading Bureau of Vital Statistics (BVS) into JuryFlex. The data is then used to update the juror master and excuse jurors who are deceased.

Juror Deceased Stage – External Insertion Specification

Target table: juror_deceased_stage

Notes:

• id is auto-generated by the database.

• matched should be set to 0 (zero) or false

• source_county_id is the id provided provided by BVS as the county identifier

juror_deceased_stage 
    ( 
        id               BIGINT NOT NULL IDENTITY, 
        first_name       VARCHAR(15) , 
        middle_name      VARCHAR(15) , 
        last_name        VARCHAR(15) , 
        suffix           VARCHAR(3) , 
        gender_code      VARCHAR(1) , 
        race_code        VARCHAR(1) , 
        ssn              VARCHAR(9) , 
        date_of_death    DATE, 
        date_of_birth    DATE, 
        age_years        INT, 
        address          VARCHAR(30) , 
        city             VARCHAR(20) , 
        zip              VARCHAR(5) , 
        matched          BIT, 
        source_county_id INT NOT NULL, 
        CONSTRAINT PK_JUROR_DECEASED_STAGE PRIMARY KEY (id) 
    );