Maudfer

SET search_path TO raw, public;
BEGIN;

-- Patients (omit generated cols like id, phone_number_digits, en_weighted_name_search)
INSERT INTO raw.patient (mrn, dob, first_name, last_name, phone_number, zipcode, email, org_id)
VALUES
  ('ACM-PT-0001', '1989-04-12', 'Jordan', 'Michaels', '+14155550187', '94107', 'jordan.michaels+demo@clarityrcm.com', 1),
  ('LOO-PT-0001', '1992-09-30', 'Avery', 'Lopez', '+13105550123', '90012', 'avery.lopez+demo@clarityrcm.com', 2)
ON CONFLICT DO NOTHING;