Last Update: August 05, 2015

FvrsVoterIdNumber

FVRS voter registration ID.

Note  Do not rely on this column being populated.

Certificate

Pre-FVRS voter registration ID.

Date_Last_Record_Change

Date and time of last change to column denoted in Audit_Field_Name.

Note  The Date_Last_Record_Change field in the tVaudm table should not be confused with the Date_Last_Record_Change field in the Votrm table.

Time_Last_Record_Change

Unused.

Audit_Field_Name

Name of column being changed:

AbAd1—Vote-by-mail address line 1

AbAd2—Vote-by-mail address line 2

AbAd3—Vote-by-mail address line 3

AbAd4—Vote-by-mail address line 4

AbAd5—Vote-by-mail address line 5

AbElc—Election for vote-by-mail address change

AProt—Address-protection flag

Asist—Assistance-required flag

BDate—Date of birth

BPlce—Birth place

Brnch—Branch site code

CtyZp—Residence city and zip code

DrvLc—Driver license number

Felny—Felony flag (no longer used)

FName—Voter first name

LName—Voter last name

MAdd1—Mailing address line 1

MAdd2—Mailing address line 2

MCity—Mailing city

MCtry—Mailing country

MInit—Voter middle initial

MName—Voter middle name

MrMrs—Mr/ Mrs/Miss (no longer used)

MStat—Mailing state

MZip—Mailing zip code

Name—Name (no longer used)

NStyl—Voter name style

Numbr—Street number and apartment number

Party—Party

PrcOv—Precinct override

Race—Race

Reasn—Holding reason code

RegDt—Registration date

RePrc—Precinct

Sex—Sex

SocSc—Social security number

Stret—Street name

Sttus—Status

Tel—Telephone number

USPS—Mailing city code

Note  When a voter moves into your county, Voter Focus downloads audit activity from FVRS. The Audit_Field_Name is then set to the FVRS voter activity code.

Operator_Number

User making last change.

Audit_NewVal

Current value of the field.

Audit_OldVal

Former value of the field.

CountyId

Current county of residence of voter whose record was changed.