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 Meds_New.*, PatientMeds.Med_Status, PatientMeds.DateOrdered,PatientMeds.Drug_Name,PatientMeds.Medication_id FROM #Request.prefix_db_agency#.PatientMeds left outer join #Request.prefix_db_lookup#.Meds_New on PatientMeds.Medication_id = Meds_New.Trade_ID WHERE Patient_ID = #session.cs.patientid# AND PatientMeds.Med_status = 'Active' ORDER By PatientMeds.Drug_Name
» Click Here to Print
#getP.Last_Name#, #getP.First_Name# #getP.Middle# - Comprehensive Medication Profile
#Drug_Name#
Trade Name
#trade_name# unknown
Generic Name
#generic_name# unknown
Classification(s)
#classification# unknown
Classification Group(s)
#grouping# unknown
Uses
#Uses# unknown
Administration
#administration# unknown
Contraindications
#Contraindications# unknown
Interactions
#Interactions# unknown
Side Effects
#Side_effects# unknown
Teach
#Teach# unknown