Society Evaluations 

Purpose

The SocietyEvaluations data-table holds data for a range of data-points relating to evaluations of the Societies and Zones KKFU work with. It is a child data-table which links to Societies.

It includes data-fields such as "MeetingsPerYear", to list the number of times the society members meet. Several of the fields are types list-fields allowing a rating to be selected such as "good" / "fair" / "poor" 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 SocietyEvaluations 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. Prior to serious use the data-structure and data-fields should be reviewed, unnecessary fields can be removed, and more useful fields could be added.

How and when to access Society Evaluations

The edit form is accessible from the child data-entity on the KKSys System Entities scree, and is shown below.

 

SocietyEvaluations  

 

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

Field- Name and 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 tableSelected from list by UserWill default to the currently open Societies ID
DateDone (Date) Self explanitoryEntered by user
InspectorID (Link-ID) Links to the Staff tableSelected from list by User
Findings (Long Text) Self explanitoryEntered by user
GenderEqualityID (Link-ID) Links to the Types tablePick from list of possible Types values.
RegularMeetings (true/false) Self explanitoryTrue / false Default value: False
MeetingsPerYear (Number) Self explanitoryAny number value Default value: 0
AccessibilityID (Link-ID) Links to the Types tablePick from list of possible Types values.
MinutesBookKept (true/false) Self explanitoryTrue / false Default value: False
MinutesBookSigned (true/false) Self explanitoryTrue / false Default value: False
DocumentsWellFilled (true/false) Self explanitoryTrue / false Default value: False
WrittenByLawsInPlace (true/false) Self explanitoryTrue / false Default value: False
InterestLevelID (Link-ID) Links to the Types tablePick from list of possible Types values.
ApplicationStatusID (Link-ID) Links to the Types tablePick from list of possible Types values.
UpToDateMembershipListAvailable (true/false) Self explanitoryTrue / false Default value: false
FarmersLedgerBooksPresent (true/false) Self explanitoryTrue / false Default value: False
ProducePaymentBookPresent (true/false) Self explanitoryTrue / false Default value: False
WaybillBookPresent (true/false) Self explanitoryTrue / false Default value: False
HasShed (true/false) Self explanitoryTrue / false Default value: False
HasScales (true/false) Self explanitoryTrue / false Default value: False
HasChemicalsList (true/false) Self explanitoryTrue / false Default value: False
SuggestionsFromFarmers (Long Text) Self explanitoryEntered 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.
AuthorID (Integer) Self explanitoryAutomatically 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
SocietyOfficerID (Link-ID) Links to the Farmers tableSelected from list by UserDependent, PeopleWithSocietyLUList, SocietiesID, Farmers