VLM Import File Specification - Indiana Secretary of State | 11/2/2014

RFQ # VLM 16-001

Attachment F

Quest SVRS VLM Import File Requirements

Field Name / Field Type / Comments
REGISTRATION_UID / GUID
LOCALITY / varchar(40) / County Name, called Locality in SVRS
FIRST_NAME / varchar(100) / Field Updates 5/27/2014
MIDDLE_NAME / varchar(100)
LAST_NAME / varchar(100)
SUFFIX / varchar(10)
DOB / Date / YYYY-MM-DD
MAIL_FULL_ADDRESS / varchar(255) / These 7 fields are copies of the mailing address fields used to send the card.
MAIL_FULL_ADDRESS_LINE2 / varchar(255)
MAIL_FULL_ADDRESS_LINE3 / varchar(255)
MAIL_CITY / varchar(50)
MAIL_STATE / varchar(30)
MAIL_ZIP / varchar(15)
MAIL_COUNTRY / varchar(50)
MAILER1_RETURN_DISPOSITION / varchar(50) / “Returned Undeliverable/Insufficient Address", Returned Other Status”
MAILER1_USPS_RETURN_DATE / Date / Date USPS returned the card YYYY-MM-DD
MAILER2_RETURN_DISPOSITION / varchar(50) / “Returned Undeliverable/Insufficient Address",“Response Received from Voter”, “Returned Other Status”
, ”No Response by Deadline”
MAILER2_USPS_RETURN_DATE / Date / Date USPS returned the card YYYY-MM-DD
VOTER_RESPONSE_Q1_LISTED_ADDRESS_CURRENT / Bit / 1 or 0 1=yes or 0=no
VOTER_RESPONSE_Q2_MOVED_OUTSIDE_OF_COUNTY / Bit / 1 or 0 1=yes or 0=no
VOTER_RESPONSE_Q3_ADDRESS_CHANGED_WITHIN_COUNTY / Bit / 1 or 0 1=yes or 0=no
VOTER_RESPONSE_NEW_ADDRESSLINE1 / varchar(255) / These 7 address fields show the voter response address correction.
VOTER_RESPONSE_NEW_ADDRESSLINE2 / varchar(255)
VOTER_RESPONSE_NEW_ADDRESSLINE3 / varchar(255)
VOTER_RESPONSE_NEW_CITY / varchar(50)
VOTER_RESPONSE_NEW_STATE / varchar(30)
VOTER_RESPONSE_NEW_ZIP / varchar(15)
VOTER_RESPONSE_NEW_COUNTRY / varchar(50)
VOTER_RESPONSE_NEW_MAILING_ADDRESSLINE1 / varchar(255) / These 7 address fields show the voter response address correction.
VOTER_RESPONSE_NEW_MAILING_ADDRESSLINE2 / varchar(255)
VOTER_RESPONSE_NEW_MAILING_ADDRESSLINE3 / varchar(255)
VOTER_RESPONSE_NEW_MAILING_CITY / varchar(50)
VOTER_RESPONSE_NEW_MAILING_STATE / varchar(30)
VOTER_RESPONSE_NEW_MAILING_ZIP / varchar(15)
VOTER_RESPONSE_NEW_MAILING_COUNTRY / varchar(50)
PROCESSING_FLAG_VOTER_SIGNED_CARD / Bit / 1 or 0 1=yes or 0=no
VOTER_NO_ACTION_NEEDED_FLAG / Bit / 1 or 0 1=yes or 0=no
VOTER_INACTIVATE_FLAG / Bit / 1 or 0 1=yes or 0=no
VOTER_CANCEL_FLAG / Bit / 1 or 0 1=yes or 0=no
VOTER_ADDR_UPDATE_FLAG / Bit / 1 or 0 1=yes or 0=no
VOTER_EXCEPTION_FLAG / Bit / 1 or 0 1=yes or 0=no
RECORD_CREATE_TS / DateTime / Date/Time data file created

VLM Import File Specifications September 17, 2015 Page 1 of 2