Society Elections
The Society Elections data-table holds data for elections at the Society level within KKFU. It is a linking data-table which links any Society in the KKFU database to series of Farmer records, which are the elected officials for any year,=.
The Society Elections data-table includes data-fields to record the people who have been elected in KKFU Society District Elections. It includes the Position to which they were elected (ie "President", "Treasurer" etc.). This data-table can be used to return reports of the current or past committee members for all of KKFU's Districts. These values are all pulled through from the "ElectionCandidates" data-table.
It can also be used to find things like the phone numbers and contact information for all the Presidents or Secretaries of any series of Societies, 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 Society Elections data
The image below shows the "SocietyElections" Edit Form. This is accessed via its own entry in the System Entities screen. Records in this tables are children of the Regions and Societies entities.
Societies Election 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. | |
| DistrictsID (Link-ID) | Links to the Regions table | Selected from list by User | Custom, Regions, DistrictsLUList |
| SocietiesID (Link-ID) | Links to the Societies table | Selected from list by User | Will default to the currently open Societies ID |
| DateDone (Date) | Self explanitory | Entered by user | |
| MembersCount (Number) | Count of members for voting process, entered by KKFU staff. | Any number value | Default value: 0 |
| PresidentID (Integer) | ReadOnly, value generated by Orixa based on the successful candidate in the "ElectionCandidates" table. | Value generated by Orixa | |
| VicePresidentID (Integer) | ReadOnly, value generated by Orixa based on the successful candidate in the "ElectionCandidates" table. | Value generated by Orixa | |
| SecretaryID (Integer) | ReadOnly, value generated by Orixa based on the successful candidate in the "ElectionCandidates" table. | Value generated by Orixa | |
| TreasurerID (Integer) | ReadOnly, value generated by Orixa based on the successful candidate in the "ElectionCandidates" table. | Value generated by Orixa | |
| RecorderID (Integer) | ReadOnly, value generated by Orixa based on the successful candidate in the "ElectionCandidates" table. | Value generated by Orixa | |
| Delegate1ID (Link-ID) | Links to the Farmers table | Selected from list by User | Dependent, PeopleWithSocietyLUList, SocietiesID, Farmers |
| Delegate2ID (Link-ID) | Links to the Farmers table | Selected from list by User | Dependent, PeopleWithSocietyLUList, SocietiesID, Farmers |
| 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. | |
| Current (true/false) | Untick this field if the record is out-dated, no longer in use or discontinued. | True / false | Default value: true |
| OverseeingOfficerID (Link-ID) | Links to the Staff table | Selected from list by User | |
| ID (Primary Key) | Unique number which identifies each record. | Automatically set by Orixa, not under the control of users or developers. |