UPDATE #Request.prefix_db_agency#.Assessment_New SET After_Discharge_Services_M0880 = '#form.Evaluation_Reason#', M0650_Assess = '#form.Other_Services#', M0810_Assess = '#form.OtherAgencies#', Grooming_M0640 = '#form.PatientHstry1#', Grooming_M0640 = null, Ambulation_M0700 = '#form.painlevel#', Ambulation_M0700 = null, Ambulation_M0700p = '#form.chkthrobbing#', Ambulation_M0700p = null, Eating_M0710 = '#form.radthreshold#', Eating_M0710 = null, Bathing_M0670 = '#form.Prior_level#', Bathing_M0670p = '#form.Precautions#', Discharged_From_M0175 = '#form.Fee#', Medical_or_Treatment_Change_M0200 = '#form.groom#', Therapies_Home_M0250 = '#form.Bath#', Transferring_M0690 = '#form.Dress#', High_Risk_Factors_M0290 = '#form.LDress#', Hearing_M0400 = '#form.Homemake#', Freq_of_Pain_M0420 = '#form.DME#', Open_Wounds_M0440 = '#form.Toilet#', Meal_Prep_M0720p = '#form.Functional#', Bowel_Incont_M0540 = '#form.VERBAL_Feed#', Conditions_Prior_M0220 = '#form.VERBAL_Grooming#', Overall_Prognosis_M0260 = '#form.VERBAL_Bathing#', Life_Exp_M0280 = '#form.VERBAL_Dressing#', Vision_M0390 = '#form.VERBALL_Dressing#', Speech_M0410 = '#form.VERBAL_Homemaking#', Intrac_Pain_M0430 = '#form.VERBAL_DME#', Pressure_Ulcer_M0445 = '#form.VERBAL_Toileting#', Breathing_M0490 = '#form.VERBAL_Functional#', Pressure_Ulcer_a_M0450 = '#form.Reach#', Pressure_Ulcer_b_M0450 = '#form.Mouth#', Pressure_Ulcer_c_M0450 = '#form.Head#', Pressure_Ulcer_d_M0450 = '#form.Back#', Pressure_Ulcer_e_M0450 = '#form.Side#', Pressure_Ulcer_Stage_M0460 = '#form.Coordination#', Pressure_Ulcer_Status_M0464 = '#form.Grasp#', Stasis_Ulcer_Num_M0470 = '#form.UPPER_Reach#', Stasis_Ulcer_Hidden_M0474 = '#form.UPPER_Mouth#', Stasis_Ulcer_Status_M0476 = '#form.UPPER_Head#', Surgical_Wound_M0482 = '#form.UPPER_Back#', Surgical_Wound_OB_M0484 = '#form.UPPER_lap#', Transport_M0730 = '#form.UPPER_Coordination#', Transport_M0730p = '#form.UPPER_Grasp#', Urinary_INcont_when_M0530 = '#form.DOMINANCE#', When_Anxious_M0580 = '#form.Apraxia#', Patient_Behav_freq_M0620 = '#form.Discrimination#', Psy_Nursing_M0630 = '#form.Visual#', Grooming_M0640p = '#form.Tracking#', Dress_Lower_M0660 = '#form.Orientation#', Caregiver_Manage_Equip_M0820 = '#form.Skills#', Dress_Upper_M0650p = '#form.Awareness#', Cog_Function_M0560 = '#form.Problem#', Depressive_Feelings_M0590 = '#form.Medication#', Discharge_Disposition_M0870 = '#form.Financial#', Dress_Lower_M0660p = '#form.Sharp#', Dress_Upper_M0650 = '#form.Stereognosis#', Eating_M0710p = '#form.Sense#', Emergent_Care_M0830 = '#form.Location#', Emergent_Care_M0830 = null, Housekeeping_M0750p = '#form.Tissue#', Inhalant_Meds_M0790 = '#form.Girth#', Inhalant_Meds_M0790p = '#form.History#', Inject_Meds_M0800 = '#form.wounds#', Nursing_Home_M0900 = '#form.Shortness#', Oral_Meds_M0780p = '#form.ENVIRONMENT#', Oral_Meds_M0780p = null, Inpatient_Facility_M0855 = '#form.Issues#', Inpatient_Facility_M0855 = null, Laundry_M0740 = '#form.Prosthetics#', Laundry_M0740 = null, Laundry_M0740p = '#form.ProstheticsComment#', Rehab_Prognosis_M0270 = '#form.Potential#' Rehab_Prognosis_M0270 = 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#