7. Lookup tables
Video Courses
All CoursesGetting started
About this course1. Welcome: six modules, one church2. Signing in, and a forgotten password3. Two-step verification4. The header, the menus and your campus5. Search, help and notifications6. Your account7. Roles in plain wordsSetting up your church
About this course1. Settings and the Setup Guide2. Your church profile3. Campuses4. Your logo and your modules5. Inviting your staff6. Roles, titles and suspending a login7. Lookup tables8. Funds and the fiscal year9. Service schedules10. Stripe, the giving QR code and your emails11. Security12. Custom fields, the connect card and privacy requests13. Background jobs14. The Activity Log15. Start Fresh16. The other settings, and BillingFlock: your people
About this course1. Flock at a glance2. The directory: finding anyone3. Advanced search, selecting people and export4. Membership statuses and person categories5. Adding a person6. Reading a profile7. Editing a profile, the photo and the title8. Notes, care, circles, attendance and history9. Archive, delete, merge and access requests10. Households11. Children's profiles12. Importing your member list13. The onboarding pipeline14. The connect card15. Engagement scores16. Flock reports and email campaigns17. Who sees what, and Flock Leader scopes18. Member sign-in and My churchSteward: giving
About this course1. The Steward dashboard2. Sessions, and the life of a session3. Starting a session4. The entry grid and the keyboard5. Who gave it: envelopes, names and anonymous gifts6. A new donor in the middle of counting7. Payment methods, cheques and split gifts8. The counted total and the live difference9. Possible duplicates10. Saving, refreshing and two laptops11. Counters, the review and Submit12. Posting a session13. Correcting a posted gift14. Gifts in kind15. Interac e-Transfers16. Deposits and bank reconciliation17. Donors and the donor profile18. Merging duplicate donors19. Pledge campaigns20. Recurring gifts21. Online giving22. Refunds and card disputes23. Year-end CRA receipts24. Fixing and sending receipts25. Reports, imports and event revenue26. Who sees givingGather: services and attendance
About this course1. Gather at a glance2. Service Schedules and the calendar3. Children's rooms and who counts as a child4. Building an Order of Service5. Starting, completing and cancelling a Service6. Opening check-in7. Lookup mode: finding people fast8. New visitors and first-time visitors9. People with no date of birth10. Person Categories: who counts as a child, and the attendance breakdown11. Printing labels12. Checking in children13. Allergy and medical alerts14. Children's Pickup15. Member QR codes and Scan mode16. The family check-in code17. Express Check-in18. Clicker headcounts and Roster mode19. Many devices, and finishing check-in20. Self check-in kiosks21. Attendance records and corrections22. Absence alerts23. Attendance reports24. Events and the public calendar25. Registrations and paid eventsServe: volunteers
About this course1. Serve at a glance2. Teams and departments3. A team's page4. Volunteers and availability5. The Schedule Builder6. Assigning a position7. Auto-fill, copy and share8. Asking for confirmations9. A volunteer's schedule10. A volunteer's availability11. When someone declines12. Team Scheduling13. The song library14. Importing songs15. Setlists and Stage View16. The lineup of your service17. Volunteer screening18. Volunteer requests and reports19. Who can do what in ServeCircles: small groups
About this course1. Circles at a glance2. Before the first group3. The groups list4. Creating a group5. A group's page6. The roster7. Taking attendance8. A saved meeting9. Attendance across every group10. The public group finder11. Reviewing join requests12. People without a group13. Lapsed members14. Group health and reports15. Who can do what in CirclesCare: pastoral care
About this course1. Care at a glance2. The three privacy levels3. Logging a care need4. All care items5. Working a care item6. Assigning care, and elders7. My Queue and follow-ups8. Hospital and home visits9. Bereavement and counseling10. Prayer requests and the prayer wall11. The public prayer page12. Life events13. Prayer guides14. Care reports and settingsServices: one service across the modules
About this course1. Services at a glance2. The list of services3. One service's page4. Who sees which panel5. Services reportsLookup tables
Setting up your church · Lesson 7 of 16
The choices in your dropdowns: add, rename, switch off and delete, and what each table decides.
Read it in the guide
Transcript
In this lesson, you'll set up your lookup tables: the choices in your church's dropdowns, in your own words.
Lookup tables are the choices in your church's dropdowns: transaction sources, fund categories, membership statuses, payment methods, onboarding stages, household relationships, prayer categories, group types and person categories. Rename them to your words.
Add Entry asks for a code, which never changes, and the label people see, then a colour and where it sorts. Code and label are required, and a code can't be used twice.
Edit renames it, and Save keeps it. Everything already filed under it follows, because they point at the code.
Switch an entry off, and it leaves every dropdown but keeps its history. Switched-off entries hide here too: Show switched off brings them back into the list.
Delete removes an entry for good, once you confirm. An entry in use can't be deleted: a status people hold, a group type groups use. The built-in system entries can't be deleted either. Switch those off instead.
Membership Statuses have two more columns. New people: the one status a person starts on. And Counts as a member: which statuses your member figures count. The Flock course sets them.
Payment Methods each have a Type: physical, electronic or unclassified. It decides which side of a service's giving a method counts on. Switching a method off never drops its gifts from a total.
Person Category is your church's own way of grouping people, under the name you choose. Until you add an entry, it appears nowhere in SanctuaryOS.
Super Admins, Lead Pastors and Finance Admins add and edit entries; only a Super Admin deletes. Grace, the treasurer, has no Delete.
That's lookup tables. Next, funds and the fiscal year.