select * from #Request.prefix_db_agency#.Assessment_New where Assessment_ID = #url.AID# select M1100_Living_Situation from #Request.prefix_db_agency#.patient where Patient_ID = #url.ID# SELECT Assessment_ID, Order_ID, ICD, count(*) AS dxcount FROM #Request.prefix_db_agency#.Coding_Results where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Textfield_11 = 'OT' and Order_ID = 28 and Message_ID = 10 order by Results_ID SELECT * FROM #Request.prefix_db_lookup#.CW_Visit_Stagger where Total_Visits = #OT_User# and Total_Dx = '#CWProbs#' INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Scrub (Assessment_ID,Patient_ID,Message_ID,Risk,Risk_Type,Message,Subject,Created_Date) VALUES (#url.AID#,#url.ID#,'#VisitNo#','OT','#Goals#','User Entered','Caregiver recalls teaching from prior visit''Patient recalls teaching from prior visit''no teachable caregiver; patient is not teachable','#DateFormat(Now(),"yyyy-mm-dd")#') Select Diagnosis, Deficits from #Request.prefix_db_agency#.Coding_Results where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Textfield_11 = 'OT' and Order_ID = 28 and Message_ID = 10 order by Dx_Order
'> Select Diagnosis, Textfield_1 from #Request.prefix_db_agency#.Coding_Results where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Textfield_11 = 'OT' and Order_ID = 28 and Message_ID = 10 order by Dx_Order
'> SELECT r.Diagnosis, r.Textfield_14 FROM #Request.prefix_db_agency#.Coding_Scrub s LEFT OUTER JOIN #Request.prefix_db_lookup#.CW_Visit_Stagger_Detail v ON s.Message_ID = v.visit_no JOIN #Request.prefix_db_agency#.Coding_Results r ON r.Dx_order = v.goals where s.Assessment_ID = #url.AID# and s.Patient_ID = #url.ID# and r.Assessment_ID = s.Assessment_ID and r.Dx_order = v.goals and r.Order_ID = 28 and s.Risk = 'OT' and v.visit_no = 1 and v.problems = #CWProbs# and v.total_visits = #OT_User#
'> Update #Request.prefix_db_agency#.Coding_Scrub set Created_by = '#CW_Visit_1#', Answer_1 = '#goals#',Answer_2 = '#assessment#', GG_1 = 'report unstable symptoms to physician; implement changes to physician orders', GG_2 = 'since patient does not have teachable caregiver document challenges of teaching patient symptom monitoring and preventive care all while patient must manage ADLs with minimal or no assistance' 'since patient is not teachable and does not have teachable caregiver document challenges of achieving stable symptoms and the need for long-term monitoring''document unstable symptoms and success of caregiver recall' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 1 and Message = 'User Entered' and Risk = 'OT' SELECT r.Diagnosis, r.Textfield_14 FROM #Request.prefix_db_agency#.Coding_Scrub s LEFT OUTER JOIN #Request.prefix_db_lookup#.CW_Visit_Stagger_Detail v ON s.Message_ID = v.visit_no JOIN #Request.prefix_db_agency#.Coding_Results r ON r.Dx_order = v.goals where s.Assessment_ID = #url.AID# and s.Patient_ID = #url.ID# and r.Assessment_ID = s.Assessment_ID and r.Dx_order = v.goals and r.Order_ID = 28 and s.Risk = 'OT' and v.visit_no = 2 and v.problems = #CWProbs# and v.total_visits = #OT_User#
'> Update #Request.prefix_db_agency#.Coding_Scrub set Created_by = '#CW_Visit_2#', Answer_1 = '#goals#',Answer_2 = '#assessment#', GG_1 = 'report unstable symptoms to physician; implement changes to physician orders', GG_2 = 'since patient does not have teachable caregiver document challenges of teaching patient symptom monitoring and preventive care all while patient must manage ADLs with minimal or no assistance' 'since patient is not teachable and does not have teachable caregiver document challenges of achieving stable symptoms and the need for long-term monitoring''document unstable symptoms and success of caregiver recall' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 2 and Message = 'User Entered' and Risk = 'OT' Update #Request.prefix_db_agency#.Coding_Scrub set Field_12 = '#CW_Visit_1#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 2 and Risk = 'OT' SELECT r.Diagnosis, r.Textfield_14 FROM #Request.prefix_db_agency#.Coding_Scrub s LEFT OUTER JOIN #Request.prefix_db_lookup#.CW_Visit_Stagger_Detail v ON s.Message_ID = v.visit_no JOIN #Request.prefix_db_agency#.Coding_Results r ON r.Dx_order = v.goals where s.Assessment_ID = #url.AID# and s.Patient_ID = #url.ID# and r.Assessment_ID = s.Assessment_ID and r.Dx_order = v.goals and r.Order_ID = 28 and s.Risk = 'OT' and v.visit_no = 3 and v.problems = #CWProbs# and v.total_visits = #OT_User#
'> Update #Request.prefix_db_agency#.Coding_Scrub set Created_by = '#CW_Visit_3#', Answer_1 = '#goals#',Answer_2 = '#assessment#', GG_1 = 'report unstable symptoms to physician; implement changes to physician orders', GG_2 = 'since patient does not have teachable caregiver document challenges of teaching patient symptom monitoring and preventive care all while patient must manage ADLs with minimal or no assistance' 'since patient is not teachable and does not have teachable caregiver document challenges of achieving stable symptoms and the need for long-term monitoring''document unstable symptoms and success of caregiver recall' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 3 and Message = 'User Entered' and Risk = 'OT' Update #Request.prefix_db_agency#.Coding_Scrub set Field_12 = '#CW_Visit_2#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 3 and Risk = 'OT' SELECT r.Diagnosis, r.Textfield_14 FROM #Request.prefix_db_agency#.Coding_Scrub s LEFT OUTER JOIN #Request.prefix_db_lookup#.CW_Visit_Stagger_Detail v ON s.Message_ID = v.visit_no JOIN #Request.prefix_db_agency#.Coding_Results r ON r.Dx_order = v.goals where s.Assessment_ID = #url.AID# and s.Patient_ID = #url.ID# and r.Assessment_ID = s.Assessment_ID and r.Dx_order = v.goals and r.Order_ID = 28 and s.Risk = 'OT' and v.visit_no = 4 and v.problems = #CWProbs# and v.total_visits = #OT_User#
'> Update #Request.prefix_db_agency#.Coding_Scrub set Created_by = '#CW_Visit_4#', Answer_1 = '#goals#',Answer_2 = '#assessment#', GG_1 = 'report unstable symptoms to physician; implement changes to physician orders', GG_2 = 'since patient does not have teachable caregiver document challenges of teaching patient symptom monitoring and preventive care all while patient must manage ADLs with minimal or no assistance' 'since patient is not teachable and does not have teachable caregiver document challenges of achieving stable symptoms and the need for long-term monitoring''document unstable symptoms and success of caregiver recall' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 4 and Message = 'User Entered' and Risk = 'OT' Update #Request.prefix_db_agency#.Coding_Scrub set Field_12 = '#CW_Visit_3#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 4 and Risk = 'OT' SELECT r.Diagnosis, r.Textfield_14 FROM #Request.prefix_db_agency#.Coding_Scrub s LEFT OUTER JOIN #Request.prefix_db_lookup#.CW_Visit_Stagger_Detail v ON s.Message_ID = v.visit_no JOIN #Request.prefix_db_agency#.Coding_Results r ON r.Dx_order = v.goals where s.Assessment_ID = #url.AID# and s.Patient_ID = #url.ID# and r.Assessment_ID = s.Assessment_ID and r.Dx_order = v.goals and r.Order_ID = 28 and s.Risk = 'OT' and v.visit_no = 5 and v.problems = #CWProbs# and v.total_visits = #OT_User#
'> Update #Request.prefix_db_agency#.Coding_Scrub set Created_by = '#CW_Visit_5#', Answer_1 = '#goals#',Answer_2 = '#assessment#', GG_1 = 'report unstable symptoms to physician; implement changes to physician orders', GG_2 = 'since patient does not have teachable caregiver document challenges of teaching patient symptom monitoring and preventive care all while patient must manage ADLs with minimal or no assistance' 'since patient is not teachable and does not have teachable caregiver document challenges of achieving stable symptoms and the need for long-term monitoring''document unstable symptoms and success of caregiver recall' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 5 and Message = 'User Entered' and Risk = 'OT' Update #Request.prefix_db_agency#.Coding_Scrub set Field_12 = '#CW_Visit_4#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 5 and Risk = 'OT' SELECT r.Diagnosis, r.Textfield_14 FROM #Request.prefix_db_agency#.Coding_Scrub s LEFT OUTER JOIN #Request.prefix_db_lookup#.CW_Visit_Stagger_Detail v ON s.Message_ID = v.visit_no JOIN #Request.prefix_db_agency#.Coding_Results r ON r.Dx_order = v.goals where s.Assessment_ID = #url.AID# and s.Patient_ID = #url.ID# and r.Assessment_ID = s.Assessment_ID and r.Dx_order = v.goals and r.Order_ID = 28 and s.Risk = 'OT' and v.visit_no = 6 and v.problems = #CWProbs# and v.total_visits = #OT_User#
'> Update #Request.prefix_db_agency#.Coding_Scrub set Created_by = '#CW_Visit_6#', Answer_1 = '#goals#',Answer_2 = '#assessment#', GG_1 = 'report unstable symptoms to physician; implement changes to physician orders', GG_2 = 'since patient does not have teachable caregiver document challenges of teaching patient symptom monitoring and preventive care all while patient must manage ADLs with minimal or no assistance' 'since patient is not teachable and does not have teachable caregiver document challenges of achieving stable symptoms and the need for long-term monitoring''document unstable symptoms and success of caregiver recall' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 6 and Message = 'User Entered' and Risk = 'OT' Update #Request.prefix_db_agency#.Coding_Scrub set Field_12 = '#CW_Visit_5#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 6 and Risk = 'OT' SELECT r.Diagnosis, r.Textfield_14 FROM #Request.prefix_db_agency#.Coding_Scrub s LEFT OUTER JOIN #Request.prefix_db_lookup#.CW_Visit_Stagger_Detail v ON s.Message_ID = v.visit_no JOIN #Request.prefix_db_agency#.Coding_Results r ON r.Dx_order = v.goals where s.Assessment_ID = #url.AID# and s.Patient_ID = #url.ID# and r.Assessment_ID = s.Assessment_ID and r.Dx_order = v.goals and r.Order_ID = 28 and s.Risk = 'OT' and v.visit_no = 7 and v.problems = #CWProbs# and v.total_visits = #OT_User#
'> Update #Request.prefix_db_agency#.Coding_Scrub set Created_by = '#CW_Visit_7#', Answer_1 = '#goals#',Answer_2 = '#assessment#', GG_1 = 'report unstable symptoms to physician; implement changes to physician orders', GG_2 = 'since patient does not have teachable caregiver document challenges of teaching patient symptom monitoring and preventive care all while patient must manage ADLs with minimal or no assistance' 'since patient is not teachable and does not have teachable caregiver document challenges of achieving stable symptoms and the need for long-term monitoring''document unstable symptoms and success of caregiver recall' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 7 and Message = 'User Entered' and Risk = 'OT' Update #Request.prefix_db_agency#.Coding_Scrub set Field_12 = '#CW_Visit_6#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 7 and Risk = 'OT' SELECT r.Diagnosis, r.Textfield_14 FROM #Request.prefix_db_agency#.Coding_Scrub s LEFT OUTER JOIN #Request.prefix_db_lookup#.CW_Visit_Stagger_Detail v ON s.Message_ID = v.visit_no JOIN #Request.prefix_db_agency#.Coding_Results r ON r.Dx_order = v.goals where s.Assessment_ID = #url.AID# and s.Patient_ID = #url.ID# and r.Assessment_ID = s.Assessment_ID and r.Dx_order = v.goals and r.Order_ID = 28 and s.Risk = 'OT' and v.visit_no = 8 and v.problems = #CWProbs# and v.total_visits = #OT_User#
'> Update #Request.prefix_db_agency#.Coding_Scrub set Created_by = '#CW_Visit_8#', Answer_1 = '#goals#',Answer_2 = '#assessment#', GG_1 = 'report unstable symptoms to physician; implement changes to physician orders', GG_2 = 'since patient does not have teachable caregiver document challenges of teaching patient symptom monitoring and preventive care all while patient must manage ADLs with minimal or no assistance' 'since patient is not teachable and does not have teachable caregiver document challenges of achieving stable symptoms and the need for long-term monitoring''document unstable symptoms and success of caregiver recall' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 8 and Message = 'User Entered' and Risk = 'OT' Update #Request.prefix_db_agency#.Coding_Scrub set Field_12 = '#CW_Visit_7#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 8 and Risk = 'OT' SELECT r.Diagnosis, r.Textfield_14 FROM #Request.prefix_db_agency#.Coding_Scrub s LEFT OUTER JOIN #Request.prefix_db_lookup#.CW_Visit_Stagger_Detail v ON s.Message_ID = v.visit_no JOIN #Request.prefix_db_agency#.Coding_Results r ON r.Dx_order = v.goals where s.Assessment_ID = #url.AID# and s.Patient_ID = #url.ID# and r.Assessment_ID = s.Assessment_ID and r.Dx_order = v.goals and r.Order_ID = 28 and s.Risk = 'OT' and v.visit_no = 9 and v.problems = #CWProbs# and v.total_visits = #OT_User#
'> Update #Request.prefix_db_agency#.Coding_Scrub set Created_by = '#CW_Visit_9#', Answer_1 = '#goals#',Answer_2 = '#assessment#', GG_1 = 'report unstable symptoms to physician; implement changes to physician orders', GG_2 = 'since patient does not have teachable caregiver document challenges of teaching patient symptom monitoring and preventive care all while patient must manage ADLs with minimal or no assistance' 'since patient is not teachable and does not have teachable caregiver document challenges of achieving stable symptoms and the need for long-term monitoring''document unstable symptoms and success of caregiver recall' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 9 and Message = 'User Entered' and Risk = 'OT' Update #Request.prefix_db_agency#.Coding_Scrub set Field_12 = '#CW_Visit_8#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 9 and Risk = 'OT' SELECT r.Diagnosis, r.Textfield_14 FROM #Request.prefix_db_agency#.Coding_Scrub s LEFT OUTER JOIN #Request.prefix_db_lookup#.CW_Visit_Stagger_Detail v ON s.Message_ID = v.visit_no JOIN #Request.prefix_db_agency#.Coding_Results r ON r.Dx_order = v.goals where s.Assessment_ID = #url.AID# and s.Patient_ID = #url.ID# and r.Assessment_ID = s.Assessment_ID and r.Dx_order = v.goals and r.Order_ID = 28 and s.Risk = 'OT' and v.visit_no = 10 and v.problems = #CWProbs# and v.total_visits = #OT_User#
'> Update #Request.prefix_db_agency#.Coding_Scrub set Created_by = '#CW_Visit_10#', Answer_1 = '#goals#',Answer_2 = '#assessment#', GG_1 = 'report unstable symptoms to physician; implement changes to physician orders', GG_2 = 'since patient does not have teachable caregiver document challenges of teaching patient symptom monitoring and preventive care all while patient must manage ADLs with minimal or no assistance' 'since patient is not teachable and does not have teachable caregiver document challenges of achieving stable symptoms and the need for long-term monitoring''document unstable symptoms and success of caregiver recall' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 10 and Message = 'User Entered' and Risk = 'OT' Update #Request.prefix_db_agency#.Coding_Scrub set Field_12 = '#CW_Visit_9#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 10 and Risk = 'OT' SELECT r.Diagnosis, r.Textfield_14 FROM #Request.prefix_db_agency#.Coding_Scrub s LEFT OUTER JOIN #Request.prefix_db_lookup#.CW_Visit_Stagger_Detail v ON s.Message_ID = v.visit_no JOIN #Request.prefix_db_agency#.Coding_Results r ON r.Dx_order = v.goals where s.Assessment_ID = #url.AID# and s.Patient_ID = #url.ID# and r.Assessment_ID = s.Assessment_ID and r.Dx_order = v.goals and r.Order_ID = 28 and s.Risk = 'OT' and v.visit_no = 11 and v.problems = #CWProbs# and v.total_visits = #OT_User#
'> Update #Request.prefix_db_agency#.Coding_Scrub set Created_by = '#CW_Visit_11#', Answer_1 = '#goals#',Answer_2 = '#assessment#', GG_1 = 'report unstable symptoms to physician; implement changes to physician orders', GG_2 = 'since patient does not have teachable caregiver document challenges of teaching patient symptom monitoring and preventive care all while patient must manage ADLs with minimal or no assistance' 'since patient is not teachable and does not have teachable caregiver document challenges of achieving stable symptoms and the need for long-term monitoring''document unstable symptoms and success of caregiver recall' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 11 and Message = 'User Entered' and Risk = 'OT' Update #Request.prefix_db_agency#.Coding_Scrub set Field_12 = '#CW_Visit_10#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 11 and Risk = 'OT' SELECT r.Diagnosis, r.Textfield_14 FROM #Request.prefix_db_agency#.Coding_Scrub s LEFT OUTER JOIN #Request.prefix_db_lookup#.CW_Visit_Stagger_Detail v ON s.Message_ID = v.visit_no JOIN #Request.prefix_db_agency#.Coding_Results r ON r.Dx_order = v.goals where s.Assessment_ID = #url.AID# and s.Patient_ID = #url.ID# and r.Assessment_ID = s.Assessment_ID and r.Dx_order = v.goals and r.Order_ID = 28 and s.Risk = 'OT' and v.visit_no = 12 and v.problems = #CWProbs# and v.total_visits = #OT_User#
'> Update #Request.prefix_db_agency#.Coding_Scrub set Created_by = '#CW_Visit_12#', Answer_1 = '#goals#',Answer_2 = '#assessment#', GG_1 = 'report unstable symptoms to physician; implement changes to physician orders', GG_2 = 'since patient does not have teachable caregiver document challenges of teaching patient symptom monitoring and preventive care all while patient must manage ADLs with minimal or no assistance' 'since patient is not teachable and does not have teachable caregiver document challenges of achieving stable symptoms and the need for long-term monitoring''document unstable symptoms and success of caregiver recall' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 12 and Message = 'User Entered' and Risk = 'OT' Update #Request.prefix_db_agency#.Coding_Scrub set Field_12 = '#CW_Visit_11#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 12 and Risk = 'OT' SELECT r.Diagnosis, r.Textfield_14 FROM #Request.prefix_db_agency#.Coding_Scrub s LEFT OUTER JOIN #Request.prefix_db_lookup#.CW_Visit_Stagger_Detail v ON s.Message_ID = v.visit_no JOIN #Request.prefix_db_agency#.Coding_Results r ON r.Dx_order = v.goals where s.Assessment_ID = #url.AID# and s.Patient_ID = #url.ID# and r.Assessment_ID = s.Assessment_ID and r.Dx_order = v.goals and r.Order_ID = 28 and s.Risk = 'OT' and v.visit_no = 13 and v.problems = #CWProbs# and v.total_visits = #OT_User#
'> Update #Request.prefix_db_agency#.Coding_Scrub set Created_by = '#CW_Visit_13#', Answer_1 = '#goals#',Answer_2 = '#assessment#', GG_1 = 'report unstable symptoms to physician; implement changes to physician orders', GG_2 = 'since patient does not have teachable caregiver document challenges of teaching patient symptom monitoring and preventive care all while patient must manage ADLs with minimal or no assistance' 'since patient is not teachable and does not have teachable caregiver document challenges of achieving stable symptoms and the need for long-term monitoring''document unstable symptoms and success of caregiver recall' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 13 and Message = 'User Entered' and Risk = 'OT' Update #Request.prefix_db_agency#.Coding_Scrub set Field_12 = '#CW_Visit_12#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 13 and Risk = 'OT' SELECT r.Diagnosis, r.Textfield_14 FROM #Request.prefix_db_agency#.Coding_Scrub s LEFT OUTER JOIN #Request.prefix_db_lookup#.CW_Visit_Stagger_Detail v ON s.Message_ID = v.visit_no JOIN #Request.prefix_db_agency#.Coding_Results r ON r.Dx_order = v.goals where s.Assessment_ID = #url.AID# and s.Patient_ID = #url.ID# and r.Assessment_ID = s.Assessment_ID and r.Dx_order = v.goals and r.Order_ID = 28 and s.Risk = 'OT' and v.visit_no = 14 and v.problems = #CWProbs# and v.total_visits = #OT_User#
'> Update #Request.prefix_db_agency#.Coding_Scrub set Created_by = '#CW_Visit_14#', Answer_1 = '#goals#',Answer_2 = '#assessment#', GG_1 = 'report unstable symptoms to physician; implement changes to physician orders', GG_2 = 'since patient does not have teachable caregiver document challenges of teaching patient symptom monitoring and preventive care all while patient must manage ADLs with minimal or no assistance' 'since patient is not teachable and does not have teachable caregiver document challenges of achieving stable symptoms and the need for long-term monitoring''document unstable symptoms and success of caregiver recall' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 14 and Message = 'User Entered' and Risk = 'OT' Update #Request.prefix_db_agency#.Coding_Scrub set Field_12 = '#CW_Visit_13#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 14 and Risk = 'OT' SELECT r.Diagnosis, r.Textfield_14 FROM #Request.prefix_db_agency#.Coding_Scrub s LEFT OUTER JOIN #Request.prefix_db_lookup#.CW_Visit_Stagger_Detail v ON s.Message_ID = v.visit_no JOIN #Request.prefix_db_agency#.Coding_Results r ON r.Dx_order = v.goals where s.Assessment_ID = #url.AID# and s.Patient_ID = #url.ID# and r.Assessment_ID = s.Assessment_ID and r.Dx_order = v.goals and r.Order_ID = 28 and s.Risk = 'OT' and v.visit_no = 15 and v.problems = #CWProbs# and v.total_visits = #OT_User#
'> Update #Request.prefix_db_agency#.Coding_Scrub set Created_by = '#CW_Visit_15#', Answer_1 = '#goals#',Answer_2 = '#assessment#', GG_1 = 'report unstable symptoms to physician; implement changes to physician orders', GG_2 = 'since patient does not have teachable caregiver document challenges of teaching patient symptom monitoring and preventive care all while patient must manage ADLs with minimal or no assistance' 'since patient is not teachable and does not have teachable caregiver document challenges of achieving stable symptoms and the need for long-term monitoring''document unstable symptoms and success of caregiver recall' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 15 and Message = 'User Entered' and Risk = 'OT' Update #Request.prefix_db_agency#.Coding_Scrub set Field_12 = '#CW_Visit_14#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 15 and Risk = 'OT' SELECT Assessment_ID, Order_ID, ICD, count(*) AS dxcount FROM #Request.prefix_db_agency#.Coding_Results where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Textfield_11 = 'PT' and Order_ID = 29 and Message_ID = 10 order by Results_ID SELECT * FROM #Request.prefix_db_lookup#.CW_Visit_Stagger where Total_Visits = #PT_User# and Total_Dx = #CWProbs# INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Scrub (Assessment_ID,Patient_ID,Message_ID,Risk,Risk_Type,Message,Subject,Created_Date) VALUES (#url.AID#,#url.ID#,'#VisitNo#','PT','#Goals#','User Entered','Caregiver recalls teaching from prior visit''Patient recalls teaching from prior visit''no teachable caregiver; patient is not teachable','#DateFormat(Now(),"yyyy-mm-dd")#') Select Diagnosis, Deficits from #Request.prefix_db_agency#.Coding_Results where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Textfield_11 = 'PT' and Order_ID = 29 and Message_ID = 10 order by Dx_Order
'> Select Diagnosis, Textfield_1 from #Request.prefix_db_agency#.Coding_Results where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Textfield_11 = 'PT' and Order_ID = 29 and Message_ID = 10 order by Dx_Order
'> SELECT r.Diagnosis, r.Textfield_14 FROM #Request.prefix_db_agency#.Coding_Scrub s LEFT OUTER JOIN #Request.prefix_db_lookup#.CW_Visit_Stagger_Detail v ON s.Message_ID = v.visit_no JOIN #Request.prefix_db_agency#.Coding_Results r ON r.Dx_order = v.goals where s.Assessment_ID = #url.AID# and s.Patient_ID = #url.ID# and r.Assessment_ID = s.Assessment_ID and r.Dx_order = v.goals and r.Order_ID = 29 and s.Risk = 'PT' and v.visit_no = 1 and v.problems = #CWProbs# and v.total_visits = #PT_User#
'> Update #Request.prefix_db_agency#.Coding_Scrub set Created_by = '#CW_Visit_1#', Answer_1 = '#goals#',Answer_2 = '#assessment#', GG_1 = 'report unstable symptoms to physician; implement changes to physician orders', GG_2 = 'since patient does not have teachable caregiver document challenges of teaching patient symptom monitoring and preventive care all while patient must manage ADLs with minimal or no assistance' 'since patient is not teachable and does not have teachable caregiver document challenges of achieving stable symptoms and the need for long-term monitoring''document unstable symptoms and success of caregiver recall' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 1 and Message = 'User Entered' and Risk = 'PT' SELECT r.Diagnosis, r.Textfield_14 FROM #Request.prefix_db_agency#.Coding_Scrub s LEFT OUTER JOIN #Request.prefix_db_lookup#.CW_Visit_Stagger_Detail v ON s.Message_ID = v.visit_no JOIN #Request.prefix_db_agency#.Coding_Results r ON r.Dx_order = v.goals where s.Assessment_ID = #url.AID# and s.Patient_ID = #url.ID# and r.Assessment_ID = s.Assessment_ID and r.Dx_order = v.goals and r.Order_ID = 29 and s.Risk = 'PT' and v.visit_no = 2 and v.problems = #CWProbs# and v.total_visits = #PT_User#
'> Update #Request.prefix_db_agency#.Coding_Scrub set Created_by = '#CW_Visit_2#', Answer_1 = '#goals#',Answer_2 = '#assessment#', GG_1 = 'report unstable symptoms to physician; implement changes to physician orders', GG_2 = 'since patient does not have teachable caregiver document challenges of teaching patient symptom monitoring and preventive care all while patient must manage ADLs with minimal or no assistance' 'since patient is not teachable and does not have teachable caregiver document challenges of achieving stable symptoms and the need for long-term monitoring''document unstable symptoms and success of caregiver recall' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 2 and Message = 'User Entered' and Risk = 'PT' Update #Request.prefix_db_agency#.Coding_Scrub set Field_12 = '#CW_Visit_1#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 2 and Risk = 'PT' SELECT r.Diagnosis, r.Textfield_14 FROM #Request.prefix_db_agency#.Coding_Scrub s LEFT OUTER JOIN #Request.prefix_db_lookup#.CW_Visit_Stagger_Detail v ON s.Message_ID = v.visit_no JOIN #Request.prefix_db_agency#.Coding_Results r ON r.Dx_order = v.goals where s.Assessment_ID = #url.AID# and s.Patient_ID = #url.ID# and r.Assessment_ID = s.Assessment_ID and r.Dx_order = v.goals and r.Order_ID = 29 and s.Risk = 'PT' and v.visit_no = 3 and v.problems = #CWProbs# and v.total_visits = #PT_User#
'> Update #Request.prefix_db_agency#.Coding_Scrub set Created_by = '#CW_Visit_3#', Answer_1 = '#goals#',Answer_2 = '#assessment#', GG_1 = 'report unstable symptoms to physician; implement changes to physician orders', GG_2 = 'since patient does not have teachable caregiver document challenges of teaching patient symptom monitoring and preventive care all while patient must manage ADLs with minimal or no assistance' 'since patient is not teachable and does not have teachable caregiver document challenges of achieving stable symptoms and the need for long-term monitoring''document unstable symptoms and success of caregiver recall' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 3 and Message = 'User Entered' and Risk = 'PT' Update #Request.prefix_db_agency#.Coding_Scrub set Field_12 = '#CW_Visit_2#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 3 and Risk = 'PT' SELECT r.Diagnosis, r.Textfield_14 FROM #Request.prefix_db_agency#.Coding_Scrub s LEFT OUTER JOIN #Request.prefix_db_lookup#.CW_Visit_Stagger_Detail v ON s.Message_ID = v.visit_no JOIN #Request.prefix_db_agency#.Coding_Results r ON r.Dx_order = v.goals where s.Assessment_ID = #url.AID# and s.Patient_ID = #url.ID# and r.Assessment_ID = s.Assessment_ID and r.Dx_order = v.goals and r.Order_ID = 29 and s.Risk = 'PT' and v.visit_no = 4 and v.problems = #CWProbs# and v.total_visits = #PT_User#
'> Update #Request.prefix_db_agency#.Coding_Scrub set Created_by = '#CW_Visit_4#', Answer_1 = '#goals#',Answer_2 = '#assessment#', GG_1 = 'report unstable symptoms to physician; implement changes to physician orders', GG_2 = 'since patient does not have teachable caregiver document challenges of teaching patient symptom monitoring and preventive care all while patient must manage ADLs with minimal or no assistance' 'since patient is not teachable and does not have teachable caregiver document challenges of achieving stable symptoms and the need for long-term monitoring''document unstable symptoms and success of caregiver recall' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 4 and Message = 'User Entered' and Risk = 'PT' Update #Request.prefix_db_agency#.Coding_Scrub set Field_12 = '#CW_Visit_3#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 4 and Risk = 'PT' SELECT r.Diagnosis, r.Textfield_14 FROM #Request.prefix_db_agency#.Coding_Scrub s LEFT OUTER JOIN #Request.prefix_db_lookup#.CW_Visit_Stagger_Detail v ON s.Message_ID = v.visit_no JOIN #Request.prefix_db_agency#.Coding_Results r ON r.Dx_order = v.goals where s.Assessment_ID = #url.AID# and s.Patient_ID = #url.ID# and r.Assessment_ID = s.Assessment_ID and r.Dx_order = v.goals and r.Order_ID = 29 and s.Risk = 'PT' and v.visit_no = 5 and v.problems = #CWProbs# and v.total_visits = #PT_User#
'> Update #Request.prefix_db_agency#.Coding_Scrub set Created_by = '#CW_Visit_5#', Answer_1 = '#goals#',Answer_2 = '#assessment#', GG_1 = 'report unstable symptoms to physician; implement changes to physician orders', GG_2 = 'since patient does not have teachable caregiver document challenges of teaching patient symptom monitoring and preventive care all while patient must manage ADLs with minimal or no assistance' 'since patient is not teachable and does not have teachable caregiver document challenges of achieving stable symptoms and the need for long-term monitoring''document unstable symptoms and success of caregiver recall' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 5 and Message = 'User Entered' and Risk = 'PT' Update #Request.prefix_db_agency#.Coding_Scrub set Field_12 = '#CW_Visit_4#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 5 and Risk = 'PT' SELECT r.Diagnosis, r.Textfield_14 FROM #Request.prefix_db_agency#.Coding_Scrub s LEFT OUTER JOIN #Request.prefix_db_lookup#.CW_Visit_Stagger_Detail v ON s.Message_ID = v.visit_no JOIN #Request.prefix_db_agency#.Coding_Results r ON r.Dx_order = v.goals where s.Assessment_ID = #url.AID# and s.Patient_ID = #url.ID# and r.Assessment_ID = s.Assessment_ID and r.Dx_order = v.goals and r.Order_ID = 29 and s.Risk = 'PT' and v.visit_no = 6 and v.problems = #CWProbs# and v.total_visits = #PT_User#
'> Update #Request.prefix_db_agency#.Coding_Scrub set Created_by = '#CW_Visit_6#', Answer_1 = '#goals#',Answer_2 = '#assessment#', GG_1 = 'report unstable symptoms to physician; implement changes to physician orders', GG_2 = 'since patient does not have teachable caregiver document challenges of teaching patient symptom monitoring and preventive care all while patient must manage ADLs with minimal or no assistance' 'since patient is not teachable and does not have teachable caregiver document challenges of achieving stable symptoms and the need for long-term monitoring''document unstable symptoms and success of caregiver recall' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 6 and Message = 'User Entered' and Risk = 'PT' Update #Request.prefix_db_agency#.Coding_Scrub set Field_12 = '#CW_Visit_5#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 6 and Risk = 'PT' SELECT r.Diagnosis, r.Textfield_14 FROM #Request.prefix_db_agency#.Coding_Scrub s LEFT OUTER JOIN #Request.prefix_db_lookup#.CW_Visit_Stagger_Detail v ON s.Message_ID = v.visit_no JOIN #Request.prefix_db_agency#.Coding_Results r ON r.Dx_order = v.goals where s.Assessment_ID = #url.AID# and s.Patient_ID = #url.ID# and r.Assessment_ID = s.Assessment_ID and r.Dx_order = v.goals and r.Order_ID = 29 and s.Risk = 'PT' and v.visit_no = 7 and v.problems = #CWProbs# and v.total_visits = #PT_User#
'> Update #Request.prefix_db_agency#.Coding_Scrub set Created_by = '#CW_Visit_7#', Answer_1 = '#goals#',Answer_2 = '#assessment#', GG_1 = 'report unstable symptoms to physician; implement changes to physician orders', GG_2 = 'since patient does not have teachable caregiver document challenges of teaching patient symptom monitoring and preventive care all while patient must manage ADLs with minimal or no assistance' 'since patient is not teachable and does not have teachable caregiver document challenges of achieving stable symptoms and the need for long-term monitoring''document unstable symptoms and success of caregiver recall' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 7 and Message = 'User Entered' and Risk = 'PT' Update #Request.prefix_db_agency#.Coding_Scrub set Field_12 = '#CW_Visit_6#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 7 and Risk = 'PT' SELECT r.Diagnosis, r.Textfield_14 FROM #Request.prefix_db_agency#.Coding_Scrub s LEFT OUTER JOIN #Request.prefix_db_lookup#.CW_Visit_Stagger_Detail v ON s.Message_ID = v.visit_no JOIN #Request.prefix_db_agency#.Coding_Results r ON r.Dx_order = v.goals where s.Assessment_ID = #url.AID# and s.Patient_ID = #url.ID# and r.Assessment_ID = s.Assessment_ID and r.Dx_order = v.goals and r.Order_ID = 29 and s.Risk = 'PT' and v.visit_no = 8 and v.problems = #CWProbs# and v.total_visits = #PT_User#
'> Update #Request.prefix_db_agency#.Coding_Scrub set Created_by = '#CW_Visit_8#', Answer_1 = '#goals#',Answer_2 = '#assessment#', GG_1 = 'report unstable symptoms to physician; implement changes to physician orders', GG_2 = 'since patient does not have teachable caregiver document challenges of teaching patient symptom monitoring and preventive care all while patient must manage ADLs with minimal or no assistance' 'since patient is not teachable and does not have teachable caregiver document challenges of achieving stable symptoms and the need for long-term monitoring''document unstable symptoms and success of caregiver recall' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 8 and Message = 'User Entered' and Risk = 'PT' Update #Request.prefix_db_agency#.Coding_Scrub set Field_12 = '#CW_Visit_7#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 8 and Risk = 'PT' SELECT r.Diagnosis, r.Textfield_14 FROM #Request.prefix_db_agency#.Coding_Scrub s LEFT OUTER JOIN #Request.prefix_db_lookup#.CW_Visit_Stagger_Detail v ON s.Message_ID = v.visit_no JOIN #Request.prefix_db_agency#.Coding_Results r ON r.Dx_order = v.goals where s.Assessment_ID = #url.AID# and s.Patient_ID = #url.ID# and r.Assessment_ID = s.Assessment_ID and r.Dx_order = v.goals and r.Order_ID = 29 and s.Risk = 'PT' and v.visit_no = 9 and v.problems = #CWProbs# and v.total_visits = #PT_User#
'> Update #Request.prefix_db_agency#.Coding_Scrub set Created_by = '#CW_Visit_9#', Answer_1 = '#goals#',Answer_2 = '#assessment#', GG_1 = 'report unstable symptoms to physician; implement changes to physician orders', GG_2 = 'since patient does not have teachable caregiver document challenges of teaching patient symptom monitoring and preventive care all while patient must manage ADLs with minimal or no assistance' 'since patient is not teachable and does not have teachable caregiver document challenges of achieving stable symptoms and the need for long-term monitoring''document unstable symptoms and success of caregiver recall' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 9 and Message = 'User Entered' and Risk = 'PT' Update #Request.prefix_db_agency#.Coding_Scrub set Field_12 = '#CW_Visit_8#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 9 and Risk = 'PT' SELECT r.Diagnosis, r.Textfield_14 FROM #Request.prefix_db_agency#.Coding_Scrub s LEFT OUTER JOIN #Request.prefix_db_lookup#.CW_Visit_Stagger_Detail v ON s.Message_ID = v.visit_no JOIN #Request.prefix_db_agency#.Coding_Results r ON r.Dx_order = v.goals where s.Assessment_ID = #url.AID# and s.Patient_ID = #url.ID# and r.Assessment_ID = s.Assessment_ID and r.Dx_order = v.goals and r.Order_ID = 29 and s.Risk = 'PT' and v.visit_no = 10 and v.problems = #CWProbs# and v.total_visits = #PT_User#
'> Update #Request.prefix_db_agency#.Coding_Scrub set Created_by = '#CW_Visit_10#', Answer_1 = '#goals#',Answer_2 = '#assessment#', GG_1 = 'report unstable symptoms to physician; implement changes to physician orders', GG_2 = 'since patient does not have teachable caregiver document challenges of teaching patient symptom monitoring and preventive care all while patient must manage ADLs with minimal or no assistance' 'since patient is not teachable and does not have teachable caregiver document challenges of achieving stable symptoms and the need for long-term monitoring''document unstable symptoms and success of caregiver recall' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 10 and Message = 'User Entered' and Risk = 'PT' Update #Request.prefix_db_agency#.Coding_Scrub set Field_12 = '#CW_Visit_9#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 10 and Risk = 'PT' SELECT r.Diagnosis, r.Textfield_14 FROM #Request.prefix_db_agency#.Coding_Scrub s LEFT OUTER JOIN #Request.prefix_db_lookup#.CW_Visit_Stagger_Detail v ON s.Message_ID = v.visit_no JOIN #Request.prefix_db_agency#.Coding_Results r ON r.Dx_order = v.goals where s.Assessment_ID = #url.AID# and s.Patient_ID = #url.ID# and r.Assessment_ID = s.Assessment_ID and r.Dx_order = v.goals and r.Order_ID = 29 and s.Risk = 'PT' and v.visit_no = 11 and v.problems = #CWProbs# and v.total_visits = #PT_User#
'> Update #Request.prefix_db_agency#.Coding_Scrub set Created_by = '#CW_Visit_11#', Answer_1 = '#goals#',Answer_2 = '#assessment#', GG_1 = 'report unstable symptoms to physician; implement changes to physician orders', GG_2 = 'since patient does not have teachable caregiver document challenges of teaching patient symptom monitoring and preventive care all while patient must manage ADLs with minimal or no assistance' 'since patient is not teachable and does not have teachable caregiver document challenges of achieving stable symptoms and the need for long-term monitoring''document unstable symptoms and success of caregiver recall' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 11 and Message = 'User Entered' and Risk = 'PT' Update #Request.prefix_db_agency#.Coding_Scrub set Field_12 = '#CW_Visit_11#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 11 and Risk = 'PT' SELECT r.Diagnosis, r.Textfield_14 FROM #Request.prefix_db_agency#.Coding_Scrub s LEFT OUTER JOIN #Request.prefix_db_lookup#.CW_Visit_Stagger_Detail v ON s.Message_ID = v.visit_no JOIN #Request.prefix_db_agency#.Coding_Results r ON r.Dx_order = v.goals where s.Assessment_ID = #url.AID# and s.Patient_ID = #url.ID# and r.Assessment_ID = s.Assessment_ID and r.Dx_order = v.goals and r.Order_ID = 29 and s.Risk = 'PT' and v.visit_no = 12 and v.problems = #CWProbs# and v.total_visits = #PT_User#
'> Update #Request.prefix_db_agency#.Coding_Scrub set Created_by = '#CW_Visit_12#', Answer_1 = '#goals#',Answer_2 = '#assessment#', GG_1 = 'report unstable symptoms to physician; implement changes to physician orders', GG_2 = 'since patient does not have teachable caregiver document challenges of teaching patient symptom monitoring and preventive care all while patient must manage ADLs with minimal or no assistance' 'since patient is not teachable and does not have teachable caregiver document challenges of achieving stable symptoms and the need for long-term monitoring''document unstable symptoms and success of caregiver recall' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 12 and Message = 'User Entered' and Risk = 'PT' Update #Request.prefix_db_agency#.Coding_Scrub set Field_12 = '#CW_Visit_11#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 12 and Risk = 'PT' SELECT r.Diagnosis, r.Textfield_14 FROM #Request.prefix_db_agency#.Coding_Scrub s LEFT OUTER JOIN #Request.prefix_db_lookup#.CW_Visit_Stagger_Detail v ON s.Message_ID = v.visit_no JOIN #Request.prefix_db_agency#.Coding_Results r ON r.Dx_order = v.goals where s.Assessment_ID = #url.AID# and s.Patient_ID = #url.ID# and r.Assessment_ID = s.Assessment_ID and r.Dx_order = v.goals and r.Order_ID = 29 and s.Risk = 'PT' and v.visit_no = 13 and v.problems = #CWProbs# and v.total_visits = #PT_User#
'> Update #Request.prefix_db_agency#.Coding_Scrub set Created_by = '#CW_Visit_13#', Answer_1 = '#goals#',Answer_2 = '#assessment#', GG_1 = 'report unstable symptoms to physician; implement changes to physician orders', GG_2 = 'since patient does not have teachable caregiver document challenges of teaching patient symptom monitoring and preventive care all while patient must manage ADLs with minimal or no assistance' 'since patient is not teachable and does not have teachable caregiver document challenges of achieving stable symptoms and the need for long-term monitoring''document unstable symptoms and success of caregiver recall' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 13 and Message = 'User Entered' and Risk = 'PT' Update #Request.prefix_db_agency#.Coding_Scrub set Field_12 = '#CW_Visit_12#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 13 and Risk = 'PT' SELECT r.Diagnosis, r.Textfield_14 FROM #Request.prefix_db_agency#.Coding_Scrub s LEFT OUTER JOIN #Request.prefix_db_lookup#.CW_Visit_Stagger_Detail v ON s.Message_ID = v.visit_no JOIN #Request.prefix_db_agency#.Coding_Results r ON r.Dx_order = v.goals where s.Assessment_ID = #url.AID# and s.Patient_ID = #url.ID# and r.Assessment_ID = s.Assessment_ID and r.Dx_order = v.goals and r.Order_ID = 29 and s.Risk = 'PT' and v.visit_no = 14 and v.problems = #CWProbs# and v.total_visits = #PT_User#
'> Update #Request.prefix_db_agency#.Coding_Scrub set Created_by = '#CW_Visit_14#', Answer_1 = '#goals#',Answer_2 = '#assessment#', GG_1 = 'report unstable symptoms to physician; implement changes to physician orders', GG_2 = 'since patient does not have teachable caregiver document challenges of teaching patient symptom monitoring and preventive care all while patient must manage ADLs with minimal or no assistance' 'since patient is not teachable and does not have teachable caregiver document challenges of achieving stable symptoms and the need for long-term monitoring''document unstable symptoms and success of caregiver recall' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 14 and Message = 'User Entered' and Risk = 'PT' Update #Request.prefix_db_agency#.Coding_Scrub set Field_12 = '#CW_Visit_13#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 14 and Risk = 'PT' SELECT r.Diagnosis, r.Textfield_14 FROM #Request.prefix_db_agency#.Coding_Scrub s LEFT OUTER JOIN #Request.prefix_db_lookup#.CW_Visit_Stagger_Detail v ON s.Message_ID = v.visit_no JOIN #Request.prefix_db_agency#.Coding_Results r ON r.Dx_order = v.goals where s.Assessment_ID = #url.AID# and s.Patient_ID = #url.ID# and r.Assessment_ID = s.Assessment_ID and r.Dx_order = v.goals and r.Order_ID = 29 and s.Risk = 'PT' and v.visit_no = 15 and v.problems = #CWProbs# and v.total_visits = #PT_User#
'> Update #Request.prefix_db_agency#.Coding_Scrub set Created_by = '#CW_Visit_15#', Answer_1 = '#goals#',Answer_2 = '#assessment#', GG_1 = 'report unstable symptoms to physician; implement changes to physician orders', GG_2 = 'since patient does not have teachable caregiver document challenges of teaching patient symptom monitoring and preventive care all while patient must manage ADLs with minimal or no assistance' 'since patient is not teachable and does not have teachable caregiver document challenges of achieving stable symptoms and the need for long-term monitoring''document unstable symptoms and success of caregiver recall' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 15 and Message = 'User Entered' and Risk = 'PT' Update #Request.prefix_db_agency#.Coding_Scrub set Field_12 = '#CW_Visit_14#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 15 and Risk = 'PT' SELECT HHA_Visit_Count from #Request.prefix_db_agency#.Assessment_New where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and HHA_Visit_Count > 0 SELECT * from #Request.prefix_db_lookup#.CW_Visit_Stagger_Detail where problems = 1 and total_visits = '#HHA_visits#' SELECT Textfield_14 FROM #Request.prefix_db_agency#.Coding_Results where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and (Order_ID = 30) and Message_ID = 10
'> INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Scrub (Assessment_ID,Patient_ID,Message_ID,Risk,Risk_Type,Message,GG_2,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#visit_no#','HHA','1','User entered','#H_List#','#DateFormat(Now(),"yyyy-mm-dd")#')