Last Update: July 21, 2015 |
This table holds information on petitions.
Petition_Number |
Petition number. |
Petition_Batch_Number |
Petition batch number. |
Petition_Short_Desc |
Short description of the petition. |
Petition_Id |
Petition ID. |
Petition_Type |
Cand—Candidate petition Initiative—Initiative petition |
District_Type |
District type. |
District_Number |
District number for petition. |
Party |
Unused. |
Petition_Description |
Full description of the petition. |
Date_Petition_Opened |
Date the petition was created on the system, In the case of Candidate petitions, this should be the candidate-filing date. |
Date_Petition_Closed |
Date petition closed. |
Number_Signatures_Claimed |
Number of signatures claimed. |
Number_of_Signatures_Req |
Number of signatures required. |
Number_of_Sigs_checked |
Number of signatures checked. |
Total_Signatures_Accepted |
Total valid signatures. |
Total_Signatures_Rejected |
Total unknown voters. |
Total_Duplicate_Sigs |
Total duplicate signatures. |
City_Ward |
City-ward district for city candidate petitions. |
FvrsPetitionNumber |
FVRS petition reference number. |
Petition_subBatch |
Jira DOC-36 asking how one assigns a sub-batch. |
SpareStyleParty |
Jira DOC-36 asking how this field is used. |
Date_Batch_Certified |
Timestamp when petition totals for the batch were certified by running the Certify Petition Totals program. |
Date_Treasurer_Appt_Filed |
Date of filing of the form for Appointment of Campaign Treasurer and Designation of Campaign Depository. |