{
  "facility_sql": "SELECT /*FACILITY_TAG*/\r\n    c.GUID,\r\n    c.FIRSTNAME AS First_Name,\r\n    c.LASTNAME AS Last_Name,\r\n    c.CURRENT_STATUS AS Current_Status,\r\n    s.STATUS AS Scheduled_Status,\r\n    s.START_DATE AS Termination_Start_Date\r\nFROM customers c\r\nJOIN status s \r\n    ON s.CUSTOMER_ID = c.CUSTOMER_ID\r\nWHERE s.STATUS = 'TERMINATE'\r\n  AND s.START_DATE BETWEEN '/*START_DATE*/' AND '/*END_DATE*/'\r\n  AND c.CUSTOMER_ID NOT IN (\r\n        SELECT n.CUSTOMER_ID\r\n        FROM notes n\r\n        WHERE n.NOTES LIKE '%transferred to%'\r\n          AND n.POSTDATE BETWEEN '/*START_DATE*/' AND '/*END_DATE*/'\r\n    )\r\nORDER BY s.START_DATE DESC;",
  "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}",
  "name": "Terminations (No Transfers)"
}