> ## Documentation Index
> Fetch the complete documentation index at: https://docs.getparable.io/llms.txt
> Use this file to discover all available pages before exploring further.

# Overview

# Planning Center Services Overview

Access comprehensive worship planning and volunteer management data from Planning Center Services through Parable's unified SQL interface.

<CardGroup cols={2}>
  <Card title="Data Model" icon="database" href="/planning-center/services/data-model">
    Explore all 63 Services tables with complete field documentation
  </Card>

  <Card title="Basic Queries" icon="magnifying-glass" href="/planning-center/services/basic-queries">
    Simple queries for common worship and volunteer questions
  </Card>

  <Card title="Advanced Analytics" icon="chart-mixed" href="/planning-center/services/advanced-queries">
    Sophisticated analysis for scheduling optimization and trends
  </Card>

  <Card title="Reporting Examples" icon="file-chart-line" href="/planning-center/services/reporting-examples">
    Production-ready queries for dashboards and reports
  </Card>
</CardGroup>

## What's Available

Planning Center Services data in Parable provides complete access to your worship planning and volunteer management system.

### 📊 Core Capabilities

* **Service Planning** - Access all service plans, series, and scheduling data
* **Volunteer Management** - Track team participation, availability, and engagement
* **Song Analytics** - Monitor song usage, keys, themes, and rotation patterns
* **Team Health** - Analyze team capacity, confirmation rates, and scheduling gaps
* **Resource Tracking** - Manage attachments, chord charts, and media files
* **Multi-Site Coordination** - Synchronize services across campuses

### 🎯 Key Use Cases

<AccordionGroup>
  <Accordion title="Volunteer Scheduling & Management">
    * Track volunteer participation and availability
    * Identify scheduling conflicts and gaps
    * Monitor team health and prevent burnout
    * Analyze confirmation and decline patterns
    * Coordinate blockout dates and preferences
  </Accordion>

  <Accordion title="Worship Planning & Song Selection">
    * Analyze song usage and rotation patterns
    * Track key preferences and arrangements
    * Monitor theme combinations and flow
    * Manage CCLI reporting and copyright
    * Optimize service length and composition
  </Accordion>

  <Accordion title="Team Development & Growth">
    * Assess team capacity and coverage
    * Identify training needs and gaps
    * Track background check compliance
    * Monitor team engagement levels
    * Plan recruitment strategies
  </Accordion>

  <Accordion title="Service Effectiveness">
    * Analyze service timing and flow
    * Track item types and distributions
    * Monitor volunteer-to-task ratios
    * Measure preparation timelines
    * Evaluate multi-service consistency
  </Accordion>
</AccordionGroup>

## Quick Start Examples

### Who's Serving This Sunday?

```sql theme={null}
SELECT
    p.full_name,
    t.name as team,
    pp.team_position_name as role,
    pl.title as service,
    pp.status
FROM planning_center.services_plan_people pp
JOIN planning_center.services_people p ON pp.person_id = p.person_id
JOIN planning_center.services_teams t ON pp.team_id = t.team_id
JOIN planning_center.services_plans pl ON pp.plan_id = pl.plan_id
WHERE pl.sort_date >= CURRENT_DATE
    AND pl.sort_date < CURRENT_DATE + INTERVAL '7 days'
ORDER BY pl.sort_date, t.name;
```

### Top Songs This Quarter

```sql theme={null}
SELECT
    s.title,
    s.author,
    COUNT(DISTINCT i.plan_id) as times_used,
    MAX(pl.sort_date) as last_used
FROM planning_center.services_songs s
JOIN planning_center.services_items i ON s.song_id = i.song_id
JOIN planning_center.services_plans pl ON i.plan_id = pl.plan_id
WHERE pl.sort_date >= CURRENT_DATE - INTERVAL '3 months'
    AND i.item_type = 'song'
GROUP BY s.song_id, s.title, s.author
ORDER BY times_used DESC
LIMIT 20;
```

### Volunteer Activity Summary

```sql theme={null}
SELECT
    t.name as team,
    COUNT(DISTINCT pp.person_id) as volunteers,
    COUNT(CASE WHEN pp.status = 'C' THEN 1 END) as confirmed,
    COUNT(CASE WHEN pp.status = 'D' THEN 1 END) as declined,
    ROUND(AVG(CASE WHEN pp.status = 'C' THEN 100.0 ELSE 0 END), 1) as confirm_rate
FROM planning_center.services_plan_people pp
JOIN planning_center.services_teams t ON pp.team_id = t.team_id
JOIN planning_center.services_plans pl ON pp.plan_id = pl.plan_id
WHERE pl.sort_date >= CURRENT_DATE - INTERVAL '30 days'
GROUP BY t.name
ORDER BY volunteers DESC;
```

## Available Tables

The Services module includes **63 tables** organized into these categories:

### Core Planning Tables

* `services_service_types` - Service categories and settings
* `services_plans` - Individual service plans
* `services_plan_times` - Service and rehearsal times
* `services_plan_templates` - Reusable service templates
* `services_items` - Service order and elements
* `services_series` - Sermon series information

### People & Teams

* `services_people` - Volunteer and staff records
* `services_teams` - Ministry teams
* `services_team_positions` - Roles within teams
* `services_plan_people` - Who's scheduled when
* `services_schedules` - Individual scheduling records
* `services_person_team_position_assignments` - Role assignments

### Worship Resources

* `services_songs` - Song library
* `services_arrangements` - Keys and arrangements
* `services_attachments` - Files and media
* `services_media` - Video and audio resources
* `services_keys` - Musical key information
* `services_song_schedules` - Song planning data

### Scheduling & Availability

* `services_blockouts` - Unavailability patterns
* `services_blockout_dates` - Specific blocked dates
* `services_blockout_exceptions` - Override dates
* `services_needed_positions` - Unfilled positions
* `services_time_preference_options` - Scheduling preferences

[View Complete Data Model →](/planning-center/services/data-model)

## Integration Benefits

Combine Services data with other Planning Center modules for powerful insights:

### With Check-ins

* Compare volunteer schedules with actual attendance
* Track volunteer family check-in patterns
* Analyze service time effectiveness

### With People

* Access complete member profiles
* Track household serving patterns
* Coordinate family scheduling

### With Giving

* Correlate serving with giving patterns
* Identify engaged members across ministries
* Track volunteer donor overlap

### With Groups

* Find group members serving on teams
* Identify potential volunteers from groups
* Track ministry involvement paths

### With Calendar

* Coordinate facility usage with services
* Manage resource conflicts
* Plan rehearsal spaces

## Best Practices

<Note>
  **Performance Tip**: Index frequently queried columns like `sort_date`, `person_id`, and `team_id` for faster queries.
</Note>

<Tip>
  **Data Freshness**: Services data syncs regularly. Check the `system_updated_at` field for last sync time.
</Tip>

<Warning>
  **Privacy**: Always respect volunteer privacy. Limit access to personal information and scheduling details.
</Warning>

## Next Steps

Ready to dive deeper? Explore our comprehensive guides:

1. **[Understand the Data Model](/planning-center/services/data-model)** - Learn about all tables and relationships
2. **[Start with Basic Queries](/planning-center/services/basic-queries)** - Simple SQL for common questions
3. **[Master Advanced Analytics](/planning-center/services/advanced-queries)** - Complex analysis and optimization
4. **[Build Complete Reports](/planning-center/services/reporting-examples)** - Production-ready dashboard queries

***

*Transform your worship planning and volunteer management with data-driven insights from Planning Center Services.*