SELECT Assessment_Completed_M0090 FROM #Request.prefix_db_agency#.Assessment_New where Assessment_ID = '#Session.CS.AssessmentID#'
SELECT id,`Procedure` as Diagnosis FROM #Request.prefix_db_lookup#.surgical_codes WHERE `Procedure` LIKE '%#url.text#%'

Inpatient Facilities ICD10 Z-Codes


Diagnosis Action
#M1012Diagnosis.Diagnosis#
No Result Found
SELECT id,Diagnosis,Case_Mix_Message,ICD,Code_Type FROM #Request.prefix_db_lookup#.Dx_list_ICD10 WHERE Diagnosis LIKE '%#url.text#%' Order by ICD SELECT id,Diagnosis,Case_Mix_Message,ICD,Code_Type FROM #Request.prefix_db_lookup#.diagnosis_list WHERE Diagnosis LIKE '%#url.text#%'

Diagnosis requiring treatment change ICD10 Z-Codes

Diagnosis Action
#M1016Diagnosis.Diagnosis#
No Result Found
SELECT id,Diagnosis,Case_Mix_Message,Code_Type,ICD FROM #Request.prefix_db_lookup#.Dx_list_ICD10 WHERE Diagnosis LIKE '%#url.text#%' Order by ICD

Diagnosis Select

Diagnosis ICD Action
#M0230Diagnosis.Diagnosis# #M0230Diagnosis.ICD#
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 Order by ICD

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#
No Result Found
SELECT s.id,s.Procedure FROM #Request.prefix_db_lookup#.surgical_codes s WHERE s.Procedure LIKE '%#url.text#%'

Procedure Search

Procedure Action
#PTAdd1Surgical.Procedure#
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 Order by ICD SELECT id,Diagnosis,Case_Mix_Message FROM #Request.prefix_db_lookup#.diagnosis_list WHERE Diagnosis LIKE '%#url.text#%' and Manfestation='M' and Manfestation is not null

Diagnosis Select

Diagnosis Action
#M0230Diagnosis.Diagnosis#
#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#%' Order by ICD SELECT id,Diagnosis,Case_Mix_Message FROM #Request.prefix_db_lookup#.diagnosis_list WHERE Diagnosis LIKE '%#url.text#%'

Diagnosis Select

Diagnosis Action
#M0230Diagnosis.Diagnosis#
No Result Found
isdefined('url.snhospice') or isdefined('url.chaplaincomp') > SELECT id,Diagnosis,Case_Mix_Message,ICD,Code_Type FROM #Request.prefix_db_lookup#.Dx_list_ICD10 WHERE Diagnosis LIKE '%#url.text#%' Order by ICD SELECT id,Diagnosis,Case_Mix_Message,ICD,Code_Type FROM #Request.prefix_db_lookup#.diagnosis_list WHERE Diagnosis LIKE '%#url.text#%'

Inpatient Facilities ICD10 Z-Codes

isdefined('url.OTadult') or isdefined('url.OTped')>
Diagnosis Action
#M1010Diagnosis.Diagnosis#
No Result Found
SELECT id,Diagnosis,Case_Mix_Message,ICD,Code_Type FROM #Request.prefix_db_lookup#.Dx_list_ICD10 WHERE Diagnosis LIKE '%#url.text#%' Order by ICD SELECT id,Diagnosis,Case_Mix_Message,ICD,Code_Type FROM #Request.prefix_db_lookup#.diagnosis_list WHERE Diagnosis LIKE '%#url.text#%'

Inpatient Facilities ICD10 Z-Codes

Diagnosis Action
#M1010Diagnosis.Diagnosis#
No Result Found
SELECT id,Diagnosis,Case_Mix_Message,ICD,Code_Type FROM #Request.prefix_db_lookup#.Dx_list_ICD10 WHERE Diagnosis LIKE '%#url.text#%' Order by ICD SELECT id,Diagnosis,Case_Mix_Message,ICD,Code_Type FROM #Request.prefix_db_lookup#.diagnosis_list WHERE Diagnosis LIKE '%#url.text#%'

Inpatient Facilities ICD10 Z-Codes

Diagnosis Action
#M1010Diagnosis.Diagnosis#
No Result Found