UPDATE #Request.prefix_db_agency#.Assessment_New SET M0110 = '#form.1M0110#', M0110=NULL, Discharged_From_M0175 = '#form.hdnM1000#', Discharged_From_M0175 ='', M1028_diagnosis = '#form.M1028_diagnosis#', M1028_diagnosis = '', M1060 = '#form.M1060#', M1060 = '', M1000_Other = '#form.txtM1000#', M1000_Other ='', M0063_Pattern = '#form.careplan#', M0063_Pattern ='Use ONLY SmartDX database', Inpatient_Discharge_Date_M0180 = #CreateODBCDate(form.dtM1005)#, Inpatient_Discharge_Date_M0180 =NULL, Inpatient_Discharge_Date_NA_M0180 = '#form.hdnM1005UK#', Inpatient_Discharge_Date_NA_M0180 ='', Conditions_Prior_M0220 = '#form.hdnUrinary#', Conditions_Prior_M0220 ='', control_infection = '#form.hdncontrol_infection#', prevention = '#form.hdnprevention#', antibiotics = '#form.hdnantibiotics#', M0250_Assess = '#form.hdnOverweight#', M0250_Assess ='', Endocrine_Assess = '#form.hdnHyperglycemiFZaSleeping#', Endocrine_Assess ='', Therapies_Home_M0250 = '#form.ChkIntravenous#', Therapies_Home_M0250 ='', M1032_Frailty = '#form.hdnM1032Recent#', M1032_Frailty ='', Rehab_Prognosis_M0270 = '#form.drpM1034#', Rehab_Prognosis_M0270 ='', High_Risk_Factors_M0290 = '#form.hdnHeavysmoking#', High_Risk_Factors_M0290 ='', Vision_M0390 = '#form.drpM1200#', Vision_M0390 ='', Hearing_M0400 = '#form.drpM1210#', Hearing_M0400 ='', M1220_Verbal_Under = '#form.drpM1220#', M1220_Verbal_Under ='', Speech_M0410 = '#form.drpM1230#', Speech_M0410 = '', M1240_Pain_Assess = '#form.0no#', M1240_Pain_Assess ='', Freq_of_Pain_M0420 = '#form.drpM1242#', Freq_of_Pain_M0420 ='', M0440_Assess = '#form.hdnColor#', M0440_Assess ='', M1300_Pressure = '#form.drpM1300#', M1300_Pressure ='', M1302_Pressure = '#form.hdnradioM1302Count#', M1302_Pressure = '', M1306_Unhealed_Pressure = '#form.hdnradioM1306Count#', M1306_Unhealed_Pressure = '', Pressure_Ulcer_b_M0450 = '#form.drpStage2#', Pressure_Ulcer_b_M0450 = '', Pressure_Ulcer_c_M0450 = '#form.drpStage3#', Pressure_Ulcer_c_M0450 = '', Pressure_Ulcer_d_M0450 = '#form.drpStage4#', Pressure_Ulcer_d_M0450 ='', Pressure_Ulcer_e_M0450 = '#form.drpdlUnstage#', Pressure_Ulcer_e_M0450 = '', M1308_d_2_Pressure = '#form.drpd2UnStage#', M1308_d_2_Pressure = NULL, M1308_d_3_Pressure = '#form.drpd3UnStage#', M1308_d_3_Pressure =NULL, M1310_Length = '#form.drpdM1310Length#', M1310_Length = NULL, M1310_1 = '#form.drpdM1310#', M1310_1 = NULL, M1312_Width= '#form.drpdM1312Width#', M1312_Width = NULL, M1312_1= '#form.drpdM1312#', M1312_1 = NULL, M1314_Depth= '#form.drpdM1314Depth#', M1314_Depth = NULL, M1314_1 = '#form.drpdM1314#', M1314_1 = NULL, Pressure_Ulcer_Status_M0464 = '#form.oulcerpressure#', Pressure_Ulcer_Status_M0464 ='', Pressure_Ulcer_a_M0450 = '#form.M0450_1#', Pressure_Ulcer_a_M0450 ='', Pressure_Ulcer_Stage_M0460 = '#form.M0460_1#', Pressure_Ulcer_Stage_M0460 ='', Stasis_Ulcer_M0468 = '#form.drpM1330#', Stasis_Ulcer_M0468 = '', Stasis_Ulcer_Num_M0470 = '#form.hdnradioM1332Count#', Stasis_Ulcer_Num_M0470 ='', Stasis_Ulcer_Status_M0476 = '#form.hdnradioM1334Count#', Stasis_Ulcer_Status_M0476='', Surgical_Wound_M0482 = '#form.drpM1340#', Surgical_Wound_M0482 = '', Surgical_Wound_Status_M0488 = '#form.hdnradioM1342Count#', Surgical_Wound_Status_M0488 ='', M1350_Other_Wounds = '#form.hdnradioM1350Count#', M1350_Other_Wounds = NULL, Breathing_M0490 = '#form.radBreath#', Breathing_M0490 = '', Resp_Treatments_M0500 = '#form.chkOxygen#', Resp_Treatments_M0500 ='', M0490_Assess = '#form.hdnCardio#', M0490_Assess = '', M0520_Assess = '#form.hdnUrinecolor#', M0520_Assess = '', UTI_M0510 = '#form.radM1600NO#', UTI_M0510 = '', Urinary_INcont_M0520='#form.drpM1610#', Urinary_INcont_M0520='', Urinary_INcont_when_M0530 = '#form.radTimedvoiding#', Urinary_INcont_when_M0530 = '', M0540_Assess = '#form.hdnBowelSound#', M0540_Assess = '', Bowel_Incont_M0540 = '#form.radVeryrarely#', Bowel_Incont_M0540 = '', M0550_Assess = '#form.hdnFlatulence#', M0550_Assess = '', Ostomy_for_Bowel_M0550 = '#form.drpM1630#', Ostomy_for_Bowel_M0550 = '', Cog_Function_M0560 = '#form.drpM1700#', Cog_Function_M0560 ='', When_Confused_M0570 = '#form.radM1710Never#', When_Confused_M0570='', When_Anxious_M0580 = '#form.radM1720Never#', When_Anxious_M0580='', M1730_Depression = '#form.drpM1730#', M1730_Depression ='', M1730a='#form.radLittleNotatall#', M1730a= '', M1730b = '#form.radNotatall#', M1730b = '', M0610_Assess='#form.hdnPT#', M0610_Assess='', Patient_Behav_Weekly_M0610 = '#form.hdnMemory#', Patient_Behav_Weekly_M0610 ='', Patient_Behav_freq_M0620 = '#form.radM1745Never#', Patient_Behav_freq_M0620 ='', Psy_Nursing_M0630 = '#form.radM1750Never#', Psy_Nursing_M0630 ='', M0650_Assess='#form.hdnMusculoTemp#', M0650_Assess='', Grooming_M0640='#form.drpM1800#', Grooming_M0640 ='', Dress_Upper_M0650='#form.drpM1810#', Dress_Upper_M0650 = '', Dress_Lower_M0660='#form.drpM1820#', Dress_Lower_M0660= '', Bathing_M0670='#form.drpM1830#', Bathing_M0670 ='', M1840_Toilet ='#form.drpM1840#', M1840_Toilet ='', M1845_Toilet= '#form.drpM1845#', M1845_Toilet='', Transferring_M0690='#form.drpM1850#', Transferring_M0690='', CGO170C_1_Mobility='#form.CGO170C_1_Mobility#', CGO170C_1_Mobility='', CGO170C_2_Mobility='#form.CGO170C_2_Mobility#', CGO170C_2_Mobility='', Ambulation_M0700='#form.drpM1860#', Ambulation_M0700= '', Eating_M0710 = '#form.drpM1870#', Eating_M0710 = '', Meal_Prep_M0720 = '#form.drpM1880#', Meal_Prep_M0720 = '', Use_Phone_M0770 = '#form.drpM1890#', Use_Phone_M0770 = '', M1900a_SelfCare = '#form.rdnSelf#', M1900a_SelfCare = '', M1900b_Amb='#form.rdnAmbulation#', M1900b_Amb = '', M1900c_Transfer='#form.rdnTransfer#', M1900c_Transfer='', M1900d_House= '#form.rdnHouseHold#', M1900d_House = '', M1910_Fall_Risk='#form.rdnM1910#', M1910_Fall_Risk='', M2000_Adverse = '#form.rdnM2000#', M2000_Adverse = '', M2002_Med_FU='#form.hdnM2002Count#', M2002_Med_FU='', M2010_Med_Edu='#form.drpM2010#', M2010_Med_Edu='', Oral_Meds_M0780='#form.drpM2020#', Oral_Meds_M0780='', Inject_Meds_M0800='#form.drpM2030#', Inject_Meds_M0800='', Oral_Meds_M0780p = '#form.rdnOral#', Oral_Meds_M0780p ='', Inject_Meds_m0800p ='#form.rdnInject#', Inject_Meds_m0800p ='', M2100a_Equip='#form.rdnADL#', M2100a_Equip = '', M2100b_Equip='#form.rdnIADL#', M2100b_Equip='', M2100c_Equip ='#form.rdnMedAdmin#', M2100c_Equip = '', M2100d_Equip = '#form.rdnMedtreatment#', M2100d_Equip = '', M2100e_Equip = '#form.rdnEquipMgt#', M2100e_Equip ='', M2100f_Equip = '#form.rdnSupervision#', M2100f_Equip ='', M2100g_Equip = '#form.rdnAdvocacy#', M2100g_Equip ='', M2110_Assist_Freq = '#form.rdnM2110#', M2110_Assist_Freq ='', M0826_Ther_Need = '#form.txtTher#', M0826_Ther_Need = 0, M0826_NA = '#form.hdnNA#', M0826_NA = NULL, Waiting_For_Eval='#form.hdnYes#', Waiting_For_Eval=NULL, M1016_DX_NA='#form.hdnM1016Yes#', M1016_DX_NA=NULL, M2250a_PhysNot = '#form.rdnSpecific#', M2250a_PhysNot = NULL, M2250b_Diabetic='#form.rdnDiabetic#', M2250b_Diabetic = NULL, M2250c_FallsPrev='#form.rdnFalls#', M2250c_FallsPrev = NULL, M2250d_Depress='#form.rdnDepression#', M2250d_Depress= NULL, M2250e_Pain='#form.rdnPain#', M2250e_Pain = NULL, M2250f_PressUlc='#form.rdnPressure#', M2250f_PressUlc= NULL, M2250g_PressUlcMoist='#form.rdnMoist#', M2250g_PressUlcMoist= NULL, Assessment_Completed_M0090 = #CreateODBCDate(form.dateass)#, Assessment_Completed_M0090 = NULL, M0420_Assess ='#form.hdnPainLevel#', M0420_Assess ='', Pain1 = '#form.hdnthrobbing#', Pain1 = '', Pain2 = '#form.hdnradthreshold#', Pain2 = '', Pain3='#form.hdnradscale#', Pain3 = '', Pain4='#form.hdnraddose#', Pain4 = '', Pain5= '#form.hdnphysical#', Pain5 = '', Braden_1_Sensory='#form.drlPresureUlcersSensory#', Braden_1_Sensory= '', Braden_2_Moisture='#form.drlPresureUlcersMoisture#', Braden_2_Moisture= '', Braden_3_Activity='#form.drlPresureUlcersActivity#', Braden_3_Activity= '', Braden_4_Mobility='#form.drlPresureUlcersMobility#', Braden_4_Mobility= '', Braden_5_Nutrition ='#form.drlPresureUlcersNutrition#', Braden_5_Nutrition= '', Braden_6_Friction='#form.drlPresureUlcersFriction#', Braden_6_Friction= '', Fall_A='#form.drlFallRiskConsciousness1#', Fall_A ='', Fall_B='#form.drlFallRiskHistory1#', Fall_B ='', Fall_C='#form.drlFallRiskAmbulation1#', Fall_C ='', Fall_D='#form.drlFallRiskVision1#', Fall_D ='', Fall_E='#form.drlFallRiskGait1#', Fall_E ='', Fall_F='#form.drlFallRiskOrthostatic1#', Fall_F ='', Fall_G='#form.drlFallRiskMedications1#', Fall_G ='', Fall_H='#form.drlFallRiskMedical1#', Fall_H ='', Fall_I='#form.drlFallRiskEquipment1#', Fall_I ='', M1016_DX_NA='#form.hdnM1016NA#', M1016_DX_NA= NULL, M1012_Inpat_DX_NA = '#form.hdnM1012NA#', M1012_Inpat_DX_NA = NULL, M1012_Inpat_DX_UK = '#form.hdnM1012UK#', M1012_Inpat_DX_UK = NULL, Home_Safety_Assess = '#form.hdnhomeother#' Home_Safety_Assess = '' WHERE Assessment_ID= #form.txtAssId# Select Assessment_Tracker_ID,Patient_ID,Agency_ID From #Request.prefix_db_agency#.Assessment_New where Assessment_ID= #form.txtAssId# delete from #Request.prefix_db_agency#.Pathway_Details where Pathway_Details.Assessment_ID=#form.txtAssId# and Pathway_Details.Pathway_Details_ID not in(#cookie.PathwayID#) INSERT INTO #Request.prefix_db_agency#.Pathway_Details(Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,Skill,Description) VALUES ('#AssID.Agency_ID#','#AssID.Patient_ID#','#AssID.Assessment_Tracker_ID#','#form.txtAssId#','#Skill#','#Desc#') UPDATE #Request.prefix_db_agency#.Pathway_Details SET Description = '#UpdateDesc#' ,Skill='#UpdateSkill#' where Assessment_ID = '#form.txtAssId#' and Pathway_Details_ID = '#UpdateID#' 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# UPDATE #Request.prefix_db_agency#.Diagnosis SET Dx_Order = '#Order#''' WHERE Diagnosis.Assessment_ID=#session.cs.AssessmentId# and Diagnosis_ID=#UpdateID# UPDATE #Request.prefix_db_agency#.Diagnosis SET Dx_Order = '#Order#' WHERE Diagnosis.Assessment_ID=#session.cs.AssessmentId# and Diagnosis_ID=#UpdateID# 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#