Show 

Last Update: August 07, 2015

Votrm Table

Votrm is the master table for voter registration of all voters in the county and those previously registered in the county.

Queries against the Votrm table can be run and saved in the FlexRep program. See How to Fine-Tune Your Selection Criteria for FlexRep Outputs.

The columns described here are those a county user might use in reporting activities. Because there are so many columns, we have grouped related columns together under the following headings, rather than listing them in the exact order in which they appear in the database table.

General_Information_on_Voter

Addresses_and_Other_Contact_Information

Precinct_and_Districts

Vote-by-Mail

Transaction_Information

Voting_History

Eligibility_Maintenance

Signature_Images

Miscellaneous

 

General Information on Voter

Certificate

Pre-FVRS voter registration ID.

Note  This is not normally visible but is the internal number. It can be seen in the Pre-FVRS Regn Number field on the Activity tab in the voter's record.

FVRSVoterIdNumber

FVRS voter registration ID.

Note  For voters who registered or moved into the county after Jan. 1, 2006, FvrsVoterIdNumber and Certificate are the same.

Registration_Code

Source of most recent voter registration application.

County_Of_Residence

Voter's current county.

CountyVoterRegistrationId

Unused.

Voter_Name

Voter name in the format Last, First Middleinitial.

Last_Name

Voter last name.

Middle_Name

Voter middle name.

Middle_Initial

Voter middle initial, automatically derived from the letter(s) of name(s) in Middle_Name column.

First_Name

Voter first name.

Name_Style

SR, JR, III, etc.

Last_Name_Normalized

System use only.

First_Name_Normalized

System use only.

Birth_Date

Voter date of birth.

Driver_License_Number

Driver license number.

FLDLNumberSource

Source of driver-license number:

F—Application form

H—HSMV

P—Proof of driver license provided by voter to elections official.

FLDLNumberVerified

Y indicates voter's driver license was verified by HSMW.

FLStateIDFlag

Y indicates the voter's ID verified by HSMV is a Florida ID rather than a driver license.

Soc_Sec_Num

Social Security Number. Often contains only the last four digits. Remaining positions are space- or underscore-filled.

Last4SSN

Last four digits of Social Security Number.

Last4SSNSource

Source of last four digits of Social Security Number:

F—Application form

H—HSMV

P—Proof of Social Security Number provided by voter to elections official.

Last4SSNVerified

Y indicates last four digits of voter's Social Security Number was reported by HSMV as verified.

SocSecNumSource

Source of Social Security Number:

F—Application form

H—HSMV

P—Proof of Social Security Number provided by voter to elections official.

SocSecNumVerified

Y indicates voter's Social Security Number was reported by HSMV as verified.

HSMVVerifiedStatus

System use only.

HSMVVerifiedDate

HSMVDateSent

HSMVDateReturned

HSMVVerifiedType

HSMVOverride

Y indicates voter ID could not be verified by HSMV but Supervisor decided to accept it anyway.

VoterClaimsNoSSNorDLN

Voter marked box on application claiming no driver license, Florida ID, or Social Security Number.

Assistance_Required

Y indicates voter needs assistance with voting.

Note  This column is for voters needing assistance at voting sites. For voters needing assistance at assisted living and similar facilities, the column is Supervised_Voting.

Sex

Voter's sex:

M—Male

F—Female

U—Unknown

Race

Voter's race code, from the Racel table.

RaceOther

Text written by voter on application along with selecting Other as their race.

Party

Voter's party code, from the Partyl table.

Last_Party

If the voter's party changed, their party prior to the change.

Note  See also Last_Party_Change_Date, below.

Next_Party

If a party change is currently deferred, voter's new party after party change takes effect.

Note  See also Next_Party_Effective_Date, below.

Birth_Place

Place of birth.

Status

Voter registration status.

Note  See Voter Status Codes and Associated Reason Codes for the possible values in this column.

Holding_Reason_Code

Reason code associated with voter registration status.

Note  See Voter Status Codes and Associated Reason Codes for the possible values in this column.

ID_Required_to_Vote

Y indicates that voter who has not yet provided a photo ID to Supervisor.

PhotoIdSeenByOfficial

Y indicates the ID Seen field is selected on voter's application dialog, indicating the photo ID was presented to an elections official.

PhotoIdType

Code indicating the type of photo ID presented to elections officials.

