-- 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);

-- ---- Nurse Site Visit Report and 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, 'nurse-site-visit-report-invoice',
       'Nurse Site Visit Report and Invoice', 'Thank you — the site visit report 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 = 'nurse-site-visit-report-invoice');

SET @nurse_site_visit_invoice_id = (SELECT id FROM dim_web_forms WHERE site_id = @larcare_site_id AND form_key = 'nurse-site-visit-report-invoice');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @nurse_site_visit_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 @nurse_site_visit_invoice_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_site_visit_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 @nurse_site_visit_invoice_id AS a, 'nurseFirstName' AS b, 'Nurse First Name' AS c, 'text' AS d, 1 AS e, 2 AS f) AS t
WHERE @nurse_site_visit_invoice_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_site_visit_invoice_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 @nurse_site_visit_invoice_id AS a, 'nurseLastName' AS b, 'Nurse Last Name' AS c, 'text' AS d, 1 AS e, 3 AS f) AS t
WHERE @nurse_site_visit_invoice_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_site_visit_invoice_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 @nurse_site_visit_invoice_id AS a, 'patientFirstName' AS b, 'Patient First Name' AS c, 'text' AS d, 1 AS e, 4 AS f) AS t
WHERE @nurse_site_visit_invoice_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_site_visit_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 @nurse_site_visit_invoice_id AS a, 'patientLastName' AS b, 'Patient Last Name' AS c, 'text' AS d, 1 AS e, 5 AS f) AS t
WHERE @nurse_site_visit_invoice_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_site_visit_invoice_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 @nurse_site_visit_invoice_id AS a, 'siteVisitDate' AS b, 'Date of Site Visit' AS c, 'date' AS d, 1 AS e, 6 AS f) AS t
WHERE @nurse_site_visit_invoice_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_site_visit_invoice_id AND field_key = 'siteVisitDate');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @nurse_site_visit_invoice_id AS a, 'amountDue' AS b, 'Amount Due for This Visit' AS c, 'number' AS d, 1 AS e, 7 AS f) AS t
WHERE @nurse_site_visit_invoice_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_site_visit_invoice_id AND field_key = 'amountDue');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @nurse_site_visit_invoice_id AS a, 'totalAmountDue' AS b, 'Total Amount Due of All Nurse Site Visits' AS c, 'number' AS d, 0 AS e, 8 AS f) AS t
WHERE @nurse_site_visit_invoice_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_site_visit_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 @nurse_site_visit_invoice_id AS a, 'dateTime' AS b, 'Date-Time' AS c, 'date' AS d, 0 AS e, 9 AS f) AS t
WHERE @nurse_site_visit_invoice_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_site_visit_invoice_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 @nurse_site_visit_invoice_id AS a, 'nurseSignature' AS b, 'Nurse Signature — type your full legal name to sign' AS c, 'text' AS d, 1 AS e, 10 AS f) AS t
WHERE @nurse_site_visit_invoice_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_site_visit_invoice_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 @nurse_site_visit_invoice_id AS a, 'title' AS b, 'Title (e.g. RN)' AS c, 'text' AS d, 1 AS e, 11 AS f) AS t
WHERE @nurse_site_visit_invoice_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_site_visit_invoice_id AND field_key = 'title');

-- ---- In-Home Site Visit Report ----
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, 'in-home-site-visit-report',
       'In-Home Site Visit Report', 'Thank you — the site visit report 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 = 'in-home-site-visit-report');

