Hi! We have three campuses. We chose to indicate our separate campuses on the activity level. It seems to work really great. So for example we have Kids Ministry- as our ministry, then we have Weekend Programming - Lino Lakes, Weekend Programming - White Bear Lake, and Weekend Programming Spring Lake Park all as separate activities. ( We use intials - but I thought I would spell it out for your benefit.) As far as giving is concerned we use the automatice attendance to indicate which batch comes from which campus/activity. That is also set up as 3 separate activities under the same ministry. The ministry is Church Wide Activities - then we have Worship - Lino Lakes, Worship - White Bear Lake, Worship - Spring Lake Park. etc., If we ever add another campus, each ministry adds another activity, and it's appropriate schedule times, rooms, etc., This works well because I can run reports at the ministry level if I need a big picture view or I can run reports at the activity level if I need a specific campus view. I think setting up separate databases would be more difficult because we seem to have people who move around. They don't always settle on one specific campus. If they do settle on one campus - we give them an attribute. We like this because attributes can be so flexible. For example, we can put all of our prayer requests together on one page - but indicate their campus choice by displaying the corresponding attribute. Our campus pastors love it!
Moe O'Brien
Database Administrator
Eagle Brook Church
Minnesota