Field |
Description |
---|---|
id |
This is the internal record id |
status |
This is the status of the member. new: When a person applies for membership. member: When they are made a member renew: When they are due for renewal. renewForm: A separate renewal form. This will need to be matched against an existing entry and the two merged into one. renewDone: When they have renewed. lapsed: When they have not renewed leave: When they have left the club The system will generally set the status as needed. Once the membership secretary has reviewed the join,renewal,lasped or leave status they can then edit the record and either set the status to be a member or delete the record. |
membershipType |
"1 year": Normal 1 year membership. Renewal date will be incrementd by a year on joining/renewal. "5 year": Normal 5 year membership. Renewal date will be incrementd by 5 years on joining/renewal. "Complimentary": Membership record set to free for 6 months. On renewal date the user will be sent a renewal notice as normal. "Special": Special entry. Set the renewalDate as wanted. This could be 2999-12-31 so that no renewal notics are sent. "Honoury": No renewal notices or payments. |
fullId | Full members and Joint members records are in the same database table. The "fullId" field is set to the full members record id if the entry is for a joint member or 0 if a full member. |
renewalDate |
This date defines the date when a member should renew. When they renew this will be automatically updated by a year or 5 years as appropriate.Honory and Special members should have there renewalDate set to a long time in the future. We recommend 2999-12-31. |
All accesses are made via the SSL HTTPS secure connection.
There are two security groups for access. "viewMembership" and
"adminMembership". Any website user can be given those permissions as
needed. Without them no membership database access will be allowed.
The viewMembership" allows viewing only.