SET @in_home_site_visit_id = (SELECT id FROM dim_web_forms WHERE site_id = @larcare_site_id AND form_key = 'in-home-site-visit-report');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @in_home_site_visit_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 @in_home_site_visit_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @in_home_site_visit_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 @in_home_site_visit_id AS a, 'patientType' AS b, 'Patient Type' AS c, 'select' AS d, 0 AS e, 2 AS f, '{"options": ["Medicaid", "Veteran"]}' AS g) AS t
WHERE @in_home_site_visit_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @in_home_site_visit_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 @in_home_site_visit_id AS a, 'visitType' AS b, 'What Type of Site Visit Is This Request For?' AS c, 'select' AS d, 1 AS e, 3 AS f, '{"options": ["Initial Site Visit", "30 Day Site Visit", "90 Day Site Visit", "120 Day Site Visit for the 4 Month Site Visit", "Random drop by site visit"]}' AS g) AS t
WHERE @in_home_site_visit_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @in_home_site_visit_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 @in_home_site_visit_id AS a, 'patientFirstName' AS b, 'Patient First Name' AS c, 'text' AS d, 1 AS e, 4 AS f) AS t
WHERE @in_home_site_visit_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @in_home_site_visit_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 @in_home_site_visit_id AS a, 'patientLastName' AS b, 'Patient Last Name' AS c, 'text' AS d, 1 AS e, 5 AS f) AS t
WHERE @in_home_site_visit_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @in_home_site_visit_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 @in_home_site_visit_id AS a, 'siteVisitDate' AS b, 'Site Visit Date' AS c, 'date' AS d, 0 AS e, 6 AS f) AS t
WHERE @in_home_site_visit_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @in_home_site_visit_id AND field_key = 'siteVisitDate');

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

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

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

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @in_home_site_visit_id AS a, 'nurseFirstName' AS b, 'Nurse First Name' AS c, 'text' AS d, 0 AS e, 10 AS f) AS t
WHERE @in_home_site_visit_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @in_home_site_visit_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 @in_home_site_visit_id AS a, 'nurseLastName' AS b, 'Nurse Last Name' AS c, 'text' AS d, 0 AS e, 11 AS f) AS t
WHERE @in_home_site_visit_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @in_home_site_visit_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 @in_home_site_visit_id AS a, 'patientCltcNo' AS b, 'Patient CLTC No.' AS c, 'text' AS d, 0 AS e, 12 AS f) AS t
WHERE @in_home_site_visit_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @in_home_site_visit_id AND field_key = 'patientCltcNo');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @in_home_site_visit_id AS a, 'careLevelOfService' AS b, 'Personal Care Level of Service (e.g. companion care, personal care, respite care)' AS c, 'text' AS d, 0 AS e, 13 AS f) AS t
WHERE @in_home_site_visit_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @in_home_site_visit_id AND field_key = 'careLevelOfService');

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

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

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @in_home_site_visit_id AS a, 'aideOrSupervisorLastName' AS b, 'Aide or Supervisor Last Name' AS c, 'text' AS d, 0 AS e, 16 AS f) AS t
WHERE @in_home_site_visit_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @in_home_site_visit_id AND field_key = 'aideOrSupervisorLastName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @in_home_site_visit_id AS a, 'aideStatus' AS b, 'Aide Status' AS c, 'select' AS d, 1 AS e, 17 AS f, '{"options": ["Present", "Not Present", "Routine Site Visit", "Unscheduled Site Visit"]}' AS g) AS t
WHERE @in_home_site_visit_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @in_home_site_visit_id AND field_key = 'aideStatus');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @in_home_site_visit_id AS a, 'newStaffIntroduction' AS b, 'Introduction of New Staff or Routine Checking on Current Staff' AS c, 'select' AS d, 1 AS e, 18 AS f, '{"options": ["Yes", "No"]}' AS g) AS t
WHERE @in_home_site_visit_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @in_home_site_visit_id AND field_key = 'newStaffIntroduction');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @in_home_site_visit_id AS a, 'observationsNoted' AS b, 'Any Observation That Need to Be Noted' AS c, 'textarea' AS d, 0 AS e, 19 AS f) AS t
WHERE @in_home_site_visit_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @in_home_site_visit_id AND field_key = 'observationsNoted');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @in_home_site_visit_id AS a, 'careNeedsMet' AS b, 'Personal Care Needs of Patient Met' AS c, 'select' AS d, 1 AS e, 20 AS f, '{"options": ["Yes", "No", "N/A for not applicable"]}' AS g) AS t
WHERE @in_home_site_visit_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @in_home_site_visit_id AND field_key = 'careNeedsMet');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @in_home_site_visit_id AS a, 'carePlanReviewed' AS b, 'Plan of Care Reviewed/Revised' AS c, 'select' AS d, 1 AS e, 21 AS f, '{"options": ["Yes", "No", "N/A for not applicable"]}' AS g) AS t
WHERE @in_home_site_visit_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @in_home_site_visit_id AND field_key = 'carePlanReviewed');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @in_home_site_visit_id AS a, 'carePlanComments' AS b, 'Care Plan Comments' AS c, 'textarea' AS d, 0 AS e, 22 AS f) AS t
WHERE @in_home_site_visit_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @in_home_site_visit_id AND field_key = 'carePlanComments');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @in_home_site_visit_id AS a, 'clientSatisfied' AS b, 'Is the Client/Family Satisfied with Services?' AS c, 'select' AS d, 1 AS e, 23 AS f, '{"options": ["Yes", "No", "N/A for not applicable"]}' AS g) AS t
WHERE @in_home_site_visit_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @in_home_site_visit_id AND field_key = 'clientSatisfied');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @in_home_site_visit_id AS a, 'satisfactionComments' AS b, 'Satisfaction Comments' AS c, 'textarea' AS d, 0 AS e, 24 AS f) AS t
WHERE @in_home_site_visit_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @in_home_site_visit_id AND field_key = 'satisfactionComments');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @in_home_site_visit_id AS a, 'environmentSafe' AS b, 'Environment Noted with No Safety Issues' AS c, 'select' AS d, 1 AS e, 25 AS f, '{"options": ["Yes", "No", "N/A for not applicable"]}' AS g) AS t
WHERE @in_home_site_visit_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @in_home_site_visit_id AND field_key = 'environmentSafe');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @in_home_site_visit_id AS a, 'environmentComments' AS b, 'Environment Comments' AS c, 'textarea' AS d, 0 AS e, 26 AS f) AS t
WHERE @in_home_site_visit_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @in_home_site_visit_id AND field_key = 'environmentComments');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @in_home_site_visit_id AS a, 'aideChecklistHeading' AS b, 'Aide Checklist' AS c, 'heading' AS d, 0 AS e, 27 AS f) AS t
WHERE @in_home_site_visit_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @in_home_site_visit_id AND field_key = 'aideChecklistHeading');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @in_home_site_visit_id AS a, 'aidePpeBadge' AS b, '1) Aide Has Necessary PPE & Name Badge' AS c, 'select' AS d, 1 AS e, 28 AS f, '{"options": ["Yes", "No", "N/A for not applicable"]}' AS g) AS t
WHERE @in_home_site_visit_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @in_home_site_visit_id AND field_key = 'aidePpeBadge');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @in_home_site_visit_id AS a, 'aidePpeComments' AS b, 'PPE/Badge Comments' AS c, 'textarea' AS d, 0 AS e, 29 AS f) AS t
WHERE @in_home_site_visit_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @in_home_site_visit_id AND field_key = 'aidePpeComments');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @in_home_site_visit_id AS a, 'aideTimesheetReview' AS b, '2) Review of Aide Timesheet/Service Log' AS c, 'select' AS d, 1 AS e, 30 AS f, '{"options": ["Yes", "No", "N/A for not applicable"]}' AS g) AS t
WHERE @in_home_site_visit_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @in_home_site_visit_id AND field_key = 'aideTimesheetReview');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @in_home_site_visit_id AS a, 'aideTimesheetComments' AS b, 'Timesheet Comments' AS c, 'textarea' AS d, 0 AS e, 31 AS f) AS t
WHERE @in_home_site_visit_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @in_home_site_visit_id AND field_key = 'aideTimesheetComments');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @in_home_site_visit_id AS a, 'aideHandHygiene' AS b, '3) Aide Uses Hand Washing/Hand Hygiene' AS c, 'select' AS d, 1 AS e, 32 AS f, '{"options": ["Yes", "No", "N/A for not applicable"]}' AS g) AS t
WHERE @in_home_site_visit_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @in_home_site_visit_id AND field_key = 'aideHandHygiene');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @in_home_site_visit_id AS a, 'aideHandHygieneComments' AS b, 'Hand Hygiene Comments' AS c, 'textarea' AS d, 0 AS e, 33 AS f) AS t
WHERE @in_home_site_visit_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @in_home_site_visit_id AND field_key = 'aideHandHygieneComments');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @in_home_site_visit_id AS a, 'aideStandardPrecautions' AS b, '4) Demonstrates Compliance with Standard Precautions' AS c, 'select' AS d, 1 AS e, 34 AS f, '{"options": ["Satisfactory", "Unsatisfactory", "N/A for not applicable"]}' AS g) AS t
WHERE @in_home_site_visit_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @in_home_site_visit_id AND field_key = 'aideStandardPrecautions');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @in_home_site_visit_id AS a, 'aideStandardPrecautionsComments' AS b, 'Standard Precautions Comments' AS c, 'textarea' AS d, 0 AS e, 35 AS f) AS t
WHERE @in_home_site_visit_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @in_home_site_visit_id AND field_key = 'aideStandardPrecautionsComments');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @in_home_site_visit_id AS a, 'aideTasksPerformed' AS b, '5) Performs Tasks/Hours of Service as Specified on Plan of Care' AS c, 'select' AS d, 1 AS e, 36 AS f, '{"options": ["Satisfactory", "Unsatisfactory", "N/A for not applicable"]}' AS g) AS t
WHERE @in_home_site_visit_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @in_home_site_visit_id AND field_key = 'aideTasksPerformed');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @in_home_site_visit_id AS a, 'aideTasksComments' AS b, 'Comments/Areas to Improve' AS c, 'textarea' AS d, 0 AS e, 37 AS f) AS t
WHERE @in_home_site_visit_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @in_home_site_visit_id AND field_key = 'aideTasksComments');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @in_home_site_visit_id AS a, 'aideQuestionsConcerns' AS b, '6) Questions/Concerns by Patient, Aide, and/or Other or Custom Care Plans' AS c, 'textarea' AS d, 1 AS e, 38 AS f) AS t
WHERE @in_home_site_visit_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @in_home_site_visit_id AND field_key = 'aideQuestionsConcerns');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @in_home_site_visit_id AS a, 'aideResponse' AS b, '7) Response' AS c, 'textarea' AS d, 1 AS e, 39 AS f) AS t
WHERE @in_home_site_visit_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @in_home_site_visit_id AND field_key = 'aideResponse');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @in_home_site_visit_id AS a, 'timeIn' AS b, '8) Time In' AS c, 'text' AS d, 1 AS e, 40 AS f) AS t
WHERE @in_home_site_visit_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @in_home_site_visit_id AND field_key = 'timeIn');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @in_home_site_visit_id AS a, 'timeOut' AS b, 'Time Out' AS c, 'text' AS d, 1 AS e, 41 AS f) AS t
WHERE @in_home_site_visit_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @in_home_site_visit_id AND field_key = 'timeOut');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @in_home_site_visit_id AS a, 'supervisorFullName' AS b, 'Supervisor Site Visit — Full Name' AS c, 'text' AS d, 1 AS e, 42 AS f) AS t
WHERE @in_home_site_visit_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @in_home_site_visit_id AND field_key = 'supervisorFullName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @in_home_site_visit_id AS a, 'supervisorTitle' AS b, 'Supervisor Title (e.g. RN)' AS c, 'text' AS d, 0 AS e, 43 AS f) AS t
WHERE @in_home_site_visit_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @in_home_site_visit_id AND field_key = 'supervisorTitle');

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

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

