Services Data Model

This document provides complete documentation of the Planning Center Services data model in Parable, including all tables, fields, and relationships.

Overview

The Services module contains 56 tables (54 entity tables and 2 relationship tables) supporting worship planning, volunteer scheduling, song management, and service coordination across your entire ministry.

Visual Data Model

The diagram below shows the core entities and their relationships in the Services module. Use it as a visual reference while exploring the detailed table definitions below.

Core Entity Relationships

Open diagram in new tab →

Key Relationships Explained

Service Planning Hierarchy:

SERVICE_TYPE defines worship service types (Sunday AM, Sunday PM, Youth, etc.)
PLANs are individual service plans within a service type
PLAN_TIMEs define when rehearsals and services occur
ITEMs are the ordered elements within a plan (songs, media, announcements)

Team Structure:

TEAMs organize volunteers by function (Worship, Production, Hospitality)
TEAM_POSITIONs define specific roles (Vocalist, Keys, Sound Engineer)
PLAN_PERSON assigns people to positions for specific plans
Status tracking: C=Confirmed, D=Declined, U=Unconfirmed

Song Library:

SONGs are the core song catalog
ARRANGEMENTs provide different versions (Slow, Upbeat, Acoustic)
KEYs define available musical keys per arrangement
ITEMs link songs/arrangements to specific plans

Scheduling System:

SCHEDULEs assign people to specific plan times
BLOCKOUTs indicate when volunteers are unavailable
BLOCKOUT_DATEs specify exact dates blocked out
SIGNUP_SHEETs facilitate volunteer self-scheduling

Organization:

SERIES groups related plans (sermon series, special events)
FOLDERs provide hierarchical organization
MEDIA tracks video, audio, and presentation files

Query Requirements

Schema Prefix

IMPORTANT: All tables in the Planning Center Services module are in the planning_center schema. You MUST prefix all table names with planning_center. in your queries. ✅ CORRECT: SELECT * FROM planning_center.services_plans ❌ INCORRECT: SELECT * FROM services_plans

Row Level Security (RLS)

This database uses Row Level Security (RLS) to automatically filter data based on:

tenant_organization_id: You only see data for your current organization
system_status: You only see ‘active’ records by default

DO NOT add these filters to your WHERE clause - they are applied automatically:

❌ WHERE tenant_organization_id = 1 (unnecessary)
❌ WHERE system_status = 'active' (unnecessary)

The RLS policies ensure you only access data you’re authorized to see, making these filters redundant and potentially causing performance issues.

Core Tables Overview

Primary Entity Tables

services_service_types - Service categories (Sunday morning, youth, special events)
services_plans - Individual service plans with dates and details
services_teams - Volunteer and worship teams
services_people - People who serve in ministry
services_songs - Song library and metadata
services_arrangements - Song arrangements and keys
services_items - Service elements and order
services_schedules - Person scheduling information
services_plan_people - People scheduled for specific plans
services_attachments - Files, charts, and media

Supporting Entity Tables

services_plan_times - Service times (9am service, 11am service, etc.)
services_plan_templates - Reusable service templates
services_team_positions - Roles within teams (drummer, vocalist, etc.)
services_person_team_position_assignments - Who can serve in what roles
services_needed_positions - Unfilled positions for services
services_blockouts - When people are unavailable
services_blockout_dates - Specific unavailable dates
services_lives - Live service control and streaming
services_media - Media files and videos
services_folders - Organizational structure

Relationship Tables

services_song_relationships - Links songs to tags and attachments
services_team_relationships - Links teams to service types

Table Definitions

services_service_types

Service types define categories of services (Sunday Morning, Youth Service, etc.).

Column	Type	Description
`id`	UUID	Internal unique identifier
`service_type_id`	VARCHAR(64)	Planning Center service type ID
`name`	VARCHAR(255)	Service type name
`sequence`	INTEGER	Display order
`permissions`	VARCHAR(50)	Permission level
`attachment_types_enabled`	BOOLEAN	Whether attachment types are enabled
`scheduled_publish`	BOOLEAN	Whether scheduled publishing is enabled
`frequency`	VARCHAR(50)	Service frequency (Weekly, Monthly, etc.)
`archived_at`	TIMESTAMP	When service type was archived
`created_at`	TIMESTAMP	When created in Planning Center
`updated_at`	TIMESTAMP	Last update in Planning Center
`deleted_at`	TIMESTAMP	When deleted in Planning Center
`custom_item_types`	JSONB	Custom service item types configuration
`standard_item_types`	JSONB	Standard item types (Header, Song, Media)
`background_check_permissions`	VARCHAR(50)	Background check requirement level
`comment_permissions`	VARCHAR(50)	Who can comment on plans
`last_plan_from`	VARCHAR(50)	How last plan was created
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status: ‘active’, ‘transferring’, ‘stale’
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_plans

Individual service plans containing all details for a specific service date.

Column	Type	Description
`id`	UUID	Internal unique identifier
`plan_id`	VARCHAR(64)	Planning Center plan ID
`service_type_id`	VARCHAR(64)	Associated service type
`title`	VARCHAR(255)	Plan title
`series_title`	VARCHAR(255)	Sermon series title
`public`	BOOLEAN	Whether plan is publicly visible
`can_view_order`	BOOLEAN	Whether order is viewable
`rehearsable`	BOOLEAN	Whether rehearsal is scheduled
`multi_day`	BOOLEAN	Whether plan spans multiple days
`items_count`	INTEGER	Total number of service items
`plan_people_count`	INTEGER	Number of scheduled people
`needed_positions_count`	INTEGER	Number of unfilled positions
`plan_notes_count`	INTEGER	Number of plan notes
`service_time_count`	INTEGER	Number of service times
`rehearsal_time_count`	INTEGER	Number of rehearsal times
`other_time_count`	INTEGER	Number of other scheduled times
`total_length`	INTEGER	Total service length in seconds
`sort_date`	TIMESTAMP	Date used for chronological sorting
`last_time_at`	TIMESTAMP	Last service time
`dates`	VARCHAR(255)	Human-readable date string
`short_dates`	VARCHAR(100)	Abbreviated date string
`files_expire_at`	TIMESTAMP	When attached files expire
`planning_center_url`	VARCHAR(2048)	Direct link to plan
`reminders_disabled`	BOOLEAN	Whether reminders are turned off
`created_at`	TIMESTAMP	When created
`updated_at`	TIMESTAMP	Last update
`permissions`	VARCHAR(50)	User permissions for this plan
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When created in Parable
`system_updated_at`	TIMESTAMP	Last update in Parable

services_teams

Teams of volunteers and staff who serve in ministry.

Column	Type	Description
`id`	UUID	Internal unique identifier
`team_id`	VARCHAR(64)	Planning Center team ID
`service_type_id`	VARCHAR(64)	Associated service type
`name`	VARCHAR(255)	Team name
`rehearsal_team`	BOOLEAN	Whether team attends rehearsals
`secure_team`	BOOLEAN	Whether team requires background checks
`sequence`	INTEGER	Display order
`schedule_to`	VARCHAR(50)	Scheduling type (‘plan’ or ‘time’)
`default_status`	VARCHAR(50)	Default response status
`default_prepare_notifications`	BOOLEAN	Default notification setting
`assigned_directly`	BOOLEAN	Whether people are assigned directly
`viewers_see`	INTEGER	What viewers can see
`stage_color`	VARCHAR(50)	Color for stage display
`stage_variant`	VARCHAR(50)	Stage display variant
`archived_at`	TIMESTAMP	When team was archived
`created_at`	TIMESTAMP	When created
`updated_at`	TIMESTAMP	Last update
`last_plan_from`	VARCHAR(50)	How last plan was created
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When created in Parable
`system_updated_at`	TIMESTAMP	Last update in Parable

