Lookup Tables
Admin Guide

Lookup Tables (System Dictionary)

Access:Super AdminLead PastorFinance Admin

The System Dictionary stores tenant-configurable lookup values used across all modules. Each category contains entries with a code, label, sort order, and active status. Some categories have additional fields like color or physical classification.

Getting Here

Navigation: Settings → Communication → Lookup Tables

Overview

The page displays tabs for each dictionary category. Select a tab to view and manage the entries in that category. Each entry can be edited inline, reordered, or toggled active/inactive.

Dictionary Categories

Transaction Sources

Defines where a transaction originated (e.g., Offering Plate, Online, Mail, Kiosk). Used in session entry to classify how a donation was received.

Fund Categories

Groupings for funds used in reporting (e.g., Operating, Missions, Building, Benevolence). Funds are assigned to a category in the fund settings.

Membership Statuses

People lifecycle statuses (e.g., Member, Regular Attendee, Visitor, Inactive). This category supports a color field for badge display. This list is your church's own: every status you add (for example “WSAM/LGAM”) appears in the Flock filter chips, the edit form, the member importer and the reports.

  • Member and Inactive can be renamed but not switched off or deleted, because the product decides who is active from them.
  • A status anyone still holds, archived people included, cannot be deleted.
  • Make default marks the status a new person gets when nobody picks one (added by hand, a walk-in at check-in, a giving import, online giving, the member import). Gather and Services count people on it as “not yet members”. One entry at most is the default, and it is marked Default. A church may have no default: new people then get no status. The default cannot be switched off until another entry is made the default.
  • Counts as a member decides who is in every figure labelled members: Total Members on the Flock dashboard and the Members list, the Network dashboard's total and per-campus Members, and Total Members in the Membership Report. It is on for every status, existing and new, so nothing changes until you switch one off. Switch it off for a status such as Attendee and people on it stay in Flock, in their groups, in attendance and in giving, but are left out of the member count. The cards then show both numbers, for example “10 people in Flock, 9 not counted as members (Attendee)”. New This Month, Active, engagement, circles, attendance and giving figures count people and do not change. Nor does the count of active people your plan is billed on.

Payment Methods

Payment types available in session entry (e.g., Cash, Cheque, Credit Card, E-Transfer). This category supports an Is Physical toggle that classifies each method as physical or electronic for deposit calculations.

Household Relationships

Relationship types within a household (e.g., Spouse, Child, Parent, Sibling). These are the choices offered for each member on a household's page in Flock.

Prayer Categories

Categories for prayer requests in the Care module (e.g., Health, Family, Financial, Spiritual, Other).

Group Types

The kinds of small group offered in Circles.

Person Category

A second way to group people, beside membership status, with entries your church chooses: for example age groups or ministries. It starts empty, and until you add an entry the field appears nowhere in SanctuaryOS.

  • What do you call this? is the name your church gives it. The default is “Category”. The name is used wherever the field appears: the member profile, the Members list, the import wizard, the import template and the member export. SanctuaryOS already uses Network for a group of churches (the Network dashboard), so “Age Group” or “Ministry” may read more clearly, but any name up to 30 characters works. Leave it blank to go back to “Category”.
  • Each entry has a name, an optional age range (from and to, in whole years; leave “to” blank for “and over”) and a Counts as choice: Child, Adult or Not set. A new entry starts as Not set.
  • The age range only suggests. When a date of birth is known and no entry has been chosen, Add Member pre-selects the entry the age fits; when a person's age and their entry disagree, their profile says so (for example “Age 14 fits CYN”) and the Members list can filter for it. Nobody is ever moved to another entry automatically.
  • Counts as answers who is a child wherever Gather needs to know: check-in (Lookup, Roster and QR scan alike), the attendance counts, the reports and Add attendance. The rule is the same everywhere. A date of birth decides first. With none, the entry's Counts as answers, so nobody is asked at the door. Only someone with neither a date of birth nor an entry that answers (Not set, or no entry) is asked adult or child at check-in, and that answer is kept on that service's attendance only.
  • For a child's safety, a child by either rule is a child: an entry that Counts as Child gets the room and the security tag even when the date of birth says adult, and an entry that Counts as Adult never makes a child by date of birth an adult.
  • An entry that people still hold cannot be deleted. Move them first, rename it, or switch it off.
  • Tell me when someone's age no longer fits their category (under your church's name for it) is offered once an entry has an age range. It is off by default, and Super Admin and Lead Pastor turn it on. Each morning at 6 AM, your church's time, the people chosen (everyone who holds a role you pick, and any logins you tick; with nobody chosen, the Super Admins and Lead Pastors) are told in the app, once per person, about anyone whose birthday has taken them outside their entry's age range, with the entry their age now fits. Nobody's category is changed automatically. The Flock dashboard shows the same people.

Switched-Off Entries

Switching an entry off hides it from dropdowns but keeps it for the records that use it. Switched-off entries are hidden from the list until you click Show N switched off, where you can switch one back on. Adding an entry whose code a switched-off entry already holds is refused with a message naming that entry and pointing you to switch it back on instead; people already on it keep it.

Entry Fields

FieldTypeDescription
Code*Text (uppercase)Unique identifier within the category. Cannot be changed after creation for system entries.
Label*TextDisplay name shown in dropdowns and forms throughout SanctuaryOS.
ColorHex colorBadge color for visual distinction. Only available for Membership Statuses.
Is PhysicalToggleClassifies payment as physical (cash, cheque) or electronic. Only available for Payment Methods.
Sort OrderNumberControls display order in dropdowns. Lower numbers appear first.
ActiveToggleInactive entries are hidden from dropdowns but retained for historical records.
SystemBadge (read-only)System entries can be edited but not deleted. They are part of the default SanctuaryOS configuration.

Actions

Add an Entry

  1. Select the desired category tab
  2. Click + Add Entry
  3. Enter a code (uppercase, unique within the category) and label
  4. Set additional fields if applicable (color, isPhysical)
  5. Save the entry

Edit an Entry

  1. Click on an entry row to start editing
  2. Modify the label, color, sort order, or isPhysical flag
  3. Press Enter or click away to save

Deactivate an Entry

  1. Toggle the active switch to deactivate
  2. The entry disappears from dropdowns but existing records using it are unaffected

Super Admin, Lead Pastor and Finance Admin can add and edit entries. Only a Super Admin can delete one, and the Delete button is shown only to them.

Related Pages