-- Batch: Client/Patient forms migrated from larcareservices.com/portal (Zoho Forms)
-- into ABOS web forms. Idempotent (guarded by form_key/field_key existence), additive only.
-- Deploy: mysql -u root -p db_abos_v0.1 < db/larcare_forms_seed_client_patient.sql

USE db_abos_v0.1;

SET @larcare_site_id = (SELECT id FROM dim_web_sites WHERE primary_domain = 'larcareservices.com' LIMIT 1);
SET @larcare_tenant_id = (SELECT tenant_id FROM dim_web_sites WHERE id = @larcare_site_id);
SET @larcare_business_id = (SELECT business_id FROM dim_web_sites WHERE id = @larcare_site_id);

-- ---- Patient Information and Intake Form ----
INSERT INTO dim_web_forms (tenant_id, business_id, site_id, form_key, name, success_message, is_active)
SELECT @larcare_tenant_id, @larcare_business_id, @larcare_site_id, 'patient-intake',
       'Patient Information and Intake Form', 'Thank you — the patient intake information has been submitted.', 1
WHERE @larcare_site_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_forms WHERE site_id = @larcare_site_id AND form_key = 'patient-intake');

SET @patient_intake_id = (SELECT id FROM dim_web_forms WHERE site_id = @larcare_site_id AND form_key = 'patient-intake');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @patient_intake_id AS a, 'location' AS b, 'Location' AS c, 'select' AS d, 1 AS e, 1 AS f, '{"options": ["Chester, South Carolina - 178 Columbia St.", "Hopewell, Virginia - 2304 Freeman St.", "SamariCare/Williamsburg - 710 Queensbury Lane", "St. Thomas, Virgin Islands"]}' AS g) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'location');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @patient_intake_id AS a, 'clientStage' AS b, 'Client Stage' AS c, 'select' AS d, 0 AS e, 2 AS f, '{"options": ["Prospect", "New Patient Onboarding", "Active Current Patient", "Update a Current Patient", "OffBoarding / Closeout of a Current Patient"]}' AS g) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'clientStage');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'patientFirstName' AS b, 'Patient First Name' AS c, 'text' AS d, 1 AS e, 3 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'patientFirstName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'patientLastName' AS b, 'Patient Last Name' AS c, 'text' AS d, 1 AS e, 4 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'patientLastName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'patientEmail' AS b, 'Patient Email / Point of Contact / Next of Kin Email' AS c, 'email' AS d, 1 AS e, 5 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'patientEmail');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @patient_intake_id AS a, 'patientType' AS b, 'Patient Type or Classification' AS c, 'select' AS d, 0 AS e, 6 AS f, '{"options": ["Veteran", "Private Insurance", "Out of Pocket/Personal Pay", "Other state type", "Other federal type", "Medicare", "Medicaid", "Medicaid Retro Coverage", "Grant", "Other"]}' AS g) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'patientType');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'cltcNumber' AS b, 'CLTC#' AS c, 'text' AS d, 0 AS e, 7 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'cltcNumber');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @patient_intake_id AS a, 'grantOption' AS b, 'Grant Options (if applicable)' AS c, 'select' AS d, 0 AS e, 8 AS f, '{"options": ["Catawba", "Central Midlands", "Other"]}' AS g) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'grantOption');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @patient_intake_id AS a, 'privateInsuranceName' AS b, 'Private Insurance Name' AS c, 'select' AS d, 0 AS e, 9 AS f, '{"options": ["Humana", "United HealthCare", "Cigna", "Blue Cross Blue Shield", "Medicare", "Catawba", "Other"]}' AS g) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'privateInsuranceName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @patient_intake_id AS a, 'additionalIdType' AS b, 'Additional Identification Number Type' AS c, 'select' AS d, 0 AS e, 10 AS f, '{"options": ["Any Unique Identifying Number", "CLTC Number", "Claim Number", "Group Number or ID", "N/A", "Other Medical Number", "Revenue Code", "Social Security Number", "Other"]}' AS g) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'additionalIdType');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'additionalIdNumber' AS b, 'Additional Identification Number' AS c, 'text' AS d, 0 AS e, 11 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'additionalIdNumber');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'patientSsn' AS b, 'Patient ID / Social Security Number' AS c, 'text' AS d, 0 AS e, 12 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'patientSsn');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'patientPhone' AS b, 'Patient Best Phone Number' AS c, 'tel' AS d, 1 AS e, 13 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'patientPhone');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'pointOfContactPhone' AS b, 'Point of Contact Phone Number' AS c, 'tel' AS d, 0 AS e, 14 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'pointOfContactPhone');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'birthDate' AS b, 'Birth Date' AS c, 'date' AS d, 1 AS e, 15 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'birthDate');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'patientAge' AS b, 'Patient Age' AS c, 'number' AS d, 0 AS e, 16 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'patientAge');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'addressStreet' AS b, 'Street Address' AS c, 'text' AS d, 1 AS e, 17 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'addressStreet');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'addressCity' AS b, 'City' AS c, 'text' AS d, 1 AS e, 18 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'addressCity');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'addressState' AS b, 'State/Region/Province' AS c, 'text' AS d, 1 AS e, 19 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'addressState');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'addressZip' AS b, 'Postal / Zip Code' AS c, 'text' AS d, 0 AS e, 20 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'addressZip');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @patient_intake_id AS a, 'gender' AS b, 'Gender' AS c, 'select' AS d, 1 AS e, 21 AS f, '{"options": ["Female", "Male", "Did not Disclose"]}' AS g) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'gender');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @patient_intake_id AS a, 'maritalStatus' AS b, 'Marital Status' AS c, 'select' AS d, 1 AS e, 22 AS f, '{"options": ["Single", "Married", "Divorced", "Separated", "Widowed"]}' AS g) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'maritalStatus');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'serviceInfoHeading' AS b, 'Service Information' AS c, 'heading' AS d, 0 AS e, 23 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'serviceInfoHeading');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'provider' AS b, 'Provider' AS c, 'text' AS d, 1 AS e, 24 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'provider');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @patient_intake_id AS a, 'personalCareLevel' AS b, 'Personal Care Level of Service' AS c, 'select' AS d, 1 AS e, 25 AS f, '{"options": ["Personal Care hours", "Companion Care hours", "N/A Not Applicable"]}' AS g) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'personalCareLevel');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @patient_intake_id AS a, 'procedureCode' AS b, 'Procedure Code' AS c, 'select' AS d, 1 AS e, 26 AS f, '{"options": ["S5130", "T1019", "N/A Not Applicable", "Other"]}' AS g) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'procedureCode');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @patient_intake_id AS a, 'careHoursType' AS b, 'Care Hours Type' AS c, 'select' AS d, 0 AS e, 27 AS f, '{"options": ["Personal Care hours", "Companion care hours", "Authorized hours", "Other hours"]}' AS g) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'careHoursType');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'careHoursTotal' AS b, 'Total Hours Allotted' AS c, 'number' AS d, 0 AS e, 28 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'careHoursTotal');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'totalWeeklyHours' AS b, 'Total Service Hours Weekly' AS c, 'number' AS d, 0 AS e, 29 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'totalWeeklyHours');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'serviceDays' AS b, 'Service Day(s)' AS c, 'text' AS d, 0 AS e, 30 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'serviceDays');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @patient_intake_id AS a, 'servicePreferredTime' AS b, 'Service Hours Preferred Time' AS c, 'select' AS d, 0 AS e, 31 AS f, '{"options": ["Morning", "Afternoon", "Evening", "Overnight"]}' AS g) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'servicePreferredTime');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'careStartDate' AS b, 'Personal Care Start Date' AS c, 'date' AS d, 0 AS e, 32 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'careStartDate');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'careEndDate' AS b, 'End Date (if applicable)' AS c, 'date' AS d, 0 AS e, 33 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'careEndDate');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'terminationReason' AS b, 'Termination Reason (if applicable)' AS c, 'text' AS d, 0 AS e, 34 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'terminationReason');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'assignedAideFirstName' AS b, 'Assigned Home Health Aide First Name' AS c, 'text' AS d, 0 AS e, 35 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'assignedAideFirstName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'assignedAideLastName' AS b, 'Assigned Home Health Aide Last Name' AS c, 'text' AS d, 0 AS e, 36 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'assignedAideLastName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'nurseFirstName' AS b, 'Nurse First Name' AS c, 'text' AS d, 1 AS e, 37 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'nurseFirstName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'nurseLastName' AS b, 'Nurse Last Name' AS c, 'text' AS d, 1 AS e, 38 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'nurseLastName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'caseWorkerHeading' AS b, 'Case Worker Information' AS c, 'heading' AS d, 0 AS e, 39 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'caseWorkerHeading');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'caseWorkerFirstName' AS b, 'Case Worker First Name' AS c, 'text' AS d, 0 AS e, 40 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'caseWorkerFirstName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'caseWorkerLastName' AS b, 'Case Worker Last Name' AS c, 'text' AS d, 0 AS e, 41 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'caseWorkerLastName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'caseWorkerPhone' AS b, 'Case Worker Phone Number' AS c, 'tel' AS d, 0 AS e, 42 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'caseWorkerPhone');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'emergencyContactHeading' AS b, 'Emergency Contact Information' AS c, 'heading' AS d, 0 AS e, 43 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'emergencyContactHeading');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'emergencyContactFirstName' AS b, 'Emergency Contact First Name' AS c, 'text' AS d, 0 AS e, 44 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'emergencyContactFirstName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'emergencyContactLastName' AS b, 'Emergency Contact Last Name' AS c, 'text' AS d, 0 AS e, 45 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'emergencyContactLastName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'emergencyContactAddress' AS b, 'Emergency Contact Address' AS c, 'text' AS d, 1 AS e, 46 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'emergencyContactAddress');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'emergencyContactRelationship' AS b, 'Emergency Contact Relationship' AS c, 'text' AS d, 1 AS e, 47 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'emergencyContactRelationship');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'emergencyContactPhone' AS b, 'Emergency Contact Phone Number' AS c, 'tel' AS d, 0 AS e, 48 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'emergencyContactPhone');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'otherInfoHeading' AS b, 'Other Information' AS c, 'heading' AS d, 0 AS e, 49 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'otherInfoHeading');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @patient_intake_id AS a, 'legalStatus' AS b, 'Legal Status' AS c, 'select' AS d, 0 AS e, 50 AS f, '{"options": ["Responsible for self", "Power of attorney", "Guardian", "DNR"]}' AS g) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'legalStatus');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'medicalContactHeading' AS b, 'Medical Contact Information' AS c, 'heading' AS d, 0 AS e, 51 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'medicalContactHeading');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'pcpFirstName' AS b, 'Primary Care Physician First Name' AS c, 'text' AS d, 0 AS e, 52 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'pcpFirstName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'pcpLastName' AS b, 'Primary Care Physician Last Name' AS c, 'text' AS d, 0 AS e, 53 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'pcpLastName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'pcpPhone' AS b, 'Physician Telephone' AS c, 'tel' AS d, 0 AS e, 54 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'pcpPhone');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'hospitalNameAddress' AS b, 'Hospital Name and Address' AS c, 'text' AS d, 0 AS e, 55 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'hospitalNameAddress');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'hospitalPhone' AS b, 'Hospital Telephone' AS c, 'tel' AS d, 0 AS e, 56 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'hospitalPhone');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'specialistFirstName' AS b, 'Specialist Physician First Name' AS c, 'text' AS d, 0 AS e, 57 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'specialistFirstName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'specialistLastName' AS b, 'Specialist Physician Last Name' AS c, 'text' AS d, 0 AS e, 58 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'specialistLastName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'specialistPhone' AS b, 'Specialist Telephone' AS c, 'tel' AS d, 0 AS e, 59 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'specialistPhone');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'specialistHospitalAddress' AS b, 'Specialist Hospital Name and Address' AS c, 'text' AS d, 0 AS e, 60 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'specialistHospitalAddress');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'specialistHospitalPhone' AS b, 'Specialist Hospital Telephone' AS c, 'tel' AS d, 0 AS e, 61 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'specialistHospitalPhone');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'dateServiceBegin' AS b, 'Date Service Begin' AS c, 'date' AS d, 1 AS e, 62 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'dateServiceBegin');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'initialSiteVisitDate' AS b, 'Initial Site Visit Date' AS c, 'date' AS d, 0 AS e, 63 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'initialSiteVisitDate');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'ninetyDayVisitDate' AS b, '90 Day Visit Date' AS c, 'date' AS d, 0 AS e, 64 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'ninetyDayVisitDate');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'sixtyDayVisit1Date' AS b, '60 Day Visit 1 Date' AS c, 'date' AS d, 0 AS e, 65 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'sixtyDayVisit1Date');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'sixtyDayVisit2Date' AS b, '60 Day Visit 2 Date' AS c, 'date' AS d, 0 AS e, 66 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'sixtyDayVisit2Date');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @patient_intake_id AS a, 'visitType' AS b, 'Type of Visit' AS c, 'select' AS d, 1 AS e, 67 AS f, '{"options": ["Initial site visit", "90 day site visit", "60 day site visit", "30 day site visit", "Wellness/Emergency check"]}' AS g) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'visitType');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'intakeAdminFirstName' AS b, 'Name of Admin Doing Intake - First Name' AS c, 'text' AS d, 0 AS e, 68 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'intakeAdminFirstName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'intakeAdminLastName' AS b, 'Name of Admin Doing Intake - Last Name' AS c, 'text' AS d, 0 AS e, 69 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'intakeAdminLastName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'intakeDate' AS b, 'Date' AS c, 'date' AS d, 1 AS e, 70 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'intakeDate');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'signature' AS b, 'Signature — type your full legal name to sign' AS c, 'text' AS d, 1 AS e, 71 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'signature');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @patient_intake_id AS a, 'signatureAgreement' AS b, 'I confirm the information above is accurate and I am electronically signing this form' AS c, 'checkbox' AS d, 1 AS e, 72 AS f) AS t
WHERE @patient_intake_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @patient_intake_id AND field_key = 'signatureAgreement');

