SELECT Patient_ID, Last_Name_M0040, First_Name_M0040, Allergies, Primary_ReferringPhys_ID_M0072 FROM #Request.prefix_db_agency#.patient WHERE Patient_ID = #session.cs.patientid# SELECT Drug_Name, Med_Status, DateOrdered, DateDCed, Dose, Route, Freq, Notes, Dose_Units FROM #Request.prefix_db_agency#.PatientMeds WHERE Patient_ID = #session.cs.patientid# AND Med_Status <> 'delete' ORDER By Med_Status, DateDCed, Drug_Name ASC SELECT Physician.Physician_ID, Employee.Last_Name, Employee.First_Name,Employee.Address1, Employee.City, Employee.State, Employee.Zip, Employee.Home_Phone FROM #Request.prefix_db_lookup#.Employee LEFT OUTER JOIN Physician on Employee.Employee_ID = Physician.Employee_ID WHERE Physician.Physician_ID = #GetP.Primary_ReferringPhys_ID_M0072# AND Employee.EmployeeType = 'Physician'

Medication List - #First_Name_M0040# #Last_Name_M0040#
#DateFormat(NOW(), "mmm dd, yyyy")#

Allergies: #Allergies#

#FirstName# #LastName# Physician
#Address1#
#City#, #State# #Zip#
#Home_Phone#

Physician Unknown

Medication	Dose	Units	Route	Freq	Notes	Status	Ordered	DCed
#Drug_Name#	#Dose#	#Dose_Units#	#Route#	#Freq#	#Notes#	#Med_Status#	#DateFormat(DateOrdered, "mm/dd/yy")#	#DateFormat(DateDCed, "mm/dd/yy")#