Last Update: August 03, 2015

Vtrcomm Table

This table holds information about communications to and from voters.

Certificate

Voter registration ID.

Commn_Number

Unique, system-assigned number for the communication.

Commn_Date

Timestamp of communication.

In_or_Out

Whether the communication was incoming or outgoing:

I—Incoming

O—Outgoing

Commn_Type

Communication type code from the Comresl table.

Commn_Comments

Comments, 255 characters of text.

Commn_Path

For communications with images only. The network path to the image file.

Commn_Image_Type

For communications with images only. G indicates an image is associated with the communication.

Commn_Feed_Code

For communications with images only. The value in the Feed Code field on the Image Batch Selection dialog when the image was indexed, indicating the rotation of the image.

Operator_Number

User creating or recording communication.

Commn_Clip_Code

For communications with images only. Clip code used when voter's signature was clipped from larger image.

SigXPos

For communications with images only. Position of voter's signature clip on the larger image.

X and Y—X and Y positions of top-left corner.

X2 and Y2—X and Y positions of bottom-right corner.

SigYPos

SigX2Pos

SigY2Pos

CountyId

Voter's county of residence when the communication occurred.

Note  Activity is copied into the local database when a voter moves into the county.

Address1

Address to which outgoing communication was sent.

Address2

Address3

AddressCity

AddressState

AddressZip

AddressCountry

FvrsContactNumber

FVRS number assigned to communication.

AddressType

Address used for the outgoing communication.

M—Mailing address

R—Residence address

T—Temporary address entered at the time the communication was sent.

VoterActivityFlag

Communication is considered "voter activity."

FvrsNotificationNumber

FVRS notification number authorizing the communication.

Note  Not all communications are authorized by FVRS. Communications can also be created by local county users.

FvrsContactType

FVRS contact type assigned to communication.

FvrsImageNumber

Number assigned to image associated with communication.

FvrsImageConvertedFlag

Unused.

UndeliverableDate

Date when undeliverable mail was recorded in voter record.