Farmers
Purpose
The Farmers data-table holds data for farmers KKFU work with. It is an extension data-table which links to other data-tables: Each Farmers record shares the same "ID" value as the linked "Person" record.
The Farmers data-table includes data-fields for the data unique to any farmer which KKFU needs to collect and store, such as their KKIDNum, Date of Joining the Co-op, whether they have paid membership dues, etc.
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 Farmer data
The image below shows the "People" Edit Form, with the "Farmers data" page visible. This is accessed via its own entry in the System Entities screen. People are children of the Societies entity.
Farmers 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.
Linkages to the Farmers Entity
Linkages to the Farmers Entity
From the Farmers Entity it is possible to see lists of linked data, and add linked data. The image above shows the "New Items" menu open in the Farmers edit-form, with the linked data that can be added.
- Farmers can link to all the entities shown: Caretakers, Inspections, CoopTransations and many more. In many cases these linkages are coupled with a Linkage to the Societies entity, so individual records relate to the farmer as well.
- The Societies entity is automatically linked to several "base entities" which are part of the Orixa framework, to allow storage of data such as Addresses, Phone-numbers and so on.
- The Societies entity is linked to the Images system, so if needed photos of the society or its membership can be added to the database.
Data-schema: full details of the data-fields and their purpose in the Farmer 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. | |
| KKIDNum (Text) | Self explanitory | Computed by Orixa, but can be updated by user. | ReadOnly, 30 Default value: NewKKIDNum(ID) |
| PassbookNum (Text) | Self explanitory | Entered by user | |
| DateJoined (Date) | Self explanitory | Entered by user | |
| UTZCertComplying (true/false) | Self explanitory | True / false | Default value: false |
| CertificationIDList (Text) | List of certifications such as UTZ, Organic, Fairtrade to which the farmer complies. | Entered by user | ID-List: Allows users to select one or more items from a list stored in the Types data-table. |
| DateJoinedUTZ (Date) | Self explanitory | Entered by user | |
| CaretakerCount (Integer) | ReadOnly, value generated by Orixa from the number of Caretaker records added for this farmer. | Value generated by Orixa | |
| CoopMember (true/false) | Self explanitory | True / false | Default value: false |
| DateJoinedCoop (Date) | Self explanitory | Entered by user | |
| OldKKIDNum (Text) | ReadOnly, value generated by Orixa | Value generated by Orixa | |
| FarmMapped (true/false) | Self explanitory | True / false | Default value: false |
| 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 |