-- ---- New Patient Checklist ----
INSERT INTO dim_web_forms (tenant_id, business_id, site_id, form_key, name, success_message, is_active)
SELECT @larcare_tenant_id, @larcare_business_id, @larcare_site_id, 'new-patient-checklist',
       'New Patient Checklist', 'Thanks — the checklist has been submitted.', 1
WHERE @larcare_site_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_forms WHERE site_id = @larcare_site_id AND form_key = 'new-patient-checklist');

SET @new_patient_checklist_id = (SELECT id FROM dim_web_forms WHERE site_id = @larcare_site_id AND form_key = 'new-patient-checklist');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @new_patient_checklist_id AS a, 'employeeFirstName' AS b, 'Employee Name Filling Out This Form — First Name' AS c, 'text' AS d, 1 AS e, 1 AS f) AS t
WHERE @new_patient_checklist_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @new_patient_checklist_id AND field_key = 'employeeFirstName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @new_patient_checklist_id AS a, 'employeeLastName' AS b, 'Employee Name Filling Out This Form — Last Name' AS c, 'text' AS d, 1 AS e, 2 AS f) AS t
WHERE @new_patient_checklist_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @new_patient_checklist_id AND field_key = 'employeeLastName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @new_patient_checklist_id AS a, 'employeeEmail' AS b, 'Employee Email' AS c, 'email' AS d, 1 AS e, 3 AS f) AS t
WHERE @new_patient_checklist_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @new_patient_checklist_id AND field_key = 'employeeEmail');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @new_patient_checklist_id AS a, 'patientIntakeComplete' AS b, 'Patient Intake Form Completed — Complete?' AS c, 'select' AS d, 1 AS e, 4 AS f, '{"options": ["YES", "NO"]}' AS g) AS t
WHERE @new_patient_checklist_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @new_patient_checklist_id AND field_key = 'patientIntakeComplete');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @new_patient_checklist_id AS a, 'patientIntakeDate' AS b, 'Patient Intake Form Completed — Date Completed' AS c, 'date' AS d, 0 AS e, 5 AS f) AS t
WHERE @new_patient_checklist_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @new_patient_checklist_id AND field_key = 'patientIntakeDate');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @new_patient_checklist_id AS a, 'applicationDate' AS b, 'Application Date on Website' AS c, 'date' AS d, 0 AS e, 6 AS f) AS t
WHERE @new_patient_checklist_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @new_patient_checklist_id AND field_key = 'applicationDate');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @new_patient_checklist_id AS a, 'assignedPatientNumber' AS b, 'Assigned LarCare Patient Number' AS c, 'text' AS d, 0 AS e, 7 AS f) AS t
WHERE @new_patient_checklist_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @new_patient_checklist_id AND field_key = 'assignedPatientNumber');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @new_patient_checklist_id AS a, 'supervisoryVisitComplete' AS b, 'In-Home Aide Supervisory Visit Report — Complete?' AS c, 'select' AS d, 1 AS e, 8 AS f, '{"options": ["YES", "NO"]}' AS g) AS t
WHERE @new_patient_checklist_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @new_patient_checklist_id AND field_key = 'supervisoryVisitComplete');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @new_patient_checklist_id AS a, 'supervisoryVisitDate' AS b, 'In-Home Aide Supervisory Visit Report — Date Completed' AS c, 'date' AS d, 0 AS e, 9 AS f) AS t
WHERE @new_patient_checklist_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @new_patient_checklist_id AND field_key = 'supervisoryVisitDate');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @new_patient_checklist_id AS a, 'newPatientChecklistComplete' AS b, 'New Patient Checklist — Complete?' AS c, 'select' AS d, 1 AS e, 10 AS f, '{"options": ["YES", "NO"]}' AS g) AS t
WHERE @new_patient_checklist_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @new_patient_checklist_id AND field_key = 'newPatientChecklistComplete');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @new_patient_checklist_id AS a, 'newPatientChecklistDate' AS b, 'New Patient Checklist — Date Completed' AS c, 'date' AS d, 0 AS e, 11 AS f) AS t
WHERE @new_patient_checklist_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @new_patient_checklist_id AND field_key = 'newPatientChecklistDate');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @new_patient_checklist_id AS a, 'patientType' AS b, 'Patient Type' AS c, 'select' AS d, 0 AS e, 12 AS f, '{"options": ["Veteran", "Medicaid", "Personal out of pocket", "Private Insurance", "Grant", "Other federal type", "Other state type", "Other"]}' AS g) AS t
WHERE @new_patient_checklist_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @new_patient_checklist_id AND field_key = 'patientType');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @new_patient_checklist_id AS a, 'hasCltcNumber' AS b, 'Does the Patient Have CLTC or Different Type of Patient Number' AS c, 'select' AS d, 0 AS e, 13 AS f, '{"options": ["YES", "NO"]}' AS g) AS t
WHERE @new_patient_checklist_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @new_patient_checklist_id AND field_key = 'hasCltcNumber');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @new_patient_checklist_id AS a, 'cltcNumber' AS b, 'What Is The Number' AS c, 'text' AS d, 0 AS e, 14 AS f) AS t
WHERE @new_patient_checklist_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @new_patient_checklist_id AND field_key = 'cltcNumber');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @new_patient_checklist_id AS a, 'servicePlanComplete' AS b, 'Service Plan Reviewed — Complete?' AS c, 'select' AS d, 1 AS e, 15 AS f, '{"options": ["YES", "NO"]}' AS g) AS t
WHERE @new_patient_checklist_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @new_patient_checklist_id AND field_key = 'servicePlanComplete');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @new_patient_checklist_id AS a, 'servicePlanDate' AS b, 'Service Plan Reviewed — Date Completed' AS c, 'date' AS d, 0 AS e, 16 AS f) AS t
WHERE @new_patient_checklist_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @new_patient_checklist_id AND field_key = 'servicePlanDate');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @new_patient_checklist_id AS a, 'personalCareLogComplete' AS b, 'Personal Care Log — Complete?' AS c, 'select' AS d, 1 AS e, 17 AS f, '{"options": ["YES", "NO"]}' AS g) AS t
WHERE @new_patient_checklist_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @new_patient_checklist_id AND field_key = 'personalCareLogComplete');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @new_patient_checklist_id AS a, 'personalCareLogDate' AS b, 'Personal Care Log — Date Completed' AS c, 'date' AS d, 0 AS e, 18 AS f) AS t
WHERE @new_patient_checklist_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @new_patient_checklist_id AND field_key = 'personalCareLogDate');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @new_patient_checklist_id AS a, 'rightToComplainComplete' AS b, 'Right to Complain — Complete?' AS c, 'select' AS d, 1 AS e, 19 AS f, '{"options": ["YES", "NO"]}' AS g) AS t
WHERE @new_patient_checklist_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @new_patient_checklist_id AND field_key = 'rightToComplainComplete');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @new_patient_checklist_id AS a, 'rightToComplainDate' AS b, 'Right to Complain — Date Completed' AS c, 'date' AS d, 0 AS e, 20 AS f) AS t
WHERE @new_patient_checklist_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @new_patient_checklist_id AND field_key = 'rightToComplainDate');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @new_patient_checklist_id AS a, 'advanceDirectivesComplete' AS b, 'Advance Directives — Complete?' AS c, 'select' AS d, 1 AS e, 21 AS f, '{"options": ["YES", "NO"]}' AS g) AS t
WHERE @new_patient_checklist_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @new_patient_checklist_id AND field_key = 'advanceDirectivesComplete');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @new_patient_checklist_id AS a, 'advanceDirectivesDate' AS b, 'Advance Directives — Date Completed' AS c, 'date' AS d, 0 AS e, 22 AS f) AS t
WHERE @new_patient_checklist_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @new_patient_checklist_id AND field_key = 'advanceDirectivesDate');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @new_patient_checklist_id AS a, 'nonSolicitationComplete' AS b, 'SC LARCARE INC Client Non Solicitation Agreement — Complete?' AS c, 'select' AS d, 1 AS e, 23 AS f, '{"options": ["YES", "NO"]}' AS g) AS t
WHERE @new_patient_checklist_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @new_patient_checklist_id AND field_key = 'nonSolicitationComplete');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @new_patient_checklist_id AS a, 'nonSolicitationDate' AS b, 'SC LARCARE INC Client Non Solicitation Agreement — Date Completed' AS c, 'date' AS d, 0 AS e, 24 AS f) AS t
WHERE @new_patient_checklist_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @new_patient_checklist_id AND field_key = 'nonSolicitationDate');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @new_patient_checklist_id AS a, 'emergencyPreparednessComplete' AS b, 'SC LarCare Inc Emergency Preparedness Plan — Complete?' AS c, 'select' AS d, 1 AS e, 25 AS f, '{"options": ["YES", "NO"]}' AS g) AS t
WHERE @new_patient_checklist_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @new_patient_checklist_id AND field_key = 'emergencyPreparednessComplete');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @new_patient_checklist_id AS a, 'emergencyPreparednessDate' AS b, 'SC LarCare Inc Emergency Preparedness Plan — Date Completed' AS c, 'date' AS d, 0 AS e, 26 AS f) AS t
WHERE @new_patient_checklist_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @new_patient_checklist_id AND field_key = 'emergencyPreparednessDate');

