Last Update: August 07, 2015 |
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.
Addresses_and_Other_Contact_Information
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. |
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 |
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. |
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. |
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. |
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. |
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_Path |
Unused. |
Signature_Feed_Code |
Unused. |
Signature_Clip_Code |
Clip code used when signature was clipped from larger image. |
FvrsSigConvertedFlag |
Unused. |
FvrsSigImageNumber |
Unused. |
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. |