Secretariat/Database

From Sekhet-Maat Lodge

The following consists of notes pertaining to the Initiation/Secretarial Database for reference and collaboration toward development of the next version.

Contents 1 Tables & Fields 1.1 Event Table 1.2 Participation Table 1.3 Contacts Table 1.4 EventType 1.5 Degree List 1.6 Roles List

Tables & Fields

Event Table

The Event Table contains all event-specific information.

EventID

Key. Auto increment.

Date

Date of the event.

EventType

What kind of event, e.g., initiation, training, mass, etc., selected here from the EventType table.

Degree

For degree-specific events, degree is selected here from the Degree List table.

EventNotes

Any notes pertaining to the event overall.

Participation Table

The Participation Table contains all participant-specific information.

EventID

Carried over from Event Table.

ParticipationID

Key. Auto increment.

Name

Name of participant. Selected from, or added to Contacts Table.

Role

Participant's role in the event, e.g. Candidate, Instructor, Priest, etc., selected from a list generated from the Roles List table.

Sponsor1, Sponsor2

In the case of initiation, baptism and confirmation, and any future use of sponsorship in other event types, the names of sponsors are included in these fields.

App, Fees Paid, Dues Paid, Back Dues Paid, Indem

Checkboxes used in the case of initiation events, to verify that the candidate has turned in their application for initiation, that they have paid all dues and fees, and that they have signed an indemnification form for the event.

Time

In the case where a specific time is needed for a participant, e.g., the time that a candidate was initiated.

Participant Notes

Any notes pertaining to the participant's activity in the event.

Contacts Table

Name, Home Phone, Alternate Phone, Email Address, City, State, Zip

Self-explanatory

Body

Local OTO body affiliation.

Birthdate

Common date of birth.

Show Eligibility

For the purpose of reporting initiation eligibility, this checkbox indicates whether to list this contact or not. Useful for removing inactive people from such reports.

Public

Cannot recall the purpose of this field at the moment. This is a stub. Please edit this page to add information here. See also: List of Stubs

EventType

EventType

A list of types of event which can then be selected, e.g., initiation, training, mass, etc.

Degree List

Degree

For degree-specific events, the degrees that can be selected are listed here.

Rank

Ranking of the degrees in numerical order (since degrees are a mix of Roman numerals and initialisms) for ease of sorting in reports.

Roles List

Roles

A listing of all possible roles that a person may have in a given event, e.g., instructor, priest, candidate, etc.

Rank

Ranking of the roles (based solely upon desired sort order, not importance or authority) for ease of sorting in reports.