-- ---- VA SamariCare - Rights to Complain ----
INSERT INTO dim_web_forms (tenant_id, business_id, site_id, form_key, name, success_message, is_active)
SELECT @larcare_tenant_id, @larcare_business_id, @larcare_site_id, 'va-rights-to-complain',
       'VA SamariCare - Rights to Complain', 'Thank you — this has been recorded.', 1
WHERE @larcare_site_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_forms WHERE site_id = @larcare_site_id AND form_key = 'va-rights-to-complain');

SET @va_rights_id = (SELECT id FROM dim_web_forms WHERE site_id = @larcare_site_id AND form_key = 'va-rights-to-complain');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_rights_id AS a, 'policyHeading' AS b, 'I acknowledge that I have the right to complain if I am unhappy about any of the services provided. I can reach LarCare representatives at 803-209-0956 or 803-209-8667. I will exercise my right to cancel if needed.' AS c, 'heading' AS d, 0 AS e, 1 AS f) AS t
WHERE @va_rights_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_rights_id AND field_key = 'policyHeading');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_rights_id AS a, 'patientFirstName' AS b, 'Patient First Name' AS c, 'text' AS d, 1 AS e, 2 AS f) AS t
WHERE @va_rights_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_rights_id AND field_key = 'patientFirstName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_rights_id AS a, 'patientLastName' AS b, 'Patient Last Name' AS c, 'text' AS d, 1 AS e, 3 AS f) AS t
WHERE @va_rights_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_rights_id AND field_key = 'patientLastName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_rights_id AS a, 'patientDateTime' AS b, 'Patient Date-Time' AS c, 'date' AS d, 0 AS e, 4 AS f) AS t
WHERE @va_rights_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_rights_id AND field_key = 'patientDateTime');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_rights_id AS a, 'patientSignature' AS b, 'Patient Signature — type your full legal name to sign' AS c, 'text' AS d, 1 AS e, 5 AS f) AS t
WHERE @va_rights_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_rights_id AND field_key = 'patientSignature');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_rights_id AS a, 'nurseFirstName' AS b, 'Nurse First Name' AS c, 'text' AS d, 1 AS e, 6 AS f) AS t
WHERE @va_rights_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_rights_id AND field_key = 'nurseFirstName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_rights_id AS a, 'nurseLastName' AS b, 'Nurse Last Name' AS c, 'text' AS d, 1 AS e, 7 AS f) AS t
WHERE @va_rights_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_rights_id AND field_key = 'nurseLastName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_rights_id AS a, 'nurseSignature' AS b, 'Nurse Signature — type your full legal name to sign' AS c, 'text' AS d, 0 AS e, 8 AS f) AS t
WHERE @va_rights_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_rights_id AND field_key = 'nurseSignature');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_rights_id AS a, 'witnessFirstName' AS b, 'LarCare Witness First Name' AS c, 'text' AS d, 1 AS e, 9 AS f) AS t
WHERE @va_rights_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_rights_id AND field_key = 'witnessFirstName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_rights_id AS a, 'witnessLastName' AS b, 'LarCare Witness Last Name' AS c, 'text' AS d, 1 AS e, 10 AS f) AS t
WHERE @va_rights_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_rights_id AND field_key = 'witnessLastName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_rights_id AS a, 'witnessSignature' AS b, 'Witness Signature — type your full legal name to sign' AS c, 'text' AS d, 0 AS e, 11 AS f) AS t
WHERE @va_rights_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_rights_id AND field_key = 'witnessSignature');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_rights_id AS a, 'signatureDateTime' AS b, 'Signature Date-Time' AS c, 'date' AS d, 0 AS e, 12 AS f) AS t
WHERE @va_rights_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_rights_id AND field_key = 'signatureDateTime');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_rights_id AS a, 'agreement' AS b, 'I confirm the above signatures are authentic and electronically executed' AS c, 'checkbox' AS d, 1 AS e, 13 AS f) AS t
WHERE @va_rights_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_rights_id AND field_key = 'agreement');