services_people

People who participate in services as volunteers, staff, or worship team members.

Column	Type	Description
`id`	UUID	Internal unique identifier
`person_id`	VARCHAR(64)	Planning Center person ID
`first_name`	VARCHAR(100)	First name
`last_name`	VARCHAR(100)	Last name
`full_name`	VARCHAR(255)	Complete name
`nickname`	VARCHAR(100)	Preferred name
`given_name`	VARCHAR(100)	Given name
`middle_name`	VARCHAR(100)	Middle name
`birthdate`	DATE	Date of birth
`anniversary`	DATE	Anniversary date
`photo_url`	VARCHAR(2048)	Profile photo URL
`photo_thumbnail_url`	VARCHAR(2048)	Thumbnail photo URL
`preferred_app`	VARCHAR(50)	Preferred Planning Center app
`assigned_to_rehearsal_team`	BOOLEAN	Whether on rehearsal team
`archived`	BOOLEAN	Whether person is archived
`site_administrator`	BOOLEAN	Whether site admin
`permissions`	VARCHAR(50)	General permissions
`media_permissions`	VARCHAR(50)	Media access permissions
`song_permissions`	VARCHAR(50)	Song access permissions
`status`	VARCHAR(50)	Active status
`notes`	TEXT	Personal notes
`passed_background_check`	BOOLEAN	Background check status
`access_media_attachments`	BOOLEAN	Can access media
`access_plan_attachments`	BOOLEAN	Can access plan files
`access_song_attachments`	BOOLEAN	Can access song files
`preferred_max_plans_per_day`	INTEGER	Daily scheduling limit
`preferred_max_plans_per_month`	INTEGER	Monthly scheduling limit
`praise_charts_enabled`	BOOLEAN	PraiseCharts integration
`ical_code`	VARCHAR(100)	Calendar feed code
`logged_in_at`	TIMESTAMP	Last login time
`created_at`	TIMESTAMP	When created
`updated_at`	TIMESTAMP	Last update
`archived_at`	TIMESTAMP	When archived
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When created in Parable
`system_updated_at`	TIMESTAMP	Last update in Parable

services_songs

Complete song library with metadata for worship planning.

Column	Type	Description
`id`	UUID	Internal unique identifier
`song_id`	VARCHAR(64)	Planning Center song ID
`title`	VARCHAR(255)	Song title
`author`	VARCHAR(255)	Song author/composer
`copyright`	VARCHAR(500)	Copyright information
`admin`	VARCHAR(255)	Administrator/publisher
`ccli_number`	INTEGER	CCLI license number
`hidden`	BOOLEAN	Whether song is hidden
`notes`	TEXT	Song notes
`themes`	VARCHAR(500)	Song themes/tags
`last_scheduled_at`	TIMESTAMP	When last used in service
`last_scheduled_short_dates`	VARCHAR(100)	Short date of last use
`created_at`	TIMESTAMP	When created
`updated_at`	TIMESTAMP	Last update
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When created in Parable
`system_updated_at`	TIMESTAMP	Last update in Parable

services_arrangements

Different arrangements and keys for songs.

Column	Type	Description
`id`	UUID	Internal unique identifier
`arrangement_id`	VARCHAR(64)	Planning Center arrangement ID
`song_id`	VARCHAR(64)	Associated song
`name`	VARCHAR(255)	Arrangement name
`bpm`	DECIMAL(5,1)	Beats per minute
`length`	INTEGER	Length in seconds
`meter`	VARCHAR(10)	Time signature (4/4, 3/4, etc.)
`notes`	TEXT	Arrangement notes
`chord_chart`	TEXT	Chord chart content
`lyrics`	TEXT	Song lyrics
`sequence`	JSONB	Song section sequence
`sequence_short`	JSONB	Abbreviated sequence
`sequence_full`	JSONB	Full detailed sequence
`chord_chart_key`	VARCHAR(10)	Musical key
`chord_chart_font`	VARCHAR(50)	Display font
`chord_chart_font_size`	INTEGER	Font size
`chord_chart_columns`	INTEGER	Column layout
`has_chords`	BOOLEAN	Whether chords exist
`has_chord_chart`	BOOLEAN	Whether chart exists
`lyrics_enabled`	BOOLEAN	Whether lyrics are enabled
`number_chart_enabled`	BOOLEAN	Nashville number system
`numeral_chart_enabled`	BOOLEAN	Roman numeral system
`print_margin`	VARCHAR(20)	Print margins
`print_orientation`	VARCHAR(20)	Portrait/landscape
`print_page_size`	VARCHAR(20)	Paper size
`archived_at`	TIMESTAMP	When archived
`created_at`	TIMESTAMP	When created
`updated_at`	TIMESTAMP	Last update
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When created in Parable
`system_updated_at`	TIMESTAMP	Last update in Parable

services_items

Individual elements within a service plan.

Column	Type	Description
`id`	UUID	Internal unique identifier
`item_id`	VARCHAR(64)	Planning Center item ID
`plan_id`	VARCHAR(64)	Associated plan
`title`	VARCHAR(255)	Item title
`sequence`	INTEGER	Order in service
`length`	INTEGER	Duration in seconds
`item_type`	VARCHAR(50)	Type (song, header, media, item)
`service_position`	VARCHAR(50)	Position (pre, during, post)
`description`	TEXT	Item description
`key_name`	VARCHAR(10)	Musical key
`html_details`	TEXT	Formatted details
`custom_arrangement_sequence`	JSONB	Custom sequence
`song_id`	VARCHAR(64)	Associated song
`arrangement_id`	VARCHAR(64)	Associated arrangement
`created_at`	TIMESTAMP	When created
`updated_at`	TIMESTAMP	Last update
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When created in Parable
`system_updated_at`	TIMESTAMP	Last update in Parable

services_plan_people

People scheduled to serve in specific service plans.

Column	Type	Description
`id`	UUID	Internal unique identifier
`plan_person_id`	VARCHAR(64)	Planning Center plan person ID
`plan_id`	VARCHAR(64)	Associated plan
`person_id`	VARCHAR(64)	Associated person
`team_id`	VARCHAR(64)	Associated team
`status`	VARCHAR(20)	Status (C=Confirmed, U=Unconfirmed, D=Declined)
`team_position_name`	VARCHAR(100)	Position/role name
`photo_thumbnail`	VARCHAR(2048)	Person’s photo
`decline_reason`	TEXT	Why declined
`notes`	TEXT	Scheduling notes
`prepare_notification`	BOOLEAN	Whether to send prep notification
`can_accept_partial`	BOOLEAN	Can accept partial scheduling
`notification_sent_at`	TIMESTAMP	When notified
`notification_read_at`	TIMESTAMP	When read notification
`notification_prepared_at`	TIMESTAMP	When notification prepared
`notification_changed_at`	TIMESTAMP	When notification changed
`notification_changed_by_name`	VARCHAR(255)	Who changed notification
`notification_sender_name`	VARCHAR(255)	Who sent notification
`status_updated_at`	TIMESTAMP	When status changed
`scheduled_by_name`	VARCHAR(255)	Who scheduled this person
`created_at`	TIMESTAMP	When created
`updated_at`	TIMESTAMP	Last update
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When created in Parable
`system_updated_at`	TIMESTAMP	Last update in Parable

