SELECT * FROM #Request.prefix_db_lookup#.Meds_New WHERE Trade_Name = '#medication_name#' ORDER BY Name SELECT * FROM #Request.prefix_db_lookup#.Meds_New WHERE Trade_Name = '#medication_name_twice#' ORDER BY Name SELECT * FROM #Request.prefix_db_lookup#.Meds_New WHERE Trade_Name like '#medication_name_thrice#%' ORDER BY Name ' /> INSERT INTO #Request.prefix_db_agency#.PatientMeds ( Patient_ID, Medication_ID, Drug_Name, Med_Status, DateOrdered, RX_ID, Record_Creation_Date, Record_Created_By, Record_Mod_Date, Record_Mod_By ) VALUES ( #session.cs.patientid#, '#Trade_ID#', '#Name#', 'active', #CreateODBCDateTime(Now())#, '#RX_ID#', #CreateODBCDateTime(Now())#, #Session.EmployeeID#, #CreateODBCDateTime(Now())#, #Session.EmployeeID# ) SELECT * FROM #Request.prefix_db_lookup#.Meds_New WHERE Trade_Name = '#medication_name#' ORDER BY Name SELECT * FROM #Request.prefix_db_lookup#.Meds_New WHERE Trade_Name = '#medication_name_twice#' ORDER BY Name SELECT * FROM #Request.prefix_db_lookup#.Meds_New WHERE Trade_Name = '#medication_name_thrice#' ORDER BY Name ' /> INSERT INTO #Request.prefix_db_agency#.PatientMeds ( Patient_ID, Medication_ID, Drug_Name, Med_Status, DateOrdered, RX_ID, Record_Creation_Date, Record_Created_By, Record_Mod_Date, Record_Mod_By ) VALUES ( #session.cs.patientid#, '#Trade_ID#', '#Name#', 'active', #CreateODBCDateTime(Now())#, '#RX_ID#', #CreateODBCDateTime(Now())#, #Session.EmployeeID#, #CreateODBCDateTime(Now())#, #Session.EmployeeID# ) SELECT * FROM #Request.prefix_db_lookup#.Meds_New WHERE Trade_Name = '#medication_name#' ORDER BY Name SELECT * FROM #Request.prefix_db_lookup#.Meds_New WHERE Trade_Name = '#medication_name_twice#' ORDER BY Name SELECT * FROM #Request.prefix_db_lookup#.Meds_New WHERE Trade_Name like '#medication_name_thrice#%' ORDER BY Name ' /> INSERT INTO #Request.prefix_db_agency#.PatientMeds ( Patient_ID, Medication_ID, Drug_Name, Med_Status, DateOrdered, RX_ID, Record_Creation_Date, Record_Created_By, Record_Mod_Date, Record_Mod_By ) VALUES ( #session.cs.patientid#, '#Trade_ID#', '#Name#', 'active', #CreateODBCDateTime(Now())#, '#RX_ID#', #CreateODBCDateTime(Now())#, #Session.EmployeeID#, #CreateODBCDateTime(Now())#, #Session.EmployeeID# ) SELECT * FROM #Request.prefix_db_lookup#.Meds_New WHERE Trade_Name = '#medication_name#' ORDER BY Name SELECT * FROM #Request.prefix_db_lookup#.Meds_New WHERE Trade_Name = '#medication_name_twice#' ORDER BY Name SELECT * FROM #Request.prefix_db_lookup#.Meds_New WHERE Trade_Name like '#medication_name_thrice#%' ORDER BY Name ' /> INSERT INTO #Request.prefix_db_agency#.PatientMeds ( Patient_ID, Medication_ID, Drug_Name, Med_Status, DateOrdered, RX_ID, Record_Creation_Date, Record_Created_By, Record_Mod_Date, Record_Mod_By ) VALUES ( #session.cs.patientid#, '#Trade_ID#', '#Name#', 'active', #CreateODBCDateTime(Now())#, '#RX_ID#', #CreateODBCDateTime(Now())#, #Session.EmployeeID#, #CreateODBCDateTime(Now())#, #Session.EmployeeID# ) SELECT * FROM #Request.prefix_db_lookup#.Meds_New WHERE Trade_Name = '#medication_name#' ORDER BY Name SELECT * FROM #Request.prefix_db_lookup#.Meds_New WHERE Trade_Name = '#medication_name_twice#' ORDER BY Name SELECT * FROM #Request.prefix_db_lookup#.Meds_New WHERE Trade_Name = '#medication_name_thrice#%' ORDER BY Name ' /> INSERT INTO #Request.prefix_db_agency#.PatientMeds ( Patient_ID, Medication_ID, Drug_Name, Med_Status, DateOrdered, RX_ID, Record_Creation_Date, Record_Created_By, Record_Mod_Date, Record_Mod_By ) VALUES ( #session.cs.patientid#, '#Trade_ID#', '#Name#', 'active', #CreateODBCDateTime(Now())#, '#RX_ID#', #CreateODBCDateTime(Now())#, #Session.EmployeeID#, #CreateODBCDateTime(Now())#, #Session.EmployeeID# ) SELECT * FROM #Request.prefix_db_lookup#.Meds_New WHERE Name = '#medication_name#' ORDER BY Name SELECT * FROM #Request.prefix_db_lookup#.Meds_New WHERE Name = '#medication_name_twice#' ORDER BY Name SELECT * FROM #Request.prefix_db_lookup#.Meds_New WHERE Name = '#medication_name_thrice#%' ORDER BY Name ' /> INSERT INTO #Request.prefix_db_agency#.PatientMeds ( Patient_ID, Medication_ID, Drug_Name, Med_Status, DateOrdered, RX_ID, Record_Creation_Date, Record_Created_By, Record_Mod_Date, Record_Mod_By ) VALUES ( #session.cs.patientid#, '#Trade_ID#', '#Name#', 'active', #CreateODBCDateTime(Now())#, '#RX_ID#', #CreateODBCDateTime(Now())#, #Session.EmployeeID#, #CreateODBCDateTime(Now())#, #Session.EmployeeID# ) ---> SELECT * FROM #Request.prefix_db_lookup#.Meds_New WHERE Name like '#Trim(Left(var3[j],i))#%' ORDER BY Name ' /> INSERT INTO #Request.prefix_db_agency#.PatientMeds ( Patient_ID, Medication_ID, Drug_Name, Med_Status, DateOrdered, RX_ID, Record_Creation_Date, Record_Created_By, Record_Mod_Date, Record_Mod_By ) VALUES ( #session.cs.patientid#, '#Trade_ID#', '#Name#', 'active', #CreateODBCDateTime(Now())#, '#RX_ID#', #CreateODBCDateTime(Now())#, #Session.EmployeeID#, #CreateODBCDateTime(Now())#, #Session.EmployeeID# ) SELECT * FROM #Request.prefix_db_lookup#.Meds_New WHERE Trade_Name = '#Left(medication_name,k)#' ORDER BY Name
INSERT INTO #Request.prefix_db_agency#.PatientMeds ( Patient_ID, Medication_ID, Drug_Name, Med_Status, DateOrdered, RX_ID, Record_Creation_Date, Record_Created_By, Record_Mod_Date, Record_Mod_By ) VALUES ( #session.cs.patientid#, '#Trade_ID#', '#Name#', 'active', #CreateODBCDateTime(Now())#, '#RX_ID#', #CreateODBCDateTime(Now())#, #Session.EmployeeID#, #CreateODBCDateTime(Now())#, #Session.EmployeeID# )
INSERT INTO #Request.prefix_db_agency#.PatientMeds ( Patient_ID, Medication_ID, Drug_Name, Med_Status, DateOrdered, RX_ID, Record_Creation_Date, Record_Created_By, Record_Mod_Date, Record_Mod_By ) VALUES ( #session.cs.patientid#, '#Trade_ID#', '#Name#', 'active', #CreateODBCDateTime(Now())#, '#RX_ID#', #CreateODBCDateTime(Now())#, #Session.EmployeeID#, #CreateODBCDateTime(Now())#, #Session.EmployeeID# ) #var1[i]# - #medication_name# - #Name#
SELECT * FROM #Request.prefix_db_agency#.PatientMeds WHERE Patient_ID = #session.cs.patientid# AND RX_ID is not null Order by Patient_ID DESC SELECT * FROM #Request.prefix_db_agency#.PatientMeds Left outer join hhapowerpath.Meds_New mn on PatientMeds.Medication_ID = mn.Trade_id WHERE Patient_ID = #session.cs.patientid# UPDATE IGNORE #Request.prefix_db_agency#.PatientMeds SET Interaction_Medications = '#getResult.interactionTypeGroup[1].interactionType[1].interactionPair[j].interactionConcept[1].minConceptItem.name# Interacts with #Interaction_name#' Where PatientMeds_ID = #PatientMeds_ID# SELECT * FROM #Request.prefix_db_agency#.patient WHERE Patient_ID = '#session.cs.patientid#' Hi Debbie,

Missed below medication when you import file Patient Name : #Get_patient.Last_Name_M0040# #Get_patient.First_Name_M0040#
Medication : #missed_medication#
Uploaded by: #Session.Display#