5th November 2017

Members Help

The Members table records members of the DDA (as well as Tower Correspondents etc). All members must be assigned to an Organisation record (usually a tower, but there are also records for Unattached members, and non-residents).

On creating a new member, a full set of information is available for entry:

Label Details
Title Title (e.g. Rev). Please avoid using Mr, Mrs, Miss, Ms
Forename(s) First name(s) or with initial if preferred
Surname Surname
Honours etc Only if significant (e.g. OBE) or relevant qualifications (e.g. for Bell Consultants)
Preferred Name Check if this is the preferred name to use (see note below under Change of Name)
Distinct ID Distinguishing ID for duplicate name conflicts. See not below.
Address Postal address
Post Code Post Code
Address visible to public Check if the address may be displayed to the public. (Only required for selected officers).
Address visible to members Check if the address may be displayed to other members
Email Email address. This is required in order for the member to register on the site
Address visible to public Check if the address may be displayed to the public.
Address visible to members Check if the address may be displayed to other members
Phone Phone Number
Phone visible to public Phone can be displayed publicly
Phone visible to members Phone can be displayed to members
Show phone in report Phone can be printed in the Annual Report
Mobile Mobile Phone Number
Mobile visible to public Mobile can be displayed publicly
Mobile visible to members Mobile can be displayed to members
Show mobile in report Mobile can be printed in the Annual Report
Tower Tower (or District for non residents)
Category Membership category
Proposed By Proposer (recent members)
Seconded By Seconder (recent members). One of the current District Ringing masters.
Start Date The date the current tower/category commenced
End Date The date the current tower/category commenced

Behind the scenes, each members has a record in the Persons table, one or more records in the Names table, and one current record in the Membertable. The latter records the tower and category. Once a record has been created the following options are presented

Change Details Updates the current set of records
Change Tower/Category Updates the tower and/or category. The current member record will be terminated, and a new one added
Change of Name Use to record a name change (as opposed to correction). The current record will be retained, and a new record (marked as preferred) will be added. Both records will be visible in the listing.
Personal Data This will give a listing of all the personal data for the member.