Last Update: August 03, 2015 |
This is the master table for information on the elections in your system.
Election_Number |
Election number. |
Election_Date |
Date of the election. |
Election_Name |
Election name. |
City_Code |
For elections prior to the Voter Focus release 2014, this column was the city code where Election_Type = C. From release 2014 going forward, this column is not used. |
Mail_Ballot |
Y indicates election is mail-ballot-only election. |
CVF_Election_Type |
Election classification: 1—First primary 2—Second primary P—Presidential preference primary G—General election O—All other elections including local, city, and special elections |
Books_Closing_Date |
Date of election's book closing. |
Abs_Ballots_Used |
Y indicates vote-by-mail ballots are used in election. |
Adv_Ballots_Used |
Y indicates advance ballots are used in election. |
Next_Candidate_Number |
System use only. |
Next_Ballot_Style_Number |
System use only. |
Abs_Election_Status |
O—Open A—Active R—Return processing only C—Closed D—Deleted |
The following five columns are used for summary reporting but are not guaranteed to be completely accurate. The system counts transactions when complete accuracy is required. |
|
Abs_Ballots_Mailed |
Number of vote-by-mail ballots sent out. |
Abs_Ballots_Requested |
Number of vote-by-mail ballots requested. |
Abs_Ballots_Returned |
Number of vote-by-mail ballots returned. |
Abs_Ballots_Replaced |
Number of vote-by-mail ballots replaced. |
Abs_Ballots_Cancelled |
Number of vote-by-mail requests cancelled. |
Total_Counter_Votes |
Unused. |
Adv_Ballots_Mailed |
|
Adv_Ballots_Returned |
|
Both_Adv_Abs_Returned |
|
Mil_Abs_Ballots_Mailed |
|
Mil_Abs_Ballots_Requested |
|
Mil_Abs_Ballots_Returned |
|
Mil_Abs_Ballots_Replaced |
|
Mil_Total_Counter_Votes |
|
Mil_Abs_Ballots_Cancelled |
|
Mil_Adv_Ballots_Mailed |
|
Mil_Adv_Ballots_Returned |
|
Mil_Both_Adv_Abs_Returned |
|
Next_Cand_Req_Number |
System use only. |
Lines_per_register_page |
Number of lines per page on precinct registers: either 12 or 18. |
Register_Generation_Date |
Date the precinct register was last generated (not including supplements) for election. |
History_Update_Date |
Date the Voting History Update was last run for election. |
CVDB_Hist_Update_Date |
Unused. |
Supplement_Generation_Date |
Date of last precinct register supplement generation. |
Early_Voting_Start |
Date early voting starts. |
Early_Voting_End |
Date early voting ends. |
FvrsElectionNumber |
FVRS election number. |
FvrsElectionType |
Unused. |
EViD_Processing_Started |
Unused. |
DateLastFPCACheck |
System use only. (Enforces FPCA vote-by-mail request generation only once per day.) |
EvidEarlyGenerationDate |
Unused. |
EViDExportDBDate |
System use only (for EViD support). |
FederalElectionsBallotStyle |
Ballot style assigned to voters whose Fed Elections Only check box is selected. |
OtherStyleParty |
For primary elections, identifies the party occupying the first of two minority party slots in the system. |
SpareStyleParty |
For primary elections, identifies the party occupying the second of two minority party slots in the system. |
PWLockPayModeV |
Y indicates that changes affecting election-worker payroll for this election cannot be made. (Election is locked for payroll purposes.) |
VH03_Creation_Date |
System use only. |
VotingCenters |
Unused. |
Sending_Sample_Ballots |
JIRA Doc-36 asks Dev what is purpose of this column. |