SELECT Patient_ID, Last_Name_M0040 AS Last_Name, First_Name_M0040 AS First_Name, Middle_Initial_M0040 AS Middle FROM #Request.prefix_db_agency#.patient WHERE Patient_ID = #session.cs.patientid# SELECT PatientMeds_ID, Medication_ID, Drug_Name, Med_Status, Dose, Dose_Units, Route, Freq, Notes, DateOrdered, DateDCed, mn.grouping,mn.trade_name,mn.classification,mn.generic_name,mn.RX_ID FROM #Request.prefix_db_agency#.PatientMeds Left outer join #Request.prefix_db_lookup#.Meds_New mn on PatientMeds.Medication_ID = mn.Trade_id WHERE Patient_ID = #session.cs.patientid# AND Med_status <> 'delete' Order By Drug_Name,Med_status
pm = CreateObject("Component", "PatientMenu"); pm.getPatientMenu(#getP.Patient_Id#);
#getP.Last_Name#, #getP.First_Name# #getP.Middle# - Medication List
Action
#cfcatch.Message#
#cfcatch.Detail#
Medication Dose Units Route Frequency Ordered Discontinued Notes Class Interaction
#UCASE(Med_Status)# MEDICATIONS
- Unknown -#getM.Drug_Name# - Unknown -#getM.Drug_Name# -#Trim(Dose)# -#Dose_Units# -#Trim(Route)# -#Trim(Freq)# -#DateFormat(DateOrdered,'mm/dd/yyyy')# -#DateFormat(DateDCed,'mm/dd/yyyy')# -#Trim(Notes)# #replacenocase(getM.Classification," & ","
","ALL")# (#trim(replacenocase(getM.grouping," & ","
","ALL"))#) 		Interacts with  #getM.trade_name#