services_schedules

Individual scheduling records for people across all services.

Column	Type	Description
`id`	UUID	Internal unique identifier
`schedule_id`	VARCHAR(64)	Planning Center schedule ID
`person_id`	VARCHAR(64)	Associated person
`service_type_id`	VARCHAR(64)	Associated service type
`plan_id`	VARCHAR(64)	Associated plan
`team_id`	VARCHAR(64)	Associated team
`organization_name`	VARCHAR(255)	Organization name
`service_type_name`	VARCHAR(255)	Service type name
`team_name`	VARCHAR(255)	Team name
`team_position_name`	VARCHAR(100)	Position name
`person_name`	VARCHAR(255)	Person’s full name
`sort_date`	TIMESTAMP	Date for sorting
`dates`	VARCHAR(255)	Service dates
`short_dates`	VARCHAR(100)	Short date format
`status`	VARCHAR(20)	Schedule status
`decline_reason`	TEXT	Reason if declined
`can_accept_partial`	BOOLEAN	Can accept partial
`can_accept_partial_one_time`	BOOLEAN	One-time partial
`can_rehearse`	BOOLEAN	Available for rehearsal
`plan_visible`	BOOLEAN	Can see plan
`plan_visible_to_me`	BOOLEAN	Plan visible to user
`position_display_times`	VARCHAR(255)	When position shows
`responds_to_name`	VARCHAR(255)	Who responds to
`organization_time_zone`	VARCHAR(100)	Time zone
`organization_twenty_four_hour_time`	BOOLEAN	24-hour format
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When created in Parable
`system_updated_at`	TIMESTAMP	Last update in Parable

services_attachments

Files attached to plans, songs, or other resources.

Column	Type	Description
`id`	UUID	Internal unique identifier
`attachment_id`	VARCHAR(64)	Planning Center attachment ID
`filename`	VARCHAR(255)	File name
`file_size`	BIGINT	Size in bytes
`content_type`	VARCHAR(100)	MIME type
`url`	VARCHAR(2048)	Download URL
`thumbnail_url`	VARCHAR(2048)	Thumbnail URL
`linked_url`	VARCHAR(2048)	External link
`pco_type`	VARCHAR(50)	Planning Center type
`display_name`	VARCHAR(255)	Display name
`filetype`	VARCHAR(50)	File type
`remote_link`	VARCHAR(2048)	Remote file link
`page_order`	VARCHAR(50)	Page ordering
`licenses_purchased`	INTEGER	Number of licenses
`licenses_remaining`	INTEGER	Remaining licenses
`licenses_used`	INTEGER	Used licenses
`allow_mp3_download`	BOOLEAN	MP3 download allowed
`web_streamable`	BOOLEAN	Can stream on web
`downloadable`	BOOLEAN	Can be downloaded
`transposable`	BOOLEAN	Can transpose
`streamable`	BOOLEAN	Can stream
`has_preview`	BOOLEAN	Preview available
`attachable_type`	VARCHAR(50)	What it’s attached to
`attachable_id`	VARCHAR(64)	Parent resource ID
`created_at`	TIMESTAMP	When created
`updated_at`	TIMESTAMP	Last update
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When created in Parable
`system_updated_at`	TIMESTAMP	Last update in Parable

Relationship Tables

services_song_relationships

Links songs to tags and attachments.

Column	Type	Description
`id`	UUID	Internal unique identifier
`song_id`	VARCHAR(64)	Song ID
`relationship_type`	VARCHAR(50)	Type of relationship (Tag, Attachment)
`relationship_id`	VARCHAR(64)	Related entity ID
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_team_relationships

Links teams to service types and parent teams.

Column	Type	Description
`id`	UUID	Internal unique identifier
`team_id`	VARCHAR(64)	Team ID
`relationship_type`	VARCHAR(50)	Type of relationship
`relationship_id`	VARCHAR(64)	Related entity ID
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

Planning & Scheduling

services_plan_person_times

Junction table linking plan people to specific plan times.

Column	Type	Description
`id`	UUID	Internal unique identifier
`plan_person_time_id`	VARCHAR(64)	Planning Center entity ID
`created_at`	TIMESTAMP	When the plan person time was created in Planning Center
`status`	VARCHAR(50)	Status of the person’s availability for this time (accepted, declined, etc.)
`updated_at`	TIMESTAMP	When the plan person time was last updated in Planning Center
`plan_time_id`	VARCHAR(64)	Reference to the plan time
`plan_id`	VARCHAR(64)	Reference to the plan
`plan_person_id`	VARCHAR(64)	Reference to the person scheduled for the plan
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_plan_templates

Templates for creating new service plans with predefined structure.

Column	Type	Description
`id`	UUID	Internal unique identifier
`plan_template_id`	VARCHAR(64)	Planning Center entity ID
`can_view_order`	BOOLEAN	Whether the order of service can be viewed
`created_at`	TIMESTAMP	When the template was created in Planning Center
`item_count`	INTEGER	Number of items in the template
`multi_day`	BOOLEAN	Whether the template spans multiple days
`name`	VARCHAR(255)	Name of the plan template
`note_count`	INTEGER	Number of notes in the template
`prefers_order_view`	BOOLEAN	Whether order view is preferred over schedule view
`rehearsable`	BOOLEAN	Whether the plan can be rehearsed
`team_count`	INTEGER	Number of teams involved in the template
`updated_at`	TIMESTAMP	When the template was last updated in Planning Center
`service_type_id`	VARCHAR(64)	Reference to the service type
`created_by_id`	VARCHAR(64)	Person who created the template
`updated_by_id`	VARCHAR(64)	Person who last updated the template
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_plan_times

Specific times associated with service plans (rehearsals, services, other events).

Column	Type	Description
`id`	UUID	Internal unique identifier
`plan_time_id`	VARCHAR(64)	Planning Center entity ID
`created_at`	TIMESTAMP	When the plan time was created in Planning Center
`ends_at`	TIMESTAMP	When the plan time ends
`live_ends_at`	TIMESTAMP	Actual end time of the live event
`live_starts_at`	TIMESTAMP	Actual start time of the live event
`name`	VARCHAR(255)	Name of the plan time (e.g., “Sunday Morning”, “Saturday Rehearsal”)
`recorded`	BOOLEAN	Whether the plan time was recorded
`starts_at`	TIMESTAMP	When the plan time starts
`team_reminders`	JSONB	Reminder settings for teams
`time_type`	VARCHAR(50)	Type of time (rehearsal, service, other)
`updated_at`	TIMESTAMP	When the plan time was last updated in Planning Center
`assigned_teams`	JSONB	Teams assigned to this plan time
`split_team_rehearsal_assignments`	JSONB	Split team rehearsal assignment details
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_needed_positions