-- ---- SC LarCare - Rights to Complain ----
INSERT INTO dim_web_forms (tenant_id, business_id, site_id, form_key, name, success_message, is_active)
SELECT @larcare_tenant_id, @larcare_business_id, @larcare_site_id, 'sc-rights-to-complain',
       'SC LarCare - Rights to Complain', 'Thank you — this has been recorded.', 1
WHERE @larcare_site_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_forms WHERE site_id = @larcare_site_id AND form_key = 'sc-rights-to-complain');

SET @sc_rights_id = (SELECT id FROM dim_web_forms WHERE site_id = @larcare_site_id AND form_key = 'sc-rights-to-complain');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @sc_rights_id AS a, 'patientFirstName' AS b, 'Patient First Name' AS c, 'text' AS d, 0 AS e, 1 AS f) AS t
WHERE @sc_rights_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @sc_rights_id AND field_key = 'patientFirstName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @sc_rights_id AS a, 'patientLastName' AS b, 'Patient Last Name' AS c, 'text' AS d, 0 AS e, 2 AS f) AS t
WHERE @sc_rights_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @sc_rights_id AND field_key = 'patientLastName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @sc_rights_id AS a, 'dateTime' AS b, 'Date-Time' AS c, 'date' AS d, 0 AS e, 3 AS f) AS t
WHERE @sc_rights_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @sc_rights_id AND field_key = 'dateTime');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @sc_rights_id AS a, 'employeeSignature' AS b, 'Employee Signature — type your full legal name to sign' AS c, 'text' AS d, 1 AS e, 4 AS f) AS t
WHERE @sc_rights_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @sc_rights_id AND field_key = 'employeeSignature');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @sc_rights_id AS a, 'agreement' AS b, 'I confirm the above signature is authentic and electronically executed' AS c, 'checkbox' AS d, 1 AS e, 5 AS f) AS t
WHERE @sc_rights_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @sc_rights_id AND field_key = 'agreement');

-- ---- LarCare Inc (VA) DBA SamariCare Client Rights ----
INSERT INTO dim_web_forms (tenant_id, business_id, site_id, form_key, name, success_message, is_active)
SELECT @larcare_tenant_id, @larcare_business_id, @larcare_site_id, 'client-rights-va',
       'LarCare Inc (VA) DBA SamariCare Client Rights', 'Thank you.', 1
WHERE @larcare_site_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_forms WHERE site_id = @larcare_site_id AND form_key = 'client-rights-va');

SET @client_rights_id = (SELECT id FROM dim_web_forms WHERE site_id = @larcare_site_id AND form_key = 'client-rights-va');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @client_rights_id AS a, 'policyHeading' AS b, 'LarCare Inc (VA) DBA SamariCare Client Rights — please confirm your name to proceed to the document.' AS c, 'heading' AS d, 0 AS e, 1 AS f) AS t
WHERE @client_rights_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @client_rights_id AND field_key = 'policyHeading');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @client_rights_id AS a, 'employeeFirstName' AS b, 'Employee First Name' AS c, 'text' AS d, 1 AS e, 2 AS f) AS t
WHERE @client_rights_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @client_rights_id AND field_key = 'employeeFirstName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @client_rights_id AS a, 'employeeLastName' AS b, 'Employee Last Name' AS c, 'text' AS d, 1 AS e, 3 AS f) AS t
WHERE @client_rights_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @client_rights_id AND field_key = 'employeeLastName');

-- ---- Client / Patient Personal Care Agreement ----
INSERT INTO dim_web_forms (tenant_id, business_id, site_id, form_key, name, success_message, is_active)
SELECT @larcare_tenant_id, @larcare_business_id, @larcare_site_id, 'personal-care-agreement',
       'Client / Patient Personal Care Agreement', 'Thank you — the agreement has been submitted.', 1
WHERE @larcare_site_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_forms WHERE site_id = @larcare_site_id AND form_key = 'personal-care-agreement');

SET @personal_care_agreement_id = (SELECT id FROM dim_web_forms WHERE site_id = @larcare_site_id AND form_key = 'personal-care-agreement');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @personal_care_agreement_id AS a, 'patientFirstName' AS b, 'Patient First Name' AS c, 'text' AS d, 1 AS e, 1 AS f) AS t
WHERE @personal_care_agreement_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @personal_care_agreement_id AND field_key = 'patientFirstName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @personal_care_agreement_id AS a, 'patientLastName' AS b, 'Patient Last Name' AS c, 'text' AS d, 1 AS e, 2 AS f) AS t
WHERE @personal_care_agreement_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @personal_care_agreement_id AND field_key = 'patientLastName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @personal_care_agreement_id AS a, 'contactEmail' AS b, 'Patient or Point of Contact Email Address' AS c, 'email' AS d, 1 AS e, 3 AS f) AS t
WHERE @personal_care_agreement_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @personal_care_agreement_id AND field_key = 'contactEmail');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @personal_care_agreement_id AS a, 'firstPaymentDate' AS b, 'Start Date for The First Payment' AS c, 'date' AS d, 1 AS e, 4 AS f) AS t
WHERE @personal_care_agreement_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @personal_care_agreement_id AND field_key = 'firstPaymentDate');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @personal_care_agreement_id AS a, 'agencyName' AS b, 'Agency Name' AS c, 'select' AS d, 1 AS e, 5 AS f, '{"options": ["LarCare Inc. South Carolina", "LarCare Inc. DBA SamariCare", "LarCare Inc. Virginia", "LarCare Inc. USVI Saint Thomas", "Other"]}' AS g) AS t
WHERE @personal_care_agreement_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @personal_care_agreement_id AND field_key = 'agencyName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @personal_care_agreement_id AS a, 'invoicePaymentType' AS b, 'Invoice Payment Type' AS c, 'select' AS d, 1 AS e, 6 AS f, '{"options": ["Weekly", "Bi-Weekly", "Monthly", "Other"]}' AS g) AS t
WHERE @personal_care_agreement_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @personal_care_agreement_id AND field_key = 'invoicePaymentType');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @personal_care_agreement_id AS a, 'terminationNoticeDays' AS b, 'How Many Days in Advance to Terminate the Agreement' AS c, 'text' AS d, 1 AS e, 7 AS f) AS t
WHERE @personal_care_agreement_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @personal_care_agreement_id AND field_key = 'terminationNoticeDays');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @personal_care_agreement_id AS a, 'stateOfLaw' AS b, 'State of Law' AS c, 'select' AS d, 1 AS e, 8 AS f, '{"options": ["South Carolina", "St. Thomas, USVI", "Virginia"]}' AS g) AS t
WHERE @personal_care_agreement_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @personal_care_agreement_id AND field_key = 'stateOfLaw');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @personal_care_agreement_id AS a, 'payRate' AS b, 'Pay Rate (e.g. 15.00)' AS c, 'text' AS d, 1 AS e, 9 AS f) AS t
WHERE @personal_care_agreement_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @personal_care_agreement_id AND field_key = 'payRate');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @personal_care_agreement_id AS a, 'customAgreementDetails' AS b, 'Non-Compete / Custom Care Agreement Additional Terms' AS c, 'textarea' AS d, 1 AS e, 10 AS f) AS t
WHERE @personal_care_agreement_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @personal_care_agreement_id AND field_key = 'customAgreementDetails');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @personal_care_agreement_id AS a, 'emergencyCarePlan' AS b, 'Emergency Care Plan and Expectations' AS c, 'textarea' AS d, 1 AS e, 11 AS f) AS t
WHERE @personal_care_agreement_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @personal_care_agreement_id AND field_key = 'emergencyCarePlan');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @personal_care_agreement_id AS a, 'signatureDateTime' AS b, 'Date-Time' AS c, 'date' AS d, 0 AS e, 12 AS f) AS t
WHERE @personal_care_agreement_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @personal_care_agreement_id AND field_key = 'signatureDateTime');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @personal_care_agreement_id AS a, 'signature' AS b, 'Signature — type your full legal name to sign' AS c, 'text' AS d, 1 AS e, 13 AS f) AS t
WHERE @personal_care_agreement_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @personal_care_agreement_id AND field_key = 'signature');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @personal_care_agreement_id AS a, 'agreement' AS b, 'I have read and agree to this Personal Care Agreement' AS c, 'checkbox' AS d, 1 AS e, 14 AS f) AS t
WHERE @personal_care_agreement_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @personal_care_agreement_id AND field_key = 'agreement');

-- ---- VA SamariCare - Advance Directives ----
INSERT INTO dim_web_forms (tenant_id, business_id, site_id, form_key, name, success_message, is_active)
SELECT @larcare_tenant_id, @larcare_business_id, @larcare_site_id, 'va-advance-directives',
       'VA SamariCare - Advance Directives', 'Thank you — the advance directives form has been submitted.', 1
WHERE @larcare_site_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_forms WHERE site_id = @larcare_site_id AND form_key = 'va-advance-directives');

