SELECT * from #Request.prefix_db_agency#.Coding_Results where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 78 Update #Request.prefix_db_agency#.Coding_Results c, #Request.prefix_db_lookup#.CW_Coding_Class_PDGM u set c.Textfield_8 = u.Goal where c.Assessment_ID = #url.AID# and c.Patient_ID = #url.ID# and c.Order_ID = u.Priority SELECT OASIS FROM #Request.prefix_db_agency#.Coding_Results where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 10 order by Results_ID
"> Select Left(a.HIPPS_Code,4) AS HIPPS, a.HIPPS_Code ,a.SN_Visit_Count, a.Therapy_Visit_Count, a.M0826_Ther_Need, a.HHA_Visit_Count, u.Total_Reimburse from #Request.prefix_db_agency#.Assessment_New a, #Request.prefix_db_lookup#.CW_Utilization_2019 u where a.Assessment_ID = #url.AID# and a.Patient_ID = #url.ID# and Left(a.HIPPS_Code,4) = u.HIPPS_Code and u.rank = '1'
' & 'Patient has ' & #Session.CS.Count_Thpy# & ' ADL/mobility deficits requiring therapy. Since there is a caregiver available during the day, home health aide is not indicated.'>
' & 'Patient has ' & #Session.CS.Count_Thpy# & ' ADL/mobility deficits requiring therapy. Since there is no caregiver available during the day and the patient has ADL deficits home health aide IS INDICATED.'>
' & 'Patient has ' & #Session.CS.Count_Thpy# & ' ADL/mobility deficits requiring therapy. Since patient is confused and has no caregiver, home health aide IS INDICATED. Since patient is not teachable, intermittent long-term rehabilitation and home health aide services is possible.'>
' & ' PATIENT HAS NO ADL DEFICITS REQUIRING THERAPY. VIEW THERAPY ANALYSIS BELOW.'> Delete from #Request.prefix_db_agency#.Coding_Scrub where Patient_ID = #session.cs.patientid# AND Assessment_ID = #url.AID# INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Scrub (Assessment_ID,Patient_ID,Message_ID,M0_Item,Risk_Type,Risk,Message,Created_by,Created_Date) VALUES (#url.AID#,#url.ID#,76,'#Get_H.HIPPS_Code#','#Get_H.SN_Visit_Count#','#Get_H.Therapy_Visit_Count#','#Get_H.HHA_Visit_Count#','#Get_H.Total_Reimburse#','#DateFormat(Now(),"yyyy-mm-dd")#') Update #Request.prefix_db_agency#.Coding_Scrub c, #Request.prefix_db_lookup#.CW_Utilization_Therapy_2019 u set c.Answer_1 = concat('#Summary#','

','HIPPS code > ','#Get_H.HIPPS_Code#','

60-Day Episode Reimbursement > ','#LSEuroCurrencyFormat(Get_H.Total_Reimburse, "local")#',' Total Cost > ','#LSEuroCurrencyFormat(user_All, "local")#',' Net Profit > ','#LSEuroCurrencyFormat(user_Profit, "local")#', '

SN ','#Get_H.SN_Visit_Count#',' visits | Cost > ','#LSEuroCurrencyFormat(user_SN, "local")#', '

Therapy ', '#user_Th_visits#',' visits | Cost > ','#LSEuroCurrencyFormat(Th_2019, "local")#', '

HHA ','#Get_H.HHA_Visit_Count#',' visits | Cost > ','#LSEuroCurrencyFormat(user_HHA, "local")#', '

','#Session.CS.Therapy_Analysis#') where c.Assessment_ID = #url.AID# and c.Patient_ID = #url.ID# Update #Request.prefix_db_agency#.Coding_Scrub c set c.Answer_1 = concat('#Summary#','

','HIPPS code > ','#Get_H.HIPPS_Code#','

60-Day Episode Reimbursement > ','#LSEuroCurrencyFormat(Get_H.Total_Reimburse, "local")#', '

Therapy ', '#user_Th_visits#',' visits | Cost > ','#LSEuroCurrencyFormat(user_Th, "local")#','

','#Session.CS.Therapy_Analysis#') where c.Assessment_ID = #url.AID# and c.Patient_ID = #url.ID# Update #Request.prefix_db_agency#.Coding_Scrub c, #Request.prefix_db_lookup#.CW_Utilization_Therapy_2019 u set c.Answer_2 = u.Visits_Therapy_2019, c.GG_1 = '#Therapy_Util_Code#' where c.Assessment_ID = #url.AID# and c.Patient_ID = #url.ID# and u.Code = '#Therapy_Util_Code#' Select Answer_2 from #Request.prefix_db_agency#.Coding_Scrub where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 76 Update #Request.prefix_db_agency#.Coding_Scrub c, #Request.prefix_db_lookup#.CW_Utilization_2019 u set c.GG_2 = '#New_HIPPS#', c.Subject = u.Visits_SN, c.Desired = u.Visits_Therapy, c.Short = u.Visits_HHA, c.Field_1 = u.Total_Reimburse where c.Assessment_ID = #url.AID# and c.Patient_ID = #url.ID# and u.HIPPS_Code = '#New_HIPPS#' and u.rank = #rank_2019# and u.Visits_Therapy = '#Get_S.Answer_2#' Select IFNULL(Subject,0) as Subject, IFNULL(Desired,0) as Desired, IFNULL(Short,0) as Short, IFNULL(Field_1,0) as Field_1 from #Request.prefix_db_agency#.Coding_Scrub where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 76 Update #Request.prefix_db_agency#.Coding_Scrub set Field_2 = concat('#Summary#','