-- ---- LarCare/SamariCare Home Care Assessment 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, 'home-care-assessment',
       'LarCare/SamariCare Home Care Assessment Form', 'Thank you — the assessment 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 = 'home-care-assessment');

SET @home_care_assessment_id = (SELECT id FROM dim_web_forms WHERE site_id = @larcare_site_id AND form_key = 'home-care-assessment');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @home_care_assessment_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 @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_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 @home_care_assessment_id AS a, 'clientInfoHeading' AS b, '1. Client Information' AS c, 'heading' AS d, 0 AS e, 2 AS f) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'clientInfoHeading');

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

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

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'dateOfBirth' AS b, 'Date of Birth' AS c, 'date' AS d, 1 AS e, 5 AS f) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_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 @home_care_assessment_id AS a, 'addressStreet' AS b, 'Street Address' AS c, 'text' AS d, 0 AS e, 6 AS f) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_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 @home_care_assessment_id AS a, 'addressCity' AS b, 'City' AS c, 'text' AS d, 0 AS e, 7 AS f) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_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 @home_care_assessment_id AS a, 'addressState' AS b, 'State/Region/Province' AS c, 'text' AS d, 0 AS e, 8 AS f) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_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 @home_care_assessment_id AS a, 'addressZip' AS b, 'Postal / Zip Code' AS c, 'text' AS d, 0 AS e, 9 AS f) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'addressZip');

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

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'emergencyContactFirstName' AS b, 'Emergency Contact First Name' AS c, 'text' AS d, 0 AS e, 11 AS f) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_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 @home_care_assessment_id AS a, 'emergencyContactLastName' AS b, 'Emergency Contact Last Name' AS c, 'text' AS d, 0 AS e, 12 AS f) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_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 @home_care_assessment_id AS a, 'emergencyContactRelationship' AS b, 'Emergency Contact Relationship' AS c, 'text' AS d, 0 AS e, 13 AS f) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_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 @home_care_assessment_id AS a, 'emergencyContactPhone' AS b, 'Emergency Contact Phone' AS c, 'tel' AS d, 0 AS e, 14 AS f) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_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 @home_care_assessment_id AS a, 'pcpName' AS b, 'Primary Care Physician (title, first, last)' AS c, 'text' AS d, 0 AS e, 15 AS f) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'pcpName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'pcpPhone' AS b, 'Physician Phone' AS c, 'tel' AS d, 0 AS e, 16 AS f) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_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 @home_care_assessment_id AS a, 'dnr' AS b, 'DNR' AS c, 'text' AS d, 0 AS e, 17 AS f) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'dnr');

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

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'hospitalOfChoice' AS b, 'Hospital of Choice' AS c, 'text' AS d, 0 AS e, 19 AS f) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'hospitalOfChoice');

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

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'medicalHistoryHeading' AS b, '2. Medical History & Current Conditions' AS c, 'heading' AS d, 0 AS e, 21 AS f) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'medicalHistoryHeading');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'primaryDiagnosis' AS b, 'Primary Diagnosis' AS c, 'text' AS d, 0 AS e, 22 AS f) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'primaryDiagnosis');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'chronicConditions' AS b, 'Chronic Conditions (comma-separated: Diabetes, Dementia/Alzheimer''s, Parkinson''s, Stroke, COPD, CHF, Arthritis, Cancer, Other)' AS c, 'text' AS d, 0 AS e, 23 AS f) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'chronicConditions');

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

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'currentMedications' AS b, 'Current Medications (name, dose, taken — one per line)' AS c, 'textarea' AS d, 0 AS e, 25 AS f) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'currentMedications');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'recentHospitalizations' AS b, 'Recent Hospitalizations (Last 6 Months)' AS c, 'select' AS d, 0 AS e, 26 AS f, '{"options": ["Yes", "No"]}' AS g) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'recentHospitalizations');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'recentHospitalizationReason' AS b, 'If Yes, Reason' AS c, 'text' AS d, 0 AS e, 27 AS f) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'recentHospitalizationReason');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'functionalAbilitiesHeading' AS b, '3. Functional Abilities (ADLs & IADLs Assessment)' AS c, 'heading' AS d, 0 AS e, 28 AS f) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'functionalAbilitiesHeading');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'adlBathing' AS b, 'Bathing' AS c, 'select' AS d, 1 AS e, 29 AS f, '{"options": ["Independent", "Needs Some Help", "Needs Full Assistance"]}' AS g) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'adlBathing');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'adlDressing' AS b, 'Dressing' AS c, 'select' AS d, 1 AS e, 30 AS f, '{"options": ["Independent", "Needs Some Help", "Needs Full Assistance"]}' AS g) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'adlDressing');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'adlGrooming' AS b, 'Grooming' AS c, 'select' AS d, 1 AS e, 31 AS f, '{"options": ["Independent", "Needs Some Help", "Needs Full Assistance"]}' AS g) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'adlGrooming');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'adlToileting' AS b, 'Toileting' AS c, 'select' AS d, 1 AS e, 32 AS f, '{"options": ["Independent", "Needs Some Help", "Needs Full Assistance"]}' AS g) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'adlToileting');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'adlMobility' AS b, 'Mobility (Walking)' AS c, 'select' AS d, 1 AS e, 33 AS f, '{"options": ["Independent", "Needs Some Help", "Needs Full Assistance"]}' AS g) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'adlMobility');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'adlTransferring' AS b, 'Transferring (Bed/Chair)' AS c, 'select' AS d, 1 AS e, 34 AS f, '{"options": ["Independent", "Needs Some Help", "Needs Full Assistance"]}' AS g) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'adlTransferring');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'adlEating' AS b, 'Eating' AS c, 'select' AS d, 1 AS e, 35 AS f, '{"options": ["Independent", "Needs Some Help", "Needs Full Assistance"]}' AS g) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'adlEating');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'adlMedicationManagement' AS b, 'Medication Management' AS c, 'select' AS d, 1 AS e, 36 AS f, '{"options": ["Independent", "Needs Some Help", "Needs Full Assistance"]}' AS g) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'adlMedicationManagement');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'adlMealPrep' AS b, 'Meal Preparation' AS c, 'select' AS d, 1 AS e, 37 AS f, '{"options": ["Independent", "Needs Some Help", "Needs Full Assistance"]}' AS g) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'adlMealPrep');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'adlHousekeeping' AS b, 'Housekeeping' AS c, 'select' AS d, 1 AS e, 38 AS f, '{"options": ["Independent", "Needs Some Help", "Needs Full Assistance"]}' AS g) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'adlHousekeeping');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'adlTransportation' AS b, 'Transportation' AS c, 'select' AS d, 1 AS e, 39 AS f, '{"options": ["Independent", "Needs Some Help", "Needs Full Assistance"]}' AS g) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'adlTransportation');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'adlMoneyManagement' AS b, 'Money Management' AS c, 'select' AS d, 1 AS e, 40 AS f, '{"options": ["Independent", "Needs Some Help", "Needs Full Assistance"]}' AS g) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'adlMoneyManagement');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'cognitiveHeading' AS b, '4. Cognitive & Behavioral Assessment' AS c, 'heading' AS d, 0 AS e, 41 AS f) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'cognitiveHeading');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'orientedToTimePlace' AS b, 'Oriented to Time & Place?' AS c, 'select' AS d, 1 AS e, 42 AS f, '{"options": ["Yes", "No"]}' AS g) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'orientedToTimePlace');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'memoryIssues' AS b, 'Memory Issues' AS c, 'select' AS d, 0 AS e, 43 AS f, '{"options": ["Mild", "Moderate", "Severe"]}' AS g) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'memoryIssues');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'wandersOrGetsLost' AS b, 'Wanders or Gets Lost?' AS c, 'select' AS d, 1 AS e, 44 AS f, '{"options": ["Yes", "No"]}' AS g) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'wandersOrGetsLost');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'moodBehavioralIssues' AS b, 'Mood or Behavioral Issues (comma-separated: Depression, Anxiety, Agitation, None)' AS c, 'text' AS d, 0 AS e, 45 AS f) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'moodBehavioralIssues');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'homeSafetyHeading' AS b, '5. Home Safety & Environment' AS c, 'heading' AS d, 0 AS e, 46 AS f) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'homeSafetyHeading');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'homeSafetyFeatures' AS b, 'Home Has (comma-separated: Stairs, Grab Bars in Bathroom, Ramps, Smoke Detectors)' AS c, 'text' AS d, 0 AS e, 47 AS f) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'homeSafetyFeatures');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'fallsHistory' AS b, 'Is There a History of Falls?' AS c, 'select' AS d, 1 AS e, 48 AS f, '{"options": ["Yes", "No"]}' AS g) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'fallsHistory');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'fallsHistoryWhen' AS b, 'If Yes, When' AS c, 'text' AS d, 0 AS e, 49 AS f) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'fallsHistoryWhen');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'petsInHome' AS b, 'Are There Pets in the Home?' AS c, 'select' AS d, 1 AS e, 50 AS f, '{"options": ["Yes", "No"]}' AS g) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'petsInHome');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'petsType' AS b, 'If Yes, Type' AS c, 'text' AS d, 0 AS e, 51 AS f) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'petsType');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'caregiverSupportHeading' AS b, '6. Caregiver & Support System' AS c, 'heading' AS d, 0 AS e, 52 AS f) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'caregiverSupportHeading');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'livesAlone' AS b, 'Does the Client Live Alone?' AS c, 'select' AS d, 1 AS e, 53 AS f, '{"options": ["Yes", "No"]}' AS g) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'livesAlone');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'primaryCaregiverName' AS b, 'Primary Caregiver Name (title, first, last)' AS c, 'text' AS d, 0 AS e, 54 AS f) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'primaryCaregiverName');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'caregiverRelationship' AS b, 'Relationship to Client' AS c, 'text' AS d, 0 AS e, 55 AS f) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'caregiverRelationship');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'caregiverAvailability' AS b, 'Caregiver Availability' AS c, 'select' AS d, 0 AS e, 56 AS f, '{"options": ["Full-Time", "Part-Time", "None"]}' AS g) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'caregiverAvailability');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'otherSupportServices' AS b, 'Other Support Services in Place (comma-separated: Home Health Nurse, Physical Therapy, Occupational Therapy, Meals on Wheels, Transportation Services)' AS c, 'text' AS d, 0 AS e, 57 AS f) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'otherSupportServices');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'servicesRequestedHeading' AS b, '7. Home Care Services Requested' AS c, 'heading' AS d, 0 AS e, 58 AS f) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'servicesRequestedHeading');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'servicesRequested' AS b, 'Services Requested (comma-separated: Personal Care, Medication Reminders, Light Housekeeping, Meal Preparation, Transportation, Dementia/Alzheimer''s Care, 24/7 Live-in Care, Companionship)' AS c, 'text' AS d, 1 AS e, 59 AS f) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'servicesRequested');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'notesHeading' AS b, '8. Notes & Care Plan Recommendations' AS c, 'heading' AS d, 0 AS e, 60 AS f) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'notesHeading');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'notesRecommendations' AS b, 'Notes & Care Plan Recommendations' AS c, 'textarea' AS d, 0 AS e, 61 AS f) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'notesRecommendations');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'nextSteps' AS b, 'Next Steps' AS c, 'textarea' AS d, 0 AS e, 62 AS f) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'nextSteps');

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

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

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'reviewedBySupervisor' AS b, 'Reviewed by Agency Supervisor (title, first, last)' AS c, 'text' AS d, 0 AS e, 65 AS f) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'reviewedBySupervisor');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'caregiverNeeds' AS b, 'What Are the Caregiver Needs' AS c, 'textarea' AS d, 0 AS e, 66 AS f) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'caregiverNeeds');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'hoursNeeded' AS b, 'Hours Needed' AS c, 'text' AS d, 0 AS e, 67 AS f) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'hoursNeeded');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @home_care_assessment_id AS a, 'daysOfWeek' AS b, 'Days of the Week (comma-separated)' AS c, 'text' AS d, 1 AS e, 68 AS f) AS t
WHERE @home_care_assessment_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @home_care_assessment_id AND field_key = 'daysOfWeek');