Positions needed for service plans that require scheduling.

Column	Type	Description
`id`	UUID	Internal unique identifier
`needed_position_id`	VARCHAR(64)	Planning Center entity ID
`quantity`	INTEGER	Number of people needed for this position
`scheduled_to`	VARCHAR(255)	Type of time this position is scheduled for
`team_position_name`	VARCHAR(255)	Name of the team position
`team_id`	VARCHAR(64)	Reference to the team
`plan_id`	VARCHAR(64)	Reference to the plan
`time_id`	VARCHAR(64)	Reference to the plan time
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_signup_sheets

Signup sheets for volunteer positions on service plans.

Column	Type	Description
`id`	UUID	Internal unique identifier
`signup_sheet_id`	VARCHAR(64)	Planning Center entity ID
`display_times`	VARCHAR(50)	How times should be displayed on the signup sheet
`group_key`	VARCHAR(64)	Key for grouping related signup sheets
`position_name`	VARCHAR(255)	Name of the position being signed up for
`sort_date`	TIMESTAMP	Date used for sorting signup sheets
`sort_index`	INTEGER	Index for sorting within a group
`team_name`	VARCHAR(255)	Name of the team
`title`	VARCHAR(255)	Title of the signup sheet
`plan_id`	VARCHAR(64)	Reference to the plan
`team_position_id`	VARCHAR(64)	Reference to the team position
`team_id`	VARCHAR(64)	Reference to the team
`scheduled_people`	JSONB	People already scheduled for this position
`signup_sheet_metadata`	JSONB	Additional metadata about the signup sheet
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_signup_sheet_metadata

Metadata about specific times on signup sheets.

Column	Type	Description
`id`	UUID	Internal unique identifier
`signup_sheet_metadata_id`	VARCHAR(64)	Planning Center entity ID
`conflicts`	JSONB	Scheduling conflicts for this time
`ends_at`	TIMESTAMP	When the time period ends
`starts_at`	TIMESTAMP	When the time period starts
`time_name`	VARCHAR(255)	Name of the time period
`time_type`	VARCHAR(255)	Type of time (rehearsal, service, other)
`plan_time_id`	VARCHAR(64)	Reference to the plan time
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_scheduled_people

People scheduled on signup sheets.

Column	Type	Description
`id`	UUID	Internal unique identifier
`scheduled_person_id`	VARCHAR(64)	Planning Center entity ID
`full_name`	VARCHAR(255)	Full name of the scheduled person
`status`	VARCHAR(50)	Status of the person’s signup (confirmed, declined, etc.)
`thumbnail`	VARCHAR(255)	URL to the person’s profile photo thumbnail
`person_id`	VARCHAR(64)	Reference to the person
`signup_sheet_id`	VARCHAR(64)	Reference to the signup sheet
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_available_signups

Available signup opportunities for people in the organization.

Column	Type	Description
`id`	UUID	Internal unique identifier
`available_signup_id`	VARCHAR(64)	Planning Center entity ID
`organization_name`	VARCHAR(255)	Name of the organization
`planning_center_url`	TEXT	URL to view the signup in Planning Center
`service_type_name`	VARCHAR(255)	Name of the service type
`signups_available`	BOOLEAN	Whether signups are currently available
`organization_id`	VARCHAR(64)	Reference to the organization
`person_id`	VARCHAR(64)	Reference to the person
`service_type_id`	VARCHAR(64)	Reference to the service type
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_attendances

Attendance records linking people to plan times through check-ins.

Column	Type	Description
`id`	UUID	Internal unique identifier
`attendance_id`	VARCHAR(64)	Planning Center entity ID
`plan_id`	VARCHAR(64)	Reference to the plan
`check_ins_event_id`	VARCHAR(64)	Reference to the check-ins event
`check_ins_event_period_id`	VARCHAR(64)	Reference to the check-ins event period
`checked_in_at`	TIMESTAMP	When the person checked in
`plan_person_id`	VARCHAR(64)	Reference to the person scheduled for the plan
`plan_time_id`	VARCHAR(64)	Reference to the plan time
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_blockouts

Recurring or one-time blockout periods when people are unavailable.

Column	Type	Description
`id`	UUID	Internal unique identifier
`blockout_id`	VARCHAR(64)	Planning Center entity ID
`created_at`	TIMESTAMP	When the blockout was created in Planning Center
`description`	TEXT	Detailed description of the blockout
`ends_at`	TIMESTAMP	When the blockout period ends
`group_identifier`	VARCHAR(64)	Identifier for grouping related blockouts
`organization_name`	VARCHAR(255)	Name of the organization
`reason`	TEXT	Reason for the blockout
`repeat_frequency`	VARCHAR(255)	How often the blockout repeats
`repeat_interval`	VARCHAR(255)	Interval for repeating blockouts
`repeat_period`	VARCHAR(255)	Period of repetition
`repeat_until`	DATE	Date when the blockout repetition ends
`settings`	VARCHAR(255)	Additional blockout settings
`share`	BOOLEAN	Whether the blockout is shared with schedulers
`starts_at`	TIMESTAMP	When the blockout period begins
`time_zone`	VARCHAR(255)	Time zone for the blockout
`updated_at`	TIMESTAMP	When the blockout was last updated in Planning Center
`person_id`	VARCHAR(64)	Reference to the person with the blockout
`organization_id`	VARCHAR(64)	Reference to the organization
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_blockout_dates

Individual dates within a blockout period.

Column	Type	Description
`id`	UUID	Internal unique identifier
`blockout_date_id`	VARCHAR(64)	Planning Center entity ID
`ends_at`	TIMESTAMP	When the blockout date ends (local time)
`ends_at_utc`	TIMESTAMP	When the blockout date ends (UTC)
`group_identifier`	VARCHAR(64)	Identifier for grouping related blockout dates
`reason`	TEXT	Reason for this specific blockout date
`share`	BOOLEAN	Whether this blockout date is shared with schedulers
`starts_at`	TIMESTAMP	When the blockout date begins (local time)
`starts_at_utc`	TIMESTAMP	When the blockout date begins (UTC)
`time_zone`	VARCHAR(64)	Time zone for the blockout date
`person_id`	VARCHAR(64)	Reference to the person with the blockout
`blockout_id`	VARCHAR(64)	Reference to the parent blockout
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_blockout_exceptions

Exceptions to recurring blockouts (dates when the blockout doesn’t apply).

Column	Type	Description
`id`	UUID	Internal unique identifier
`blockout_exception_id`	VARCHAR(64)	Planning Center entity ID
`created_at`	TIMESTAMP	When the exception was created in Planning Center
`date`	DATE	Date when the blockout exception applies
`updated_at`	TIMESTAMP	When the exception was last updated in Planning Center
`blockout_id`	VARCHAR(64)	Reference to the blockout
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_scheduling_preferences

Scheduling preferences between household members.

Column	Type	Description
`id`	UUID	Internal unique identifier
`scheduling_preference_id`	VARCHAR(64)	Planning Center entity ID
`preference`	VARCHAR(255)	Type of scheduling preference (schedule together, avoid scheduling together, etc.)
`household_member_id`	VARCHAR(64)	Reference to the household member
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_time_preference_options

