MembershipDetails
Purpose
The MembershipDetails data-table holds data for dates on which farmers who KKFU work with have paid for or renewed their memberships. It is a child data-table which links to Farmers and Societies. It allows KKSys to record when farmer-members join or renew their membership to the co-op and the dues they have paid.
The MembershipDetails data-table includes data-fields for the basic values of Dues paid and the farmers cococa volume. 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 Membership Details data
The image below shows the "MembershipDetails" Edit Form. This is accessed via its own entry in the System Entities screen, or via the People or Societies it is linked to. MembershipDetails are a child of the People entity.
Membership Details 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.
How access to MembershipDetails works in practice in KKSys
Because large numbers of membership records must be added, together with other data relating to things like the Fields a Farmer owns, Dues they have paid to KKFU etc., automated systems have been built to enable staff to enter data into multiple entities simulataneously using Rapid-data-entry-grids.
To understand thes more fully please consult the following links:
Farmer Deliveries Rapid Entry Grid
Dynamic Pascal-Scripting in Orixa: Adding a Resource to create Rapid-Entry-Grids in your App
The existance of these Rapid data-entry grids does not remove any of the usual functionality of edit-forms within KKSys. All records that hae been inserted automatically using a rapid-entry process can also be reviewed and updated in their edit-forms, and added to any reporting that management require.
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. | |
| FarmersID (Link-ID) | Links to the Farmers table | Selected from list by User | Will default to the currently open Farmers ID |
| SocietiesID (Link-ID) | Links to the Societies table | Selected from list by User | Will default to the currently open Societies ID |
| DateRenewed (Date) | Self explanitory | Set by Orixa, but can be overriden by user. | Default value: MembershipStartDate() |
| DuesPaid (Currency Value) | Self explanitory | Any number value | Default value: 0 |
| Volume (Number) | The weight in kilos of cocoa the farmer has deliveried in the year. | Any number value | Default value: 0 |
| 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. KKSys is programmed to untick this field for older records when a new one is added for the same farmer. This means there should only be one "Current" MembershipDetails record for each farmer. | True / false | Default value: true |
| AuthorID (Integer) | Self explanitory | Automatically set by Orixa, not under the control of users or developers. |