Last Update: July 12, 2016

Database Fields Available for Documents

The fields shown here are available for selection on the Document Maintenance dialog for insertion into a document.

VoterName

Voter's name formatted as Last-Name, First-Name Middle-Name Style-Suffix.

Note  For line printer forms where the maximum length of the string is known, this format is progressively shortened using middle initial, first initial, and finally dropping name style if necessary.

VoterNameLMF

Voter's name formatted as First-Name Middle-Name Last-Name Style-Suffix.

Note  For line printer forms where the maximum length of the string is known, this format is progressively shortened using the middle initial, first initial, and finally dropping name style if necessary.

Address1

Voter's mailing address if available, otherwise the first line of the residence address. Protected addresses are shown.

Address2

If the mailing address is available, the next line is shown, otherwise the city, state, and zip code line of the residence address.

Address3

Third line of the mailing address if available.

Address4

Fourth line of the mailing address if available.

Mail1

First line of the mailing address. Blank if no mailing address.

Mail2

Second line of the mailing address. Blank if no mailing address.

Mail3

Third line of the mailing address. Blank if no mailing address.

MailCtySt

City, state, and zip code of the mailing address. Blank if no mailing address.

MailCityName

Mailing-address city. Blank if no mailing address.

MailState

Mailing-address state. Blank if no mailing address.

MailZip

Mailing-address zip code. Blank if no mailing address.

MailCountry

Mailing-address country. Blank if no mailing address.

Residence

Formatted residence-address line

ResidenceProt

For voters with a protected address, the text ** Protected ** will print in place of the residence address. The address will appear as usual for voters whose address is not protected.

ResCtySt

Formatted residence city and state line.

ResCtyStProt

For voters with a protected address, the text ** Protected ** will print in place of the city and state of the residence address. The city and state will appear as usual for voters whose address is not protected.

ResCounty

Voter's county of residence.

FullResidence

Full one-line residence address including city name, state, and zip code.

USPSCity

USPS city name for residence address.

Party

Party code

PartyName

Party name (up to 40 characters)

Sex

Sex code

Race

Race code

RaceShortDesc

Race short description (W, B, etc)

Regn Code

Registration code

Regn Date

Registration date

BirthDate

Voter's date of birth

BirthPlace

Voter's state or country of birth

Assistance

Prints a Y for voters with Assistance-flag set to Y or an N for voters who do not have the Assistance-flag set

AssistanceX

The value specified in Voter Focus Admin > System Options > VIC Options > Assistance Required Text for Voter ID Cards

AssistanceN

Prints an X if assistance not required

AssistanceY

Prints an X if assistance is required

CongDist

US Congressional district number

FLSenate

Florida Senate seat

FLHouse

Florida House Seat

County

County Commission seat

SchlBrd

School Board seat

Dst-{district}

Seat number for the district

Note  Your database will have multiple fields of this type, one for each district.

DSC-{district}

District type for the district

Note  Your database will have multiple fields of this type, one for each district.

Short-DSC-{district}

Short description for the district

Note  Your database will have multiple fields of this type, one for each district.

Inc-{district}

Incumbent's name

Note  Your database will have multiple fields of this type, one for each district.

IncParty-{district}

Incumbent's party

Note  Your database will have multiple fields of this type, one for each district.

IncCont-{district}

Incumbent's contact information

Note  Your database will have multiple fields of this type, one for each district.

CityCode

City in which voter can vote

CityName

City name for which voter can vote

CityLongName

The full name of the city (20 characters)

CityWard

City ward in which voter can vote

TodaysDate

Date at time of printing

Precinct

Voter's precinct ID

PrecinctPart

Voter's precinct split

Status

Voter's registration status code

StatusDesc

Text description of voter's status code

ReasonCode

Voter's status reason code

ReasonDesc

Text description of voter's status reason code

PrcLocn

Place name of voter's polling place

PrcRegionDesc

Polling place region description

PrcAddress

Street address of voter's polling place

PrcCityStZp

City, state and zip code for voter's polling place

Directions

Directions to voter's polling place

