Select Agency_Login FROM Agency WHERE Agency_Login = #variables.agencylogin# SELECT Max(Agency_ID) AS ID FROM Agency CREATE DATABASE IF NOT EXISTS #agency_db# SELECT table_name FROM information_schema.tables WHERE table_schema = 'agency_179' and table_name not like 'x%' CREATE TABLE #agency_db#.#tablesname# LIKE agency_179.#tablesname# INSERT INTO pEmployee (Loc_ID,Status,Emp_First,Emp_Middle,Emp_Last,Emp_Street1,Emp_City,Emp_State,Emp_Zip,Emp_Telephone,Emp_Email, Emp_DOB,Emp_Gender,Emp_Type,Emp_Latitude,Emp_Longitude,Skill_1,Skill_2,Skill_3, Date_Hire,Date_Terminate,PasswordReset) VALUES ( '#agency_id#', 0, 'Joy', '', 'De Castro', 'TEst address1', 'Maine', 'Maine', '04401', '9874561231', 'joy.d@myhomecarebiz.com', '1990-01-30', '2 - FeMale', 'Employee','-68.815722', '44', 'SN', 'PT', 'OT', '2022-06-07', NULL, NULL) INSERT INTO #agency_db#.DocumentDesc (DOC_ID, Agency_ID, DocumentType, Skill, Required, Description, Expires) VALUES ( '1', '#agency_id#' , 'Patient', 'SN', '1', 'Physician Face-to-Face (F2F)','expires on certification end date'), ( '2', '#agency_id#' , 'Patient', 'SN', '1', 'History & Physical (H&P)','expires never'), ( '3', '#agency_id#' , 'Patient', 'SN', '0', 'Home Health Order','expires never'), ( '4', '#agency_id#' , 'Patient', 'SN', '0', 'CMS Forms','expires never'), ( '5', '#agency_id#' , 'Patient', 'SN', '0', 'Admission Forms','expires never'), ( '6', '#agency_id#' , 'Patient', 'SN', '0', 'Clinical Forms','expires never'), ( '7', '#agency_id#' , 'Patient', 'SN', '0', 'Insurance Pre-Authorizations','expires never'), ( '8', '#agency_id#' , 'Patient', 'SN', '0', 'Physician Visit Notes','expires never'), ( '9', '#agency_id#' , 'Patient', 'SN', '0', 'Labs/Diagnostics Orders','expires never'), ( '10', '#agency_id#' , 'Patient', 'SN', '0', 'Labs/Diagnostics Results','expires never'); INSERT INTO #agency_db#.CommunicationSubjects ( Agency_ID, Subject, Created_By, Created_Date, Mod_By, Mod_Date, active) VALUES ('#agency_id#', 'missed visit', 2, NULL, NULL, NULL, 'Y'), ('#agency_id#', 'status & careplan changes', NULL, NULL, '2', '2022-11-03 09:31:16', 'Y'), ('#agency_id#', 'no treatment', '2', NULL, NULL, NULL, 'Y'), ('#agency_id#', 'Medication reconciliation', 2, NULL, NULL, NULL, 'Y'), ('#agency_id#', 'Discharge Summary - SN', 2, NULL, NULL, NULL, 'Y'), ('#agency_id#', 'Discharge Summary - PT', 2, NULL, NULL, NULL, 'Y'), ('#agency_id#', 'Discharge Summary - OT', 2, NULL, NULL, NULL, 'Y'), ('#agency_id#', 'Discharge Summary - ST', 2, NULL, NULL, NULL, 'Y'), ('#agency_id#', 'Discharge Summary - MSW', 2, NULL, NULL, NULL, 'Y'), ('#agency_id#', 'Physical Therapy BEFORE the 30 days', '2', NULL, NULL, NULL, 'Y'), ('#agency_id#', 'Report of Unstable Symptoms to Certifying Physician', 2, NULL, NULL, NULL, 'Y'), ('#agency_id#', 'Case Conference', 2, NULL, NULL, NULL, 'Y'), ('#agency_id#', 'Agency Transfer/Discharge Summary', 2, NULL, NULL, NULL, 'Y'), ('#agency_id#', '30-Day Summary', 2, NULL, NULL, NULL, 'Y'), ('#agency_id#', '60-Day Symmary', 2, NULL, NULL, NULL, 'Y'), ('#agency_id#', 'New Admission - Eligibility and/or Authorization Request', 2, NULL, NULL, NULL, 'Y'), ('#agency_id#', 'New Coding Request', 2, NULL, NULL, NULL, 'Y'), ('#agency_id#', 'procedure requires correction', 2, NULL, NULL, NULL, 'Y'), ('#agency_id#', 'progress note requires correction', 2, NULL, NULL, NULL, 'Y'), ('#agency_id#', 'Infection Surveillance Alert', 2, NULL, NULL, NULL, 'Y'), ('#agency_id#', 'patient needs will go unmet', 2, NULL, NULL, NULL, 'Y'), ('#agency_id#', 'Patient Cognition & Caregiver Status', 2, NULL, NULL, NULL, 'Y'), ('#agency_id#', 'Certification of Terminal Illness (CTI)', 2, NULL, NULL, NULL, 'Y'), ('#agency_id#', 'Physician Certification of Terminal Illness', 2, NULL, NULL, NULL, 'Y'), ('#agency_id#', 'Face to Face Encounter', 2, NULL, NULL, NULL, 'Y'), ('#agency_id#', 'symptoms with no related diagnosis', 2, NULL, NULL, NULL, 'Y'); INSERT INTO #agency_db#.pVital_Param (Param_ID, Agency_ID, Status, Item_ID, Vital_Sign, Value_Low, Value_High, Date_Create, Created_by, Date_Change, Change_by) VALUES ('1', '#agency_id#', '0', '1', 'temperature', '95', '100.5', NULL, NULL, NULL, NULL), ('2', '#agency_id#', '0', '2', 'heart rate', '50', '110', NULL, NULL, NULL, NULL), ('3', '#agency_id#', '0', '3', 'respiratory rate', '8', '22', NULL, NULL, NULL, NULL), ('4', '#agency_id#', '0', '4', 'blood pressure systolic', '90', '169', NULL, NULL, NULL, NULL), ('5', '#agency_id#', '0', '5', 'blood pressure diastolic', '60', '90', NULL, NULL, NULL, NULL), ('6', '#agency_id#', '0', '7', 'O2 saturation', '88', '100', NULL, NULL, NULL, NULL), ('7', '#agency_id#', '0', '8', 'pain', '0', '5', NULL, NULL, NULL, NULL), ('8', '#agency_id#', '0', '9', 'blood sugar', '60', '300', NULL, NULL, NULL, NULL), ('9', '#agency_id#', '0', '10', 'INR', '2', '3', NULL, NULL, NULL, NULL), ('10', '#agency_id#', '0', '11', 'cholesterol', '60', '500', NULL, NULL, NULL, NULL), ('11', '#agency_id#', '0', '12', 'lithium', '0', '0', NULL, NULL, NULL, NULL); INSERT INTO #Request.prefix_db_lookup#.pStanding_Orders (Agency_ID, Status, Description) VALUES ( '#agency_id#', '0', 'infection control: hygiene, proper hand washing'), ( '#agency_id#', '0', 'advance directive: plan if patient is unable to make healthcare decisions '), ( '#agency_id#', '0', 'fall precautions: wear sensible shoes, remove home hazards, living space adequately lit, assistive devices prn'), ( '#agency_id#', '0', 'emergency preparedness: plan for prn evacuation, resumption of home health visits'); INSERT INTO #agency_db#.EventSubjects ( Agency_ID, Subject) VALUES (#agency_id#,'missing medical records'), (#agency_id#,'equipment maintenance and/or operational problems'), (#agency_id#,'inadequate supplies'), (#agency_id#,'error(s) in medication administration, dosage, route, frequency'), (#agency_id#,'error(s) in treatment'), (#agency_id#,'failure of patient education material'), (#agency_id#,'significant side effect(s) associated with medication'), (#agency_id#,'significant side effect(s) associated with treatment'), (#agency_id#,'patient or employee injury during care'), (#agency_id#,'hazardous waste management violation'), (#agency_id#,'fire or utility hazard'), (#agency_id#,'workplace safety violation'), (#agency_id#,'direct exposure to patient body fluid including needlestick(s)'), (#agency_id#,'error(s) in documentation/reporting'), (#agency_id#,'inadequate Agency and/or community resources'), (#agency_id#,'violation of patient confidentiality, privacy, or security'), (#agency_id#,'scheduling error(s)'), (#agency_id#,'Other'); UPDATE #Request.prefix_db_lookup#.Agency SET Agency_Name = , Agency_Address1 = , Agency_Address2 = , Agency_City = , Agency_State = , timezone = , Agency_Zip = , Agency_Fax = , Agency_Contact = , Agency_Contact_Phone = , Agency_Contact_Email = , Agency_Medicare_ID = , Agency_Medicaid_ID = , Agency_State_ID = , Hospice_Medicare_Provider = , Hospice_Medicare_NPI = , SFW_ID = , Hospice_Medicaid_Provider = , Hospice_Medicaid_NPI = , Agency_Branch_State = , Agency_Branch_ID = , Natl_Provider_ID = , Agent_FEIN = , Agency_Login = , Record_Mod_Date = , Record_Mod_By = , Status = , Wage_Index = , svc_coding = , svc_soc = , svc_resumption = , svc_recertification = , svc_authorization = , svc_eligibility = , svc_intake_dataentry= , svc_admit_QA= , svc_hp_review= , svc_dataset_trans= , svc_CAHPS= , svc_meds = , svc_QA = , svc_dataset = , meds_dataentry = WHERE Agency_ID =