Spartan Plumbing business operations, job types, material patterns, pricing targets, crew capabilities. Load when making business logic decisions or building features for the field team.
WHERE bu.name ILIKE '%replacement%' OR bu.name ILIKE '%whole house%'
{customer-name-slug}--{random-id}-{st_location_id} NEVER search by job_id. Always get st_location_id from st_jobs_v2, then search bookmark_tracked_channels with LIKE '%-{location_id}'