UPDATE #Request.prefix_db_agency#.Assessment_New SET After_Discharge_Services_M0880 = '#form.Reason#', After_Discharge_Services_M0880 = '', Ambulation_M0700 = '#form.Other_Services#', Ambulation_M0700 = '', Ambulation_M0700p = '#form.OtherAgencies#', Ambulation_M0700p = '', Bowel_Incont_M0540 = '#form.txtBowel_Incont_M0540#', Bowel_Incont_M0540 = '', Therapies_Home_M0250 = '#form.Fee#', Therapies_Home_M0250 = null, Psy_Nursing_M0630 = '#form.painlevel#', Psy_Nursing_M0630 = null, Grooming_M0640 = '#form.chkthrobbing#', Grooming_M0640 = null, Grooming_M0640p = '#form.radthreshold#', Grooming_M0640p = null, Dress_Upper_M0650 = '#form.currentpain#', Dress_Upper_M0650 = null, Dress_Upper_M0650p = '#form.doeseach#', Dress_Upper_M0650p = null, Hearing_M0400 = '#form.groom#', Hearing_M0400 = null, Speech_M0410 = '#form.Bath#', Speech_M0410 = null, Freq_of_Pain_M0420 = '#form.Dress#', Freq_of_Pain_M0420 = null, Intrac_Pain_M0430 = '#form.LDress#', Intrac_Pain_M0430 = null, Pressure_Ulcer_M0445 = '#form.Homemake#', Pressure_Ulcer_M0445 = null, Open_Wounds_M0440 = '#form.DME#', Open_Wounds_M0440 = null, Overall_Prognosis_M0260 = '#form.Reach#', Overall_Prognosis_M0260 = null, Transferring_M0690p = '#form.Mouth#', Transferring_M0690p = null, Life_Exp_M0280 = '#form.Head#', Life_Exp_M0280 = null, High_Risk_Factors_M0290 = '#form.Back#', High_Risk_Factors_M0290 = null, Vision_M0390 = '#form.long_Back#', Vision_M0390 = null, Pressure_Ulcer_a_M0450 = '#form.Side#', Pressure_Ulcer_a_M0450 = null, Pressure_Ulcer_b_M0450 = '#form.Coordination#', Pressure_Ulcer_b_M0450 = null, Pressure_Ulcer_e_M0450 = '#form.Grasp#', Pressure_Ulcer_e_M0450 = null, Pressure_Ulcer_Stage_M0460 = '#form.Gait#', Pressure_Ulcer_Stage_M0460 = null, Pressure_Ulcer_c_M0450 = '#form.Berg_Score#', Pressure_Ulcer_c_M0450 = null, Pressure_Ulcer_d_M0450 = '#form.Tinetti_Score#', Pressure_Ulcer_d_M0450 = null, Inject_Meds_m0800p = '#form.TUG_Test#', Inject_Meds_m0800p = null, Pressure_Ulcer_Status_M0464 = '#form.UPPER_Reach#', Pressure_Ulcer_Status_M0464 = null, Breathing_M0490 = '#form.UPPER_Mouth#', Breathing_M0490 = null, Stasis_Ulcer_Num_M0470 = '#form.UPPER_Head#', Stasis_Ulcer_Num_M0470 = null, Stasis_Ulcer_Hidden_M0474 = '#form.Respiratory#', Stasis_Ulcer_Hidden_M0474 = null, Stasis_Ulcer_Status_M0476 = '#form.Right_Lower#', Stasis_Ulcer_Status_M0476 = null, Surgical_Wound_M0482 = '#form.Right_Hand#', Surgical_Wound_M0482 = null, Caregiver_Manage_Equip_M0820 = '#form.Impaired1#', Caregiver_Manage_Equip_M0820 = null, Cog_Function_M0560 = '#form.Impaired2#', Cog_Function_M0560 = null, Conditions_Prior_M0220 = '#form.Impaired3#', Conditions_Prior_M0220 = null, Depressive_Feelings_M0590 = '#form.Impaired4#', Depressive_Feelings_M0590 = null, Discharge_Disposition_M0870 = '#form.Impaired5#', Discharge_Disposition_M0870 = null, Eating_M0710 = '#form.Impaired6#', Eating_M0710 = null, Eating_M0710p = '#form.Impaired7#', Eating_M0710p = null, Emergent_Care_M0830 = '#form.Impaired8#', Emergent_Care_M0830 = null, Emergent_Care_Reason_M0840 = '#form.Impaired9#', Emergent_Care_Reason_M0840 = null, Endocrine_Assess = '#form.Impaired10#', Endocrine_Assess = null, Home_Safety_Assess = '#form.Impaired11#', Home_Safety_Assess = null, Hospice_Assess = '#form.Impaired12#', Hospice_Assess = null, Hospital_Reason_List_M0895 = '#form.Impaired13#', Hospital_Reason_List_M0895 = null, Hospital_Reason_M0890 = '#form.Impaired14#', Hospital_Reason_M0890 = null, Housekeeping_M0750 = '#form.Impaired15#', Housekeeping_M0750 = null, Housekeeping_M0750p = '#form.Impaired16#', Housekeeping_M0750p = null, Inhalant_Meds_M0790 = '#form.Shoulder1#', Inhalant_Meds_M0790 = null, Inhalant_Meds_M0790p = '#form.Shoulder2#', Inhalant_Meds_M0790p = null, Inject_Meds_M0800 = '#form.Shoulder3#', Inject_Meds_M0800 = null, Inpatient_Facility_M0855 = '#form.Shoulder4#', Inpatient_Facility_M0855 = null, Laundry_M0740 = '#form.Shoulder5#', Laundry_M0740 = null, Laundry_M0740p = '#form.Shoulder6#', Laundry_M0740p = null, M0250_Assess = '#form.Shoulder7#', M0250_Assess = null, M0420_Assess = '#form.Shoulder8#', M0420_Assess = null, M0440_Assess = '#form.Hip1#', M0440_Assess = null, M0490_Assess = '#form.Hip2#', M0490_Assess = null, M0520_Assess = '#form.Hip3#', M0520_Assess = null, M0540_Assess = '#form.Hip4#', M0540_Assess = null, M0550_Assess = '#form.Hip5#', M0550_Assess = null, M0610_Assess = '#form.Hip6#', M0610_Assess = null, M0650_Assess = '#form.Hip7#', M0650_Assess = null, M0810_Assess = '#form.Hip8#', M0810_Assess = null, Meal_Prep_M0720 = '#form.Hip9#', Meal_Prep_M0720 = null, Meal_Prep_M0720p = '#form.Hip10#', Meal_Prep_M0720p = null, Medical_or_Treatment_Change_M0200 = '#form.Hip11#', Medical_or_Treatment_Change_M0200 = null, Nursing_Home_M0900 = '#form.Hip12#', Nursing_Home_M0900 = null, Oral_Meds_M0780 = '#form.Hip13#', Oral_Meds_M0780 = null, Oral_Meds_M0780p = '#form.Hip14#', Oral_Meds_M0780p = null, Ostomy_for_Bowel_M0550 = '#form.Hip15#', Ostomy_for_Bowel_M0550 = null, Patient_Behav_freq_M0620 = '#form.Hip16#', Patient_Behav_freq_M0620 = null, Patient_Behav_Weekly_M0610 = '#form.Knee1#', Patient_Behav_Weekly_M0610 = null, Patient_Manage_Equip_M0810 = '#form.Knee2#', Patient_Manage_Equip_M0810 = null, Resp_Treatments_M0500 = '#form.Knee3#', Resp_Treatments_M0500 = null, Shopping_M0760 = '#form.Knee4#', Shopping_M0760 = null, Shopping_M0760p = '#form.Knee5#', Shopping_M0760p = null, Stasis_Ulcer_M0468 = '#form.Knee6#', Stasis_Ulcer_M0468 = null, Surgical_Wound_Hidden_M0486 = '#form.Knee7#', Surgical_Wound_Hidden_M0486 = null, Surgical_Wound_OB_M0484 = '#form.Knee8#', Surgical_Wound_OB_M0484 = null, Surgical_Wound_Status_M0488 = '#form.Ankle1#', Surgical_Wound_Status_M0488 = null, Therapy_Need_M0825 = '#form.Ankle2#', Therapy_Need_M0825 = null, Toileting_M0680p = '#form.Ankle3#', Toileting_M0680p = null, Transferring_M0690 = '#form.Ankle4#', Transferring_M0690 = null, Transport_M0730 = '#form.Ankle5#', Transport_M0730 = null, Transport_M0730p = '#form.Ankle6#', Transport_M0730p = null, Urinary_INcont_M0520 = '#form.Ankle7#', Urinary_INcont_M0520 = null, Urinary_INcont_when_M0530 = '#form.Ankle8#', Urinary_INcont_when_M0530 = null, Use_Phone_M0770 = '#form.Cervical_Spine1#', Use_Phone_M0770 = null, Use_Phone_M0770p = '#form.Cervical_Spine2#', Use_Phone_M0770p = null, UTI_M0510 = '#form.Cervical_Spine3#', UTI_M0510 = null, When_Anxious_M0580 = '#form.Cervical_Spine4#', When_Anxious_M0580 = null, Dress_Lower_M0660p = '#form.Shortness_Breath#', Dress_Lower_M0660p = null, Bathing_M0670 = '#form.txtBathing_M0670#', Bathing_M0670 = null, When_Confused_M0570 = '#form.txtWhen_Confused_M0570#', When_Confused_M0570 = null, Discharged_From_M0175 = '#form.txtDischarged_From_M0175#', Discharged_From_M0175 = null, Bathing_M0670p = '#form.txtBathing_M0670p#', Bathing_M0670p = null, Toileting_M0680 = '#form.needs#', Toileting_M0680 = null, Rehab_Prognosis_M0270 = '#form.Potential#', Rehab_Prognosis_M0270 = '#form.Potential1#', Rehab_Prognosis_M0270 = null, Assessment_note = '#FORM.Assessmentnote#' Assessment_note = null 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#