Select Agency_Login FROM #Request.prefix_db_lookup#.Agency WHERE Agency_Login = #variables.agencylogin# INSERT INTO #Request.prefix_db_lookup#.Agency (Agency_Login, status, Agency_Name, Agency_Address1, Agency_Address2, Agency_City, Agency_State, Agency_Zip, Agency_Contact_Phone, Agency_Contact, Agency_Contact_Email, Agency_Fax, Agency_Medicare_ID,CMS_Cert_No, Agency_Medicaid_ID, Agency_State_ID, Agency_Branch_State, Agency_Branch_ID, Contact_Notes, Agent_FEIN, Natl_Provider_ID, Wage_Index, Hospice_Medicare_Provider, Hospice_Medicare_NPI, Hospice_Medicaid_Provider, Hospice_Medicaid_NPI, Mileage_Rate, timezone, Rural, CAHPS, Cost_SN_visit, Cost_therapy_visit, Cost_hha_visit, Super_ID, svc_coding,svc_coding_other, svc_QA, svc_meds, svc_dataset, Record_Creation_Date, Record_Created_By, Record_Mod_Date, Record_Mod_By) VALUES ( , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ) SELECT Max(Agency_ID) AS ID FROM Agency CREATE DATABASE IF NOT EXISTS #agency_db# SELECT * FROM information_schema.tables WHERE table_schema = 'agency_179' and table_name not like 'x%'; CREATE TABLE #agency_db#.#TABLE_NAME# LIKE agency_179.#TABLE_NAME# UPDATE #Request.prefix_db_lookup#.Agency SET Agency_Name = '#Trim(form.Agency_Name)#', Agency_Address1 = '#Trim(form.Agency_Address1)#', Agency_Address2 = '#Trim(form.Agency_Address2)#', Agency_City = '#Trim(form.Agency_City)#', Agency_State = '#Trim(form.Agency_State)#', Agency_Zip = '#form.Agency_Zip#', Agency_Contact_Phone = '#Trim(form.Agency_Contact_Phone)#', Agency_Contact = '#Trim(form.Agency_Contact)#', Agency_Contact_Email = '#Trim(form.Agency_Contact_Email)#', Agency_Fax = '#Trim(form.Agency_Fax)#', Agency_Medicare_ID = '#Trim(form.Agency_Medicare_ID)#', CMS_Cert_No = '#Trim(form.CMS_Cert_No)#', Agency_Medicaid_ID = '#Trim(form.Agency_Medicaid_ID)#', Agency_State_ID = '#trim(form.Agency_State_ID)#', Agency_Branch_State = '#trim(form.Agency_Branch_State)#', Agency_Branch_ID = '#trim(form.Agency_Branch_ID)#', Agent_FEIN = '#trim(form.Agent_FEIN)#', Natl_Provider_ID = '#Trim(form.Natl_Provider_ID)#', Wage_Index = '#trim(form.Wage_Index)#', Hospice_Medicare_Provider = '#Trim(form.Hospice_Medicare_Provider)#', Hospice_Medicare_NPI = '#Trim(form.Hospice_Medicare_NPI)#', Hospice_Medicaid_Provider = '#trim(form.Hospice_Medicaid_Provider)#', Hospice_Medicaid_NPI = '#Trim(form.Hospice_Medicaid_NPI)#', Mileage_Rate = '#trim(form.Mileage_Rate)#', Rural = '#trim(form.Rural)#', CAHPS = #form.Topic_ID#, Cost_SN_visit = '#trim(form.Cost_SN_visit)#', Cost_therapy_visit = '#Trim(form.Cost_therapy_visit)#', Cost_hha_visit = '#trim(form.Cost_hha_visit)#', svc_coding = , svc_coding_other = , SN_Visit_VBP = , SN_Visit_MNC = , Visit_Lock = , svc_QA = , svc_meds = , svc_dataset = , svc_authorization = , svc_eligibility = , svc_intake_dataentry= , svc_admit_QA= , svc_hp_review= , svc_dataset_trans= , svc_CAHPS= , timezone = '#trim(form.timezone)#', Record_Mod_Date = #CreateODBCDateTime(Now())#, Record_Mod_By = #session.EmployeeID# WHERE Agency_ID = #form.Agency_ID# SELECT Max(Agency_ID) AS ID FROM Agency CREATE DATABASE IF NOT EXISTS #agency_db# SELECT * FROM information_schema.tables WHERE table_schema = 'agency_179' and table_name not like 'x%' ; SELECT * FROM information_schema.tables WHERE table_schema = '#agency_db#' and table_name = '#getalltables.TABLE_NAME#' ; CREATE TABLE #agency_db#.#TABLE_NAME# LIKE agency_179.#TABLE_NAME#