SELECT Trade_ID, Name, Classification, Grouping, Trade_Name, Generic_Name
FROM #Request.prefix_db_lookup#.Meds_New
WHERE Trade_ID = '#URL.MID#'
SELECT DISTINCT Trade_ID, Dose, Form
FROM #Request.prefix_db_lookup#.Meds_New_Dose
WHERE Trade_ID = '#URL.MID#'
Order by Dose ASC
SELECT Medication_ID, Notes, Med_Status, DateOrdered, DateDCed, Dose, Route, Freq, Drug_Name, Dose_Units, NewChanged,
Meds_New.Classification, Meds_New.Grouping, Meds_New.Trade_Name, Meds_New.Generic_Name
FROM #Request.prefix_db_agency#.PatientMeds
left outer join #Request.prefix_db_lookup#.Meds_New on PatientMeds.Medication_ID = Meds_New.Trade_id
WHERE PatientMeds_ID = #Session.CS.PatientMedicationID#
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#'
AND Agency_Id = '#session.AgencyId#'
#GetP.First_Name# #GetP.Last_Name# - New Medication
#GetP.First_Name# #GetP.Last_Name# - Update Medication
SELECT DISTINCT Trade_ID, Dose, Form
FROM #Request.prefix_db_lookup#.Meds_New_Dose
WHERE Trade_ID = '#GetM.Medication_Id#'
Order by Dose ASC
Ongoing
checked='checked'>
New
checked>
Changed
checked>
