Church Member Status

This Condition located on the Membership category tab in Search Builder allows you to select one or more Church Member Statuses for your search. The values may vary from database to database.

The default Values are as follows:

  • Member

  • Not Member

  • Previous Member

  • Pending Member

  • Just Added

Note

Just Added is a temporary status that is given to every new record at the time it is added to the database. The New Member Manager will change the status from Just Added to Not Member when they validate that record.

Use Case - Membership as of a Specific Date

To search your current membership, select Equals “Member.” To view membership as of a specific date (e.g., 9/1/2016), consider the following:

  • Include individuals with a Member Status of “Member” and a Join Date on or before (less than or equal to) 9/1/2016.

  • Also include individuals with a Previous Member status whose Drop Date is on or after 9/1/2016, since they were members as of that date.

You can refine your results by adding other conditions, such as excluding non-residents using the Resident Code or filtering out individuals with bad addresses.

Refer to the image below for an example search setup.

https://i.tpsdb.com/2025-10-03-091651.png


Latest Update

10/2/2025

Updated name of Search Condition, image, and content clarity.