Organisation Help

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

List of alliances

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.

Full NameFull (i.e. displayed) name of the organisation layer. 100 characters.
Short NameAn 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 ‘-‘
ParentPick one from the list. Unless, of course, this is the master record.
MembersThe 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 UrlThe Url for the organisation. This must include the http://. Typically for affiliated societies.
Contact EmailContact email. Must be a valid email address. Typically for affiliated societies
Start DateThe date on which this entity came (or comes – it can be in the future) into existence.
End DateThe 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.


Send to a friend