Society Activities
Purpose
The SocietyActivities data-table holds data for a range of data-points relating to activities of the Societies and Zones KKFU work with. It is a child data-table which links to Societies.
It is a sister table to the "Projects" data-table, and is intended to be used to store data about actities such as gender training, literacy training and other work done by KKFU staff with Societies and Zones.
It includes data-fields such as "ActivityType", to list the type of activity which occurred, start and end dates.
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 SocietyActivities entity was added to KKSys in the 2010's used for a period of time. As IT staff have left the company it has since stopped being used. It is still present in KKSys, and can be used again by KKFU staff at any point.
How and when to access SocietyActivities
The edit form is accessible from the child data-entity on the KKSys System Entities screen, and is shown below.
SocietyActivities
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 table | Selected from list by User | Will default to the currently open Societies ID |
| FundersID (Link-ID) | Links to the Types table | Pick from list of possible Types values. | Types, Projects, FundersID |
| DateStarted (Date) | Self explanitory | Entered by user | |
| DateFinished (Date) | Self explanitory | Entered by user | |
| Budget (Currency Value) | The money allocated for this activity | Any number value | Default value: 0 |
| ProjectOfficersID (Link-ID) | Links to the Staff table, select the person who is overseeing the project. | Selected from list by User | |
| ActivitiesTypeID (Link-ID) | Links to the Types table | Pick from list of possible Types values. | |
| NumberAttending (Number) | Self explanitory | 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. | |
| AuthorID (Integer) | Self explanitory | Automatically set by Orixa, not under the control of users or developers. | |
| Complete (true/false) | Tick this field to lock the record so further editing is restricted. | True / false | Default value: false |