Getting started

Fields your church database almost certainly does not need

The spouse's-employer columns and denominational codes churches copy out of habit, and never once fill in.

7 min read

Ask AI · in the $19/mo plan

Ask your own records a question. Which regulars have quietly stopped coming?” — answered from the records you already keep. It reads your church and no other, and it can't invent a number.

10 questions a month included · no AI add-on to buy

Open the membership template that came with almost any church database and you will find fields like “spouse's employer,” “denominational affiliation code,” and “confirmation class cohort.” Someone, somewhere, needed those fields once. That is not the same as your church needing them now.

Most churches inherit their database structure the way they inherit an old filing cabinet: whatever was in it stays in it, because nobody wants to be the one who throws away a folder that might matter. But a field nobody fills in isn't neutral. It is a small tax on every volunteer who enters data, a blank space that makes the record look incomplete, and a decision someone has to keep re-making: leave it blank, or guess.

Why the extra fields show up in the first place

Church databases have a long lineage. A lot of software still on the market traces its schema back to systems built for much larger congregations, denominational reporting requirements, or a previous era when a paper membership card asked for a dozen things because paper was free and thinking was expensive. When a small church buys that software, it inherits the whole card — spouse's occupation, home ownership status, denominational transfer history — whether or not any of it maps to how a 90-person congregation actually operates.

The pattern repeats when churches build their own spreadsheet, too. Someone copies a template from a Facebook group or a denominational office, and the columns come along for the ride. Nobody sits down and asks, for this field, who is going to read it and what will they do differently because of it. That single question is the one worth asking before any field earns a place in your system, which is really the same discipline behind moving a church off spreadsheets in the first place — you are not just changing tools, you are deciding what deserves to be recorded at all.

The fields that almost never get used

A few show up again and again in church systems, quietly unfilled:

  • Spouse's employer and occupation. Useful for a direct-mail fundraising list in 1985. For a Sunday check-in desk or a pastoral care conversation, it changes nothing.
  • A denominational or doctrinal affiliation code. Meaningful to a regional office that files reports. Meaningless to the volunteer trying to remember who is on the greeter schedule this week.
  • Wedding anniversary, tracked separately from a general “important dates” note. A kind thing to remember, but it rarely needs its own column when a note or a calendar reminder does the same job with less structure to maintain.
  • Referral source at intake. Worth capturing once in a follow-up conversation. Not worth a permanent field that nobody updates after the first Sunday.
  • T-shirt size, blood type, or other one-event fields. Copied from a youth camp registration form and left in the main database long after the camp ended.
  • A membership status with more than four or five values. “Active,” “inactive,” and “visitor” cover almost every real case. “Active-non-attending,” “transferred-pending,” and “associate-non-voting” mostly exist because a denomination once required them on a form.
  • Marital status broken into more than three categories. Single, married, and widowed cover the pastoral reality of almost any congregation. Finer distinctions rarely change what anyone does with the information.

None of these are bad ideas in isolation. The problem is cumulative. Each one alone costs a few seconds of a volunteer's attention. Add a dozen of them to every person's profile and you have built a form that discourages anyone from finishing it.

Why nobody wants to be the one who deletes them

Ask a church office why a field still exists and you rarely hear “we use it.” You hear “we're not sure, but what if someone needs it.” That instinct is understandable — nobody wants to be the volunteer who deleted the one column the pastor secretly relied on. But the instinct treats every field as equally risky to remove, when in practice a field that has been blank across ninety percent of your records for two years has already answered the question. It isn't being relied on. It's being avoided.

There is also a quieter reason unused fields survive: they came bundled with the software, so removing them feels like fighting the tool instead of adjusting a form. A church that built its own spreadsheet has an easier time here, because every column was a deliberate choice someone made. A church that inherited a vendor's schema has to do the harder work of deciding, field by field, which parts of that schema were ever actually theirs.

The cost is not the storage, it is the friction