','Recommended 2019 OASIS-D HIPPS code > ','#New_HIPPS_5#','

60-Day Episode Reimbursement > ','#LSEuroCurrencyFormat(Get_OD.Field_1, "local")#','

Total Cost > ','#LSEuroCurrencyFormat(All_2019, "local")#','

Net Profit > ','#LSEuroCurrencyFormat(All_2019_Profit, "local")#', '

SN ','#Get_OD.Subject#',' visits | Cost > ','#LSEuroCurrencyFormat(SN_2019, "local")#',' *Allows for multiple careplan changes. If no changes occur less visits may be sufficient.', '

PT ', '#NumberFormat(PT_Visits_2019, "_")#',' visits | OT ','#NumberFormat(OT_Visits_2019, "_")#',' visits | Cost > ','#LSEuroCurrencyFormat(Th_2019, "local")#', '

HHA ','#Get_OD.Short#',' visits | Cost > ','#LSEuroCurrencyFormat(HHA_2019, "local")#', '

','#Session.CS.Therapy_Analysis#') where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 76 SELECT Textfield_1, Textfield_3 From #Request.prefix_db_agency#.Coding_Results where Patient_ID = #url.ID# and Assessment_ID = #url.AID# and Dx_Order = 1 Update #Request.prefix_db_agency#.Coding_Scrub set Field_9 = '#HIPPS2020#', Field_10 = '#HIPPS2020#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID#
' & 'Patient has ' & #Session.CS.Count_Thpy# & ' ADL/mobility deficits requiring therapy. Since there is a caregiver available during the day, home health aide is not indicated.'>
' & 'Patient has ' & #Session.CS.Count_Thpy# & ' ADL/mobility deficits requiring therapy. Since there is no caregiver available during the day and the patient has ADL deficits home health aide IS INDICATED.'>
' & 'Patient has ' & #Session.CS.Count_Thpy# & ' ADL/mobility deficits requiring therapy. Since patient is confused and has no caregiver, home health aide IS INDICATED. Since patient is not teachable, intermittent long-term rehabilitation and home health aide services is possible.'>
' & ' PATIENT HAS NO ADL DEFICITS REQUIRING THERAPY. VIEW THERAPY ANALYSIS BELOW.'> Update #Request.prefix_db_agency#.Coding_Scrub c, #Request.prefix_db_lookup#.CW_Utilization_2020 u set c.Field_3 = u.Visits_SN, c.Field_4 = u.Visits_Therapy, c.Field_5 = u.Visits_HHA, c.Field_6 = u.Total_Reimburse where c.Assessment_ID = #url.AID# and c.Patient_ID = #url.ID# and u.HIPPS_Code = '#HIPPS2020#' and u.rank = '#rank_2020#' Select IFNULL(Field_3,0) as Field_3,IFNULL(Field_4,0) as Field_4,IFNULL(Field_5,0) as Field_5 , IFNULL(Field_6,0) as Field_6 from #Request.prefix_db_agency#.Coding_Scrub where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 76 Update #Request.prefix_db_agency#.Coding_Scrub set Field_7 = concat('#Summary#','

','2020 PDGM HIPPS code > ','#HIPPS2020#','

30-Day Episode Reimbursement > ','#LSEuroCurrencyFormat(Get_PD.Field_6, "local")#','

Total Cost > ','#LSEuroCurrencyFormat(All_2020, "local")#','

Net Profit > ','#LSEuroCurrencyFormat(All_2020_Profit, "local")#', '

SN ','#Get_PD.Field_3#',' visits | Cost > ','#LSEuroCurrencyFormat(SN_2020, "local")#', '

PT ', '#NumberFormat(PT_Visits_2020, "_")#',' visits | OT ','#NumberFormat(OT_Visits_2020, "_")#',' visits | Cost > ','#LSEuroCurrencyFormat(Th_2020, "local")#', '

HHA ','#Get_PD.Field_5#',' visits | Cost > ','#LSEuroCurrencyFormat(HHA_2020, "local")#','

#Session.CS.Therapy_Analysis#') where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 76 Select M0_Item_Medication, Diagnosis from #Request.prefix_db_agency#.Coding_Results where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and M0_Item_Medication like '%M102%' Order by Dx_Order ASC ' & 'from Face-to-Face | from H&P | from H&P - PDGM co-morbidity that adds casemix points | from OASIS - PDGM co-morbidity that adds casemix points | from clinician OASIS narrative'&'
' >
' & 'Please authorize/change recommended Coding & Utilization' & '

