{
  "facility_sql": "SELECT\n  /*FACILITY_TAG*/\n  c.HOME_LOCATION_TAG,\n  c.CUSTOMER_ID,\n  c.GUID,\n  c.FIRST_CONTACT_DATE,\n  c.LAST_VISIT_DATE,\n  c.CUSTOMER_TYPE,\n  c.CURRENT_STATUS,\n  c.LASTNAME,\n  c.FIRSTNAME,\n  c.BDAY,\n  s.START_DATE,\n  s.NOTES,\n  t.TAG\nFROM customers c\nLEFT JOIN tags t\n  ON c.CUSTOMER_ID = t.PARENT_ID\nAND t.TAG LIKE '/Termination%'\nLEFT JOIN status s\n  ON c.CUSTOMER_ID = s.CUSTOMER_ID\nWHERE s.STATUS LIKE 'Terminate'\n  AND (s.NOTES IS NULL OR s.NOTES NOT LIKE 'Transfer%')\n  AND s.START_DATE BETWEEN DATE('/*START_DATE*/') AND DATE('/*END_DATE*/');",
  "merge_sql": "",
  "json": "{\r\n  \"facility_column_tag\": \"/*FACILITY_TAG*/\",\r\n  \"wants_start_date\": {\r\n    \"tag\": \"/*START_DATE*/\"\r\n  },\r\n  \"wants_end_date\": {\r\n    \"tag\": \"/*END_DATE*/\"\r\n  }\r\n}",
  "guid": "593d2e7d-21a6-40c6-bb87-d9088204a23c",
  "name": "ERROR Terminated Reasons"
}