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 ** prints in place of the residence address. The address appears 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 ** prints in place of the city and state of the residence address. The city and state appears 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 the voter can vote.

CityName

City name for which the voter can vote.

CityLongName

The full name of the city (20 characters).

CityWard

City ward in which the 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 the voter's status code.

ReasonCode

Voter's status reason code.

ReasonDesc

Text description of the voter's status reason code.

PrcLocn

Place name of the voter's polling place.

PrcRegionDesc

Polling place region description.

PrcAddress

Street address of a voter's polling place.

PrcCityStZp

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

Directions

Directions to the voter's polling place.

PersonIC

Person in charge at the voter's polling place.

CntctPsn

Contact person at the voter's polling place.

WardPlace

City ward place name.

WardLocn

City ward place address.

WardDirections

City ward directions.

CreationDate

Creation date of the voter's record.

LastActivity

Last activity date of the 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 workerprecinct 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

Your county name.

PWInterested

Voter is interested in election work.

MilitaryX

Prints "X" for military voters.

MilitaryDepX

Prints "X" for military dependent voters.

OverseasX

Prints "X" for overseas voter civilian voters.

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 accepted.

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 the voter wants to receive their sample ballots via email; N if they do not.