Last Update: July 21, 2015 |
This table is intended to hold outstanding notices for printing for a relatively short time—about two months—to allow for reprinting if the need arises. Records printed more than two months ago should be removed by running the Monthly Database Cleanup program. Printing a notice creates a record in the Vtrcomm table, which is the audit trail for outputs to the voter.
Certificate |
Pre-FVRS voter ID. |
Notice_Date |
Timestamp when notice was scheduled in the Notices Queue. |
Notice_Type |
Notice type, as defined in Document Maintenance. |
Notice_Reason |
If the notice is a voter information card, the reason it was scheduled: 1—New voter registration 2—Replacement voter card 3—Change of address 4—Change of party 5—Change of name 6—Redistricting-Change of precinct 7—New voter-Blank party 8—Returned mail-Change of address 9—Printed through FlexRep 10—Activated 18-year-old 11—Change of polling place 12—Third-party address change This column also stores reason codes for incomplete and denial notices. |
Notice_Printed |
Y indicates the notice has been printed. |
Notice_Right_Now |
Jira DOC-36 ask Dev what is purpose of this column. |
Operator_Number |
User who scheduled notice. |
Notice_Date_Printed |
Timestamp when notice was printed. |
Notices_Sequence |
Sequence of printing (for reprinting purposes). |
Printer_Zone |
Printer zone to which notice is assigned. |
Address1 |
The address to which the notice was sent (for reprinting purposes). |
Address2 |
|
Address3 |
|
AddressCity |
|
AddressState |
|
AddressZip |
|
AddressCountry |
|
AddressType |
M—Mailing R—Residence |
FvrsNotificationNumber |
For notices scheduled by FVRS, the FVRS instruction to schedule the notice. Used to report back to FVRS accurately. |
IDErrorcodes |
FVRS error code indicating reason for incomplete and denial notices. |
FvrsContactType |
FVRS contact type for reporting back to FVRS |
Election_Number |
Election number when a notice is related to a specific election. |
Notices_Id |
System-assigned unique ID for the row in this table. |
Override_Address1 |
System use only (to send notice to address not held in voter record). |
Override_Address2 |
|
Override_Address3 |
|
Override_AddressCity |
|
Override_AddressState |
|
Override_AddressZip |
|
Override_AddressCountry |