UPDATE #Request.prefix_db_agency#.Assessment_New SET Inpatient_Discharge_Date_NA_M0180 = '#form.Evaluation_Reason#', Intrac_Pain_M0430 = '#form.Other_Services#', Life_Exp_M0280 = '#form.OtherAgencies#', Meal_Prep_M0720 = '#form.PatientHstry1#', Meal_Prep_M0720 = '', Discharged_From_M0175 ='#form.Fee#', Discharged_From_M0175 = '', Medical_or_Treatment_Change_M0200 = '#form.groom#', Medical_or_Treatment_Change_M0200 = '', Therapies_Home_M0250 ='#form.Bath#', Therapies_Home_M0250 = '', Transferring_M0690 = '#form.Dress#', Transferring_M0690 = '', High_Risk_Factors_M0290 = '#form.LDress#', High_Risk_Factors_M0290 = '', Hearing_M0400 = '#form.Homemake#', Hearing_M0400 = '', Freq_of_Pain_M0420 = '#form.DME#', Freq_of_Pain_M0420 = '', Open_Wounds_M0440 = '#form.Toilet#', Open_Wounds_M0440 = '', Pressure_Ulcer_a_M0450 = '#form.Reach#', Pressure_Ulcer_a_M0450 = '', Pressure_Ulcer_b_M0450 = '#form.Mouth#', Pressure_Ulcer_b_M0450 = '', Pressure_Ulcer_c_M0450 = '#form.Head#', Pressure_Ulcer_c_M0450 = '', Pressure_Ulcer_d_M0450 = '#form.Back#', Pressure_Ulcer_d_M0450 = '', Pressure_Ulcer_e_M0450 = '#form.Side#', Pressure_Ulcer_e_M0450 = '', Pressure_Ulcer_Stage_M0460 = '#form.Coordination#', Pressure_Ulcer_Stage_M0460 = '', Pressure_Ulcer_Status_M0464 = '#form.Grasp#', Pressure_Ulcer_Status_M0464 = '', Stasis_Ulcer_Num_M0470 = '#form.UPPER_Reach#', Stasis_Ulcer_Num_M0470 = '', Stasis_Ulcer_Hidden_M0474 = '#form.UPPER_Mouth#', Stasis_Ulcer_Hidden_M0474 = '', Stasis_Ulcer_Status_M0476 = '#form.UPPER_Head#', Stasis_Ulcer_Status_M0476 = '', Surgical_Wound_M0482 = '#form.UPPER_Back#', Surgical_Wound_M0482 = '', Surgical_Wound_OB_M0484 = '#form.UPPER_lap#', Surgical_Wound_OB_M0484 = '', Transport_M0730 = '#form.UPPER_Coordination#', Transport_M0730 = '', Transport_M0730p = '#form.UPPER_Grasp#', Transport_M0730p = '', Urinary_INcont_when_M0530 = '#form.DOMINANCE#', Urinary_INcont_when_M0530 = '', When_Anxious_M0580 = '#form.Apraxia#', When_Anxious_M0580 = '', Patient_Behav_freq_M0620 = '#form.Discrimination#', Patient_Behav_freq_M0620 = '', Psy_Nursing_M0630 = '#form.Visual#', Psy_Nursing_M0630 = '', Grooming_M0640p = '#form.Tracking#', Grooming_M0640p = '', Dress_Lower_M0660 = '#form.Orientation#', Dress_Lower_M0660 = '', Caregiver_Manage_Equip_M0820 = '#form.Skills#', Caregiver_Manage_Equip_M0820 = '', Dress_Upper_M0650p = '#form.Awareness#', Dress_Upper_M0650p = '', Dress_Upper_M0650 = '#form.Sharp#', Dress_Upper_M0650 = '', Conditions_Prior_M0220 = '#form.Stereognosis#', Conditions_Prior_M0220 = '', Depressive_Feelings_M0590 = '#form.Sense#', Depressive_Feelings_M0590 = '', Assessment_note = '#form.txtComment#', Assessment_note = '', Ambulation_M0700 = '#form.painlevel#', Ambulation_M0700 = '', Ambulation_M0700p = '#form.chkthrobbing#', Ambulation_M0700p = '', Eating_M0710 = '#form.radthreshold#', Eating_M0710 = '', Oral_Meds_M0780p = '#form.ENVIRONMENT#', Oral_Meds_M0780p = '', Inhalant_Meds_M0790 = '#form.Issues#', Inhalant_Meds_M0790 = '', Laundry_M0740 = '#form.Prosthetics#', Laundry_M0740 = '', Laundry_M0740p = '#form.ProstheticsComment#', Laundry_M0740p = '', Rehab_Prognosis_M0270 = '#form.Potential#' Rehab_Prognosis_M0270 = '' 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#