UPDATE #Request.prefix_db_agency#.Assessment_New SET Rehab_Prognosis_M0270 = '#form.Rehab_Prognosis_M0270#', Rehab_Prognosis_M0270 = '', Inpatient_Facility_M0855 = '#form.Inpatient_Facility_M0855#', Inpatient_Facility_M0855 = '', M0250_Assess = '#form.Nutrition#', M0250_Assess = '', Therapies_Home_M0250 = '#form.NutriTherap#', Therapies_Home_M0250 = '', Endocrine_Assess = '#form.Endocrine#', Endocrine_Assess = '', M0440_Assess = '#form.Skin#', M0440_Assess = '', M0490_Assess = '#form.Cardio#', M0490_Assess = '', M0520_Assess = '#form.Geni#', M0520_Assess = '', M0540_Assess = '#form.Gastro#', M0540_Assess = '', M0550_Assess = '#form.Ostomy#', M0550_Assess = '', M0610_Assess = '#form.Neuro#', M0610_Assess = '', Meal_Prep_M0720 = '#form.Musculo#', Meal_Prep_M0720 = '', Home_Safety_Assess = '#form.Home#', Home_Safety_Assess = '', M0810_Assess = '#form.HomeHealth#', M0810_Assess = '', Assessment_note = '#form.txtComment#', Assessment_note = '', Urinary_INcont_when_M0530 = '#form.Urinary_INcont_when_M0530#', Urinary_INcont_when_M0530 = '', Urinary_INcont_M0520 = '#form.Urinary_INcont_M0520#', Urinary_INcont_M0520 = '', Bowel_Incont_M0540 = '#form.Bowel_Incont_M0540#', Bowel_Incont_M0540 = '', Ostomy_for_Bowel_M0550 = '#form.Ostomy_for_Bowel_M0550#', Ostomy_for_Bowel_M0550 = '', Cog_Function_M0560 = '#form.Cog_Function_M0560#', Cog_Function_M0560 = '', When_Confused_M0570 = '#form.When_Confused_M0570#', When_Confused_M0570 = '', When_Anxious_M0580 = '#form.When_Anxious_M0580#', When_Anxious_M0580 = '', Depressive_Feelings_M0590 = '#form.Depressive_Feelings_M0590#', Depressive_Feelings_M0590 = '', Patient_Behav_Weekly_M0610 = '#form.Patient_Behav_Weekly_M0610#', Patient_Behav_Weekly_M0610 = '', Patient_Behav_freq_M0620 = '#form.Patient_Behav_freq_M0620#', Patient_Behav_freq_M0620 = '', Psy_Nursing_M0630 = '#form.Psy_Nursing_M0630#', Psy_Nursing_M0630 = '', Grooming_M0640 = '#form.Grooming_M0640#', Grooming_M0640 = '', Grooming_M0640p = '#form.spech#', Grooming_M0640p = '', Dress_Upper_M0650 = '#form.incoh#', Dress_Upper_M0650 = '', Dress_Upper_M0650p = '#form.increase#', Dress_Upper_M0650p = '', Dress_Lower_M0660 = '#form.mute#', Dress_Lower_M0660 = '', Dress_Lower_M0660p = '#form.pressure#', Dress_Lower_M0660p = '', Bathing_M0670 = '#form.rapid#', Bathing_M0670 = '', Bathing_M0670p = '#form.silent#', Bathing_M0670p = '', Toileting_M0680 = '#form.slowed#', Toileting_M0680 = '', Toileting_M0680p = '#form.slur#', Toileting_M0680p = '', Transferring_M0690 = '#form.stammer#', Transferring_M0690 = '', Transferring_M0690p = '#form.Transferring_M0690p#', Transferring_M0690p = '', Ambulation_M0700 = '#form.sexu#', Ambulation_M0700 = '', Ambulation_M0700p = '#form.sexua#', Ambulation_M0700p = '', Eating_M0710 = '#form.phys#', Eating_M0710 = '', Eating_M0710p = '#form.hist#', Eating_M0710p = '', Meal_Prep_M0720p = '#form.histo#', Meal_Prep_M0720p = '', Transport_M0730 = '#form.Transport_M0730#', Transport_M0730 = '', Transport_M0730p = '#form.current#', Transport_M0730p = '', Laundry_M0740 = '#form.famil#', Laundry_M0740 = '', Laundry_M0740p = '#form.accid#', Laundry_M0740p = '', Housekeeping_M0750 = '#form.etoh#', Housekeeping_M0750 = '', Housekeeping_M0750p = '#form.past#', Housekeeping_M0750p = '', Shopping_M0760 = '#form.recent#', Shopping_M0760 = '', Shopping_M0760p = '#form.rumin#', Shopping_M0760p = '', Use_Phone_M0770 = '#form.self#', Use_Phone_M0770 = '', Use_Phone_M0770p = '#form.star#', Use_Phone_M0770p = '', Oral_Meds_M0780 = '#form.suici#', Oral_Meds_M0780 = '', Oral_Meds_M0780p = '#form.Oral_Meds_M0780p#', Oral_Meds_M0780p = '', Inhalant_Meds_M0790 = '#form.eto#', Inhalant_Meds_M0790 = '', Inhalant_Meds_M0790p = '#form.barbi#', Inhalant_Meds_M0790p = '', Inject_Meds_M0800 = '#form.caff#', Inject_Meds_M0800 = '', Inject_Meds_m0800p = '#form.drug#', Inject_Meds_m0800p = '', Patient_Manage_Equip_M0810 = '#form.food#', Patient_Manage_Equip_M0810 = '', Caregiver_Manage_Equip_M0820 = '#form.tobac#', Caregiver_Manage_Equip_M0820 = '', Therapy_Need_M0825 = '#form.tranq#', Therapy_Need_M0825 = '', Emergent_Care_M0830 = '#form.Emergent_Care_M0830#' Emergent_Care_M0830 = '' WHERE Assessment_ID= #form.txtAssId# update #Request.prefix_db_agency#.Assessment_New set HHRG_175_Score="",HHRG_230_Score="",HHRG_250_Score="",HHRG_390_Score="",HHRG_420_Score="",HHRG_440_Score="" where assessment_id=#session.cs.AssessmentId# UPDATE #Request.prefix_db_agency#.Diagnosis SET Dx_Order = '#Order#' WHERE Diagnosis.Assessment_ID=#session.cs.AssessmentId# and Diagnosis_ID=#UpdateID# select ICD from #Request.prefix_db_agency#.Diagnosis where assessment_id=#session.cs.AssessmentId# and Dx_Order = '#Order#' update #Request.prefix_db_agency#.Assessment_New set HHRG_175_Score ='#geticd.ICD#' where assessment_id=#session.cs.AssessmentId# update #Request.prefix_db_agency#.Assessment_New set HHRG_230_Score ='#geticd.ICD#' where assessment_id=#session.cs.AssessmentId# update #Request.prefix_db_agency#.Assessment_New set HHRG_250_Score ='#geticd.ICD#' where assessment_id=#session.cs.AssessmentId# update #Request.prefix_db_agency#.Assessment_New set HHRG_390_Score ='#geticd.ICD#' where assessment_id=#session.cs.AssessmentId# update #Request.prefix_db_agency#.Assessment_New set HHRG_420_Score ='#geticd.ICD#' where assessment_id=#session.cs.AssessmentId# update #Request.prefix_db_agency#.Assessment_New set HHRG_440_Score ='#geticd.ICD#' where assessment_id=#session.cs.AssessmentId#