FederalElectionsOnly

Y indicates FedElections Only check box is selected on Maint tab in voter's record.

ReviewMemosFlag

The See Comments check box is selected on Maint tab of voter's record.

Voter_Card_Requested

Voter information card is scheduled for voter in Notices Queue.

Voter_Card_Reason_Code

One-digit code from Vtrcdrsn table denoting reason voter information card was scheduled.

Voter_Label_Requested

Voter label is scheduled for voter in Notices Queue.

Addresses and Other Contact Information

Address_Protect

Y indicates Addr Protect? check box is selected on Maint tab in voter's record indicating voter residence address is exempt from public records requests.

Address_Confirmation_Flag

Unused.

Streetix_ref

Pointer to column in Streetm table holding unique ID for voter's street segment. If value is zero, there is no valid connection to Streetm.

Street_Number

Individual components of voter's residence address.

Note  The residence address columns will show protected addresses, so when producing reports, use the column Residence_Address instead. The Residence_Address column fully formats the address but does not reveal protected addresses.

Note  The column USPS_City is interpreted in the table Mctycdel.

Street_Number_Suffix

Street_Dir

Street_Name

Street_Type

Street_Dir_Suffix

Unit_type

Apartment_Number

USPS_City

USPS_City_Name

Zip_Code

Residence_Address

Voter's residence address. Protected addresses are not shown; instead they are indicated by ** Protected **.

Data in this column is formatted and spaced for reporting purposes.

Formatted_Address

First three lines of voter's mailing address. If the voter has no mailing address, the value here will be the same as in the column Residence_Address.

Data in this column is formatted and spaced for reporting purposes.

Mail_Only_To_Mailing_Addr

Y indicates that no mail delivery is possible to the residence address, so the mailing address must be used for all correspondence with voter. (See No_Residence_Delivery column in Streetm table.)

Carrier_Route

Unused.

Mailing_Address_Flag

Y indicates voter has a mailing address.

Mailing_Address_1

Individual components of voter mailing address.

Mailing_Address_2

Mailing_Address_3

Mailing_City

Mailing_Zip

Mailing_State

Mailing_Country

Mailing_County

Unused.

City_State

City and two-character state fields from voter's mailing address. If the voter has no mailing address, the city and state from their residence address.

Data in this column is formatted and spaced for reporting purposes.

Zip_Country

Zip code and country from voter's mailing address. If the voter has no mailing address, the zip code from their residence address.

Data in this column is formatted and spaced for reporting purposes.

Email_Address

Voter email address on Vote-by-Mail tab of their record.

Note  This email address is exempt from public records requests.

Public_Email_Address

Voter email address on Maint tab of their record.

Note  This email address is not exempt from public records requests.

Sample_Ballots_By_Email

Y indicates the Receive Sample Ballots by Email check box is selected on Maint tab of voter's record.

Telephone_Number

Individual components of voter's phone number.

DayTimeAreaCode

DayTimePhoneExtension

Precinct and Districts

Precinct

Precinct split to which voter is assigned.

PrecinctSuffix

Unused.

PrecinctGroup

Unused.

PrecinctSplit

This shows the precinct split for the voter's residence address.

Note  If the voter's precinct has been overridden, this value will be different from the value in the Precinct column.

Precinct_Override

Y indicates precinct split in Precinct column is not the precinct for voter's residential street segment because the voter's precinct has been overridden.

House_District

Florida House district assigned to voter's precinct.

Senate_District

Florida Senate district assigned to voter's precinct.

Commission_District

County commission district assigned to voter's precinct.

School_Board_District

School board district assigned to voter's precinct.

Federal_House_District

US congressional district assigned to voter's precinct.

Other_District_Info

Other district assignments for voter's precinct, separated by commas.

District_old_Congressional

Used for petition verification after statutory redistricting.

City_Code

City-district code. A zero indicates voter does not live within a city-district boundary. Links to Citycdel table.

City_Ward

City-ward-district code. Links to Citywrdl table.

City_Name

Name of city district.

Vote-by-Mail

Absentee_Status

Value in Vote-by-Mail Status field on Vote-by-Mail tab of voter's record.

P—Permanent

T—Temporary

C—Cancelled

F—FPCA

blank—no status selected

Abs_Mil_Civ

State of Military check box on voter's Vote-by-Mail tab:

M—Military check box is selected.

