ELECT_ROLL

#	PeopleSoft Field Name	PeopleSoft Field Type	Database Column Type	Description
1	COMPANY	Character(3)	VARCHAR2(3) NOT NULL	Company Prompt Table: COMPANY_TBL
2	ESTABID	Character(12)	VARCHAR2(12) NOT NULL	Establishment ID Prompt Table: ESTAB_TBL
3	ELECTION_DT	Date(10)	DATE NOT NULL	Election Date
4	ELECTION_TYPE	Character(2)	VARCHAR2(2) NOT NULL	Mandate Type CE=Work Council DP=Staff Representative
5	ELECTION_ROUND	Character(1)	VARCHAR2(1) NOT NULL	Election Round 1=Round 1 2=Round 2
6	ELECTION_GROUP	Character(5)	VARCHAR2(5) NOT NULL	Election Group Prompt Table: ELECTION_GR_TBL
7	ELECTION_ROLL	Character(5)	VARCHAR2(5) NOT NULL	Election Roll Prompt Table: ELECTION_RL_TBL
8	NUM_CANDIDATES	Number(2,0)	SMALLINT NOT NULL	Number of Candidates
9	REGULAR_VOTES	Number(7,0)	INTEGER NOT NULL	Regular Votes Default Value: 0
10	ALTERED_VOTES	Number(7,0)	INTEGER NOT NULL	Altered Votes Default Value: 0
11	INC_VOTES	Number(10,2)	DECIMAL(9,2) NOT NULL	Incumbent Votes Default Value: 0
12	SUB_VOTES	Number(10,2)	DECIMAL(9,2) NOT NULL	Substitute Votes Default Value: 0
13	INCUMBENT_SEATS	Number(3,0)	SMALLINT NOT NULL	Incumbent Seats Default Value: 0
14	INCUMBENT_INDICATO	Number(10,2)	DECIMAL(9,2) NOT NULL	Incumbent Indicator
15	INCUMBENT_RESULT	Number(3,0)	SMALLINT NOT NULL	Incumbent Result
16	SUBSTITUTE_SEATS	Number(3,0)	SMALLINT NOT NULL	Substitute Seats Default Value: 0
17	SUBSTITUTE_INDICAT	Number(10,2)	DECIMAL(9,2) NOT NULL	Substitute Indicator
18	SUBSTITUTE_RESULT	Number(3,0)	SMALLINT NOT NULL	Substitute Result
19	PERCENT_RULE	Character(1)	VARCHAR2(1) NOT NULL	Percent Rule Y/N Table Edit Default Value: N