Inspections
Purpose
The Inspections data-table holds data for inspections of farmers, carried out by KKFU Field Officers. It is a data-table which links to other data-tables: Societies, Farmers and Staff. Each Person record includes a "SocietiesID" to link the record to the main data-entities of KKSys.
The Inspections data-table includes data-fields gathered during inspections of farmers such as "CountPermanentWorkers", "TotalNumPlots" 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.
Note: The Inspections data-table is not in use at present in KKSys. It was added during an earlier development process, and then never used. The fields present in the entity may not be those that KKFU really need. The data structure of this table may need to be extended and changed to meet KKFU's current needs.
How and where to access Inspections data
The image below shows the "Inspections" Edit Form. This is accessed via its own entry in the System Entities screen. Inspections are a child of the Farmers and Societies entities.
Inspections 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. | |
| SocietiesID (Link-ID) | Links to the Societies table | Selected from list by User | Will default to the currently open Societies ID |
| FarmersID (Link-ID) | Links to the Farmers table | Selected from list by User | Will default to the currently open Farmers ID |
| DateDone (Date) | Self explanitory | User can edit default value if necessary | Default value: Current_Date |
| CountPermanentWorkers (Number) | Self explanitory | Any number value | Default value: 0 |
| CountTemporaryWorkers (Integer) | Self explanitory | Entered by user | Default value: 0 |
| EstimatedVolume (Number) | Self explanitory | Any number value | Default value: 0 |
| PreviousYearTotalHarvest (Number) | Self explanitory | Any number value | Default value: 0 |
| TotalCertifiedArea (Number) | Self explanitory | Any number value | Default value: 0 |
| TotalNumPlots (Number) | Self explanitory | Any number value | Default value: 0 |
| TotalFarmArea (Number) | Self explanitory | Any number value | Default value: 0 |
| Delivered1YearAgo (Number) | Self explanitory | Any number value | Default value: 0 |
| Delivered2YearsAgo (Number) | Self explanitory | Any number value | Default value: 0 |
| Delivered3YearsAgo (Number) | Self explanitory | Any number value | Default value: 0 |
| InspectorID (Link-ID) | Links to the Staff table | Set by Orixa to the current-user, but can be edited. | CurrentUser |
| HouseholdSize (Number) | Self explanitory | Any number value | Default value: 0 |
| CocoaVarieties (Text) | Field-field for officer to enter cocoa varieties. | Entered 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 |