Election Candidates
Purpose
The ElectionCandidates data-table holds data for people who have stood for election to KKFU Societies. It is a linking data-table which links any Person in the KKFU database to a SocietiesElections record.
The ElectionCandidates data-table includes data-fields to record the people who have stood for election in KKFU Society Elections. It includes the Position to which they were elected (ie "Chair", "Treasurer" etc.) and the number of votes they received. This data-table can be used to return reports of the current or past committee members for all of KKFU's Societies.
It can also be used to find things like the phone numbers and contact information for all the Chair's or Secretaries of a Society or Zone, provided that the data is kept up-to-date.
A full listing of all the fields in the data-table with their purposes and any automation built into the App is laid out below. To fully understand the purpose of the data-fields please consult this.
How and where to access ElectionCandidates data
The image below shows the "ElectionCandidates" Edit Form. This is accessed via its own entry in the System Entities screen. ElectionCandidates are a child of the SocietyElections and People entities.
Election Candidates edit form
Note that the layout of this edit form may have changed if it has been updated by your administrator, and additional actions, reports or resources may have been added.
Data-schema: full details of the data-fields and their purpose in the data-table
Field- Name / Data-type |
Description / Purpose |
Possible Values |
Coding / Automation |
|---|---|---|---|
| ID (Primary Key) | Unique number which identifies each record. | Automatically set by Orixa, not under the control of users or developers. | |
| SocietyElectionsID (Link-ID) | Links to the SocietyElections table | Selected from list by User | Will default to the currently open SocietyElections ID |
| CandidatesID (Link-ID) | Links to the People table | Selected from list by User | Dependent, ElectionCandidatesDependentLUList, SocietyElectionsID, Farmers |
| ElectionPositionID (Link-ID) | Links to the Types table | Pick from list of possible Types values such as President, Vice President, Treasuer etc. | |
| NumberOfVotes (Number) | Self explanitory | Any number value | Default value: 0 |
| DateCreated (Timestamp) | Set to the exact date and time the record was first created. | Automatically set by Orixa, not under the control of users or developers. |
Data relationships of the ElectionCandidates BusinessObject
ElectionCandidates entity relationships
- Societies links to SocietyElections, allowing all elections which occur in KKFU societies to be recorded. The table is automatically populated with values for the Secretary, Treasurer and Recorder, based on the results recorded in the ElectionCandidates data-table.
- SocietyElections link to ElectionCandidates, allowing the results of all elections (including the number of votes cast) to be recorded for all elections.
- Farmers link to ElectionCandidates, so only farmers who are registered with KKFU are able to stand for elections. This helps to ensure that farmers are current members, have paid their dues, and so on, prior to standing for election.