UPDATE #Request.prefix_db_agency#.Assessment_New SET Home_Safety_Assess = '#form.hdchkhomesafety#', Rehab_Prognosis_M0270 = '#form.hdnRehab#', Therapies_Home_M0250 = '#form.hdchkTherapies#', M0250_Assess = '#form.hdchknutrition#', Endocrine_Assess = '#form.hdchkendocrine#', M0420_Assess ='#form.hdnradpainlevel#', Emergent_Care_M0830 ='#form.hdchkpaincharacter#', Emergent_Care_Reason_M0840 ='#form.hdnradthreshold#', Nursing_Home_M0900 ='#form.hdnradscale#', Discharge_Disposition_M0870 ='#form.hdnraddose#', Inpatient_Facility_M0855 ='#form.hdchkpatientopinion#', M0440_Assess ='#form.hdchkintegu#', M0490_Assess ='#form.hdchkcardio#', M0520_Assess ='#form.hdchkurine#', AssessmentType_New = 1, Admission_Status='Complete', M0540_Assess ='#form.hdchkgastro#', M0550_Assess ='#form.hdchkostomy#', M0610_Assess ='#form.hdchkneuro#', Housekeeping_M0750p ='#form.hdchkmental#', Meal_Prep_M0720 ='#form.hdchkmusclo#', Start_of_Care_M0030=#CreateODBCDate(form.dateass1)#, Start_of_Care_M0030= null, Assessment_New.Surgical_ICD_485='#form.txtsurgical1#', Assessment_New.Surgical_ICD_485_Description='#form.txtsurgical#', Assessment_New.Surgical_ICD_Date_485=#CreateODBCDate(form.dateass2)# Assessment_New.Surgical_ICD_Date_485= null WHERE Assessment_New.Assessment_ID ='#session.cs.AssessmentId#' UPDATE IGNORE #Request.prefix_db_agency#.Diagnosis SET Severity='#severity#',Primary_Diagnosis='#primary#',Secondary_Diagnosis='#secondary#', Dx_Order = '#dxorder#' where Diagnosis.Assessment_ID='#session.cs.AssessmentId#' and Diagnosis_ID='#Id#'