SELECT Assessment_Completed_M0090 FROM #Request.prefix_db_agency#.Assessment_New where Assessment_ID = '#session.cs.AssessmentId#'
insert into #Request.prefix_db_agency#.Diagnosis (Assessment_ID,Assessment_Tracker_ID,Patient_ID,Agency_ID,ICD,Diagnosis,
Short_Diagnosis,Code_Type,Severity,Primary_Diagnosis,Secondary_Diagnosis,Dx_Order,M0230_Link,Text_ICD) values
('#form.AssessmentId#','#form.Assessment_Tracker_ID#','#form.Patient_ID#','#form.Agency_ID#','#form.ICD#','#form.diagnosis#','#form.shor_Diagnosis#','#form.Code_Type#','#form.severity#','#form.primary#','#form.secondary#',
'#form.Dx_Order#','#form.M0230_Link#','#form.ICD#')
SELECT DISTINCT Diagnosis FROM #Request.prefix_db_lookup#.Dx_list_ICD10
WHERE Diagnosis LIKE '%#form.M1012searchfield1#%' and Manfestation='M'
SELECT DISTINCT Diagnosis
FROM #Request.prefix_db_lookup#.diagnosis_list
WHERE Diagnosis LIKE '%#form.M1012searchfield1#%' and Manfestation='M'