Answers
Purpose
The Answers data-table is a child entity which holds data for the actual answers given by farmers to questions that are asked by staff as part of a Questionnaire. It links to Questions, and Inspections. Each Inspections record includes a "FarmersID" and "SocietiesID" to link the record to the main data-entities of KKSys.
The Answers data-table includes data-fields for Answers given to the question, these are segmented by data-type to allow different types of answer to be presented differently in the KKSys user-interface.
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 read further in this topic.
How and where to access Answers data
The image below shows the "Answers" Edit Form. This is accessed via the Questionnaires entry in the System Entities screen.
Answers edit form
The Answers edit-form is used with-in the KKSys back-office system of KKFU. It is not intended for day-to-day data-entry. Data-entry of "Answers" data will be done within the KKICO System or the phone-app.
The Answers edit-form allows back-office users to view and review Answers records. It is provided with a "Summary View" (at the bottom) showing the Questions record to which it is linked.
Details of the Answers edit-form
Details of the Answers edit form
- InspectionsID: Link field to the Inspection during which this answer was provided by a user.
- QuestionnairesID: Link to the Questionniare this answer is part of.
- QuestionsID: Link to the Question this record gives an answer for.
- Data-fields holding all possible answers: Because Answers can have different data-types (currency, text, date etc.) the Answers data-table contains separate fields for each data type. This is done to make reporting easier at later stages of the data-processing. Note: the "Answer" column (shown with the arrow) always contains a computed version of the answer, making it easier to return the data without it's data-type when this is required.
- Memo: A long-text field used to hold any additional notes made while the answer was being recorded.
- Summary "Questions" data: This part of the form just returns data relating to the Question linked via the "QuestionsID".
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. | |
| InspectionsID (Link-ID) | Links to the Inspections table | Selected from list by User | Will default to the currently open Inspections ID |
| QuestionnairesID (Link-ID) | Links to the Questionnaires table | Selected from list by User | Will default to the currently open Questionnares ID |
| QuestionsID (Link-ID) | Links to the Questions table | Selected from list by User | Dependent, AnswersQuestionsDepLUList, InspectionsID |
| Correct (true/false) | Self explanitory | True / false | Default value: false |
| NotApplicable (true/false) | Self explanitory | True / false | Default value: false |
| Memo (Long Text) | Self explanitory | 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 |
| Complete (true/false) | Tick this field to lock the record so further editing is restricted. | True / false | LockIfCompleteSecurityLevel=101 once this field is ticked users will not be able to edit this record unless they have a Security Level greater than 100. Default value: false |
| AuthorID (Integer) | Self explanitory | Automatically set by Orixa, not under the control of users or developers. | |
| AnswerYes (true/false) | Self explanitory | True / false | Default value: false |
| AnswerNo (true/false) | Self explanitory | True / false | Default value: false |
| AnswerDate (Date) | Self explanitory | Entered by user | |
| AnswerInteger (Integer) | Self explanitory | Entered by user | Default value: 0 |
| AnswerFloat (Number) | Self explanitory | Any number value | Default value: 0 |
| AnswerCurrency (Currency Value) | Self explanitory | Any number value | Default value: 0 |
| AnswerText (Text) | Self explanitory | Entered by user | |
| Answer (Text) | ReadOnly, value generated by Orixa | Value generated by Orixa |