UPDATE #Request.prefix_db_agency#.Assessment_Forms SET Record_Mod_Date = #CreateODBCDate(form.Record_Mod_Date)#,Record_Mod_Date=NULL, Date_Sent = #CreateODBCDate(form.DateSent)#,Date_Sent=NULL, Physician_Item_24='#form.Physician_Item_24#', HI_Claim_Item_1='#form.HI_Claim_Item_1#', SOC_Item_2 = #CreateODBCDate(form.SOC_Item_2)#,SOC_Item_2 =NULL, Cert_start_Item_3a = #CreateODBCDate(form.Cert_start_Item_3a)#,Cert_start_Item_3a=NULL, Cert_End_Item_3b = #CreateODBCDate(form.Cert_End_Item_3b)#,Cert_End_Item_3b=NULL, DOB_Item_8 = #CreateODBCDate(form.DOB_Item_8)#,DOB_Item_8=NULL, Gender_Item_9='#form.rdgender#', Active_meds_Item_10='#form.Active_meds_Item_10#', M0230_ICD_Item_11='#form.M0230_ICD_Item_11#', M0230_Diagnosis_Item_11='#form.M0230_Diagnosis_Item_11#', M0230_Date_Item_11 = #CreateODBCDate(form.M0230_Date_Item_11)#,M0230_Date_Item_11=NULL, Surgical_ICD_Item_12='#form.Surgical_ICD_Item_12#', Surgical_Procedure_Item_12='#form.Surgical_Procedure_Item_12#', Surgical_Procedure_Date_Item_12 = #CreateODBCDate(form.Surgical_Procedure_Date_Item_12)#,Surgical_Procedure_Date_Item_12=NULL, M0240_ICD_Item_13='#form.M0240_ICD_Item_13#', M0240_Diagnosis_Item_13='#form.M0240_Diagnosis_Item_13#', DME_Supplies_Item_14='#form.txtDMESupplies#', Safety_Measures_Item_15='#form.txtSafetyMeasures#', Nutritional_Item_16='#form.txtNutritionalReq#', Allergies_Item_17='#form.Allergies_Item_17#', Func_Limits_Item_18a='#form.chklimitation#', Func_Limits_Item_18a_other='#form.Func_Limits_Item_18a_other#', Activities_Permitted_Item_18b='#form.Chkpermitted#', Activities_Permitted_Item_18b_other='#form.Activities_Permitted_Item_18b_other#', Mental_Status_Item_19='#form.ChkStatus#', Mental_Status_Item_19_other='#form.Mental_Status_Item_19_other#', Prognosis_Item_20='#form.rdPrognosis#', Discharge='#form.Discharge#', SN_Schedule_21='#form.SN_Schedule_21#', Therapy_Schedule_21='#form.Therapy_Schedule_21#', HHA_Schedule_21='#form.HHA_Schedule_21#', Order_item_21='#form.Order_item_21#', Addendum_Details_21='#form.Addendum_Details_21#', Goals_Item_22='#form.Goals_Item_22#' WHERE Assessment_Forms_Id = #form.formId# SELECT af.*, p.Patient_Id, p.Last_Name_M0040, p.First_Name_M0040 FROM #Request.prefix_db_agency#.Assessment_Forms af, #Request.prefix_db_agency#.patient p WHERE af.Assessment_Forms_Id = '#form.formId#' AND p.Patient_ID = af.Patient_Id UPDATE #Request.prefix_db_agency#.Assessment_New SET SN_Visit_Orders = '#form.SN_Visit_Orders#' WHERE Assessment_Id = #GetV.Assessment_Number# UPDATE #Request.prefix_db_agency#.Assessment_New SET Therapy_Visit_Orders = '#form.Therapy_Visit_Orders#' WHERE Assessment_Id = #GetV.Assessment_Number# UPDATE #Request.prefix_db_agency#.Assessment_New SET HHA_Visit_Orders = '#form.HHA_Visit_Orders#' WHERE Assessment_Id = #GetV.Assessment_Number# UPDATE #Request.prefix_db_agency#.Assessment_New SET Rehab_Prognosis_M0270 = '#form.Rehab_Prognosis_M0270#' WHERE Assessment_Id = #GetV.Assessment_Number# UPDATE #Request.prefix_db_agency#.Assessment_Forms SET Date_Sent = #CreateODBCDate(form.Date_Sent)#, date_received_item_25 = #CreateODBCDate(form.date_received_item_25)#,date_received_item_25 = null, Form_Status = '#form.Form_Status#', Record_Modified_By = #Session.EmployeeId#, Record_Mod_date = #CreateODBCDateTime(Now())# WHERE Assessment_Forms_Id = #form.formId# poe = CreateObject("Component", "PhysOrderEmail"); str = poe.NewOrderEmail(#form.formId#, #form.Physician_Id#);