Last Update: January 11, 2016

Elcprcm Table

This is the master table for election-precinct information.

The table is populated for the focused election when a user clicks Assign Ballot Styles to Precincts on the Maintain Election Settings dialog.

Polling-place overrides (temporary polling places) are recorded here. The default polling place for each precinct is in the column Default_PollingPlace in the tPrcm table.

Election_Number	Election number.
Precinct	ID of precinct split voting in election.
Ballot_Style_Dem	Ballot style for each party's voters. Other is minor party 1; Spare is minor party 2.
Ballot_Style_Gen
Ballot_Style_NonP
Ballot_Style_Other
Ballot_Style_Rep
Ballot_Style_Spare
Combine_With_Precinct	The precinct ID of the master precinct that the precinct split in the Precinct column (above) is combined with.
Select_Flag	Unused.
Dem_Books	The number of precinct-register books for each party. Other is minor party 1; Spare is minor party 2.
Rep_Books
Gen_Books
NPA_Books
Spare_Books
Other_Books
Dem_Nbr_Voted	System use only.
Rep_Nbr_Voted
NPT_Nbr_Voted
Spare_Nbr_Voted
Other_Nbr_Voted
Total_Voted
White_Voted
Black_Voted
Other_Race_Voted
Male_Voted
Female_Voted
Not_Voting	Y indicates the precinct split is not voting in the election.
Dem_Eligible	System use only.
Rep_Eligible
NPT_Eligible
Spare_Eligible
Other_Eligible
Total_Eligible
White_Eligible
Black_Eligible
Other_Race_Eligible
Mail_Eligible
Female_Eligible
Advance_Style_Dem	Ballot style of advance ballots for each party preference. Other is minor party 1; Spare is minor party 2.
Advance_Style_Gen
Advance_Style_NonP
Advance_Style_Other
Advance_Style_Rep
Advance_Style_Spare
Hispanic_Voted	System use only.
Hispanic_Eligible	System use only.
DEM_PhoneBank_Desc	Ballot-style descriptions used in PhoneBank program.
REP_PhoneBank_Desc
NPA_PhoneBank_Desc
GEN_PhoneBank_Desc
Other_PhoneBank_Desc
Spare_PhoneBank_Desc
Date_Printed	Jira DOC-36 asks DEV purpose of this column.
Date_Printing_Locked	System use only.
Printing_Lock_User	System use only.
PollingPlace	Polling place where precinct is voting. This is the precinct's normal polling place unless: the precinct has been assigned to a temporary polling place for the election (election override) or the precinct has been combined with another precinct (the master precinct), which automatically moves the precinct to the master precinct's polling place.
EViD_Combine_With_Precinct	Unused.
Gen_Probably_Voting	Y indicates temporary ballots styles are being used for this election. Gen is for general elections. All others are for primary elections.
Dem_Probably_Voting
Rep_Probably_Voting
Other_Probably_Voting
Spare_Probably_Voting