Available time preference options for scheduling team members.

Column	Type	Description
`id`	UUID	Internal unique identifier
`time_preference_option_id`	VARCHAR(64)	Planning Center entity ID
`created_at`	TIMESTAMP	When the option was created in Planning Center
`day_of_week`	VARCHAR(50)	Day of the week for this preference
`description`	VARCHAR(255)	Description of the time preference
`minute_of_day`	INTEGER	Minute of the day (0-1439) when this time occurs
`sort_index`	VARCHAR(50)	Index for sorting preference options
`starts_at`	TIMESTAMP	When the time preference starts
`time_type`	VARCHAR(50)	Type of time (rehearsal, service, other)
`updated_at`	TIMESTAMP	When the option was last updated in Planning Center
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_live_controllers

People who can control live services.

Column	Type	Description
`id`	UUID	Internal unique identifier
`live_controller_id`	VARCHAR(64)	Planning Center entity ID
`service_type_id`	VARCHAR(64)	Reference to the service type
`created_at`	TIMESTAMP	When the controller was created in Planning Center
`full_name`	VARCHAR(255)	Full name of the controller
`photo_thumbnail_url`	TEXT	URL to the controller’s profile photo thumbnail
`updated_at`	TIMESTAMP	When the controller was last updated in Planning Center
`person_id`	VARCHAR(64)	Reference to the person
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_lives

Live service sessions with control capabilities.

Column	Type	Description
`id`	UUID	Internal unique identifier
`live_id`	VARCHAR(64)	Planning Center entity ID
`plan_id`	VARCHAR(64)	Reference to the plan
`can_chat`	BOOLEAN	Whether chat is enabled for this live session
`can_control`	BOOLEAN	Whether the current user can control the live session
`can_control_video_feed`	BOOLEAN	Whether the current user can control the video feed
`can_take_control`	BOOLEAN	Whether the current user can take control
`chat_room_channel`	VARCHAR(255)	Channel identifier for the chat room
`dates`	VARCHAR(255)	Formatted date(s) for the live session
`live_channel`	VARCHAR(255)	Channel identifier for the live session
`series_title`	VARCHAR(255)	Title of the series
`title`	VARCHAR(255)	Title of the live session
`controller_id`	VARCHAR(64)	Reference to the person controlling the session
`current_item_time_id`	VARCHAR(64)	Reference to the current item time
`items`	JSONB	Items in the live session
`next_item_time_id`	VARCHAR(64)	Reference to the next item time
`service_type_id`	VARCHAR(64)	Reference to the service type
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_series

Service series for grouping related plans.

Column	Type	Description
`id`	UUID	Internal unique identifier
`series_id`	VARCHAR(64)	Planning Center entity ID
`artwork_content_type`	VARCHAR(64)	Content type of the artwork file
`artwork_file_name`	VARCHAR(255)	Original filename of the artwork
`artwork_file_size`	INTEGER	Size of the artwork file in bytes
`artwork_for_dashboard`	TEXT	URL to artwork sized for dashboard
`artwork_for_mobile`	TEXT	URL to artwork sized for mobile devices
`artwork_for_plan`	TEXT	URL to artwork sized for plan view
`artwork_original`	TEXT	URL to original artwork file
`created_at`	TIMESTAMP	When the series was created in Planning Center
`has_artwork`	BOOLEAN	Whether the series has associated artwork
`title`	VARCHAR(255)	Title of the series
`updated_at`	TIMESTAMP	When the series was last updated in Planning Center
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_public_views

Public view settings for service plans.

Column	Type	Description
`id`	UUID	Internal unique identifier
`public_view_id`	VARCHAR(64)	Planning Center entity ID
`amazon`	BOOLEAN	Whether to show Amazon Music links
`headers`	BOOLEAN	Whether to show section headers
`item_lengths`	BOOLEAN	Whether to show item lengths
`itunes`	BOOLEAN	Whether to show iTunes links
`media_items`	BOOLEAN	Whether to show media items
`regular_items`	BOOLEAN	Whether to show regular items
`series_and_plan_titles`	BOOLEAN	Whether to show series and plan titles
`series_artwork`	BOOLEAN	Whether to show series artwork
`service_times`	BOOLEAN	Whether to show service times
`song_items`	BOOLEAN	Whether to show song items
`spotify`	BOOLEAN	Whether to show Spotify links
`vimeo`	BOOLEAN	Whether to show Vimeo links
`youtube`	BOOLEAN	Whether to show YouTube links
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_contributors

People who have contributed to a plan (edits, additions, etc.).

Column	Type	Description
`id`	UUID	Internal unique identifier
`contributor_id`	VARCHAR(64)	Planning Center entity ID
`contributable_action`	VARCHAR(255)	Type of action performed (created, updated, etc.)
`contributable_category`	VARCHAR(255)	Category of contribution
`contributable_type`	VARCHAR(255)	Type of entity contributed to
`created_at`	TIMESTAMP	When the contribution was made
`full_name`	VARCHAR(255)	Full name of the contributor
`photo_thumbnail_url`	TEXT	URL to the contributor’s profile photo thumbnail
`updated_at`	TIMESTAMP	When the contribution was last updated
`plan_id`	VARCHAR(64)	Reference to the plan
`person_id`	VARCHAR(64)	Reference to the person
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_plan_notes

Notes attached to service plans.

Column	Type	Description
`id`	UUID	Internal unique identifier
`plan_note_id`	VARCHAR(64)	Planning Center entity ID
`category_name`	VARCHAR(255)	Name of the note category
`content`	TEXT	Content of the note
`created_at`	TIMESTAMP	When the note was created in Planning Center
`updated_at`	TIMESTAMP	When the note was last updated in Planning Center
`created_by_id`	VARCHAR(64)	Person who created the note
`plan_note_category_id`	VARCHAR(64)	Reference to the note category
`teams`	JSONB	Teams that can view this note
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_plan_note_categories

Categories for organizing plan notes.

Column	Type	Description
`id`	UUID	Internal unique identifier
`plan_note_category_id`	VARCHAR(64)	Planning Center entity ID
`created_at`	TIMESTAMP	When the category was created in Planning Center
`deleted_at`	TIMESTAMP	When the category was deleted in Planning Center
`name`	VARCHAR(255)	Name of the category
`sequence`	INTEGER	Display order for the category
`updated_at`	TIMESTAMP	When the category was last updated in Planning Center
`service_type_id`	VARCHAR(64)	Reference to the service type
`teams`	JSONB	Teams that can use this category
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_item_note_categories

Categories for organizing item notes.

Column	Type	Description
`id`	UUID	Internal unique identifier
`item_note_category_id`	VARCHAR(64)	Planning Center entity ID
`created_at`	TIMESTAMP	When the category was created in Planning Center
`deleted_at`	TIMESTAMP	When the category was deleted in Planning Center
`frequently_used`	BOOLEAN	Whether this category is frequently used
`name`	VARCHAR(255)	Name of the category
`sequence`	INTEGER	Display order for the category
`updated_at`	TIMESTAMP	When the category was last updated in Planning Center
`service_type_id`	VARCHAR(64)	Reference to the service type
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

Team Management

services_team_positions

Positions within service teams.

