Last Update: July 20, 2015

QueueType

W—Application submitted on your website with a webonlne app with W number

S—suspended app from any other source

Application_Queue_Id

If QueueType is W, this column holds the Web ID associated with the online registration.

If QueueType is S, this column holds the Suspense ID, a unique ID assigned by the database to the suspended record. If the voter is already registered, this is typcially their voter registration ID.

Date_Record_Added

Timestamp when the record was added to the table.

Date_Received

Timestamp when application was submitted on website (for QueueType W only).

Date_Last_Record_Change

Timestamp of last change by Voter Focus to this application record.

Date_Processed

Timestamp indicating when the application was processed into the county database.

Application_Image_Path

This is last column of header information. The following columns contain details on the specific application (RG01).

TransactionIsVoterActivity

Y indicates processing of this suspense record constitutes voter activity.

NvraFormUsed

Y indicates the voter used an NVRA registration application form.

Status

A—

D—

P—

R—

(blank)—

Query to Kara

Reject_Reason

Disposition of the record.

Certificate

Voter registration ID (pre-FVRS).

Operator_Number

User performing the last transaction on the record.

New_Registration

Y indicates the application is for a new voter.

Address_Change

Y indicates the application is for an address change.

Party_Change

Y indicates the application is for a party change.

Name_Change

Y indicates the application is for a name change.

Replacement

Y indicates the voter is requesting a new voter information card.

Signature_Update

Y indicates application was submitted to update voter's signature.

BoxUSCitizen

Y indicates the US citizen box was checked on the application.

BoxNotAFelon

Y indicates the not-a-felon box was checked on the application.

BoxIncapacitated

Y indicates the not-mentally-incapacitated box was checked on the application.

BoxMilitary

Y indicates the military box was checked on the application.

BoxMilitaryDependent

Y indicates the military-dependent box was checked on the application.

BoxOverseasFlag

Y indicates the citizen-residing-outside-US box was checked on the application.

BoxRegistrationFormIsSigned

Y indicates the paper copy of the application contained the voter's signature.

BoxValidRegistrationForm

Y indicates voter applied using a valid form.

BoxLegibleName

Y indicates the Legible Name check box on the application is selected.

VoterIsKnownFelon

Y indicates the application is denied because the applicant is known to be a felon.

FvrsApplicationStatusReasons

The three-character county code of the suspending county followed by text of remarks the county entered when suspending the application. This can be seen in the Comments column in the Suspense Queue.

FvrsErrorCodes

Code from FVRS internal error code table indicating reason why the record was suspended.

FVRSVoterIdNumber

Voter registration ID.

CountyID

Three-character ID of county to which the record is suspended.

Last_Name

Voter name columns.

First_Name

Middle_Name

Name_Style

Birth_Date

Voter date of birth

Last4SSN

Last four digits of voter's social security number

Last4SSNSource

Where the social security number came from.

Driver_License_Number

Voter driver license number

FLDLNumberSource

Source of driver license number:

F—application

H—HSMV

P—Proof of driver license number provided by the voter to an elections official

HSMVOverride

Y indicates the Override DLN/SSN check box on the voter's application is selected.

FLStateIdFlag

Y indicates the ID type on the voter's application is Florida ID.

Residence_Address

Full residence street address

Street_Number

Street_Number_Suffix

Street_Dir

Street_Name

Street_Type

Street_Dir_Suffix

Unit_Type

Apartment_Number

City_State

Zip_Code

Residence_County

Voter's county of residence.

Mailing_Address

Mailing address columns.

Mailing_Address_2

Mailing_Address_3

Mailing_City

Mailing_County

Mailing_State

Mailing_Zip_Code

Mailing_Country

Prior_Address

Voter's previous address.

Prior_Address_2

Prior_Address_3

Prior_City

Prior_County

Prior_State

Prior_Zip_Code

Former_Name

Voter's former name.

Sex

Voter's sex code.

Telephone_Number

Voter's full phone number.

DayTelAreaCode

Area code of voter's daytime phone number.

DayTelPhone

Voter's daytime phone number, less area code.

DayTelExtension

Extension of voter's daytime phone number.

Party

Voter's party code.

Race

Voter's race code.

Birth_Place

Voter's place of birth.

Assistance_Required

Y indicates voter requested assistance with voting.

PW_Interest

Y indicates voter has interest in serving as an election worker.

Email_Address

A column used prior to the decision that email addresses submitted with vote-by-mail requests are not public record.

Voter public email addresses are now stored in the Public_Email_Address column (below).

Registration_Date

Voter's official date of registration, as recorded on FVRS.

AddressProtection

Y indicates voter's address is protected.

RegistrationSource

Code indicating the location where voter registered.

FpcaExpirationDate

Date when voter's FPCA request expires.

Precinct

Voter's precinct ID.

Precinct_Suffix

Voter's precinct-split number.

Precinct_Split

Voter's precinct ID and precinct split number.

District_old_Congressional

Old Congressional district.

DistrictCongressional

US Congressional district.

DistrictSenate

Florida Senate district.

DistrictHouse

Florida House district.

DistrictCommission

County Commission district.

DistrictSchoolBoard

School Board district.

Other_District_Info

Identifier for other district.

PartyChangeReqDate

Date of voter's party-change request.

PhotoIdRequiredToVote

Y indicates voter must show photo ID before voting.

OriginatingCounty

County that suspended the application. If the record is an online registration, this column will be blank.

ThirdPartyAddressSrc

Source of a third-party change to voter's residence address.

Public_Email_Address

Voter's email address as submitted on the registration form. (This email address is public record.)

Sample_Ballots_By_Email

Y indicates voter requested receipt of their sample ballots by email.

Race_Other

The race provided by voters who checked the Other box on the application.

InternalAssignment

Query to Kara.

Application_Image_Path

Batch_Reference

FvrsApplicationProcessStatus

Precinct_Group

These columns are rarely used or are for internal system use only.