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#'
SELECT PatientRecordLock_ID
FROM #Request.prefix_db_agency#.PatientRecordLock
WHERE Patient_ID = #session.cs.patientid# AND UnlockedBy_ID = 0
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#'
SELECT PatientRecordLock_ID
FROM #Request.prefix_db_agency#.PatientRecordLock
WHERE Patient_Id = '#session.cs.patientid#'
AND UnlockedBy_ID = 0
SELECT Distinct(classification)
FROM #Request.prefix_db_lookup#.meds_classifications
ORDER BY classification
SELECT classification,generic_name,trade_name,trade_id
FROM #Request.prefix_db_lookup#.Meds_New
ORDER BY classification,trade_name
SELECT *
FROM #Request.prefix_db_lookup#.Meds_New
WHERE Name LIKE '%#Form.SearchTxt#%'
ORDER BY Name
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
#GetP.First_Name# #GetP.Last_Name# - New Medication
#GetP.First_Name# #GetP.Last_Name# - Update Medication
Do Not use the following symbols: ~ % @ & or ^ in any fields. * = medication info available.
SELECT DISTINCT Trade_ID, Dose, Form
FROM #Request.prefix_db_lookup#.Meds_New_Dose
WHERE Trade_ID = '#GetM.Medication_Id#'
Order by Dose ASC
Patient is signed-out. Updates are not allowed. Return to Patient List