Column	Type	Description
`id`	UUID	Internal unique identifier
`team_position_id`	VARCHAR(64)	Planning Center entity ID
`name`	VARCHAR(255)	Name of the position
`negative_tag_groups`	JSONB	Tag groups that exclude people from this position
`sequence`	INTEGER	Display order for the position
`tag_groups`	JSONB	Tag groups required for this position
`tags`	JSONB	Tags associated with this position
`team_id`	VARCHAR(64)	Reference to the team
`attachment_types`	JSONB	Types of attachments allowed for this position
`tag_ids`	JSONB	IDs of tags associated with this position
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_person_team_position_assignments

Assignments of people to specific team positions.

Column	Type	Description
`id`	UUID	Internal unique identifier
`person_team_position_assignment_id`	VARCHAR(64)	Planning Center entity ID
`created_at`	TIMESTAMP	When the assignment was created in Planning Center
`preferred_weeks`	VARCHAR(255)[]	Array of preferred week frequencies
`schedule_preference`	VARCHAR(50)	Scheduling preference for this assignment
`updated_at`	TIMESTAMP	When the assignment was last updated in Planning Center
`person_id`	VARCHAR(64)	Reference to the person
`team_position_id`	VARCHAR(64)	Reference to the team position
`time_preference_options`	JSONB	Preferred times for this assignment
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_team_leaders

Leaders assigned to service teams.

Column	Type	Description
`id`	UUID	Internal unique identifier
`team_leader_id`	VARCHAR(64)	Planning Center entity ID
`send_responses_for_accepts`	BOOLEAN	Whether to send notifications when people accept
`send_responses_for_blockouts`	BOOLEAN	Whether to send notifications about blockouts
`send_responses_for_declines`	BOOLEAN	Whether to send notifications when people decline
`person_id`	VARCHAR(64)	Reference to the person who is the team leader
`team_id`	VARCHAR(64)	Reference to the team
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_split_team_rehearsal_assignments

Rehearsal time assignments for split teams.

Column	Type	Description
`id`	UUID	Internal unique identifier
`split_team_rehearsal_assignment_id`	VARCHAR(64)	Planning Center entity ID
`schedule_special_service_times`	BOOLEAN	Whether to schedule special service times
`team_id`	VARCHAR(64)	Reference to the team
`time_preference_options`	JSONB	Time preferences for this assignment
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

Song & Music Management

services_arrangement_sections

Sections within song arrangements (verse, chorus, bridge, etc.).

Column	Type	Description
`id`	UUID	Internal unique identifier
`arrangement_section_id`	VARCHAR(64)	Planning Center entity ID
`sections`	JSONB	Array of section definitions with names and content
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_keys

Musical keys associated with song arrangements.

Column	Type	Description
`id`	UUID	Internal unique identifier
`key_id`	VARCHAR(64)	Planning Center entity ID
`alternate_keys`	JSONB	Alternative keys for this arrangement
`created_at`	TIMESTAMP	When the key was created in Planning Center
`ending_key`	VARCHAR(13)	Musical key at the end of the song
`ending_minor`	BOOLEAN	Whether the ending key is minor
`name`	VARCHAR(255)	Display name for the key
`starting_key`	VARCHAR(3)	Musical key at the start of the song
`starting_minor`	BOOLEAN	Whether the starting key is minor
`updated_at`	TIMESTAMP	When the key was last updated in Planning Center
`arrangement_id`	VARCHAR(64)	Reference to the arrangement
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_song_schedules

Schedule information for when songs are used in plans.

Column	Type	Description
`id`	UUID	Internal unique identifier
`song_schedule_id`	VARCHAR(64)	Planning Center entity ID
`arrangement_name`	VARCHAR(255)	Name of the arrangement used
`key_name`	VARCHAR(3)	Musical key used
`plan_dates`	VARCHAR(50)	Formatted dates when the song is scheduled
`plan_sort_date`	TIMESTAMP	Date used for sorting song schedules
`service_type_name`	VARCHAR(255)	Name of the service type
`arrangement_id`	VARCHAR(64)	Reference to the arrangement
`key_id`	VARCHAR(64)	Reference to the key
`plan_id`	VARCHAR(64)	Reference to the plan
`service_type_id`	VARCHAR(64)	Reference to the service type
`item_id`	VARCHAR(64)	Reference to the plan item
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_song_attachments

Junction table linking songs to their attachments.

Column	Type	Description
`id`	UUID	Internal unique identifier
`song_id`	VARCHAR(64)	Reference to the song
`attachment_id`	VARCHAR(64)	Reference to the attachment
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_song_tags

Junction table linking songs to their tags.

Column	Type	Description
`id`	UUID	Internal unique identifier
`song_id`	VARCHAR(64)	Reference to the song
`tag_id`	VARCHAR(64)	Reference to the tag
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_media

Media items (videos, images, audio) used in services.

Column	Type	Description
`id`	UUID	Internal unique identifier
`media_id`	VARCHAR(64)	Planning Center entity ID
`created_at`	TIMESTAMP	When the media was created in Planning Center
`creator_name`	VARCHAR(255)	Name of the person who created the media
`image_url`	TEXT	URL to the media image
`length`	INTEGER	Length of the media in seconds
`media_type`	VARCHAR(255)	Type of media (video, image, audio)
`media_type_name`	VARCHAR(255)	Display name for the media type
`preview_content_type`	VARCHAR(255)	Content type of the preview file
`preview_file_name`	TEXT	Filename of the preview
`preview_file_size`	INTEGER	Size of the preview file in bytes
`preview_updated_at`	TIMESTAMP	When the preview was last updated
`preview_url`	TEXT	URL to the preview file
`themes`	VARCHAR(255)	Themes associated with the media
`thumbnail_content_type`	VARCHAR(255)	Content type of the thumbnail
`thumbnail_file_name`	TEXT	Filename of the thumbnail
`thumbnail_file_size`	INTEGER	Size of the thumbnail file in bytes
`thumbnail_updated_at`	TIMESTAMP	When the thumbnail was last updated
`thumbnail_url`	TEXT	URL to the thumbnail
`title`	TEXT	Title of the media
`updated_at`	TIMESTAMP	When the media was last updated in Planning Center
`attachments`	JSONB	Attachments associated with this media
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_media_schedules

Schedule information for when media is used in plans.

Column	Type	Description
`id`	UUID	Internal unique identifier
`media_schedule_id`	VARCHAR(64)	Planning Center entity ID
`media_id`	VARCHAR(64)	Reference to the media
`plan_dates`	VARCHAR(255)	Formatted dates when the media is scheduled
`plan_short_dates`	VARCHAR(255)	Short formatted dates
`plan_sort_date`	TIMESTAMP	Date used for sorting media schedules
`service_type_name`	VARCHAR(255)	Name of the service type
`plan_id`	VARCHAR(64)	Reference to the plan
`service_type_id`	VARCHAR(64)	Reference to the service type
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

Communication & Notifications

services_email_templates

Templates for automated emails sent from Planning Center Services.

