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 a.HIPPS_Code,a.Certification_Start,DATE_ADD(a.Certification_Start, INTERVAL 30 DAY) as Certification_End,a.Assessment_Reason_M0100 from #Request.prefix_db_agency#.Assessment_New a where a.Assessment_ID = #url.AID# and a.Patient_ID = #url.ID# 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,Field_9,GG_2,Created_Date) VALUES (#url.AID#,#url.ID#,76,'#HIPPS20201#','#HIPPS20202#','#DateFormat(Now(),"yyyy-mm-dd")#')
' & '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, c.Risk_Type = u.LUPA where c.Assessment_ID = #url.AID# and c.Patient_ID = #url.ID# and u.HIPPS_Code = '#HIPPS20201#' and u.rank = '#rank_2020#' Update #Request.prefix_db_agency#.Coding_Scrub c, #Request.prefix_db_lookup#.CW_Utilization_2020 u set c.Subject = u.Visits_SN, c.Desired = u.Visits_Therapy, c.Short = u.Visits_HHA, c.Field_1 = u.Total_Reimburse, c.Risk = u.LUPA where c.Assessment_ID = #url.AID# and c.Patient_ID = #url.ID# and u.HIPPS_Code = '#HIPPS20202#' 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, Risk_Type from #Request.prefix_db_agency#.Coding_Scrub where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 76 Select IFNULL(Subject,0) as Subject,IFNULL(Desired,0) as Desired,IFNULL(Short,0) as Short , IFNULL(Field_1,0) as Field_1, Risk from #Request.prefix_db_agency#.Coding_Scrub where Assessment_ID = #url.AID# and Patient_ID = #url.ID# and Message_ID = 76 #Get_HIPPS.Assessment_Reason_M0100# dai '#Summary#','


','2020 PDGM HIPPS code 1st 30 days > ','#HIPPS20201#','            2nd 30-day > ', '#HIPPS20202#', '

1st 30-Day Episode Reimbursement > ','#LSEuroCurrencyFormat(Get_PD.Field_6, "local")#','            2nd 30-day > ','#LSEuroCurrencyFormat(Get_PDQ.Field_1, "local")#', '

1st 30-Day Total Cost > ','#LSEuroCurrencyFormat(All_2020, "local")#','            2nd 30-Day > ','#LSEuroCurrencyFormat(All_20201, "local")#', '

1st 30-Day Net Profit > ','#LSEuroCurrencyFormat(All_2020_Profit, "local")#','            2nd 30-Day > ','#LSEuroCurrencyFormat(All_20201_Profit, "local")#', '


VISITS FOR 1ST 30-DAYS','            LUPA > ','#Get_PD.Risk_Type#','            #DateFormat(Get_HIPPS.Certification_start,"mm/dd/yyyy")# - #DateFormat(Get_HIPPS.Certification_End,"mm/dd/yyyy")# ' '

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

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")#', '


VISITS FOR 2ND 30-DAYS','  (2nd 30-days warranted when there are physician-order changes after the 1st week)     LUPA > ','#Get_PDQ.Risk#', '

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

PT ', '#NumberFormat(PT_Visits_20201, "_")#',' visits | OT ','#NumberFormat(OT_Visits_20201, "_")#',' visits | Cost > ','#LSEuroCurrencyFormat(Th_20201, "local")#','                #DateFormat(Get_HIPPS.Certification_start,"mm/dd/yyyy")# - #DateFormat(Get_HIPPS.Certification_End,"mm/dd/yyyy")# ' '

HHA ','#Get_PDQ.Short#',' visits | Cost > ','#LSEuroCurrencyFormat(HHA_20201, "local")#', '



THERAPY ANALYSIS', '

#Session.CS.Therapy_Analysis# ~' Update #Request.prefix_db_agency#.Coding_Scrub set Field_7 = concat('#Summary#','


','2020 PDGM HIPPS code 1st 30 days > ','#HIPPS20201#','            2nd 30-day > ', '#HIPPS20202#', '

1st 30-Day Episode Reimbursement > ','#LSEuroCurrencyFormat(Get_PD.Field_6, "local")#','            2nd 30-day > ','#LSEuroCurrencyFormat(Get_PDQ.Field_1, "local")#', '

1st 30-Day Total Cost > ','#LSEuroCurrencyFormat(All_2020, "local")#','            2nd 30-Day > ','#LSEuroCurrencyFormat(All_20201, "local")#', '

1st 30-Day Net Profit > ','#LSEuroCurrencyFormat(All_2020_Profit, "local")#','            2nd 30-Day > ','#LSEuroCurrencyFormat(All_20201_Profit, "local")#', '


VISITS FOR 1ST 30-DAYS','            LUPA > ','#Get_PD.Risk_Type#','            #DateFormat(Get_HIPPS.Certification_start,"mm/dd/yyyy")# - #DateFormat(Get_HIPPS.Certification_End,"mm/dd/yyyy")# ' '

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

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")#', '


VISITS FOR 2ND 30-DAYS','  (2nd 30-days warranted when there are physician-order changes after the 1st week)     LUPA > ','#Get_PDQ.Risk#', '

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

PT ', '#NumberFormat(PT_Visits_20201, "_")#',' visits | OT ','#NumberFormat(OT_Visits_20201, "_")#',' visits | Cost > ','#LSEuroCurrencyFormat(Th_20201, "local")#','                #DateFormat(Get_HIPPS.Certification_start,"mm/dd/yyyy")# - #DateFormat(Get_HIPPS.Certification_End,"mm/dd/yyyy")# ' '

HHA ','#Get_PDQ.Short#',' visits | Cost > ','#LSEuroCurrencyFormat(HHA_20201, "local")#', '



THERAPY ANALYSIS', '

#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 ' & 'clinician-entered | 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 Diagnoses, 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.' & '

' & 'FIRST 30 DAYS' & '

' & 'SN - ' & #Get_PD.Field_3# & ' visits' & '
' & 'OT - ' & '#NumberFormat(OT_Visits_2020, "_")#' & ' visits' & '
' & 'PT - ' & '#NumberFormat(PT_Visits_2020, "_")#' & ' visits' & '
' & 'HHA - ' & '#NumberFormat(Get_PD.Field_5, "_")#' & ' visits' & '

' & 'SECOND 30 DAYS' & '

' & 'A second 30-day episode is warranted if there changes to physician orders after the 1st week.' & '

' & 'SN - ' & #Get_PDQ.Subject# & ' visits' & '
' & 'OT - ' & '#NumberFormat(OT_Visits_20201, "_")#' & ' visits' & '
' & 'PT - ' & '#NumberFormat(PT_Visits_20201, "_")#' & ' visits' & '
' & 'HHA - ' & '#NumberFormat(Get_PDQ.Short, "_")#' & ' visits' & '

' & 'So that we can update the CMS485 with goals and interventions and upload the final reports, 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 Plans.' & '

' & 'Coding Wizard Team' & '



' & 'message3' & '

' & 'Visit Plan(s) and Patient Recall Sheet(s) 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