UPDATE #Request.prefix_db_agency#.Assessment_New SET Assessment_New.Start_of_Care_M0030=#CreateODBCDate(form.Start_of_Care_M0030_hid)#, Assessment_New.Discharged_From_M0175='#form.Discharged_From_M0175_hid#', Assessment_New.Inpatient_Discharge_Date_NA_M0180='#form.Inpatient_Discharge_Date_NA_M0180_hid#', Assessment_New.Medical_or_Treatment_Change_M0200='#form.Medical_or_Treatment_Change_M0200_hid#', Assessment_New.Conditions_Prior_M0220='#form.Conditions_Prior_M0220_hid#', Assessment_New.Therapies_Home_M0250='#form.Therapies_Home_M0250_hid#', Assessment_New.Surgical_ICD_485='#form.txtsurgical1#', Assessment_New.Surgical_ICD_485_Description='#form.txtsurgical#', Assessment_New.Surgical_ICD_Date_485=#CreateODBCDate(form.Surgical_ICD_Date_485_hid)#, Assessment_New.Overall_Prognosis_M0260='#form.bedmobility1#', Assessment_New.Transferring_M0690p='#form.bedmobility2#', Assessment_New.Life_Exp_M0280='#form.bedmobility3#', Assessment_New.High_Risk_Factors_M0290='#form.bedmobility4#', Assessment_New.Vision_M0390='#form.bedmobility5#', Assessment_New.Hearing_M0400='#form.transfers1#', Assessment_New.Speech_M0410='#form.transfers2#', Assessment_New.Freq_of_Pain_M0420='#form.transfers3#', Assessment_New.Intrac_Pain_M0430='#form.transfers4#', Assessment_New.Open_Wounds_M0440='#form.transfers5#', Assessment_New.Pressure_Ulcer_M0445='#form.transfers6#', Assessment_New.Pressure_Ulcer_a_M0450='#form.sittings#', Assessment_New.Pressure_Ulcer_b_M0450='#form.standings#', Assessment_New.Pressure_Ulcer_c_M0450='#form.txtbergscore#', Assessment_New.Pressure_Ulcer_d_M0450='#form.txttinettiscore#', Assessment_New.Pressure_Ulcer_e_M0450='#form.gaitsurface#', Assessment_New.Pressure_Ulcer_Stage_M0460='#form.distance#', Assessment_New.HHRG_825_Score='#form.tugtest#', Assessment_New.Pressure_Ulcer_Status_M0464='#form.hdnmuscle1#', Assessment_New.Stasis_Ulcer_M0468='#form.hdnmuscle2#', Assessment_New.Stasis_Ulcer_Num_M0470='#form.hdnmuscle3#', Assessment_New.Stasis_Ulcer_Hidden_M0474='#form.hdnmuscle4#', Assessment_New.Stasis_Ulcer_Status_M0476='#form.hdnmuscle5#', Assessment_New.Surgical_Wound_M0482='#form.hdnmuscle6#', Assessment_New.Psy_Nursing_M0630='#form.hdnpainlevel#', Assessment_New.Grooming_M0640='#form.Grooming_M0640_hid#', Assessment_New.Grooming_M0640p='#form.hdnpainthers#', Assessment_New.Dress_Upper_M0650='#form.hdnratecurrent#', Assessment_New.Dress_Upper_M0650p='#form.hdnhowlong#', Assessment_New.Dress_Lower_M0660='#form.Dress_Lower_M0660_hid#', Assessment_New.Dress_Lower_M0660p='#form.hdnShortness#', Assessment_New.Bathing_M0670='#form.Bathing_M0670_hid#', Assessment_New.Bathing_M0670p='#form.Bathing_M0670p_hid#', Assessment_New.Toileting_M0680='#form.resonwhy#', Assessment_New.Toileting_M0680p='#form.Toileting_M0680p_hid#', Assessment_New.Rehab_Prognosis_M0270='#form.potential#', Assessment_New.Surgical_Wound_Hidden_M0486='#form.elbow#', Assessment_New.Breathing_M0490='#form.Forearm#', Assessment_New.UTI_M0510='#form.Wrist#', Assessment_New.Urinary_INcont_when_M0530='#form.Shoulder#', Assessment_New.Ostomy_for_Bowel_M0550='#form.Hip#', Assessment_New.When_Confused_M0570='#form.Knee#', Assessment_New.Depressive_Feelings_M0590='#form.Ankel#', Assessment_New.Patient_Behav_freq_M0620='#form.CervicalSpine#' where Assessment_ID='#session.cs.AssessmentId#' UPDATE IGNORE #Request.prefix_db_agency#.Diagnosis set Severity='#Form.drpsev#', Primary_Diagnosis='#Form.drppre#', Secondary_Diagnosis='#Form.drpsec#' where Assessment_ID='#session.cs.AssessmentId#'