Column	Type	Description
`id`	UUID	Internal unique identifier
`email_template_id`	VARCHAR(64)	Planning Center entity ID
`created_at`	TIMESTAMP	When the template was created in Planning Center
`html_body`	TEXT	HTML content of the email template
`kind`	VARCHAR(255)	Type of email template (schedule request, reminder, etc.)
`subject`	VARCHAR(255)	Subject line for the email
`updated_at`	TIMESTAMP	When the template was last updated in Planning Center
`template_owner_id`	VARCHAR(64)	Reference to the owner of the template
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_emails

Email addresses associated with people in Services.

Column	Type	Description
`id`	UUID	Internal unique identifier
`email_id`	VARCHAR(64)	Planning Center entity ID
`address`	VARCHAR(255)	Email address
`is_primary`	BOOLEAN	Whether this is the person’s primary email
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_phone_numbers

Phone numbers associated with people in Services.

Column	Type	Description
`id`	UUID	Internal unique identifier
`phone_number_id`	VARCHAR(64)	Planning Center entity ID
`carrier`	VARCHAR(255)	Mobile carrier name
`created_at`	TIMESTAMP	When the phone number was created in Planning Center
`location`	VARCHAR(255)	Type of phone number (mobile, home, work)
`number`	VARCHAR(255)	Phone number
`primary_number`	BOOLEAN	Whether this is the person’s primary phone number
`updated_at`	TIMESTAMP	When the phone number was last updated in Planning Center
`e164`	VARCHAR(255)	Phone number in E.164 format
`person_id`	VARCHAR(64)	Reference to the person
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_text_settings

Text messaging settings for people in Services.

Column	Type	Description
`id`	UUID	Internal unique identifier
`text_setting_id`	VARCHAR(64)	Planning Center entity ID
`carrier`	VARCHAR(64)	Mobile carrier name
`display_number`	VARCHAR(64)	Formatted phone number for display
`general_emails_enabled`	BOOLEAN	Whether general email notifications are enabled
`normalized_number`	VARCHAR(64)	Normalized phone number
`reminders_enabled`	BOOLEAN	Whether reminder texts are enabled
`scheduling_replies_enabled`	BOOLEAN	Whether scheduling reply texts are enabled
`scheduling_requests_enabled`	BOOLEAN	Whether scheduling request texts are enabled
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

Administration & Settings

services_organizations

Organization-wide settings for Planning Center Services.

Column	Type	Description
`id`	UUID	Internal unique identifier
`organization_id`	VARCHAR(64)	Planning Center entity ID
`allow_mp3_download`	BOOLEAN	Whether MP3 downloads are allowed
`calendar_starts_on_sunday`	BOOLEAN	Whether the calendar week starts on Sunday
`ccli`	VARCHAR(64)	CCLI license number
`ccli_auto_reporting_enabled`	BOOLEAN	Whether automatic CCLI reporting is enabled
`ccli_connected`	BOOLEAN	Whether CCLI integration is connected
`ccli_reporting_enabled`	BOOLEAN	Whether CCLI reporting is enabled
`created_at`	TIMESTAMP	When the organization was created in Planning Center
`date_format`	VARCHAR(64)	Preferred date format
`extra_file_storage_allowed`	BOOLEAN	Whether extra file storage is allowed
`file_storage_exceeded`	BOOLEAN	Whether file storage limit has been exceeded
`file_storage_extra_charges`	DOUBLE PRECISION	Extra charges for file storage
`file_storage_extra_enabled`	BOOLEAN	Whether extra file storage is enabled
`file_storage_size`	BIGINT	Total file storage size in bytes
`file_storage_size_used`	BIGINT	Used file storage size in bytes
`legacy_id`	VARCHAR(64)	Legacy organization identifier
`music_stand_enabled`	BOOLEAN	Whether Music Stand app is enabled
`name`	VARCHAR(255)	Organization name
`owner_name`	VARCHAR(255)	Name of the organization owner
`people_allowed`	INTEGER	Number of people allowed in the organization
`people_remaining`	INTEGER	Number of people slots remaining
`projector_enabled`	BOOLEAN	Whether projector features are enabled
`rehearsal_mix_enabled`	BOOLEAN	Whether rehearsal mix features are enabled
`rehearsal_pack_connected`	BOOLEAN	Whether Rehearsal Pack is connected
`required_to_set_download_permission`	VARCHAR(255)	Download permission requirements
`secret`	VARCHAR(255)	Organization secret key
`time_zone`	VARCHAR(255)	Organization time zone
`twenty_four_hour_time`	BOOLEAN	Whether to use 24-hour time format
`updated_at`	TIMESTAMP	When the organization was last updated in Planning Center
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_folders

Folders for organizing service plans and songs.

Column	Type	Description
`id`	UUID	Internal unique identifier
`folder_id`	VARCHAR(64)	Planning Center entity ID
`container`	VARCHAR(255)	Type of items this folder contains
`created_at`	TIMESTAMP	When the folder was created in Planning Center
`name`	VARCHAR(255)	Name of the folder
`updated_at`	TIMESTAMP	When the folder was last updated in Planning Center
`ancestors`	JSONB	Parent folders in the hierarchy
`parent`	VARCHAR(64)	Reference to the parent folder
`campus`	VARCHAR(64)	Reference to the campus
`service_types`	JSONB	Service types associated with this folder
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_tags

Tags for categorizing songs, people, and other entities.

Column	Type	Description
`id`	UUID	Internal unique identifier
`tag_id`	VARCHAR(64)	Planning Center entity ID
`name`	VARCHAR(255)	Name of the tag
`tag_group_id`	VARCHAR(64)	Reference to the tag group
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_tag_groups

Groups for organizing related tags.

Column	Type	Description
`id`	UUID	Internal unique identifier
`tag_group_id`	VARCHAR(64)	Planning Center entity ID
`allow_multiple_selections`	BOOLEAN	Whether multiple tags from this group can be selected
`name`	VARCHAR(255)	Name of the tag group
`required`	BOOLEAN	Whether a tag from this group is required
`service_type_folder_name`	VARCHAR(255)	Associated service type folder name
`tags_for`	VARCHAR(255)	What type of entity these tags apply to
`folder_id`	VARCHAR(64)	Reference to the folder
`tags`	JSONB	Tags within this group
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_attachment_type_groups

Groups for organizing attachment types.

Column	Type	Description
`id`	UUID	Internal unique identifier
`attachment_type_group_id`	VARCHAR(64)	Planning Center entity ID
`name`	VARCHAR(255)	Name of the attachment type group
`readonly`	BOOLEAN	Whether this group is read-only (system-defined)
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_attachment_types

Types of attachments that can be associated with plans, songs, and other entities.

Column	Type	Description
`id`	UUID	Internal unique identifier
`attachment_type_id`	VARCHAR(64)	Planning Center entity ID
`aliases`	TEXT[]	Alternative names for this attachment type
`built_in`	BOOLEAN	Whether this is a built-in (system-defined) type
`capoed_chord_charts`	BOOLEAN	Whether to show capoed chord charts
`chord_charts`	BOOLEAN	Whether chord charts are enabled
`exclusions`	TEXT[]	File types to exclude
`lyrics`	BOOLEAN	Whether lyrics are enabled
`name`	VARCHAR(255)	Name of the attachment type
`number_charts`	BOOLEAN	Whether number charts are enabled
`numeral_charts`	BOOLEAN	Whether numeral charts are enabled
`attachment_type_group_id`	VARCHAR(64)	Reference to the attachment type group
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