SET @va_advance_directives_id = (SELECT id FROM dim_web_forms WHERE site_id = @larcare_site_id AND form_key = 'va-advance-directives');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_advance_directives_id AS a, 'patientFirstName' AS b, 'Patient First Name' AS c, 'text' AS d, 1 AS e, 1 AS f) AS t
WHERE @va_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_advance_directives_id AND field_key = 'patientFirstName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_advance_directives_id AS a, 'patientLastName' AS b, 'Patient Last Name' AS c, 'text' AS d, 1 AS e, 2 AS f) AS t
WHERE @va_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_advance_directives_id AND field_key = 'patientLastName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_advance_directives_id AS a, 'dateOfBirth' AS b, 'Date of Birth' AS c, 'date' AS d, 1 AS e, 3 AS f) AS t
WHERE @va_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_advance_directives_id AND field_key = 'dateOfBirth');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_advance_directives_id AS a, 'contactEmail' AS b, 'Patient or Family Best Email Address' AS c, 'email' AS d, 0 AS e, 4 AS f) AS t
WHERE @va_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_advance_directives_id AND field_key = 'contactEmail');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_advance_directives_id AS a, 'dateTime' AS b, 'Date-Time' AS c, 'date' AS d, 0 AS e, 5 AS f) AS t
WHERE @va_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_advance_directives_id AND field_key = 'dateTime');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_advance_directives_id AS a, 'patientSignature' AS b, 'Patient Signature — type your full legal name to sign' AS c, 'text' AS d, 1 AS e, 6 AS f) AS t
WHERE @va_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_advance_directives_id AND field_key = 'patientSignature');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_advance_directives_id AS a, 'primaryAgentHeading' AS b, 'Primary Agent''s Contact Information' AS c, 'heading' AS d, 0 AS e, 7 AS f) AS t
WHERE @va_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_advance_directives_id AND field_key = 'primaryAgentHeading');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_advance_directives_id AS a, 'primaryAgentFirstName' AS b, 'Primary Agent''s First Name' AS c, 'text' AS d, 1 AS e, 8 AS f) AS t
WHERE @va_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_advance_directives_id AND field_key = 'primaryAgentFirstName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_advance_directives_id AS a, 'primaryAgentLastName' AS b, 'Primary Agent''s Last Name' AS c, 'text' AS d, 1 AS e, 9 AS f) AS t
WHERE @va_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_advance_directives_id AND field_key = 'primaryAgentLastName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_advance_directives_id AS a, 'primaryAgentPhoneHome' AS b, 'Primary Agent''s Phone (Home)' AS c, 'tel' AS d, 0 AS e, 10 AS f) AS t
WHERE @va_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_advance_directives_id AND field_key = 'primaryAgentPhoneHome');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_advance_directives_id AS a, 'primaryAgentPhoneCell' AS b, 'Primary Agent''s Phone (Cell)' AS c, 'tel' AS d, 0 AS e, 11 AS f) AS t
WHERE @va_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_advance_directives_id AND field_key = 'primaryAgentPhoneCell');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_advance_directives_id AS a, 'primaryAgentPhoneWork' AS b, 'Primary Agent''s Phone (Work)' AS c, 'tel' AS d, 0 AS e, 12 AS f) AS t
WHERE @va_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_advance_directives_id AND field_key = 'primaryAgentPhoneWork');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_advance_directives_id AS a, 'primaryAgentEmail' AS b, 'Primary Agent''s Email' AS c, 'email' AS d, 0 AS e, 13 AS f) AS t
WHERE @va_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_advance_directives_id AND field_key = 'primaryAgentEmail');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_advance_directives_id AS a, 'primaryAgentAddress' AS b, 'Primary Agent''s Home Address' AS c, 'text' AS d, 0 AS e, 14 AS f) AS t
WHERE @va_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_advance_directives_id AND field_key = 'primaryAgentAddress');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_advance_directives_id AS a, 'primaryAgentSignature' AS b, 'Primary Agent''s Signature — type full legal name' AS c, 'text' AS d, 0 AS e, 15 AS f) AS t
WHERE @va_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_advance_directives_id AND field_key = 'primaryAgentSignature');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_advance_directives_id AS a, 'backupAgentHeading' AS b, 'Back-up Agent''s Contact Information' AS c, 'heading' AS d, 0 AS e, 16 AS f) AS t
WHERE @va_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_advance_directives_id AND field_key = 'backupAgentHeading');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_advance_directives_id AS a, 'backupAgentFirstName' AS b, 'Back-up Agent''s First Name' AS c, 'text' AS d, 1 AS e, 17 AS f) AS t
WHERE @va_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_advance_directives_id AND field_key = 'backupAgentFirstName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_advance_directives_id AS a, 'backupAgentLastName' AS b, 'Back-up Agent''s Last Name' AS c, 'text' AS d, 1 AS e, 18 AS f) AS t
WHERE @va_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_advance_directives_id AND field_key = 'backupAgentLastName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_advance_directives_id AS a, 'backupAgentPhoneHome' AS b, 'Back-up Agent''s Phone (Home)' AS c, 'tel' AS d, 0 AS e, 19 AS f) AS t
WHERE @va_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_advance_directives_id AND field_key = 'backupAgentPhoneHome');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_advance_directives_id AS a, 'backupAgentPhoneCell' AS b, 'Back-up Agent''s Phone (Cell)' AS c, 'tel' AS d, 0 AS e, 20 AS f) AS t
WHERE @va_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_advance_directives_id AND field_key = 'backupAgentPhoneCell');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_advance_directives_id AS a, 'backupAgentPhoneWork' AS b, 'Back-up Agent''s Phone (Work)' AS c, 'tel' AS d, 0 AS e, 21 AS f) AS t
WHERE @va_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_advance_directives_id AND field_key = 'backupAgentPhoneWork');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_advance_directives_id AS a, 'backupAgentEmail' AS b, 'Back-up Agent''s Email' AS c, 'email' AS d, 0 AS e, 22 AS f) AS t
WHERE @va_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_advance_directives_id AND field_key = 'backupAgentEmail');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_advance_directives_id AS a, 'backupAgentAddress' AS b, 'Back-up Agent''s Address' AS c, 'text' AS d, 0 AS e, 23 AS f) AS t
WHERE @va_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_advance_directives_id AND field_key = 'backupAgentAddress');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_advance_directives_id AS a, 'backupAgentSignature' AS b, 'Back-up Agent''s Signature — type full legal name' AS c, 'text' AS d, 0 AS e, 24 AS f) AS t
WHERE @va_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_advance_directives_id AND field_key = 'backupAgentSignature');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_advance_directives_id AS a, 'nurseFirstName' AS b, 'Nurse First Name' AS c, 'text' AS d, 1 AS e, 25 AS f) AS t
WHERE @va_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_advance_directives_id AND field_key = 'nurseFirstName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_advance_directives_id AS a, 'nurseLastName' AS b, 'Nurse Last Name' AS c, 'text' AS d, 1 AS e, 26 AS f) AS t
WHERE @va_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_advance_directives_id AND field_key = 'nurseLastName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_advance_directives_id AS a, 'nurseSignature' AS b, 'Nurse Signature — type full legal name' AS c, 'text' AS d, 0 AS e, 27 AS f) AS t
WHERE @va_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_advance_directives_id AND field_key = 'nurseSignature');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @va_advance_directives_id AS a, 'agreement' AS b, 'I confirm the above signatures are authentic and electronically executed' AS c, 'checkbox' AS d, 1 AS e, 28 AS f) AS t
WHERE @va_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @va_advance_directives_id AND field_key = 'agreement');

-- ---- SC LarCare - Advance Directives ----
INSERT INTO dim_web_forms (tenant_id, business_id, site_id, form_key, name, success_message, is_active)
SELECT @larcare_tenant_id, @larcare_business_id, @larcare_site_id, 'sc-advance-directives',
       'SC LarCare - Advance Directives', 'Thank you — the advance directives form has been submitted.', 1
WHERE @larcare_site_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_forms WHERE site_id = @larcare_site_id AND form_key = 'sc-advance-directives');

