SELECT Max(Question_ID) as MAX from #Request.prefix_db_agency#.Coding_Results where Assessment_ID = #url.AID# and Patient_ID = #url.ID# SELECT c.Dx_order, c.Diagnosis, c.Message_ID, c.Memo, c.Deficits, i.Teach_Patient FROM #Request.prefix_db_agency#.Coding_Results c, #Request.prefix_db_lookup#.CW_Coding_Class_PDGM i where c.Assessment_ID = #url.AID# and c.Patient_ID = #url.ID# and c.Question_ID = 1 and c.Order_ID = i.Priority '> '> '> '> Update #Request.prefix_db_agency#.Coding_Results set Textfield_9 = 'PATIENT HAS A TEACHABLE CAREGIVER AVAILABLE DURING THE DAY. CAREGIVER WILL BE TAUGHT SYMPTOM MANAGEMENT AND DISEASE PREVENTION.''PATIENT HAS NO TEACHABLE CAREGIVER AVAILABLE DURING THE DAY. PATIENT WILL BE TAUGHT SYMPTOM MANAGEMENT AND DISEASE PREVENTION.''PATIENT IS CONFUSED AND DOES NOT HAVE A TEACHABLE CAREGIVER. LONG-TERM SYMPTOM MONITORING AND DISEASE MANAGEMENT POSSIBLE.', Memo = concat('#Get_Path1.Memo#','; ', '#Goal_1#'), Textfield_12 = concat('#UCASE(Get_Path1.Diagnosis)#',': MONITOR patient for ','#Get_Path1.Deficits#','; ','#Intv_1#'), Textfield_14 = '#Intv_1#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Question_ID = 1 and M0_Item_Medication like '%M102%' SELECT c.Dx_order, c.Diagnosis, c.Message_ID, c.Memo, c.Deficits, i.Teach_Patient FROM #Request.prefix_db_agency#.Coding_Results c, #Request.prefix_db_lookup#.CW_Coding_Class_PDGM i where c.Assessment_ID = #url.AID# and c.Patient_ID = #url.ID# and c.Question_ID = 2 and c.Order_ID = i.Priority '> '> '> '> Update #Request.prefix_db_agency#.Coding_Results set Memo = concat('#Get_Path2.Memo#','; ', '#Goal_2#'), Textfield_12 = concat('#UCASE(Get_Path2.Diagnosis)#',': MONITOR patient for ','#Get_Path2.Deficits#','; ','#Intv_2#'), Textfield_14 = '#Intv_2#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Question_ID = 2 and M0_Item_Medication like '%M102%' SELECT c.Dx_order, c.Diagnosis, c.Message_ID, c.Memo, c.Deficits, i.Teach_Patient FROM #Request.prefix_db_agency#.Coding_Results c, #Request.prefix_db_lookup#.CW_Coding_Class_PDGM i where c.Assessment_ID = #url.AID# and c.Patient_ID = #url.ID# and c.Question_ID = 3 and c.Order_ID = i.Priority '> '> '> '> Update #Request.prefix_db_agency#.Coding_Results set Memo = concat('#Get_Path3.Memo#','; ', '#Goal_3#'), Textfield_12 = concat('#UCASE(Get_Path3.Diagnosis)#',': MONITOR patient for ','#Get_Path3.Deficits#','; ','#Intv_3#'), Textfield_14 = '#Intv_3#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Question_ID = 3 and M0_Item_Medication like '%M102%' SELECT c.Dx_order, c.Diagnosis, c.Message_ID, c.Memo, c.Deficits, i.Teach_Patient FROM #Request.prefix_db_agency#.Coding_Results c, #Request.prefix_db_lookup#.CW_Coding_Class_PDGM i where c.Assessment_ID = #url.AID# and c.Patient_ID = #url.ID# and c.Question_ID = 4 and c.Order_ID = i.Priority '> '> '> '> Update #Request.prefix_db_agency#.Coding_Results set Memo = concat('#Get_Path4.Memo#','; ', '#Goal_4#'), Textfield_12 = concat('#UCASE(Get_Path4.Diagnosis)#',': MONITOR patient for ','#Get_Path4.Deficits#','; ','#Intv_4#'), Textfield_14 = '#Intv_4#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Question_ID = 4 and M0_Item_Medication like '%M102%' SELECT c.Dx_order, c.Diagnosis, c.Message_ID, c.Memo, c.Deficits, i.Teach_Patient FROM #Request.prefix_db_agency#.Coding_Results c, #Request.prefix_db_lookup#.CW_Coding_Class_PDGM i where c.Assessment_ID = #url.AID# and c.Patient_ID = #url.ID# and c.Question_ID = 5 and c.Order_ID = i.Priority '> '> '> '> Update #Request.prefix_db_agency#.Coding_Results set Memo = concat('#Get_Path5.Memo#','; ', '#Goal_5#'), Textfield_12 = concat('#UCASE(Get_Path5.Diagnosis)#',': MONITOR patient for ','#Get_Path5.Deficits#','; ','#Intv_5#'), Textfield_14 = '#Intv_5#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Question_ID = 5 and M0_Item_Medication like '%M102%' SELECT c.Dx_order, c.Diagnosis, c.Message_ID, c.Memo, c.Deficits, i.Teach_Patient FROM #Request.prefix_db_agency#.Coding_Results c, #Request.prefix_db_lookup#.CW_Coding_Class_PDGM i where c.Assessment_ID = #url.AID# and c.Patient_ID = #url.ID# and c.Question_ID = 6 and c.Order_ID = i.Priority '> '> '> '> Update #Request.prefix_db_agency#.Coding_Results set Memo = concat('#Get_Path6.Memo#','; ', '#Goal_6#'), Textfield_12 = concat('#UCASE(Get_Path6.Diagnosis)#',': MONITOR patient for ','#Get_Path6.Deficits#','; ','#Intv_6#'), Textfield_14 = '#Intv_6#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Question_ID = 6 and M0_Item_Medication like '%M102%' SELECT Max(Dx_Order) as MAX from #Request.prefix_db_agency#.Coding_Results where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 10 and Order_ID = 28 SELECT Dx_order, Diagnosis, Message_ID, Memo, Deficits, Textfield_1, Textfield_14 FROM #Request.prefix_db_agency#.Coding_Results c where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Dx_Order = 1 and Message_ID = 10 and Order_ID = 28 Update #Request.prefix_db_agency#.Coding_Results set Textfield_9 = 'PATIENT HAS A TEACHABLE CAREGIVER AVAILABLE DURING THE DAY. CAREGIVER WILL BE TAUGHT SYMPTOM MANAGEMENT AND DISEASE PREVENTION.''PATIENT HAS NO TEACHABLE CAREGIVER AVAILABLE DURING THE DAY. PATIENT WILL BE TAUGHT SYMPTOM MANAGEMENT AND DISEASE PREVENTION.''PATIENT IS CONFUSED AND DOES NOT HAVE A TEACHABLE CAREGIVER. LONG-TERM SYMPTOM MONITORING AND DISEASE MANAGEMENT POSSIBLE.', Memo = concat('#Get_Path1.Diagnosis#',' is optimized as evidenced by ', '#Get_Path1.Textfield_1#','; ', '#Goal_1#'), Textfield_12 = concat('#UCASE(Get_Path1.Diagnosis)#',': ','#Intv_1#'), Textfield_14 = '#Intv_1#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Dx_Order = 1 and Message_ID = 10 and Order_ID = 28 SELECT Dx_order, Diagnosis, Message_ID, Memo, Deficits, Textfield_1, Textfield_14 FROM #Request.prefix_db_agency#.Coding_Results c where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Dx_Order = 2 and Message_ID = 10 and Order_ID = 28 Update #Request.prefix_db_agency#.Coding_Results set Memo = concat('#Get_Path2.Diagnosis#',' is optimized as evidenced by ', '#Get_Path2.Textfield_1#','; ', '#Goal_2#'), Textfield_12 = concat('#UCASE(Get_Path2.Diagnosis)#',': ','#Intv_2#'), Textfield_14 = '#Intv_2#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Dx_Order = 2 and Message_ID = 10 and Order_ID = 28 SELECT Dx_order, Diagnosis, Message_ID, Memo, Deficits, Textfield_1, Textfield_14 FROM #Request.prefix_db_agency#.Coding_Results c where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Dx_Order = 3 and Message_ID = 10 and Order_ID = 28 Update #Request.prefix_db_agency#.Coding_Results set Memo = concat('#Get_Path3.Diagnosis#',' is optimized as evidenced by ', '#Get_Path3.Textfield_1#','; ', '#Goal_3#'), Textfield_12 = concat('#UCASE(Get_Path3.Diagnosis)#',': ','#Intv_3#'), Textfield_14 = '#Intv_3#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Dx_Order = 3 and Message_ID = 10 and Order_ID = 28 SELECT Dx_order, Diagnosis, Message_ID, Memo, Deficits, Textfield_1, Textfield_14 FROM #Request.prefix_db_agency#.Coding_Results c where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Dx_Order = 4 and Message_ID = 10 and Order_ID = 28 Update #Request.prefix_db_agency#.Coding_Results set Memo = concat('#Get_Path4.Diagnosis#',' is optimized as evidenced by ', '#Get_Path4.Textfield_1#','; ', '#Goal_4#'), Textfield_12 = concat('#UCASE(Get_Path4.Diagnosis)#',': ','#Intv_4#'), Textfield_14 = '#Intv_4#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Dx_Order = 4 and Message_ID = 10 and Order_ID = 28 SELECT Dx_order, Diagnosis, Message_ID, Memo, Deficits, Textfield_1, Textfield_14 FROM #Request.prefix_db_agency#.Coding_Results c where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Dx_Order = 5 and Message_ID = 10 and Order_ID = 28 Update #Request.prefix_db_agency#.Coding_Results set Memo = concat('#Get_Path5.Diagnosis#',' is optimized as evidenced by ', '#Get_Path5.Textfield_1#','; ', '#Goal_5#'), Textfield_12 = concat('#UCASE(Get_Path5.Diagnosis)#',': ','#Intv_5#'), Textfield_14 = '#Intv_5#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Dx_Order = 5 and Message_ID = 10 and Order_ID = 28 SELECT Dx_order, Diagnosis, Message_ID, Memo, Deficits, Textfield_1, Textfield_14 FROM #Request.prefix_db_agency#.Coding_Results c where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Dx_Order = 6 and Message_ID = 10 and Order_ID = 28 Update #Request.prefix_db_agency#.Coding_Results set Memo = concat('#Get_Path6.Diagnosis#',' is optimized as evidenced by ', '#Get_Path6.Textfield_1#','; ', '#Goal_6#'), Textfield_12 = concat('#UCASE(Get_Path6.Diagnosis)#',': ','#Intv_6#'), Textfield_14 = '#Intv_6#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Dx_Order = 6 and Message_ID = 10 and Order_ID = 28 SELECT Max(Dx_Order) as MAX from #Request.prefix_db_agency#.Coding_Results where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 10 and Order_ID = 29 SELECT Dx_order, Diagnosis, Message_ID, Memo, Deficits, Textfield_1, Textfield_14 FROM #Request.prefix_db_agency#.Coding_Results c where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Dx_Order = 1 and Message_ID = 10 and Order_ID = 29 Update #Request.prefix_db_agency#.Coding_Results set Textfield_9 = 'PATIENT HAS A TEACHABLE CAREGIVER AVAILABLE DURING THE DAY. CAREGIVER WILL BE TAUGHT SYMPTOM MANAGEMENT AND DISEASE PREVENTION.''PATIENT HAS NO TEACHABLE CAREGIVER AVAILABLE DURING THE DAY. PATIENT WILL BE TAUGHT SYMPTOM MANAGEMENT AND DISEASE PREVENTION.''PATIENT IS CONFUSED AND DOES NOT HAVE A TEACHABLE CAREGIVER. LONG-TERM SYMPTOM MONITORING AND DISEASE MANAGEMENT POSSIBLE.', Memo = concat('#Get_Path1.Diagnosis#',' is optimized as evidenced by ', '#Get_Path1.Textfield_1#','; ', '#Goal_1#'), Textfield_12 = concat('#UCASE(Get_Path1.Diagnosis)#',': ','#Intv_1#'), Textfield_14 = '#Intv_1#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Dx_Order = 1 and Message_ID = 10 and Order_ID = 29 SELECT Dx_order, Diagnosis, Message_ID, Memo, Deficits, Textfield_1, Textfield_14 FROM #Request.prefix_db_agency#.Coding_Results c where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Dx_Order = 2 and Message_ID = 10 and Order_ID = 29 Update #Request.prefix_db_agency#.Coding_Results set Memo = concat('#Get_Path2.Diagnosis#',' is optimized as evidenced by ', '#Get_Path2.Textfield_1#','; ', '#Goal_2#'), Textfield_12 = concat('#UCASE(Get_Path2.Diagnosis)#',': ','#Intv_2#'), Textfield_14 = '#Intv_2#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Dx_Order = 2 and Message_ID = 10 and Order_ID = 29 SELECT Dx_order, Diagnosis, Message_ID, Memo, Deficits, Textfield_1, Textfield_14 FROM #Request.prefix_db_agency#.Coding_Results c where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Dx_Order = 3 and Message_ID = 10 and Order_ID = 29 Update #Request.prefix_db_agency#.Coding_Results set Memo = concat('#Get_Path3.Diagnosis#',' is optimized as evidenced by ', '#Get_Path3.Textfield_1#','; ', '#Goal_3#'), Textfield_12 = concat('#UCASE(Get_Path3.Diagnosis)#',': ','#Intv_3#'), Textfield_14 = '#Intv_3#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Dx_Order = 3 and Message_ID = 10 and Order_ID = 29 Select Assessment_Completed_M0090 from #Request.prefix_db_agency#.Assessment_New where Assessment_ID = #url.AID# and Patient_ID = #url.ID#