C or space—Civilian, i.e., Military check box not selected.

MilitaryDependent

Y indicates Mil Dep check box on Vote-by-Mail tab is selected, indicating voter is a military dependent. Voter is normally included with Military voters for statistical purposes.

Absentee_Comment

Value from Comment field on Vote-by-Mail tab.

Permanent_Abs_Req_Expiry

For FPCA and all-elections voters, the date the FPCA/all-elections request expires/expired.

FPCA_Delivery_Method

The default delivery method for FPCA/all-elections requests. If a voter does not have an FPCA or all-elections request, the value is 1.

1—Mail

6—Fax

8—Email

Overseas_Voter_Flag

Y indicates the Default Ballot Address or mailing address is an overseas address.

DomesticOutOfCountyFlag

Y indicates a military voter who resides outside the county but not overseas. (Therefore vote-by-mail ballots to the voter are not UOCAVA.)

Supervised_Voter

Y indicates voter has requested supervised voting of their mail ballots.

Note  This column is for voters needing assistance at assisted living and similar facilities. For voters needing assistance at voting sites, the column is Assistance_Required.

Absentee_Suspect

Unused.

Transaction Information

Date_Last_Card_Requested

Date of most recent printing of voter information card.

Operator_Number

User making last change to voter's record.

Date_Last_Record_Change

Timestamp of last change to voter's record.

Last_Date_Status_Changed

Timestamp of last change to voter's registration status.

Date_Record_Added

Date when voter was added to local county system.

Registration_Date

Date voter was registered in Florida.

Date_Last_Voted

Date voter was last recorded as voting in Florida.

Last_Voter_Activity_Date

Date of last voter activity (as defined by NVRA).

Last_Party_Change_Date

Date of last party change. For new registrations this field is NULL. It contains a useful value only if the voter has changed party registrations after initial registration.

Note  See also Last_Party, above.

Next_Party_Effective_Date

Date when deferred party change becomes effective.

Note  See also Next_Party, above.

LastInactiveDate

Date when voter's status changed from Active to Inactive.

LastRemovedDate

Unused.

Last_County_Change_Date

Last date when the voter's registration moved from one county to another.

Last_Address_Notice_Sent_Date

Date when last Address Confirmation Request was sent to voter.

Last_Final_Notice_Sent_Date

Date when last Final Notice was sent to voter.

FVRS_Record_Added_Date

Date when voter record was first added to FVRS.

FVRS_Last_Record_Change_Date

The last time the voter record on FVRS was changed. This is the authoritative record-version identifier.

OriginalRegistrationDate

Unused.

OriginatingCounty

County where voter was first registered in Florida.

Last_Transaction

Unused.

Date_Last_NCOA_Processed

Date NCOA vendor data was last processed against the voter's record.

LastNcoaMoveEffectiveDate

Obtained from the spreadsheet file containing NCOA vendor's data. Used to prevent import of old NCOA data over a newer NCOA file.

SuspenseIDNumber

Unused.

SuspenseRoutingCounty

Unused.

Voting History

VotingHist_ThisYear

Number of times voter voted in current calendar year.

VotingHist_LastYear

Number of times voter voted in last calendar year.

VotingHist_Ago2Yrs

Number of times voter voted in calendar year before last.

VotingHist_Ago3Yrs

Number of times voter voted in calendar year two years before last.

VotingHist_Rolled_Year

The year in which the above fields were last rolled forward. If not set to the current year, the above fields require rolling.

Eligibility Maintenance

Felony

Unused.

Duplicate_Suspect

Used as a temporary flag for the report Alpha List of Voters for Election.

AdminHearingType

Unused.

AdminHearingDate

AdminHearingPlace

AdminHearingStatus

AdminHearingStatusLastChange

IDS_Error_Codes

FVRS error codes indicating reason for incomplete and/or denied applications.

Signature Images

Signature_Path

Unused.

Signature_Feed_Code

Unused.

Signature_Clip_Code

Clip code used when signature was clipped from larger image.

FvrsSigConvertedFlag

Unused.

FvrsSigImageNumber

Unused.

Miscellaneous

Located

Used by Maptitude for interfacing.

TransactionType

Unused.

FvrsStoreErrorNumber

Unused.

SendRG45ToFVRS

System use only.

Next_Commn_Number

Unused.

Last_Card_Commn_Number

Unused.

NewField

Unused.