SET @sc_advance_directives_id = (SELECT id FROM dim_web_forms WHERE site_id = @larcare_site_id AND form_key = 'sc-advance-directives');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @sc_advance_directives_id AS a, 'patientFirstName' AS b, 'Patient First Name' AS c, 'text' AS d, 1 AS e, 1 AS f) AS t
WHERE @sc_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @sc_advance_directives_id AND field_key = 'patientFirstName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @sc_advance_directives_id AS a, 'patientLastName' AS b, 'Patient Last Name' AS c, 'text' AS d, 1 AS e, 2 AS f) AS t
WHERE @sc_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @sc_advance_directives_id AND field_key = 'patientLastName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @sc_advance_directives_id AS a, 'dateOfBirth' AS b, 'Date of Birth' AS c, 'date' AS d, 1 AS e, 3 AS f) AS t
WHERE @sc_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @sc_advance_directives_id AND field_key = 'dateOfBirth');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @sc_advance_directives_id AS a, 'contactEmail' AS b, 'Patient or Family Best Email Address' AS c, 'email' AS d, 0 AS e, 4 AS f) AS t
WHERE @sc_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @sc_advance_directives_id AND field_key = 'contactEmail');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @sc_advance_directives_id AS a, 'dateTime' AS b, 'Date-Time' AS c, 'date' AS d, 0 AS e, 5 AS f) AS t
WHERE @sc_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @sc_advance_directives_id AND field_key = 'dateTime');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @sc_advance_directives_id AS a, 'patientSignature' AS b, 'Patient Signature — type your full legal name to sign' AS c, 'text' AS d, 1 AS e, 6 AS f) AS t
WHERE @sc_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @sc_advance_directives_id AND field_key = 'patientSignature');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @sc_advance_directives_id AS a, 'primaryAgentHeading' AS b, 'Primary Agent''s Contact Information' AS c, 'heading' AS d, 0 AS e, 7 AS f) AS t
WHERE @sc_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @sc_advance_directives_id AND field_key = 'primaryAgentHeading');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @sc_advance_directives_id AS a, 'primaryAgentFirstName' AS b, 'Primary Agent''s First Name' AS c, 'text' AS d, 1 AS e, 8 AS f) AS t
WHERE @sc_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @sc_advance_directives_id AND field_key = 'primaryAgentFirstName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @sc_advance_directives_id AS a, 'primaryAgentLastName' AS b, 'Primary Agent''s Last Name' AS c, 'text' AS d, 1 AS e, 9 AS f) AS t
WHERE @sc_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @sc_advance_directives_id AND field_key = 'primaryAgentLastName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @sc_advance_directives_id AS a, 'primaryAgentPhoneHome' AS b, 'Primary Agent''s Phone (Home)' AS c, 'tel' AS d, 0 AS e, 10 AS f) AS t
WHERE @sc_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @sc_advance_directives_id AND field_key = 'primaryAgentPhoneHome');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @sc_advance_directives_id AS a, 'primaryAgentPhoneCell' AS b, 'Primary Agent''s Phone (Cell)' AS c, 'tel' AS d, 0 AS e, 11 AS f) AS t
WHERE @sc_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @sc_advance_directives_id AND field_key = 'primaryAgentPhoneCell');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @sc_advance_directives_id AS a, 'primaryAgentPhoneWork' AS b, 'Primary Agent''s Phone (Work)' AS c, 'tel' AS d, 0 AS e, 12 AS f) AS t
WHERE @sc_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @sc_advance_directives_id AND field_key = 'primaryAgentPhoneWork');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @sc_advance_directives_id AS a, 'primaryAgentEmail' AS b, 'Primary Agent''s Email' AS c, 'email' AS d, 0 AS e, 13 AS f) AS t
WHERE @sc_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @sc_advance_directives_id AND field_key = 'primaryAgentEmail');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @sc_advance_directives_id AS a, 'primaryAgentAddress' AS b, 'Primary Agent''s Home Address' AS c, 'text' AS d, 0 AS e, 14 AS f) AS t
WHERE @sc_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @sc_advance_directives_id AND field_key = 'primaryAgentAddress');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @sc_advance_directives_id AS a, 'primaryAgentSignature' AS b, 'Primary Agent''s Signature — type full legal name' AS c, 'text' AS d, 0 AS e, 15 AS f) AS t
WHERE @sc_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @sc_advance_directives_id AND field_key = 'primaryAgentSignature');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @sc_advance_directives_id AS a, 'backupAgentHeading' AS b, 'Back-up Agent''s Contact Information' AS c, 'heading' AS d, 0 AS e, 16 AS f) AS t
WHERE @sc_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @sc_advance_directives_id AND field_key = 'backupAgentHeading');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @sc_advance_directives_id AS a, 'backupAgentFirstName' AS b, 'Back-up Agent''s First Name' AS c, 'text' AS d, 1 AS e, 17 AS f) AS t
WHERE @sc_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @sc_advance_directives_id AND field_key = 'backupAgentFirstName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @sc_advance_directives_id AS a, 'backupAgentLastName' AS b, 'Back-up Agent''s Last Name' AS c, 'text' AS d, 1 AS e, 18 AS f) AS t
WHERE @sc_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @sc_advance_directives_id AND field_key = 'backupAgentLastName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @sc_advance_directives_id AS a, 'backupAgentPhoneHome' AS b, 'Back-up Agent''s Phone (Home)' AS c, 'tel' AS d, 0 AS e, 19 AS f) AS t
WHERE @sc_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @sc_advance_directives_id AND field_key = 'backupAgentPhoneHome');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @sc_advance_directives_id AS a, 'backupAgentPhoneCell' AS b, 'Back-up Agent''s Phone (Cell)' AS c, 'tel' AS d, 0 AS e, 20 AS f) AS t
WHERE @sc_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @sc_advance_directives_id AND field_key = 'backupAgentPhoneCell');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @sc_advance_directives_id AS a, 'backupAgentPhoneWork' AS b, 'Back-up Agent''s Phone (Work)' AS c, 'tel' AS d, 0 AS e, 21 AS f) AS t
WHERE @sc_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @sc_advance_directives_id AND field_key = 'backupAgentPhoneWork');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @sc_advance_directives_id AS a, 'backupAgentEmail' AS b, 'Back-up Agent''s Email' AS c, 'email' AS d, 0 AS e, 22 AS f) AS t
WHERE @sc_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @sc_advance_directives_id AND field_key = 'backupAgentEmail');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @sc_advance_directives_id AS a, 'backupAgentAddress' AS b, 'Back-up Agent''s Address' AS c, 'text' AS d, 0 AS e, 23 AS f) AS t
WHERE @sc_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @sc_advance_directives_id AND field_key = 'backupAgentAddress');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @sc_advance_directives_id AS a, 'backupAgentSignature' AS b, 'Back-up Agent''s Signature — type full legal name' AS c, 'text' AS d, 0 AS e, 24 AS f) AS t
WHERE @sc_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @sc_advance_directives_id AND field_key = 'backupAgentSignature');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @sc_advance_directives_id AS a, 'nurseFirstName' AS b, 'Nurse First Name' AS c, 'text' AS d, 1 AS e, 25 AS f) AS t
WHERE @sc_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @sc_advance_directives_id AND field_key = 'nurseFirstName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @sc_advance_directives_id AS a, 'nurseLastName' AS b, 'Nurse Last Name' AS c, 'text' AS d, 1 AS e, 26 AS f) AS t
WHERE @sc_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @sc_advance_directives_id AND field_key = 'nurseLastName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @sc_advance_directives_id AS a, 'nurseSignature' AS b, 'Nurse Signature — type full legal name' AS c, 'text' AS d, 0 AS e, 27 AS f) AS t
WHERE @sc_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @sc_advance_directives_id AND field_key = 'nurseSignature');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @sc_advance_directives_id AS a, 'agreement' AS b, 'I confirm the above signatures are authentic and electronically executed' AS c, 'checkbox' AS d, 1 AS e, 28 AS f) AS t
WHERE @sc_advance_directives_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @sc_advance_directives_id AND field_key = 'agreement');

-- ---- Request For Private Pay Invoice ----
INSERT INTO dim_web_forms (tenant_id, business_id, site_id, form_key, name, success_message, is_active)
SELECT @larcare_tenant_id, @larcare_business_id, @larcare_site_id, 'private-pay-invoice-request',
       'Request For Private Pay Invoice', 'Thank you — the invoice request has been submitted.', 1
WHERE @larcare_site_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_forms WHERE site_id = @larcare_site_id AND form_key = 'private-pay-invoice-request');

