pm = CreateObject("Component", "Menu"); myArgument = 'medlist'; pm.MenuFunction(myArgument,#getP.Patient_Id#,'','','',''); request.pat = CreateObject("component","components.general.patients").init(); GetM = request.pat.medslist(#GetP.Patient_ID#,'#URL.status#'); enc_patpid = encrypt(#GetP.Patient_ID#,#application.enckey#,"AES","Hex"); SELECT DISTINCT pPtmeds.PtMeds_ID AS Primary_PtMeds_ID, pPtmeds_Compare.PtMeds_ID AS Compare_PtMeds_ID, Med_Interactions.level AS Interaction_Level, Med_Interactions.interaction_generic AS Interaction_Generic, IFNULL(Med_Interactions.notes,'') AS Med_Interaction_Notes FROM #Request.prefix_db_agency#.pPtmeds INNER JOIN #Request.prefix_db_lookup#.Meds_New ON pPtmeds.Drug_ID = Meds_New.Trade_Num INNER JOIN #Request.prefix_db_agency#.pPtmeds pPtmeds_Compare ON pPtmeds_Compare.Patient_ID = pPtmeds.Patient_ID AND pPtmeds_Compare.PtMeds_ID <> pPtmeds.PtMeds_ID INNER JOIN #Request.prefix_db_lookup#.Meds_New Meds_New_Compare ON pPtmeds_Compare.Drug_ID = Meds_New_Compare.Trade_Num INNER JOIN hhapowerpath.Med_Interactions ON LCASE(TRIM(Meds_New.Generic_Name)) LIKE CONCAT('%', LCASE(TRIM(Med_Interactions.drug_generic)), '%') AND LCASE(TRIM(Meds_New_Compare.Generic_Name)) LIKE CONCAT('%', LCASE(TRIM(Med_Interactions.interaction_generic)), '%') WHERE pPtmeds.Patient_ID = AND TRIM(IFNULL(Meds_New.Generic_Name,'')) <> '' AND TRIM(IFNULL(Meds_New_Compare.Generic_Name,'')) <> '' AND pPtmeds.Status = pPtmeds.Status AND pPtmeds_Compare.Status = pPtmeds_Compare.Status
Medication Information
Active Medications Inactive Medications Deleted Medications New Medication
Print Medication
Print Medication History
serious interactions high-risk medications


SELECT DISTINCT Interaction_Generic, Med_Interaction_Notes FROM GetMedInteractionRows WHERE Primary_PtMeds_ID = ORDER BY Interaction_Generic style="background-color:orange;"style="background-color:pink;"> AND (Approved IS NULL or Approved = 'Yes')) AND pAssessments.Patient_ID = '#Patient_ID#' GROUP BY pProblem.Description ---> #cfcatch.Message#
#cfcatch.Detail#
High Risk? Medication Dose/Units Route Frequency Start Is Med in
the home? 		Class Notes Interactions Audit Trail
YesNo - Unknown -#getM.Drug_Name# * - Unknown -#getM.Drug_Name#  * #listDoseUnits# #listDose# #listDoseUnits# #listDose# #listDoseUnits# #listDose# -#Trim(Route)# -#Trim(Freq)# - #DateFormat(DateOrdered,'mm/dd/yy')#
YesNoPending - will not display on 485 * required 		#replacenocase(getM.Classification," & ","
","ALL")# 		#getM.Notes# #HTMLEditFormat(GetRowInteractionDetails.Interaction_Generic)#, - Audit Trail
No Medications were found

Your Session has timed out. Please Login again.

Your Session has timed out. Please Login again.