The Organisation table is a hierarchical table in that each record (apart from the master – the one for the Central Council itself) points to its parent record. The initial structure is (e.g.):
Central Council
Additional Members
Affiliated Societies
List of societies
…
Alliances
List of alliances
…
Committees
List of committees
Ex Officio Members
Life Members
Ringing Societies
List of societies
…
University Societies
List of societies
…
In the normal course, it should not be necessary to amend the top layers – only the lists of societies and committees which, from time to time may appear, disappear or need amendment.
| Label | Details |
| Full Name | Full (i.e. displayed) name of the organisation layer. 100 characters. |
| Short Name | An abbreviated name. This should not be changed once assigned please! It will be used in some of the code to find particular records (as the name could well change over time). Also restricted to the (lowercase) characters a-z, 0-9 and ‘-‘ |
| Parent | Pick one from the list. Unless, of course, this is the master record. |
| Members | The number of directly electable members. This should be non-zero for affiliated societies, and Life/Additional/Ex-Officio members and zero for everything else. |
| Can have Roles? | If roles can apply to this part of the organisation (e.g. Committee, Officers) then Yes, otherwise No |
| Home Url | The Url for the organisation. This must include the http://. Typically for affiliated societies. |
| Contact Email | Contact email. Must be a valid email address. Typically for affiliated societies |
| Start Date | The date on which this entity came (or comes – it can be in the future) into existence. |
| End Date | The date on which this entity ceased (or ceases – it can be in the future) to exist. Once End Date has passed, the record will no longer be visible. |