services_report_templates

Templates for generating reports.

Column	Type	Description
`id`	UUID	Internal unique identifier
`report_template_id`	VARCHAR(64)	Planning Center entity ID
`body`	TEXT	Template body content
`is_default`	BOOLEAN	Whether this is the default template for its type
`title`	VARCHAR(255)	Title of the report template
`type`	VARCHAR(50)	Type of report (plan, item, etc.)
`tenant_organization_id`	INTEGER	Organization identifier
`system_status`	VARCHAR(50)	Data status
`system_created_at`	TIMESTAMP	When record was created in Parable
`system_updated_at`	TIMESTAMP	When record was last updated in Parable

Data Relationships

Key Relationships

Service Planning Hierarchy
- Service Types → Plans → Items
- Plans → Plan Times → Plan People
Team Structure
- Teams → Team Positions → Person Team Position Assignments
- Teams → Plan People → Schedules
Song Management
- Songs → Arrangements → Items
- Songs → Attachments (chord charts, lead sheets)
Scheduling Flow
- People → Schedules → Plan People
- People → Blockouts → Blockout Dates
Resource Attachments
- Plans → Attachments
- Songs → Attachments
- Items → Media

Query Patterns

Finding Scheduled Volunteers

SELECT
    pp.person_id,
    p.full_name,
    pp.team_position_name,
    pl.title as plan_title,
    pl.sort_date
FROM planning_center.services_plan_people pp
JOIN planning_center.services_people p ON pp.person_id = p.person_id
JOIN planning_center.services_plans pl ON pp.plan_id = pl.plan_id
WHERE pp.status = 'C'  -- Confirmed
    AND pl.sort_date >= CURRENT_DATE
ORDER BY pl.sort_date, p.full_name;

Analyzing Song Usage

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
GROUP BY s.song_id, s.title, s.author
ORDER BY times_used DESC;

Data Integrity Rules

Schema Qualification: Always use planning_center. prefix for all table references
Row Level Security: RLS automatically handles multi-tenancy and status filtering - do not add manual filters
Monetary Values: Any cost or fee columns are stored in cents - divide by 100.0 for display
Scheduling Status Flags: Use fields like status and decline_reason to interpret plan assignments instead of checking system_status
Direct ID Columns: Core tables such as services_plans and services_plan_people expose direct IDs for performance-sensitive joins

Common Mistakes to Avoid

Missing Schema Prefix
- ❌ FROM services_plan_people
- ✅ FROM planning_center.services_plan_people
Adding Redundant RLS Filters
- ❌ WHERE tenant_organization_id = 1 AND system_status = 'active'
- ✅ Trust RLS to handle this automatically
Joining Without Schema
- ❌ JOIN services_people p ON ...
- ✅ JOIN planning_center.services_people p ON ...
Forgetting Duration Conversion
- ❌ SELECT duration_seconds as minutes
- ✅ SELECT duration_seconds / 60.0 as minutes

Performance Considerations

Indexes: All tables have optimized indexes on:
- Primary keys and entity IDs
- Join columns and foreign keys
- Date columns for time-based queries
Query Optimization:
- Always use the planning_center. schema prefix
- RLS handles tenant and status filtering automatically
- Filter scheduling status or declined responses when relevant
- Consider CTEs for complex aggregations
- Use direct ID columns when available instead of relationship tables

Data Synchronization

All Services tables use the standard Parable synchronization pattern:

system_status: Tracks data lifecycle (‘transferring’ → ‘active’ → ‘stale’)
system_created_at: When record entered Parable
system_updated_at: Last Parable update
created_at/updated_at: Original Planning Center timestamps

Notes

Status codes often use single letters: C=Confirmed, U=Unconfirmed, D=Declined
All timestamps are stored in UTC
JSONB fields store complex nested data structures
File URLs may expire based on files_expire_at timestamps
Person records link to the main People app for complete profiles

​Services Data Model

​Overview

​Visual Data Model

​Core Entity Relationships

​Key Relationships Explained

​Query Requirements

​Schema Prefix

​Row Level Security (RLS)

​Core Tables Overview

​Primary Entity Tables

​Supporting Entity Tables

​Relationship Tables

​Table Definitions

​services_service_types

​services_plans

​services_teams

​services_people

​services_songs

​services_arrangements

​services_items

​services_plan_people

​services_schedules

​services_attachments

​Relationship Tables

​services_song_relationships

​services_team_relationships

​Planning & Scheduling

​services_plan_person_times

​services_plan_templates

​services_plan_times

​services_needed_positions

​services_signup_sheets

​services_signup_sheet_metadata

​services_scheduled_people

​services_available_signups

​services_attendances

​services_blockouts

​services_blockout_dates

​services_blockout_exceptions

​services_scheduling_preferences

​services_time_preference_options

​services_live_controllers

​services_lives

​services_series

​services_public_views

​services_contributors

​services_plan_notes

​services_plan_note_categories

​services_item_note_categories

​Team Management

​services_team_positions

​services_person_team_position_assignments

​services_team_leaders

​services_split_team_rehearsal_assignments

​Song & Music Management

​services_arrangement_sections

​services_keys

​services_song_schedules

​services_song_attachments

​services_song_tags

​services_media

​services_media_schedules

​Communication & Notifications

​services_email_templates

​services_emails

​services_phone_numbers

​services_text_settings

​Administration & Settings

​services_organizations

​services_folders

​services_tags

​services_tag_groups

​services_attachment_type_groups

​services_attachment_types

​services_report_templates

​Data Relationships

​Key Relationships

​Query Patterns

​Finding Scheduled Volunteers

​Analyzing Song Usage

Services Data Model

Overview

Visual Data Model

Core Entity Relationships

Key Relationships Explained

Query Requirements

Schema Prefix

Row Level Security (RLS)

Core Tables Overview

Primary Entity Tables

Supporting Entity Tables

Relationship Tables

Table Definitions

services_service_types

services_plans

services_teams

services_people

services_songs

services_arrangements

services_items

services_plan_people

services_schedules

services_attachments

Relationship Tables

services_song_relationships

services_team_relationships

Planning & Scheduling

services_plan_person_times

services_plan_templates

services_plan_times

services_needed_positions

services_signup_sheets

services_signup_sheet_metadata

services_scheduled_people

services_available_signups

services_attendances

services_blockouts

services_blockout_dates

services_blockout_exceptions

services_scheduling_preferences

services_time_preference_options

services_live_controllers

services_lives

services_series

services_public_views

services_contributors

services_plan_notes

services_plan_note_categories

services_item_note_categories

Team Management

services_team_positions

services_person_team_position_assignments

services_team_leaders

services_split_team_rehearsal_assignments

Song & Music Management

services_arrangement_sections

services_keys

services_song_schedules

services_song_attachments

services_song_tags

services_media

services_media_schedules

Communication & Notifications

services_email_templates

services_emails

services_phone_numbers

services_text_settings

Administration & Settings

services_organizations

services_folders

services_tags

services_tag_groups

services_attachment_type_groups

services_attachment_types

services_report_templates

Data Relationships

Key Relationships

Query Patterns

Finding Scheduled Volunteers

Analyzing Song Usage