ELECT_GROUP(SQL Table) |
Index Back |
|---|---|
Election CollegeHas the make up of the election group. Used in Monitor French Elections. |
| # | 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 | VOTERS | Number(7,0) | INTEGER NOT NULL |
Number of Voters
Default Value: 0 |
| 8 | INCUMBENT | Number(3,0) | SMALLINT NOT NULL |
Number of Incumbents
Default Value: 0 |
| 9 | INCUMBENT_RESULT | Number(3,0) | SMALLINT NOT NULL | Incumbent Result |
| 10 | SUBSTITUTE | Number(3,0) | SMALLINT NOT NULL | Number of Substitutes |
| 11 | SUBSTITUTE_RESULT | Number(3,0) | SMALLINT NOT NULL | Substitute Result |
| 12 | REGULAR_VOTES | Number(7,0) | INTEGER NOT NULL |
Regular Votes
Default Value: 0 |
| 13 | ALTERED_VOTES | Number(7,0) | INTEGER NOT NULL |
Altered Votes
Default Value: 0 |
| 14 | BLANK_VOTES | Number(7,0) | INTEGER NOT NULL |
Blank Votes
Default Value: 0 |
| 15 | INVALID_VOTES | Number(7,0) | INTEGER NOT NULL |
Invalid Votes
Default Value: 0 |
| 16 | QUORUM | Character(1) | VARCHAR2(1) NOT NULL |
Quorum
Y/N Table Edit Default Value: N |
| 17 | ELECTION_SEAT_VALU | Number(10,2) | DECIMAL(9,2) NOT NULL |
Seat Value
Default Value: 0 |
| 18 | TURNOUT | Number(5,1) | DECIMAL(4,1) NOT NULL |
Election Turnout
Default Value: 0 |
| 19 | VALIDATED | Character(1) | VARCHAR2(1) NOT NULL |
Election Validated
Y/N Table Edit Default Value: N |