SET @private_pay_invoice_id = (SELECT id FROM dim_web_forms WHERE site_id = @larcare_site_id AND form_key = 'private-pay-invoice-request');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @private_pay_invoice_id AS a, 'location' AS b, 'Location' AS c, 'select' AS d, 1 AS e, 1 AS f, '{"options": ["Chester, South Carolina - 178 Columbia St.", "Hopewell, Virginia - 2304 Freeman St.", "SamariCare/Williamsburg - 710 Queensbury Lane", "St. Thomas, Virgin Islands"]}' AS g) AS t
WHERE @private_pay_invoice_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @private_pay_invoice_id AND field_key = 'location');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @private_pay_invoice_id AS a, 'patientFirstName' AS b, 'Patient First Name' AS c, 'text' AS d, 1 AS e, 2 AS f) AS t
WHERE @private_pay_invoice_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @private_pay_invoice_id AND field_key = 'patientFirstName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @private_pay_invoice_id AS a, 'patientLastName' AS b, 'Patient Last Name' AS c, 'text' AS d, 1 AS e, 3 AS f) AS t
WHERE @private_pay_invoice_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @private_pay_invoice_id AND field_key = 'patientLastName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @private_pay_invoice_id AS a, 'patientType' AS b, 'Patient Type or Classification' AS c, 'select' AS d, 1 AS e, 4 AS f, '{"options": ["Veteran", "Private Insurance", "Out of Pocket/Personal Pay", "Other state type", "Other federal type", "Medicare", "Medicaid", "Medicaid Retro Coverage", "Grant", "Other"]}' AS g) AS t
WHERE @private_pay_invoice_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @private_pay_invoice_id AND field_key = 'patientType');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @private_pay_invoice_id AS a, 'patientTypeIdNumber' AS b, 'Patient Type ID Number' AS c, 'text' AS d, 0 AS e, 5 AS f) AS t
WHERE @private_pay_invoice_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @private_pay_invoice_id AND field_key = 'patientTypeIdNumber');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @private_pay_invoice_id AS a, 'billingContactFirstName' AS b, 'Family Member Responsible for Billing — First Name' AS c, 'text' AS d, 0 AS e, 6 AS f) AS t
WHERE @private_pay_invoice_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @private_pay_invoice_id AND field_key = 'billingContactFirstName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @private_pay_invoice_id AS a, 'billingContactLastName' AS b, 'Family Member Responsible for Billing — Last Name' AS c, 'text' AS d, 0 AS e, 7 AS f) AS t
WHERE @private_pay_invoice_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @private_pay_invoice_id AND field_key = 'billingContactLastName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @private_pay_invoice_id AS a, 'contactEmail' AS b, 'Patient or Point of Contact Email Address' AS c, 'email' AS d, 1 AS e, 8 AS f) AS t
WHERE @private_pay_invoice_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @private_pay_invoice_id AND field_key = 'contactEmail');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @private_pay_invoice_id AS a, 'billingContactPhone' AS b, 'Family Member Phone' AS c, 'tel' AS d, 1 AS e, 9 AS f) AS t
WHERE @private_pay_invoice_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @private_pay_invoice_id AND field_key = 'billingContactPhone');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @private_pay_invoice_id AS a, 'invoiceDetailsHeading' AS b, 'Invoice Details' AS c, 'heading' AS d, 0 AS e, 10 AS f) AS t
WHERE @private_pay_invoice_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @private_pay_invoice_id AND field_key = 'invoiceDetailsHeading');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @private_pay_invoice_id AS a, 'paymentOption' AS b, 'Payment Option' AS c, 'select' AS d, 0 AS e, 11 AS f, '{"options": ["Cash", "Check", "Electronic"]}' AS g) AS t
WHERE @private_pay_invoice_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @private_pay_invoice_id AND field_key = 'paymentOption');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @private_pay_invoice_id AS a, 'serviceDescription' AS b, 'Service Performed / Description' AS c, 'textarea' AS d, 1 AS e, 12 AS f) AS t
WHERE @private_pay_invoice_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @private_pay_invoice_id AND field_key = 'serviceDescription');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @private_pay_invoice_id AS a, 'totalServiceHours' AS b, 'Total Service Hours' AS c, 'number' AS d, 1 AS e, 13 AS f) AS t
WHERE @private_pay_invoice_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @private_pay_invoice_id AND field_key = 'totalServiceHours');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @private_pay_invoice_id AS a, 'billRate' AS b, 'Hourly Rate / Bill Rate (e.g. 12.00)' AS c, 'text' AS d, 1 AS e, 14 AS f) AS t
WHERE @private_pay_invoice_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @private_pay_invoice_id AND field_key = 'billRate');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @private_pay_invoice_id AS a, 'totalAmountDue' AS b, 'Total Amount Due' AS c, 'number' AS d, 0 AS e, 15 AS f) AS t
WHERE @private_pay_invoice_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @private_pay_invoice_id AND field_key = 'totalAmountDue');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @private_pay_invoice_id AS a, 'serviceStartDate' AS b, 'Service Start Date' AS c, 'date' AS d, 1 AS e, 16 AS f) AS t
WHERE @private_pay_invoice_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @private_pay_invoice_id AND field_key = 'serviceStartDate');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @private_pay_invoice_id AS a, 'serviceEndDate' AS b, 'Service End Date' AS c, 'date' AS d, 1 AS e, 17 AS f) AS t
WHERE @private_pay_invoice_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @private_pay_invoice_id AND field_key = 'serviceEndDate');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @private_pay_invoice_id AS a, 'invoiceDate' AS b, 'Invoice Date' AS c, 'date' AS d, 1 AS e, 18 AS f) AS t
WHERE @private_pay_invoice_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @private_pay_invoice_id AND field_key = 'invoiceDate');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @private_pay_invoice_id AS a, 'paymentDueDate' AS b, 'Payment Due Date' AS c, 'date' AS d, 1 AS e, 19 AS f) AS t
WHERE @private_pay_invoice_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @private_pay_invoice_id AND field_key = 'paymentDueDate');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @private_pay_invoice_id AS a, 'invoiceFrequency' AS b, 'Frequency of Invoice' AS c, 'select' AS d, 1 AS e, 20 AS f, '{"options": ["Daily", "Weekly", "Bi-Weekly", "Monthly", "One Time Payment", "Other"]}' AS g) AS t
WHERE @private_pay_invoice_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @private_pay_invoice_id AND field_key = 'invoiceFrequency');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @private_pay_invoice_id AS a, 'firstPaymentDate' AS b, 'Date of The First Payment' AS c, 'date' AS d, 0 AS e, 21 AS f) AS t
WHERE @private_pay_invoice_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @private_pay_invoice_id AND field_key = 'firstPaymentDate');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @private_pay_invoice_id AS a, 'houseCleaningHeading' AS b, 'House Cleaning Service Payment Request' AS c, 'heading' AS d, 0 AS e, 22 AS f) AS t
WHERE @private_pay_invoice_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @private_pay_invoice_id AND field_key = 'houseCleaningHeading');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @private_pay_invoice_id AS a, 'dutiesPerformed' AS b, 'What Were the Duties Performed for the Patient?' AS c, 'textarea' AS d, 1 AS e, 23 AS f) AS t
WHERE @private_pay_invoice_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @private_pay_invoice_id AND field_key = 'dutiesPerformed');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @private_pay_invoice_id AS a, 'activityCodes' AS b, 'Activity Codes Performed (comma-separated, e.g. 20, 21, 27)' AS c, 'text' AS d, 0 AS e, 24 AS f) AS t
WHERE @private_pay_invoice_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @private_pay_invoice_id AND field_key = 'activityCodes');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @private_pay_invoice_id AS a, 'additionalInfoHeading' AS b, 'Additional Information' AS c, 'heading' AS d, 0 AS e, 25 AS f) AS t
WHERE @private_pay_invoice_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @private_pay_invoice_id AND field_key = 'additionalInfoHeading');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @private_pay_invoice_id AS a, 'privateInsuranceName' AS b, 'Private Insurance Name' AS c, 'select' AS d, 1 AS e, 26 AS f, '{"options": ["Humana", "United HealthCare", "Cigna", "Blue Cross Blue Shield", "Medicare", "Catawba", "N/A", "Other"]}' AS g) AS t
WHERE @private_pay_invoice_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @private_pay_invoice_id AND field_key = 'privateInsuranceName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @private_pay_invoice_id AS a, 'additionalIdType' AS b, 'Additional Identification Number Requirement' AS c, 'select' AS d, 1 AS e, 27 AS f, '{"options": ["Any Unique Identifying Number", "CLTC Number", "Claim Number", "Group Number or ID", "N/A", "Other Medical Number", "Revenue Code", "Other"]}' AS g) AS t
WHERE @private_pay_invoice_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @private_pay_invoice_id AND field_key = 'additionalIdType');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @private_pay_invoice_id AS a, 'additionalIdNumber' AS b, 'Additional Identification / Unique Identifier Number (0 = N/A)' AS c, 'text' AS d, 1 AS e, 28 AS f) AS t
WHERE @private_pay_invoice_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @private_pay_invoice_id AND field_key = 'additionalIdNumber');

-- ---- Client Non Solicitation Agreement ----
INSERT INTO dim_web_forms (tenant_id, business_id, site_id, form_key, name, success_message, is_active)
SELECT @larcare_tenant_id, @larcare_business_id, @larcare_site_id, 'client-non-solicitation-agreement',
       'Client Non Solicitation Agreement', 'Thank you — this has been recorded.', 1
WHERE @larcare_site_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_forms WHERE site_id = @larcare_site_id AND form_key = 'client-non-solicitation-agreement');

SET @non_solicitation_id = (SELECT id FROM dim_web_forms WHERE site_id = @larcare_site_id AND form_key = 'client-non-solicitation-agreement');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @non_solicitation_id AS a, 'contactFirstName' AS b, 'Patient / Patient Family Member / POC First Name' AS c, 'text' AS d, 0 AS e, 1 AS f) AS t
WHERE @non_solicitation_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @non_solicitation_id AND field_key = 'contactFirstName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @non_solicitation_id AS a, 'contactLastName' AS b, 'Patient / Patient Family Member / POC Last Name' AS c, 'text' AS d, 0 AS e, 2 AS f) AS t
WHERE @non_solicitation_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @non_solicitation_id AND field_key = 'contactLastName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @non_solicitation_id AS a, 'recipientAddress' AS b, 'Recipient(s) Address' AS c, 'text' AS d, 0 AS e, 3 AS f) AS t
WHERE @non_solicitation_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @non_solicitation_id AND field_key = 'recipientAddress');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @non_solicitation_id AS a, 'dateTime' AS b, 'Date-Time' AS c, 'date' AS d, 0 AS e, 4 AS f) AS t
WHERE @non_solicitation_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @non_solicitation_id AND field_key = 'dateTime');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @non_solicitation_id AS a, 'employeeSignature' AS b, 'Employee Signature — type your full legal name to sign' AS c, 'text' AS d, 1 AS e, 5 AS f) AS t
WHERE @non_solicitation_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @non_solicitation_id AND field_key = 'employeeSignature');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @non_solicitation_id AS a, 'agreement' AS b, 'I confirm the above signature is authentic and electronically executed' AS c, 'checkbox' AS d, 1 AS e, 6 AS f) AS t
WHERE @non_solicitation_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @non_solicitation_id AND field_key = 'agreement');

