INSERT INTO #Request.prefix_db_agency#.Communication ( CommSub_ID, Patient_ID, Employee_ID, Schedule_ID, Agency_ID, Comm_Date, Memo, Followup_desc, Resolved, Record_Creation_Date, Record_Created_By, Record_Mod_Date, Record_Mod_By ) VALUES ( , , , , , '#DateFormat(arguments.Comm_Date,"yyyy-mm-dd")#', , , , '#DateFormat(Now(),"yyyy-mm-dd")#', , '#DateFormat(Now(),"yyyy-mm-dd")#', ) Select LAST_INSERT_ID() AS id INSERT INTO #Request.prefix_db_agency#.communication_to ( comm_id, employee_id ) VALUES ( '#id#', #arguments.Emp_ID# ) SELECT e.Emp_email AS email, e.Emp_First AS first_name, e.Emp_Last AS last_name FROM #Request.prefix_db_agency#.Communication c, #Request.prefix_db_lookup#.pEmployee e WHERE c.comm_id = '#id#' AND e.Emp_ID = c.Record_Created_By SELECT * FROM #Request.prefix_db_lookup#.pEmployee WHERE Emp_ID = A New Communication has been Assigned to You at MyHomeCareBiz.com by #postedBy#. Please click here to View the New Communication. UPDATE #Request.prefix_db_lookup#.meds_pathway_lookup SET Recomm_problem_ID = WHERE ID IN () UPDATE #Request.prefix_db_agency#.pProblem SET Path_ID = WHERE Problem_ID = AND Status = 0 UPDATE #Request.prefix_db_lookup#.meds_pathway_lookup SET Approved = WHERE ID IN () SELECT * FROM #Request.prefix_db_lookup#.meds_pathway_lookup WHERE Generic_Name = '#medsdescription#' SELECT * FROM #Request.prefix_db_agency#.pProblem WHERE Problem_ID = AND Status = 0 SELECT * FROM getmedspathway WHERE Path_ID = '#getsproblems.Path_ID#' AND Patient_ID = '#arguments.Patient_ID#' AND Agency_ID = '#arguments.Agency_ID#' UPDATE #Request.prefix_db_lookup#.meds_pathway_lookup SET Approved = WHERE ID IN () SELECT * FROM #Request.prefix_db_lookup#.Meds_New WHERE Med_ID IN () AND Trade_Name = '#medsdescription#' INSERT INTO #Request.prefix_db_lookup#.meds_pathway_lookup (Med_ID, Trade_Num, Generic_Name, Path_ID, Agency_ID, Patient_ID,Emp_ID, Approved, Date_Created) VALUES ( , , , , , , , , now())