UPDATE #Request.prefix_db_agency#.Assessment_New SET Laundry_M0740p = '#form.Reason#', Laundry_M0740p = '', M0063_Pattern = '#form.Other_Services#', M0063_Pattern = '', M0065_Pattern = '#form.OtherAgencies#', M0065_Pattern = '', Conditions_Prior_M0220 = '#form.PatientHstry1#', Conditions_Prior_M0220 = '', Therapies_Home_M0250 = '#form.Fee#', Therapies_Home_M0250 = '#form.Fee1#', Hearing_M0400 = null, Hearing_M0400 = '#form.groom#', Hearing_M0400 = '#form.groom1#', Hearing_M0400 = null, Speech_M0410 = '#form.Bath#', Speech_M0410 = '#form.Bath1#', Speech_M0410 = null, Freq_of_Pain_M0420 = '#form.Dress#', Freq_of_Pain_M0420 = '#form.Dress1#', Freq_of_Pain_M0420 = null, Intrac_Pain_M0430 = '#form.LDress#', Intrac_Pain_M0430 = '#form.LDress1#', Intrac_Pain_M0430 = null, Pressure_Ulcer_M0445 = '#form.Homemake#', Pressure_Ulcer_M0445 = '#form.Homemake1#', Pressure_Ulcer_M0445 = 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, M0420_Assess = '#form.txtpain#', M0420_Assess = null, Open_Wounds_M0440 = '#form.DME#', Open_Wounds_M0440 = '#form.DME1#', Open_Wounds_M0440 = null, Ambulation_M0700 = '#form.txtComment3#', Ambulation_M0700 = '', Overall_Prognosis_M0260 = '#form.Reach#', Overall_Prognosis_M0260 = '#form.Reach1#', Overall_Prognosis_M0260 = null, Depressive_Feelings_M0590 = '#form.Mouth#', Depressive_Feelings_M0590 = '#form.Mouth1#', Depressive_Feelings_M0590 = '', Life_Exp_M0280 = '#form.Head#', Life_Exp_M0280 = '#form.Head1#', Life_Exp_M0280 = '', High_Risk_Factors_M0290 = '#form.Back#', High_Risk_Factors_M0290 = '#form.Back1#', High_Risk_Factors_M0290 = '', Vision_M0390 = '#form.long_Back#', Vision_M0390 = '#form.long_Back1#', Vision_M0390 = '', Ambulation_M0700p = '#form.txtComment4#', Ambulation_M0700p = '', Pressure_Ulcer_a_M0450 = '#form.Side#', Pressure_Ulcer_a_M0450 = '#form.Side1#', Pressure_Ulcer_a_M0450 = '', Pressure_Ulcer_b_M0450 = '#form.Coordination#', Pressure_Ulcer_b_M0450 = '#form.Coordination1#', Pressure_Ulcer_b_M0450 = '', Pressure_Ulcer_e_M0450 = '#form.Grasp#', Pressure_Ulcer_e_M0450 = '#form.Grasp1#', Pressure_Ulcer_e_M0450 = '', Pressure_Ulcer_Stage_M0460 = '#form.Gait#', Pressure_Ulcer_Stage_M0460 = '#form.Gait1#', Pressure_Ulcer_Stage_M0460 = '', Pressure_Ulcer_c_M0450 = '#form.txtComment5#', Pressure_Ulcer_c_M0450 = '', Pressure_Ulcer_d_M0450 = '#form.Berg_Score#', Pressure_Ulcer_d_M0450 = null, HHRG_825_Score = '#form.Tinetti_Score#', HHRG_825_Score = null, Dress_Lower_M0660 = '#form.TUG_Test#', Dress_Lower_M0660 = null, Pressure_Ulcer_Status_M0464 = '#form.UPPER_Reach#', Pressure_Ulcer_Status_M0464 = '', Dress_Lower_M0660p = '#form.UPPER_Mouth#', Dress_Lower_M0660p = '', Stasis_Ulcer_Hidden_M0474 = '#form.UPPER_Head#', Stasis_Ulcer_Hidden_M0474 = '', Stasis_Ulcer_Status_M0476 = '#form.Respiratory#', Stasis_Ulcer_Status_M0476 = '', Surgical_Wound_M0482 = '#form.Right_Lower#', Surgical_Wound_M0482 = '', Use_Phone_M0770 = '#form.Right_Hand#', Use_Phone_M0770 = '', Inpatient_Discharge_Date_NA_M0180 = '#form.txtComment6#', Inpatient_Discharge_Date_NA_M0180 = '', Medical_or_Treatment_Change_M0200 = '#form.Impaired1#', Medical_or_Treatment_Change_M0200 = '', Ostomy_for_Bowel_M0550 = '#form.Impaired2#', Ostomy_for_Bowel_M0550 = '', Patient_Behav_freq_M0620 = '#form.Impaired3#', Patient_Behav_freq_M0620 = '', Stasis_Ulcer_M0468 = '#form.Impaired4#', Stasis_Ulcer_M0468 = '', Surgical_Wound_Hidden_M0486 = '#form.Impaired5#', Surgical_Wound_Hidden_M0486 = '', Toileting_M0680p = '#form.Impaired6#', Toileting_M0680p = '', Transferring_M0690p = '#form.Impaired7#', Transferring_M0690p = '', Urinary_INcont_when_M0530 = '#form.Impaired8#', Urinary_INcont_when_M0530 = null, UTI_M0510 = '#form.Impaired9#', UTI_M0510 = null, When_Confused_M0570 = '#form.Impaired10#', When_Confused_M0570 = null, Assessment_Unlock_Reason = '#form.Impaired11#', Assessment_Unlock_Reason = null, Bowel_Incont_M0540 = '#form.Impaired12#', Bowel_Incont_M0540 = null, Clinical_Severity_Invalid = '#form.Impaired13#', Clinical_Severity_Invalid = null, Clinical_Severity_Level = '#form.Impaired14#', Clinical_Severity_Level = '', Clinical_Severity_Score = '#form.Impaired15#', Clinical_Severity_Score = null, Cog_Function_M0560 = '#form.Impaired16#', Cog_Function_M0560 = null, Correction_Number = '#form.Shoulder1#', Correction_Number = null, Discharge_Disposition_M0870 = '#form.Shoulder2#', Discharge_Disposition_M0870 = null, downloadlock = '#form.Shoulder3#', downloadlock = null, Eating_M0710 = '#form.Shoulder4#', Eating_M0710 = null, Eating_M0710p = '#form.Shoulder5#', Eating_M0710p = null, Emergent_Care_M0830 = '#form.Shoulder6#', Emergent_Care_M0830 = null, Emergent_Care_Reason_M0840 = '#form.Shoulder7#', Emergent_Care_Reason_M0840 = null, Endocrine_Assess = '#form.Shoulder8#', Endocrine_Assess = null, Functional_Status_Invalid = '#form.Hip1#', Functional_Status_Invalid = null, Functional_Status_Level = '#form.Hip2#', Functional_Status_Level = null, Functional_Status_Score = '#form.Hip3#', Functional_Status_Score = null, Braden_1_Sensory = '#form.Hip4#', Braden_1_Sensory = null, Braden_2_Moisture = '#form.Hip5#', Braden_2_Moisture = null, Braden_3_Activity = '#form.Hip6#', Braden_3_Activity = null, Braden_4_Mobility = '#form.Hip7#', Braden_4_Mobility = null, Braden_5_Nutrition = '#form.Hip8#', Braden_5_Nutrition = null, Braden_6_Friction = '#form.Hip9#', Braden_6_Friction = null, HHRG_450_Score = '#form.Hip10#', HHRG_450_Score = null, HHRG_460_Score = '#form.Hip11#', HHRG_460_Score = null, HHRG_476_Score = '#form.Hip12#', HHRG_476_Score = null, HHRG_488_Score = '#form.Hip13#', HHRG_488_Score = null, HHRG_490_Score = '#form.Hip14#', HHRG_490_Score = null, HHRG_530_Score = '#form.Hip15#', HHRG_530_Score = null, HHRG_540_Score = '#form.Hip16#', HHRG_540_Score = null, HHRG_550_Score = '#form.Knee1#', HHRG_550_Score = null, HHRG_610_Score = '#form.Knee2#', HHRG_610_Score = null, HHRG_650_Score = '#form.Knee3#', HHRG_650_Score = null, HHRG_670_Score = '#form.Knee4#', HHRG_670_Score = null, HHRG_680_Score = '#form.Knee5#', HHRG_680_Score = null, HHRG_690_Score = '#form.Knee6#', HHRG_690_Score = null, HHRG_700_Score = '#form.Knee7#', HHRG_700_Score = null, Home_Safety_Assess = '#form.Knee8#', Home_Safety_Assess = null, Homebound_Status = '#form.Ankle1#', Homebound_Status = null, Hospice_Assess = '#form.Ankle2#', Hospice_Assess = null, Hospital_Reason_List_M0895 = '#form.Ankle3#', Hospital_Reason_List_M0895 = null, Hospital_Reason_M0890 = '#form.Ankle4#', Hospital_Reason_M0890 = null, Housekeeping_M0750 = '#form.Ankle5#', Housekeeping_M0750 = null, Housekeeping_M0750p = '#form.Ankle6#', Housekeeping_M0750p = null, Inhalant_Meds_M0790 = '#form.Ankle7#', Inhalant_Meds_M0790 = null, Inhalant_Meds_M0790p = '#form.Ankle8#', Inhalant_Meds_M0790p = null, Inject_Meds_M0800 = '#form.Cervical_Spine1#', Inject_Meds_M0800 = null, Inject_Meds_m0800p = '#form.Cervical_Spine2#', Inject_Meds_m0800p = null, Inpatient_Facility_M0855 = '#form.Cervical_Spine3#', Inpatient_Facility_M0855 = null, Laundry_M0740 = '#form.Cervical_Spine4#', Laundry_M0740 = null, M0250_Assess = '#form.txtComment7#', M0250_Assess = null, Breathing_M0490 = '#form.Shortness_Breath#', Breathing_M0490 = null, Transport_M0730p = '#form.Joints#', Transport_M0730p = null, Transport_M0730 = '#form.Accessibility#', Transport_M0730 = null, Discharged_From_M0175 = '#form.Safety_Issuess#', Discharged_From_M0175 = null, M0440_Assess = '#form.txtComment8#', M0440_Assess = null, Bathing_M0670p = '#form.Prosthetics#', 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.Assesmentnode#' 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#