SELECT * From #Request.prefix_db_agency#.patient p, #Request.prefix_db_lookup#.Dx_Comorbidities d where p.Patient_ID = #url.ID# and p.Safety_Hazards_M0320 = d.Descrip_1 select * from #Request.prefix_db_agency#.Assessment_New where Assessment_ID = #url.AID# Update #Request.prefix_db_agency#.Assessment_New set HIPPS_Code = '1AFKS' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# SELECT Assessment_ID, Order_ID, Diagnosis, Textfield_1, Textfield_3, count(*) AS count From #Request.prefix_db_agency#.Coding_Results where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and (TextField_1 = '' and TextField_3 = '') or (TextField_1 != '#PDGM#' and TextField_3 != '#PDGM#') and Dx_Order = 1 Update #Request.prefix_db_agency#.Coding_Results set Memo = 'This primary diagnosis is not a PDGM casemix and there is no available alternative.''The primary diagnosis is inconsistent with the primary reason for home care.', Textfield_10 = 'A DIFFERENT PRIMARY DIAGNOSIS MUST BE SELECTED.' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and (TextField_1 = '' and TextField_3 = '') or (TextField_1 != '#PDGM#' and TextField_3 != '#PDGM#') and Dx_Order = 1 Update #Request.prefix_db_agency#.Coding_Results set Memo = 'The user-entered diagnosis is a PDGM wound casemix and will optimize reimbursement.', Textfield_10 = '#Get_DX_1.Diagnosis#''The user-entered diagnosis is not a PDGM casemix and will not optimize reimbursement. We recommend using the Coding Wizard-recommend casemix diagnosis replacement that will increase reimbursement by $407.38.', Textfield_10 = '#Get_DX_1.Diagnosis#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and (TextField_1 = '#PDGM#' or TextField_3 = '#PDGM#') and Dx_Order = 1 and Message_ID NOT IN (13,15) LIMIT 1