-- ---- LarCare Emergency Preparedness Plan ----
INSERT INTO dim_web_forms (tenant_id, business_id, site_id, form_key, name, success_message, is_active)
SELECT @larcare_tenant_id, @larcare_business_id, @larcare_site_id, 'emergency-preparedness-plan',
       'LarCare Emergency Preparedness Plan', 'Thank you — the emergency preparedness plan has been submitted.', 1
WHERE @larcare_site_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_forms WHERE site_id = @larcare_site_id AND form_key = 'emergency-preparedness-plan');

SET @emergency_preparedness_id = (SELECT id FROM dim_web_forms WHERE site_id = @larcare_site_id AND form_key = 'emergency-preparedness-plan');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'outOfStateHeading' AS b, 'Out-of-State Contact' AS c, 'heading' AS d, 0 AS e, 1 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'outOfStateHeading');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'outOfStateFirstName' AS b, 'Out-of-State Contact First Name' AS c, 'text' AS d, 0 AS e, 2 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'outOfStateFirstName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'outOfStateLastName' AS b, 'Out-of-State Contact Last Name' AS c, 'text' AS d, 0 AS e, 3 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'outOfStateLastName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'outOfStateAddress' AS b, 'Out-of-State Contact Address' AS c, 'text' AS d, 0 AS e, 4 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'outOfStateAddress');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'outOfStatePhoneDay' AS b, 'Out-of-State Phone Day' AS c, 'tel' AS d, 1 AS e, 5 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'outOfStatePhoneDay');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'outOfStatePhoneEvening' AS b, 'Out-of-State Phone Evening' AS c, 'tel' AS d, 1 AS e, 6 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'outOfStatePhoneEvening');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'localHeading' AS b, 'Local Contact' AS c, 'heading' AS d, 0 AS e, 7 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'localHeading');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'localContactFirstName' AS b, 'Local Contact First Name' AS c, 'text' AS d, 0 AS e, 8 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'localContactFirstName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'localContactLastName' AS b, 'Local Contact Last Name' AS c, 'text' AS d, 0 AS e, 9 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'localContactLastName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'localContactPhoneDay' AS b, 'Local Contact Phone Day' AS c, 'tel' AS d, 1 AS e, 10 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'localContactPhoneDay');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'localContactPhoneEvening' AS b, 'Local Contact Phone Evening' AS c, 'tel' AS d, 1 AS e, 11 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'localContactPhoneEvening');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'relativeHeading' AS b, 'Nearest Relative' AS c, 'heading' AS d, 0 AS e, 12 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'relativeHeading');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'relativeFirstName' AS b, 'Nearest Relative First Name' AS c, 'text' AS d, 0 AS e, 13 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'relativeFirstName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'relativeLastName' AS b, 'Nearest Relative Last Name' AS c, 'text' AS d, 0 AS e, 14 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'relativeLastName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'relativeAddress' AS b, 'Nearest Relative Address' AS c, 'text' AS d, 0 AS e, 15 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'relativeAddress');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'relativePhoneDay' AS b, 'Nearest Relative Phone Day' AS c, 'tel' AS d, 1 AS e, 16 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'relativePhoneDay');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'relativePhoneEvening' AS b, 'Nearest Relative Phone Evening' AS c, 'tel' AS d, 1 AS e, 17 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'relativePhoneEvening');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'familyWorkHeading' AS b, 'Family Work Numbers' AS c, 'heading' AS d, 0 AS e, 18 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'familyWorkHeading');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'fatherFirstName' AS b, 'Father''s First Name' AS c, 'text' AS d, 0 AS e, 19 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'fatherFirstName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'fatherLastName' AS b, 'Father''s Last Name' AS c, 'text' AS d, 0 AS e, 20 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'fatherLastName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'motherFirstName' AS b, 'Mother''s First Name' AS c, 'text' AS d, 0 AS e, 21 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'motherFirstName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'motherLastName' AS b, 'Mother''s Last Name' AS c, 'text' AS d, 0 AS e, 22 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'motherLastName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'otherFamilyFirstName' AS b, 'Other Family Contact First Name' AS c, 'text' AS d, 0 AS e, 23 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'otherFamilyFirstName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'otherFamilyLastName' AS b, 'Other Family Contact Last Name' AS c, 'text' AS d, 0 AS e, 24 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'otherFamilyLastName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'emergencyNumbersHeading' AS b, 'Emergency Telephone Numbers (dial 911 for life-threatening emergencies)' AS c, 'heading' AS d, 0 AS e, 25 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'emergencyNumbersHeading');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'policeDepartment' AS b, 'Police Department' AS c, 'tel' AS d, 1 AS e, 26 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'policeDepartment');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'fireDepartment' AS b, 'Fire Department' AS c, 'tel' AS d, 1 AS e, 27 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'fireDepartment');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'hospital' AS b, 'Hospital' AS c, 'tel' AS d, 1 AS e, 28 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'hospital');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'physiciansHeading' AS b, 'Family Physicians' AS c, 'heading' AS d, 0 AS e, 29 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'physiciansHeading');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'physician1FirstName' AS b, 'Family Physician 1 — First Name' AS c, 'text' AS d, 0 AS e, 30 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'physician1FirstName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'physician1LastName' AS b, 'Family Physician 1 — Last Name' AS c, 'text' AS d, 0 AS e, 31 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'physician1LastName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'physician1Phone' AS b, 'Family Physician 1 — Phone' AS c, 'tel' AS d, 0 AS e, 32 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'physician1Phone');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'physician2FirstName' AS b, 'Family Physician 2 — First Name' AS c, 'text' AS d, 0 AS e, 33 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'physician2FirstName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'physician2LastName' AS b, 'Family Physician 2 — Last Name' AS c, 'text' AS d, 0 AS e, 34 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'physician2LastName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'physician2Phone' AS b, 'Family Physician 2 — Phone' AS c, 'tel' AS d, 0 AS e, 35 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'physician2Phone');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'physician3FirstName' AS b, 'Family Physician 3 — First Name' AS c, 'text' AS d, 0 AS e, 36 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'physician3FirstName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'physician3LastName' AS b, 'Family Physician 3 — Last Name' AS c, 'text' AS d, 0 AS e, 37 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'physician3LastName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'physician3Phone' AS b, 'Family Physician 3 — Phone' AS c, 'tel' AS d, 0 AS e, 38 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'physician3Phone');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'reunionHeading' AS b, 'Reunion Locations' AS c, 'heading' AS d, 0 AS e, 39 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'reunionHeading');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'reunionNearHome' AS b, 'Reunion Location — Right Outside Your Home' AS c, 'text' AS d, 1 AS e, 40 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'reunionNearHome');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'reunionAwayFromNeighborhood' AS b, 'Reunion Location — Away From the Neighborhood' AS c, 'text' AS d, 1 AS e, 41 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'reunionAwayFromNeighborhood');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'reunionAddress' AS b, 'Reunion Location Address' AS c, 'text' AS d, 0 AS e, 42 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'reunionAddress');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'reunionPhone' AS b, 'Reunion Location Phone' AS c, 'tel' AS d, 1 AS e, 43 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'reunionPhone');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'routeToTryFirst' AS b, 'Route to Try First' AS c, 'text' AS d, 1 AS e, 44 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'routeToTryFirst');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'localContactIs' AS b, 'Your Local Contact Is' AS c, 'text' AS d, 1 AS e, 45 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'localContactIs');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'localContactEmail' AS b, 'Your Local Contact — Email' AS c, 'email' AS d, 1 AS e, 46 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'localContactEmail');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @emergency_preparedness_id AS a, 'localContactPhone' AS b, 'Your Local Contact — Phone' AS c, 'tel' AS d, 1 AS e, 47 AS f) AS t
WHERE @emergency_preparedness_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @emergency_preparedness_id AND field_key = 'localContactPhone');

-- ---- LarCare Private Care Inquiry Form ----
INSERT INTO dim_web_forms (tenant_id, business_id, site_id, form_key, name, success_message, is_active)
SELECT @larcare_tenant_id, @larcare_business_id, @larcare_site_id, 'private-care-inquiry',
       'LarCare Private Care Inquiry Form', 'Thank you for your inquiry — a member of our team will be in touch shortly.', 1
WHERE @larcare_site_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_forms WHERE site_id = @larcare_site_id AND form_key = 'private-care-inquiry');

SET @private_care_inquiry_id = (SELECT id FROM dim_web_forms WHERE site_id = @larcare_site_id AND form_key = 'private-care-inquiry');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @private_care_inquiry_id AS a, 'patientFirstName' AS b, 'Patient First Name' AS c, 'text' AS d, 1 AS e, 1 AS f) AS t
WHERE @private_care_inquiry_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @private_care_inquiry_id AND field_key = 'patientFirstName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @private_care_inquiry_id AS a, 'patientLastName' AS b, 'Patient Last Name' AS c, 'text' AS d, 1 AS e, 2 AS f) AS t
WHERE @private_care_inquiry_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @private_care_inquiry_id AND field_key = 'patientLastName');