' & 'Hi All,' & '

' & 'We have completed our document review.' & '

' & 'We recommend the following diagnosis codes. Please see the attached report for rationale.'& '

' & #list# & '

' & #CG# & #CF# & '

' & 'The patient has ' & #Session.CS.Count_Thpy# &' deficits requiring therapy.' & '

' & 'Based on caregiver availability and number of ADL/IADL deficits we recommend the following utilization. Refer to the Utilization Report for complete therapy rationale.' & '

' & 'SN - ' & #Get_OD.Subject# & ' visits' & '
' & 'OT - ' & '#NumberFormat(OT_Visits_2019, "_")#' & ' visits' & '
' & 'PT - ' & '#NumberFormat(PT_Visits_2019, "_")#' & ' visits' & '
' & 'HHA - ' & '#Get_OD.Short#' & ' visits' & '

' & 'So that we can create and upload the final Visit and Teaching Plan, please reply with any changes to the above recommendations. Once your changes and/or approval is received, we’ll update the OASIS and CMS485 and upload all updated reports, including Teaching and Visit Plan.' & '

' & 'Coding Wizard Team' & '



' & 'message2' & '

' & 'OASIS & CMS485 Updated, Final Reports Attached' & '

' & 'Hi All,' & '

' & 'We have updated the OASIS with approved diagnosis codes and updated the CMS485 with goals and interventions. Attached are:' & '

' & '(1) list of diagnosis-specific goals and interventions that were used to update the CMS485'& '
' & '(2) Teaching Plan'& '
' & '(3) Patient Recall Sheet'& '
' & '(4) Visits Plans based on approved Utilization'& '

' & 'Please advise if additional changes are needed.'& '

' & 'Coding Wizard Team' & '



' & 'PROCESS 3 - message1' & '

' & 'Please authorize/change recommended Goals and Interventions, Utilization' & '

' & 'Hi All,' & '

' & 'We have completed our document review and coded the OASIS with the following diagnosis codes. Please see the attached report for rationale.'& '

' & #list# & '

' & #CG# & #CF# & '

' & 'The patient has ' & #Session.CS.Count_Thpy# &' deficits requiring therapy.' & '

' & 'Based on caregiver availability and number of ADL/IADL deficits we recommend the following utilization. Refer to the Utilization Report for complete therapy rationale.' & '

' & 'SN - ' & #Get_OD.Subject# & ' visits' & '
' & 'OT - ' & '#NumberFormat(OT_Visits_2019, "_")#' & ' visits' & '
' & 'PT - ' & '#NumberFormat(PT_Visits_2019, "_")#' & ' visits' & '
' & 'HHA - ' & '#Get_OD.Short#' & ' visits' & '

' & 'So that we can update the CMS485 with goals and interventions and upload the final Visit and Teaching Plan, please reply with any changes to the above recommendations. Once your changes and/or approval is received, we’ll upload all updated reports, including Teaching, Patient Recall and Visit Plan.' & '

' & 'Coding Wizard Team' & '



' & 'message2' & '

' & 'Visit Plan and Patient Recall Sheet Attached' & '

' & 'Hi All,' & '

' & 'Attached are:' & '

' & '(1) Patient Recall Sheet'& '
' & '(2) Visits Plans based on approved Utilization'& '

' & 'Please advise if additional changes are needed.'& '

' & 'Coding Wizard Team' & '



' & 'PROCESS 4 - message1' & '

' & 'Please authorize/change recommended Utilization' & '

' & 'Hi All,' & '

' & 'We have completed our document review, coded OASIS with the following diagnosis codes and updated the CMS485 with related goals and interventions. Please see the attached reports for rationale.'& '

' & #list# & '

' & #CG# & #CF# & '

' & 'The patient has ' & #Session.CS.Count_Thpy# &' deficits requiring therapy.' & '

' & 'Based on caregiver availability and number of ADL/IADL deficits we recommend the following utilization. Refer to the Utilization Report for complete therapy rationale.' & '

' & 'SN - ' & #Get_OD.Subject# & ' visits' & '
' & 'OT - ' & '#NumberFormat(OT_Visits_2019, "_")#' & ' visits' & '
' & 'PT - ' & '#NumberFormat(PT_Visits_2019, "_")#' & ' visits' & '
' & 'HHA - ' & '#Get_OD.Short#' & ' visits' & '

' & 'So that we can upload the final Visit Plan and Patient Recall Sheet, please reply with any changes to the above recommendations. Once your changes and/or approval is received, we’ll upload all updated reports.' & '

' & 'Coding Wizard Team' & '



' & 'message2' & '

' & 'Visit Plan and Patient Recall Sheet Attached' & '

' & 'Hi All,' & '

' & 'Attached are:' & '

' & '(1) Patient Recall Sheet'& '
' & '(2) Visits Plans based on approved Utilization'& '

' & 'Please advise if additional changes are needed.'& '

' & 'Coding Wizard Team'> Update #Request.prefix_db_agency#.Coding_Scrub set Field_11 = '#Team_Message#' where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 76