SELECT Assessment_Completed_M0090 FROM #Request.prefix_db_agency#.Assessment_New where Assessment_ID = '#Session.CS.AssessmentID#' SELECT id,Diagnosis,Code_Type FROM #Request.prefix_db_lookup#.Dx_list_ICD10 WHERE Diagnosis LIKE '%#url.text#%' SELECT id,Diagnosis FROM #Request.prefix_db_lookup#.diagnosis_list WHERE Diagnosis LIKE '%#url.text#%'

Inpatient Facilities ICD10 Z-Codes

Click Select Button	#M1010Diagnosis.Diagnosis#
No Result Found

SELECT id,Diagnosis FROM #Request.prefix_db_lookup#.Dx_list_ICD10 WHERE Diagnosis LIKE '%#url.text#%' SELECT id,Diagnosis FROM #Request.prefix_db_lookup#.diagnosis_list WHERE Diagnosis LIKE '%#url.text#%'

Procedure Select

Click Select Button	#M1012Diagnosis.Diagnosis#
No Result Found

Diagnosis requiring treatment change ICD10 Z-Codes

Click Select Button	#M1016Diagnosis.Diagnosis#
No Result Found

Diagnosis Select

Diagnosis	ICD	Action
#M0230Diagnosis.Diagnosis#	#M0230Diagnosis.ICD#	#M0230Diagnosis.Case_Mix_Message#
No Result Found

SELECT id,Diagnosis,Case_Mix_Message FROM #Request.prefix_db_lookup#.Dx_list_ICD10 WHERE Diagnosis LIKE '%#url.text#%' and Manfestation='M' and Manfestation is not null

Diagnosis Select

Diagnosis	Action
#M0230Diagnosis.Diagnosis#
No Result Found

SELECT Trade_ID,Name FROM #Request.prefix_db_lookup#.Meds_New WHERE Name LIKE '%#url.text#%'

Medication Search Result

Diagnosis	Action
#Medslist.Name#
No Result Found

select Meds_New_Dose.Dose_ID,Meds_New_Dose.Dose,Meds_New_Dose.Form from #Request.prefix_db_lookup#.Meds_New_Dose where Trade_ID='#url.text#' SELECT Name FROM #Request.prefix_db_lookup#.Meds_New m where Trade_ID='#url.text#'

#MedsDoseName.Name#

available doses/how dispensed*

Meds Dose	Action
#MedsDose.Dose# #MedsDose.Form#