Last Update: August 03, 2015 |
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. |