PersonIC

Person in charge at voter's polling place

CntctPsn

Contact person at voter's polling place

WardPlace

City ward place name

WardLocn

City ward place address

WardDirections

City ward directions

CreationDate

Creation date of voter's record

LastActivity

Last activity date of voter

StatusChange

Date the voter status was last changed

BarCode

Prints a bar code on a page printer and MT691 printer

CardReason

Reason for sending voter information card

DenialIncompReason

Reason for denial of registration or reason why registration is considered incomplete

AbsenteeReason

Reason for rejecting mail ballot request

VCrdMsg1 - 16

Voter card message lines 1 through 16 (multiple fields)

ElectionName

Election name

ElectionDate

Date of election

ElectionNumber

Election number

ElectionType

Election type (Primary or General)

BallotStyle

Voter's ballot style for this election

BallotNumber

Ballot number

BallotBarNbr

Ballot bar code number

AbsLabelDataLine

Absentee data line

AbsBarCode

Absentee bar code

PrecWorked

Election worker precinct worked

PrecPlace

Election worker precinct-worked place name

PrecLocn

Election worker precinct-worked address

PrecDirections

Election worker precinct-worked directions

PosnCode

Election worker position code

PosnDescription

Election worker position description

CheckAmtDigits

Election worker payroll check amount in digits

CheckAmtWords

Election worker payroll check amount in text

YTD Amount

Election worker payroll year-to-date pay

PayDesc1 - 6

Election worker payroll description of pay item 1 through 6 (multiple fields)

ReplacesCheck

Election worker payroll check "replaces check 9999999"

LastName

Registration form - voter's last name

FirstName

Registration form - voter's first name

MiddleName

Registration form - voter's middle name

NameStyle

Registration form - voter's name style

ResAddrNoAppt

Registration form - Residence address without apartment number

Apartment

Registration form - voter's apartment number

ResZip

Registration form - voter's zip code

SSN4Digits

Registration form - voter's social security number (last 4 digits only)

SSN9Digits

Voter's social security number (all 9 digits)

NoDsn-NoSSN

Voter claims no driver license or social security number

HomePhone

Voter's home phone number

DriversLicense

Voter's driver license number

<party name>X

Registration form - prints "X" in box for voter's party (Dem, Rep, NPA, or Other)

OtherParty

Registration form - prints name of the other party

Sex<sex name>X

Registration form - prints "X" in box for voter's sex

Race<race name>X

Registration form - prints "X" in box for voter's race

FormerName

Registration form - voter's former name

FormerNameOnly

Registration form - voter's former name (blank if there are entries in the former-address fields)

FormerAddr1 - 3

Registration form - voter's former address lines 1 through 3 (multiple fields)

FormerCity

Registration form - voter's former city

FormerCounty

Registration form - voter's former county of residence

FormerState

Registration form - voter's former state

FormerZip

Registration form - voter's former zip code

CountyName

My county name

PWInterested

Voter is interested in election work

MilitaryX

Prints "X" for military voter

MilitaryDepX

Prints "X" for military-dependent voter

OverseasX

Prints "X" for overseas civilian voter

AbAddress1-5

Vote-by-mail address lines 1 through 5 (multiple fields)

AbsFontBarCode

Vote-by-mail Windows-font bar code

PetAddrNoApt

Petition address change - address line without apartment

PetAddrApt

Petition address change - address line with apartment

PetAddrCityName

Petition address change - city name

PetAddrZip

Petition address change - zip code

PetitionName

Petition address change - petition name

PrvnlTracking

Provisional-ballot tracking number

ProvisionalReason

Reason for provisional ballot

PrvnlTabulated

Provisional ballot tabulated

PrvnlFindings

Provisional-ballot findings

PrvnlRejReason

Reason provisional ballot was rejected

USPSConfirmCode

Bar code for USPS tracking (counties with the USPS Confirm One Interface)

PublicEmailAddress

Voter's email address from the Maint tab of their record

SampleBallotsByEmail

Y if voter wants to receive their sample ballots via email; N if they do not.