UPDATE #Request.prefix_db_agency#.Assessment_New SET Date_Most_Recent_M0903 = #CreateODBCDate(Date_Most_Recent_M0903)#null, Date_Discharge_M0906 = #CreateODBCDate(Date_Discharge_M0906)#null, Discharged_From_M0175='#Discharged_From_M0175#', Medical_or_Treatment_Change_M0200 = '#Medical_or_Treatment_Change_M0200#', Conditions_Prior_M0220 = '#Conditions_Prior_M0220#', Therapies_Home_M0250 = '#Therapies_Home_M0250#', AssessmentType_New = '#Assessment_Type#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET Date_Most_Recent_M0903 = #CreateODBCDate(Date_Most_Recent_M0903)#null, Date_Discharge_M0906 = #CreateODBCDate(Date_Discharge_M0906)#null, Discharged_From_M0175='#Discharged_From_M0175#', Medical_or_Treatment_Change_M0200 = '#Medical_or_Treatment_Change_M0200#', Conditions_Prior_M0220 = '#Conditions_Prior_M0220#', Therapies_Home_M0250 = '#Therapies_Home_M0250#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET Resp_Treatments_M0500 = '#Resp_Treatments_M0500#', Urinary_INcont_M0520 = '#Urinary_INcont_M0520#', Overall_Prognosis_M0260 = '#Overall_Prognosis_M0260#', Psy_Nursing_M0630 = '#Psy_Nursing_M0630#', Life_Exp_M0280 = '#Life_Exp_M0280#', High_Risk_Factors_M0290 = '#High_Risk_Factors_M0290#', Vision_M0390 = '#Vision_M0390#', Hearing_M0400 = '#Hearing_M0400#', Rehab_Prognosis_M0270 = '#Rehab_Prognosis_M0270#', Speech_M0410 = '#Speech_M0410#', Depressive_Feelings_M0590 = '#Depressive_Feelings_M0590#', Patient_Behav_Weekly_M0610= '#Patient_Behav_Weekly_M0610#', Patient_Behav_freq_M0620 = '#Patient_Behav_freq_M0620#', Freq_of_Pain_M0420 = '#Freq_of_Pain_M0420#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET Intrac_Pain_M0430 = '#Intrac_Pain_M0430#', Open_Wounds_M0440 = '#Open_Wounds_M0440#', Pressure_Ulcer_M0445 = '#Pressure_Ulcer_M0445#', Pressure_Ulcer_a_M0450 = '#Pressure_Ulcer_a_M0450#', M0104_Date_of_Referral = #CreateODBCDate(Physician_Last_Seen_Date)#null, M1307_Date = #CreateODBCDate(M1307_Date)#null, AssessmentType_New = '#Assessment_Type#', Admission_Status ='Complete' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET Date_Most_Recent_M0903 = #CreateODBCDate(Date_Most_Recent_M0903)#null, Date_Discharge_M0906 = #CreateODBCDate(Date_Discharge_M0906)#null, Discharged_From_M0175='#Discharged_From_M0175#', Medical_or_Treatment_Change_M0200 = '#Medical_or_Treatment_Change_M0200#', Conditions_Prior_M0220 = '#Conditions_Prior_M0220#', Therapies_Home_M0250 = '#Therapies_Home_M0250#', AssessmentType_New = '#Assessment_Type#', Admission_Status='Complete' WHERE Assessment_ID = '#session.cs.AssessmentId#'