It is tempting to think extra fields are harmless because storage is cheap and a blank cell doesn't hurt anything. But the real cost shows up in three places. First, data entry: every field is a decision a volunteer has to make while entering a new family after a Sunday service, and decisions add up to reasons people stop entering data at all. Second, scanning: a profile with thirty fields, five of them meaningful, makes the five harder to find. Third, trust: a record full of blanks looks unfinished, and an unfinished-looking system quietly signals that it's fine to leave the next field blank too.

This is the same failure mode covered in cleaning up a messy church database: most of the mess isn't bad data, it's unused structure that nobody had the nerve to remove. A field that has sat empty for two years across every record isn't a gap to fill in. It's a question that was never worth asking.

A simple test before you add — or keep — a field

Before you carry a field forward into a new system, or before you add one to an existing sheet, ask two questions. Who, specifically, will read this value? Not “it could be useful someday” — an actual person, on an actual Tuesday, doing an actual task. And what will they do differently because of it? If you can't answer both, the field is decoration, not data.

Run that test against your current system's fields honestly. You will likely find that the fields people actually open — name, phone, groups, serving, giving, a pastoral note — are a small fraction of what the template originally gave you. Everything past that fraction is weight you are carrying out of habit.

What's worth keeping instead

The fields that survive the test tend to be the ones tied to something your church actually does every week: who is in this household, what groups and serving teams someone belongs to, what they've given, and a short pastoral note when something needs quiet follow-up. That short list is deliberately close to what a directory your team actually trusts tends to contain — not everything a schema could hold, only what someone will open.

A general note field does more work than most of the specific fields it replaces. “Uses a wheelchair, needs the ramp entrance” or “going through a rough divorce, be gentle about family questions” captures the rare, real thing that matters without asking every profile to carry a column for it. SundayBridge keeps this kind of context on the person's own timeline, alongside groups, serving, and giving, rather than scattered across a dozen single-purpose fields nobody remembers to check.

How to actually remove a field without losing anything

Removing a field feels riskier than it is, because it feels permanent. Two habits make it safe. First, export before you touch anything — a full CSV of the directory as it stands, so the old values exist somewhere even if you never look at them again. Second, hide rather than delete for a trial period. Stop showing the field on the entry screen, keep it in the export, and watch whether anyone asks where it went. If nobody does after a month, it was never load-bearing.

This matters more than it sounds like it should, because the fear of deleting something important is usually what keeps unused fields alive for years past their usefulness. A safe, reversible process removes the fear, and once it's gone, most churches find they were only ever using a handful of the fields their old system gave them.

The fields that look like they're about people, but aren't

One more pattern worth naming: some fields exist to describe your organization's process, not the person. “Date entered into database,” “source system ID,” or a code for which import batch a record came from are administrative residue from a migration, not information about a member. They belong in a technical log, if anywhere, not on the profile a volunteer opens to plan a visit. If a field describes your software's history rather than a person's, it almost never earns a permanent place either.

Frequently asked questions

Should we just delete these fields from our current spreadsheet?
Not right away. Hide the columns first and see if anyone asks for them over a month or two. If nobody does, delete them then. This is gentler than a mass deletion, and it doubles as proof, if a board member asks, that the field truly went unused rather than being lost by accident.
What if we need one of these fields for a single unusual situation?
A one-off does not justify a permanent column. A general note on the person's profile — “allergic to peanuts, tell the kids' ministry lead” — covers the rare case without asking every volunteer to fill in a field that means nothing for anyone else.
Is it wrong to track spiritual milestones like baptism or confirmation at all?
No — a single date, once, is fine and often meaningful. The problem is the version copied from denominational software: a class name, a cohort year, a certificate number, and a re-affirmation flag, none of which anyone at a 150-person church has ever looked up.
Our old system had a field for 'referred by.' Isn't that useful for outreach?
It can be, briefly, right after a guest's first visit — but it almost never gets updated after that, and a stale referral field is worse than none, because it looks authoritative. If you want it, put it in the first follow-up note instead of a permanent column everyone has to skip past.
How do we know which fields are actually being used?
Ask three people who touch the database weekly — usually the person who checks people in, the one who enters giving, and the one who plans classes — which fields they open and which they scroll past. Their answer, not the software vendor's original schema, is the real test.