People
Purpose
The People data-table holds data for people, farmers, and staff KKFU work with. It is a master data-table which links to other data-tables: Farmers and Staff. Each Person record includes a "SocietiesID" to link the record to the main data-entities of KKSys.
The People data-table includes data-fields for the basic descriptions of a person at the most simple level: data-fields such as "FirstName" and "DateOfBirth." More complex fields are generally added to the linked data-tables Farmers and Staff so avoid duplication.
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 People data
The image below shows the "People" Edit Form. This is accessed via its own entry in the System Entities screen. People are a child of the Societies entity.
KKSys People 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 FarmFields 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. | |
| TitleID (Link-ID) | Links to the Types table | Pick from list of possible Types values such as Mr, Ms, Mrs, Dr. | |
| FirstName (Text) | Self explanitory | Entered by user | |
| NickName (Text) | Optional | Entered by user | |
| LastName (Text) | Self explanitory | Entered by user | |
| SocietiesID (Link-ID) | Links to the Societies table | Selected from list by User | Will default to the currently open Societies ID |
| DateOfBirth (Date) | Self explanitory | Entered by user | |
| PersonTypeID (Link-ID) | Links to the Types table | Pick from list of possible Types values such as Farmer, Committee Member. | |
| GenderID (Link-ID) | Links to the Types table | Pick from list of possible Types values such as Male, Female. | |
| IDCardTypeID (Link-ID) | Links to the Types table | Pick from list of possible Types values such as Ghana Card, Passport Number. | |
| IDCardNumber (Text) | Self explanitory | Entered by user | |
| PhoneNumbers (Text) | ReadOnly, value generated by Orixa based on data entered in the Phones data table. | Value generated by Orixa | |
| 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 | |
| FullName (Text) | Read-Only, computed by Orixa, based on values in the database. | Value generated by Orixa | |
| AuthorID (Integer) | Automatically set by Orixa, not under the control of users or developers. |