District Elections
The District Elections data-table holds data for elections at the District level withinKKFU. It is a linking data-table which links any District in the KKFU database to series of Farmer records.
The District 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.
It can also be used to find things like the phone numbers and contact information for all the Presidents or Secretaries of at the District level 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.
NOTE: The DistrictElections entity was added to KKSys in around 2014, but because IT staff employed at the time left the company it has never been used. It is still available and can start to be used at any time.
How and where to access District Elections data
The image below shows the "DistrictElections" Edit Form. This is accessed via its own entry in the System Entities screen. Records in this tables are children of the Regions entity.
DistrictElections 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. | |
| DateDone (Date) | Self explanitory | Entered by user | |
| DistrictsID (Link-ID) | Links to the Regions table | Selected from list by User | Will default to the currently open Regions ID |
| VoterCount (Number) | Total number of votes cast in the election. | Any number value | Default value: 0 |
| PresidentID (Link-ID) | Links to the Farmers table | Selected from list by User | Dependent lookup list, generated by finding Farmers for the selected District using the Resource: PeopleWithDistrictLUList |
| VicePresidentID (Link-ID) | Links to the Farmers table | Selected from list by User | Dependent lookup list, generated by finding Farmers for the selected District using the Resource: PeopleWithDistrictLUList |
| SecretaryID (Link-ID) | Links to the Farmers table | Selected from list by User | Dependent lookup list, generated by finding Farmers for the selected District using the Resource: PeopleWithDistrictLUList |
| TreasurerID (Link-ID) | Links to the Farmers table | Selected from list by User | Dependent lookup list, generated by finding Farmers for the selected District using the Resource: PeopleWithDistrictLUList |
| ExecMember1ID (Link-ID) | Links to the Farmers table | Selected from list by User | Dependent lookup list, generated by finding Farmers for the selected District using the Resource: PeopleWithDistrictLUList |
| ExecMember2ID (Link-ID) | Links to the Farmers table | Selected from list by User | Dependent lookup list, generated by finding Farmers for the selected District using the Resource: PeopleWithDistrictLUList |
| ExecMember3ID (Link-ID) | Links to the Farmers table | Selected from list by User | Dependent lookup list, generated by finding Farmers for the selected District using the Resource: PeopleWithDistrictLUList |
| OverseeingOfficerID (Link-ID) | Links to the Staff table | Selected from list by User | |
| 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 |