-- ---- Home Health Nurse Performance Evaluation ----
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, 'home-health-nurse-performance-evaluation',
       'Home Health Nurse Performance Evaluation', 'Thank you — the evaluation 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 = 'home-health-nurse-performance-evaluation');

SET @nurse_performance_eval_id = (SELECT id FROM dim_web_forms WHERE site_id = @larcare_site_id AND form_key = 'home-health-nurse-performance-evaluation');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @nurse_performance_eval_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 @nurse_performance_eval_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_performance_eval_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 @nurse_performance_eval_id AS a, 'employeeFirstName' AS b, 'Employee First Name' AS c, 'text' AS d, 1 AS e, 2 AS f) AS t
WHERE @nurse_performance_eval_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_performance_eval_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 @nurse_performance_eval_id AS a, 'employeeLastName' AS b, 'Employee Last Name' AS c, 'text' AS d, 1 AS e, 3 AS f) AS t
WHERE @nurse_performance_eval_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_performance_eval_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 @nurse_performance_eval_id AS a, 'evalPeriodStart' AS b, 'Evaluation Period Start' AS c, 'date' AS d, 1 AS e, 4 AS f) AS t
WHERE @nurse_performance_eval_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_performance_eval_id AND field_key = 'evalPeriodStart');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @nurse_performance_eval_id AS a, 'evalPeriodEnd' AS b, 'Evaluation Period End' AS c, 'date' AS d, 1 AS e, 5 AS f) AS t
WHERE @nurse_performance_eval_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_performance_eval_id AND field_key = 'evalPeriodEnd');

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

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

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @nurse_performance_eval_id AS a, 'clinicalCompetenceHeading' AS b, 'Clinical Competence (21 points)' AS c, 'heading' AS d, 0 AS e, 8 AS f) AS t
WHERE @nurse_performance_eval_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_performance_eval_id AND field_key = 'clinicalCompetenceHeading');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @nurse_performance_eval_id AS a, 'clinicalCareQuality' AS b, 'Provides high-quality clinical care (1-7, 1=lowest, 7=highest)' AS c, 'number' AS d, 1 AS e, 9 AS f) AS t
WHERE @nurse_performance_eval_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_performance_eval_id AND field_key = 'clinicalCareQuality');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @nurse_performance_eval_id AS a, 'clinicalKnowledge' AS b, 'Demonstrates up-to-date nursing knowledge (1-7, 1=lowest, 7=highest)' AS c, 'number' AS d, 1 AS e, 10 AS f) AS t
WHERE @nurse_performance_eval_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_performance_eval_id AND field_key = 'clinicalKnowledge');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @nurse_performance_eval_id AS a, 'clinicalProtocols' AS b, 'Follows all healthcare protocols and procedures (1-7, 1=lowest, 7=highest)' AS c, 'number' AS d, 1 AS e, 11 AS f) AS t
WHERE @nurse_performance_eval_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_performance_eval_id AND field_key = 'clinicalProtocols');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @nurse_performance_eval_id AS a, 'assessmentHeading' AS b, 'Patient Assessment and Care Planning (21 points)' AS c, 'heading' AS d, 0 AS e, 12 AS f) AS t
WHERE @nurse_performance_eval_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_performance_eval_id AND field_key = 'assessmentHeading');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @nurse_performance_eval_id AS a, 'assessmentThorough' AS b, 'Conducts thorough and accurate patient assessments (1-7, 1=lowest, 7=highest)' AS c, 'number' AS d, 1 AS e, 13 AS f) AS t
WHERE @nurse_performance_eval_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_performance_eval_id AND field_key = 'assessmentThorough');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @nurse_performance_eval_id AS a, 'assessmentCarePlans' AS b, 'Creates and updates care plans effectively (1-7, 1=lowest, 7=highest)' AS c, 'number' AS d, 1 AS e, 14 AS f) AS t
WHERE @nurse_performance_eval_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_performance_eval_id AND field_key = 'assessmentCarePlans');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @nurse_performance_eval_id AS a, 'assessmentMonitors' AS b, 'Monitors patient status and adjusts care as needed (1-7, 1=lowest, 7=highest)' AS c, 'number' AS d, 1 AS e, 15 AS f) AS t
WHERE @nurse_performance_eval_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_performance_eval_id AND field_key = 'assessmentMonitors');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @nurse_performance_eval_id AS a, 'communicationHeading' AS b, 'Communication Skills (21 points)' AS c, 'heading' AS d, 0 AS e, 16 AS f) AS t
WHERE @nurse_performance_eval_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_performance_eval_id AND field_key = 'communicationHeading');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @nurse_performance_eval_id AS a, 'commEffective' AS b, 'Communicates effectively with patients, families, and the healthcare team (1-7, 1=lowest, 7=highest)' AS c, 'number' AS d, 1 AS e, 17 AS f) AS t
WHERE @nurse_performance_eval_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_performance_eval_id AND field_key = 'commEffective');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @nurse_performance_eval_id AS a, 'commDocumentation' AS b, 'Documents patient care accurately and in a timely manner (1-7, 1=lowest, 7=highest)' AS c, 'number' AS d, 1 AS e, 18 AS f) AS t
WHERE @nurse_performance_eval_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_performance_eval_id AND field_key = 'commDocumentation');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @nurse_performance_eval_id AS a, 'commHandover' AS b, 'Ensures clear handover and continuity of care (1-7, 1=lowest, 7=highest)' AS c, 'number' AS d, 1 AS e, 19 AS f) AS t
WHERE @nurse_performance_eval_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_performance_eval_id AND field_key = 'commHandover');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @nurse_performance_eval_id AS a, 'professionalDevHeading' AS b, 'Professional Development (21 points)' AS c, 'heading' AS d, 0 AS e, 20 AS f) AS t
WHERE @nurse_performance_eval_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_performance_eval_id AND field_key = 'professionalDevHeading');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @nurse_performance_eval_id AS a, 'devCertifications' AS b, 'Maintains required certifications and licensure (1-7, 1=lowest, 7=highest)' AS c, 'number' AS d, 1 AS e, 21 AS f) AS t
WHERE @nurse_performance_eval_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_performance_eval_id AND field_key = 'devCertifications');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @nurse_performance_eval_id AS a, 'devEducation' AS b, 'Participates in educational opportunities to enhance nursing practice (1-7, 1=lowest, 7=highest)' AS c, 'number' AS d, 1 AS e, 22 AS f) AS t
WHERE @nurse_performance_eval_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_performance_eval_id AND field_key = 'devEducation');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @nurse_performance_eval_id AS a, 'devSharesKnowledge' AS b, 'Shares knowledge with colleagues to improve team competence (1-7, 1=lowest, 7=highest)' AS c, 'number' AS d, 1 AS e, 23 AS f) AS t
WHERE @nurse_performance_eval_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_performance_eval_id AND field_key = 'devSharesKnowledge');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @nurse_performance_eval_id AS a, 'complianceHeading' AS b, 'Compliance and Ethics (21 points)' AS c, 'heading' AS d, 0 AS e, 24 AS f) AS t
WHERE @nurse_performance_eval_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_performance_eval_id AND field_key = 'complianceHeading');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @nurse_performance_eval_id AS a, 'complianceStandards' AS b, 'Adheres to legal, ethical, and regulatory standards (1-7, 1=lowest, 7=highest)' AS c, 'number' AS d, 1 AS e, 25 AS f) AS t
WHERE @nurse_performance_eval_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_performance_eval_id AND field_key = 'complianceStandards');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @nurse_performance_eval_id AS a, 'complianceConfidentiality' AS b, 'Maintains patient confidentiality and privacy (1-7, 1=lowest, 7=highest)' AS c, 'number' AS d, 1 AS e, 26 AS f) AS t
WHERE @nurse_performance_eval_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_performance_eval_id AND field_key = 'complianceConfidentiality');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @nurse_performance_eval_id AS a, 'complianceIntegrity' AS b, 'Demonstrates honesty and integrity in all aspects of work (1-7, 1=lowest, 7=highest)' AS c, 'number' AS d, 1 AS e, 27 AS f) AS t
WHERE @nurse_performance_eval_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_performance_eval_id AND field_key = 'complianceIntegrity');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @nurse_performance_eval_id AS a, 'evaluatorComments' AS b, 'Evaluator Comments' AS c, 'textarea' AS d, 0 AS e, 28 AS f) AS t
WHERE @nurse_performance_eval_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_performance_eval_id AND field_key = 'evaluatorComments');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order, config_json)
SELECT * FROM (SELECT @nurse_performance_eval_id AS a, 'overallRating' AS b, 'Overall Performance Rating (total possible score = 105)' AS c, 'select' AS d, 1 AS e, 29 AS f, '{"options": ["Outstanding 80-105", "Exceeds Expectations 60-79", "Meets Expectations 40-59", "Needs Improvement 20-39", "Unsatisfactory 1-19"]}' AS g) AS t
WHERE @nurse_performance_eval_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_performance_eval_id AND field_key = 'overallRating');

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

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @nurse_performance_eval_id AS a, 'durationOfReview' AS b, 'Duration of Review' AS c, 'text' AS d, 0 AS e, 31 AS f) AS t
WHERE @nurse_performance_eval_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_performance_eval_id AND field_key = 'durationOfReview');

INSERT INTO dim_web_form_fields (form_id, field_key, label, field_type, is_required, sort_order)
SELECT * FROM (SELECT @nurse_performance_eval_id AS a, 'dateTime' AS b, 'Date-Time' AS c, 'date' AS d, 0 AS e, 32 AS f) AS t
WHERE @nurse_performance_eval_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_performance_eval_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 @nurse_performance_eval_id AS a, 'signature' AS b, 'Signature — type your full legal name to sign' AS c, 'text' AS d, 1 AS e, 33 AS f) AS t
WHERE @nurse_performance_eval_id IS NOT NULL
  AND NOT EXISTS (SELECT 1 FROM dim_web_form_fields WHERE form_id = @nurse_performance_eval_id AND field_key = 'signature');