SELECT Assessment_Completed_M0090 FROM #Request.prefix_db_agency#.Assessment_New where Assessment_ID = '#form.txtAssId#' SELECT DISTINCT Diagnosis FROM #Request.prefix_db_lookup#.Dx_list_ICD10 WHERE Diagnosis LIKE '%#form.searchfield#%' SELECT DISTINCT Diagnosis FROM #Request.prefix_db_lookup#.Diagnosis_List WHERE Diagnosis LIKE '%#form.searchfield#%' SELECT DISTINCT surgical_codes.Procedure FROM #Request.prefix_db_lookup#.surgical_codes WHERE surgical_codes.Procedure LIKE '%#form.M1012searchfield#%' SELECT DISTINCT Diagnosis FROM #Request.prefix_db_lookup#.Dx_list_ICD10 WHERE Diagnosis LIKE '%#form.M1016searchfield#%' SELECT DISTINCT Diagnosis FROM #Request.prefix_db_lookup#.Diagnosis_List WHERE Diagnosis LIKE '%#form.M1016searchfield#%' UPDATE #Request.prefix_db_agency#.Assessment_New SET M0110 = '#form.1M0110#', Discharged_From_M0175 = '#form.hdnM1000#', M1000_Other = '#form.txtM1000#', Inpatient_Discharge_Date_M0180 = #CreateODBCDate(form.dtM1005)#, Inpatient_Discharge_Date_NA_M0180 = '#form.hdnM1005UK#', Conditions_Prior_M0220 = '#form.hdnUrinary#', M0250_Assess = '#form.hdnOverweight#', Endocrine_Assess = '#form.hdnHyperglycemiFZaSleeping#', Therapies_Home_M0250 = '#form.ChkIntravenous#', M1032_Frailty = '#form.hdnM1032Recent#', Rehab_Prognosis_M0270 = '#form.drpM1034#', High_Risk_Factors_M0290 = '#form.hdnHeavysmoking#', Vision_M0390 = '#form.drpM1200#', Hearing_M0400 = '#form.drpM1210#', M1220_Verbal_Under = '#form.drpM1220#', Speech_M0410 = '#form.drpM1230#', M1240_Pain_Assess = '#form.0no#', Freq_of_Pain_M0420 = '#form.drpM1242#', Open_Wounds_M0440 = '#form.hdnColor#', M1300_Pressure = '#form.drpM1300#', M1302_Pressure = '#form.hdnradioM1302Count#', M1306_Unhealed_Pressure = '#form.hdnradioM1306Count#', Pressure_Ulcer_b_M0450 = '#form.drpStage2#', Pressure_Ulcer_c_M0450 = '#form.drpStage3#', Pressure_Ulcer_d_M0450 = '#form.drpStage4#', Pressure_Ulcer_e_M0450 = '#form.drpdlUnstage#', M1308_d_2_Pressure = '#form.drpd2UnStage#', M1308_d_3_Pressure = '#form.drpd3UnStage#', M1310_Length = '#form.drpdM1310Length#', M1310_1 = '#form.drpdM1310#', M1312_Width= '#form.drpdM1312Width#', M1312_1= '#form.drpdM1312#', M1314_Depth= '#form.drpdM1314Depth#', M1314_1 = '#form.drpdM1314#', Pressure_Ulcer_Status_M0464 = '#form.0ulcerpressure#', Pressure_Ulcer_a_M0450 = '#form.1M0450#', Pressure_Ulcer_Stage_M0460 = '#form.1M0460#', Stasis_Ulcer_M0468 = '#form.drpM1330#', Stasis_Ulcer_Num_M0470 = '#form.hdnradioM1332Count#', Stasis_Ulcer_Status_M0476 = '#form.hdnradioM1334Count#', Surgical_Wound_M0482 = '#form.drpM1340#', Surgical_Wound_Status_M0488 = '#form.hdnradioM1342Count#', M1350_Other_Wounds = '#form.hdnradioM1350Count#', Breathing_M0490 = '#form.radBreath#', Resp_Treatments_M0500 = '#form.chkOxygen#', M0490_Assess = '#form.hdnCardio#', M0520_Assess = '#form.hdnUrinecolor#', UTI_M0510 = '#form.radM1600NO#', Urinary_INcont_M0520='#form.drpM1610#', Urinary_INcont_when_M0530 = '#form.radTimedvoiding#', M0540_Assess = '#form.hdnBowelSound#', Bowel_Incont_M0540 = '#form.radVeryrarely#', M0550_Assess = '#form.hdnFlatulence#', Ostomy_for_Bowel_M0550 = '#form.drpM1630#', Cog_Function_M0560 = '#form.drpM1700#', When_Confused_M0570 = '#form.radM1710Never#', M1730_Depression = '#form.drpM1730#', M1730a = '#form.radNotatall#', M0610_Assess='#form.hdnPT#', Patient_Behav_Weekly_M0610 = '#form.hdnMemory#', Patient_Behav_freq_M0620 = '#form.radM1745Never#', Psy_Nursing_M0630 = '#form.radM1750Never#', M0650_Assess='#form.hdnMusculoTemp#', Grooming_M0640='#form.drpM1800#', Dress_Upper_M0650='#form.drpM1810#', Dress_Lower_M0660='#form.drpM1820#', Bathing_M0670='#form.drpM1830#', M1840_Toilet ='#form.drpM1840#', M1845_Toilet= '#form.drpM1845#', Transferring_M0690='#form.drpM1850#', Ambulation_M0700='#form.drpM1860#', Eating_M0710 = '#form.drpM1870#', Meal_Prep_M0720 = '#form.drpM1880#', Use_Phone_M0770 = '#form.drpM1890#', M1900a_SelfCare = '#form.rdnSelf#', M1900b_Amb='#form.rdnAmbulation#', M1900c_Transfer='#form.rdnTransfer#', M1900d_House= '#form.rdnHouseHold#', M1910_Fall_Risk='#form.rdnM1910#', M2000_Adverse = '#form.rdnM2000#', M2002_Med_FU='#form.hdnM2002Count#', M2010_Med_Edu='#form.hdnM2010Count#', Oral_Meds_M0780='#form.hdnM2020Count#', Inject_Meds_M0800='#form.hdnM2030Count#', Oral_Meds_M0780p = '#form.rdnOral#', Inject_Meds_m0800p ='#form.rdnInject#', M2100a_Equip='#form.rdnADL#', M2100b_Equip='#form.rdnIADL#', M2100c_Equip ='#form.rdnMedAdmin#', M2100d_Equip = '#form.rdnMedtreatment#', M2100e_Equip = '#form.rdnEquipMgt#', M2100f_Equip = '#form.rdnSupervision#', M2100g_Equip = '#form.rdnAdvocacy#', M2110_Assist_Freq = '#form.rdnM2110#', M0826_Ther_Need = '#form.txtTher#', M0826_Ther_Need = 0, M0826_NA = '#form.hdnNA#', Waiting_For_Eval='#form.hdnYes#', M1016_DX_NA='#form.hdnM1016Yes#', M2250a_PhysNot = '#form.rdnSpecific#', M2250b_Diabetic='#form.rdnDiabetic#', M2250c_FallsPrev='#form.rdnFalls#', M2250d_Depress='#form.rdnDepression#', M2250e_Pain='#form.rdnPain#', M2250f_PressUlc='#form.rdnPressure#', M2250g_PressUlcMoist='#form.rdnMoist#', Assessment_Completed_M0090 = #CreateODBCDate(form.dateass)#, M0420_Assess ='#form.hdnPainLevel#', Pain1 = '#form.hdnthrobbing#', Pain2 = '#form.hdnradthreshold#', Pain3='#form.hdnradscale#', Pain4='#form.hdnraddose#', Pain5= '#form.hdnphysical#', Braden_1_Sensory='#form.drlPresureUlcersSensory#', Braden_2_Moisture='#form.drlPresureUlcersMoisture#', Braden_3_Activity='#form.drlPresureUlcersActivity#', Braden_4_Mobility='#form.drlPresureUlcersMobility#', Braden_5_Nutrition ='#form.drlPresureUlcersNutrition#', Braden_6_Friction='#form.drlPresureUlcersFriction#', Fall_A='#form.drlFallRiskConsciousness1#', Fall_B='#form.drlFallRiskHistory1#', Fall_C='#form.drlFallRiskAmbulation1#', Fall_D='#form.drlFallRiskVision1#', Fall_E='#form.drlFallRiskGait1#', Fall_F='#form.drlFallRiskOrthostatic1#', Fall_G='#form.drlFallRiskMedications1#', Fall_H='#form.drlFallRiskMedical1#', Fall_I='#form.drlFallRiskEquipment1#', M1016_DX_NA='#form.hdnM1016NA#', M1012_Inpat_DX_NA = '#form.hdnM1012NA#', M1012_Inpat_DX_UK = '#form.hdnM1012UK#', Home_Safety_Assess = '#form.hdnhomeother#' 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# select Count(Diagnosis.Diagnosis) as M1010oneCount from #Request.prefix_db_agency#.Diagnosis where Diagnosis.Assessment_ID=#form.txtAssId# and Diagnosis.Diagnosis LIKE '%#cookie.M1010one1#%' and M0190_Link LIKE '%#m02301#%' select ICD,Code_Type,Pathway_Type,Short_Diagnosis from #Request.prefix_db_lookup#.Dx_list_ICD10 WHERE Dx_list_ICD10.Diagnosis LIKE '%#cookie.M1010one1#%' select ICD,Code_Type,Pathway_Type,Short_Diagnosis from #Request.prefix_db_lookup#.Diagnosis_List WHERE Diagnosis_List.Diagnosis LIKE '%#cookie.M1010one1#%' INSERT INTO #Request.prefix_db_agency#.Diagnosis(Assessment_ID,Assessment_Tracker_ID,Patient_ID,Agency_ID,Diagnosis,ICD,Code_Type,Pathway_Type, Short_Diagnosis,Text_ICD,M0190_Link,Dx_Order) VALUES ('#form.txtAssId#','#AssID.Assessment_Tracker_ID#','#AssID.Patient_ID#', '#AssID.Agency_ID#','#cookie.M1010one1#','#M1010list1.ICD#','#M1010list1.Code_Type#','#M1010list1.Pathway_Type#', '#M1010list1.Short_Diagnosis#','#M1010list1.ICD#','#m02301#','#form.drpM1010one1#') UPDATE #Request.prefix_db_agency#.Diagnosis SET Dx_Order = '#form.drpM1010one1#' WHERE Assessment_ID= #form.txtAssId# and Diagnosis LIKE '%#cookie.M1010one1#%' and M0190_Link LIKE '%#m02301#%' select Count(Diagnosis.Diagnosis) as M1010twoCount from #Request.prefix_db_agency#.Diagnosis where Diagnosis.Assessment_ID=#form.txtAssId# and Diagnosis.Diagnosis LIKE '%#cookie.M1010one2#%' and M0190_Link LIKE '%#m02301#%' select ICD,Code_Type,Pathway_Type,Short_Diagnosis from #Request.prefix_db_lookup#.Dx_list_ICD10 WHERE Dx_list_ICD10.Diagnosis LIKE '%#cookie.M1010one2#%' select ICD,Code_Type,Pathway_Type,Short_Diagnosis from #Request.prefix_db_lookup#.Diagnosis_List WHERE Diagnosis_List.Diagnosis LIKE '%#cookie.M1010one2#%' INSERT INTO #Request.prefix_db_agency#.Diagnosis(Assessment_ID,Assessment_Tracker_ID,Patient_ID,Agency_ID,Diagnosis,ICD,Code_Type,Pathway_Type, Short_Diagnosis,Text_ICD,M0190_Link,Dx_Order) VALUES ('#form.txtAssId#','#AssID.Assessment_Tracker_ID#','#AssID.Patient_ID#', '#AssID.Agency_ID#','#cookie.M1010one2#','#M1010list2.ICD#','#M1010list2.Code_Type#','#M1010list2.Pathway_Type#', '#M1010list2.Short_Diagnosis#','#M1010list2.ICD#','#m02301#','#form.drpM1010one2#') UPDATE #Request.prefix_db_agency#.Diagnosis SET Dx_Order = '#form.drpM1010one2#' WHERE Assessment_ID= #form.txtAssId# and Diagnosis LIKE '%#cookie.M1010one2#%' and M0190_Link LIKE '%#m02301#%' select Count(Diagnosis.Diagnosis) as M1010threeCount from #Request.prefix_db_agency#.Diagnosis where Diagnosis.Assessment_ID=#form.txtAssId# and Diagnosis.Diagnosis LIKE '%#cookie.M1010one3#%' and M0190_Link LIKE '%#m02301#%' select ICD,Code_Type,Pathway_Type,Short_Diagnosis from #Request.prefix_db_lookup#.Dx_list_ICD10 WHERE Dx_list_ICD10.Diagnosis LIKE '%#cookie.M1010one3#%' select ICD,Code_Type,Pathway_Type,Short_Diagnosis from #Request.prefix_db_lookup#.Diagnosis_List WHERE Diagnosis_List.Diagnosis LIKE '%#cookie.M1010one3#%' INSERT INTO #Request.prefix_db_agency#.Diagnosis(Assessment_ID,Assessment_Tracker_ID,Patient_ID,Agency_ID,Diagnosis,ICD,Code_Type,Pathway_Type, Short_Diagnosis,Text_ICD,M0190_Link,Dx_Order) VALUES ('#form.txtAssId#','#AssID.Assessment_Tracker_ID#','#AssID.Patient_ID#', '#AssID.Agency_ID#','#cookie.M1010one3#','#M1010list3.ICD#','#M1010list3.Code_Type#','#M1010list3.Pathway_Type#', '#M1010list3.Short_Diagnosis#','#M1010list3.ICD#','#m02301#','#form.drpM1010one3#') UPDATE #Request.prefix_db_agency#.Diagnosis SET Dx_Order = '#form.drpM1010one3#' WHERE Assessment_ID= #form.txtAssId# and Diagnosis LIKE '%#cookie.M1010one3#%' and M0190_Link LIKE '%#m02301#%' select Count(Diagnosis.Diagnosis) as M1010fourCount from #Request.prefix_db_agency#.Diagnosis where Diagnosis.Assessment_ID=#form.txtAssId# and Diagnosis.Diagnosis LIKE '%#cookie.M1010one4#%' and M0190_Link LIKE '%#m02301#%' select ICD,Code_Type,Pathway_Type,Short_Diagnosis from #Request.prefix_db_lookup#.Dx_list_ICD10 WHERE Dx_list_ICD10.Diagnosis LIKE '%#cookie.M1010one4#%' select ICD,Code_Type,Pathway_Type,Short_Diagnosis from #Request.prefix_db_lookup#.Diagnosis_List WHERE Diagnosis_List.Diagnosis LIKE '%#cookie.M1010one4#%' INSERT INTO #Request.prefix_db_agency#.Diagnosis(Assessment_ID,Assessment_Tracker_ID,Patient_ID,Agency_ID,Diagnosis,ICD,Code_Type,Pathway_Type, Short_Diagnosis,Text_ICD,M0190_Link,Dx_Order) VALUES ('#form.txtAssId#','#AssID.Assessment_Tracker_ID#','#AssID.Patient_ID#', '#AssID.Agency_ID#','#cookie.M1010one4#','#M1010list4.ICD#','#M1010list4.Code_Type#','#M1010list4.Pathway_Type#', '#M1010list4.Short_Diagnosis#','#M1010list4.ICD#','#m02301#','#form.drpM1010one4#') UPDATE #Request.prefix_db_agency#.Diagnosis SET Dx_Order = '#form.drpM1010one4#' WHERE Assessment_ID= #form.txtAssId# and Diagnosis LIKE '%#cookie.M1010one4#%' and M0190_Link LIKE '%#m02301#%' select Count(Diagnosis.Diagnosis) as M1010fiveCount from #Request.prefix_db_agency#.Diagnosis where Diagnosis.Assessment_ID=#form.txtAssId# and Diagnosis.Diagnosis LIKE '%#cookie.M1010one5#%' and M0190_Link LIKE '%#m02301#%' select ICD,Code_Type,Pathway_Type,Short_Diagnosis from #Request.prefix_db_lookup#.Dx_list_ICD10 WHERE Dx_list_ICD10.Diagnosis LIKE '%#cookie.M1010one5#%' select ICD,Code_Type,Pathway_Type,Short_Diagnosis from #Request.prefix_db_lookup#.Diagnosis_List WHERE Diagnosis_List.Diagnosis LIKE '%#cookie.M1010one5#%' INSERT INTO #Request.prefix_db_agency#.Diagnosis(Assessment_ID,Assessment_Tracker_ID,Patient_ID,Agency_ID,Diagnosis,ICD,Code_Type,Pathway_Type, Short_Diagnosis,Text_ICD,M0190_Link,Dx_Order) VALUES ('#form.txtAssId#','#AssID.Assessment_Tracker_ID#','#AssID.Patient_ID#', '#AssID.Agency_ID#','#cookie.M1010one5#','#M1010list5.ICD#','#M1010list5.Code_Type#','#M1010list5.Pathway_Type#', '#M1010list5.Short_Diagnosis#','#M1010list5.ICD#','#m02301#','#form.drpM1010one5#') UPDATE #Request.prefix_db_agency#.Diagnosis SET Dx_Order = '#form.drpM1010one5#' WHERE Assessment_ID= #form.txtAssId# and Diagnosis LIKE '%#cookie.M1010one5#%' and M0190_Link LIKE '%#m02301#%' select Count(Diagnosis.Diagnosis) as M1010sixCount from #Request.prefix_db_agency#.Diagnosis where Diagnosis.Assessment_ID=#form.txtAssId# and Diagnosis.Diagnosis LIKE '%#cookie.M1010one6#%' and M0190_Link LIKE '%#m02301#%' select ICD,Code_Type,Pathway_Type,Short_Diagnosis from #Request.prefix_db_lookup#.Dx_list_ICD10 WHERE Dx_list_ICD10.Diagnosis LIKE '%#cookie.M1010one6#%' select ICD,Code_Type,Pathway_Type,Short_Diagnosis from #Request.prefix_db_lookup#.Diagnosis_List WHERE Diagnosis_List.Diagnosis LIKE '%#cookie.M1010one6#%' INSERT INTO #Request.prefix_db_agency#.Diagnosis(Assessment_ID,Assessment_Tracker_ID,Patient_ID,Agency_ID,Diagnosis,ICD,Code_Type,Pathway_Type, Short_Diagnosis,Text_ICD,M0190_Link,Dx_Order) VALUES ('#form.txtAssId#','#AssID.Assessment_Tracker_ID#','#AssID.Patient_ID#', '#AssID.Agency_ID#','#cookie.M1010one6#','#M1010list6.ICD#','#M1010list6.Code_Type#','#M1010list6.Pathway_Type#', '#M1010list6.Short_Diagnosis#','#M1010list6.ICD#','#m02301#','#form.drpM1010one6#') UPDATE #Request.prefix_db_agency#.Diagnosis SET Dx_Order = '#form.drpM1010one6#' WHERE Assessment_ID= #form.txtAssId# and Diagnosis LIKE '%#cookie.M1010one6#%' and M0190_Link LIKE '%#m02301#%' delete from #Request.prefix_db_agency#.Diagnosis where Diagnosis.Assessment_ID=#form.txtAssId# and Diagnosis.Diagnosis not in(#cookie.deleletCookie#) and M0190_Link LIKE '%#m02301#%' delete from #Request.prefix_db_agency#.Diagnosis where Diagnosis.Assessment_ID=#form.txtAssId# and M0190_Link LIKE '%#m02301#%' select Count(Diagnosis.Diagnosis) as M1012oneCount from #Request.prefix_db_agency#.Diagnosis where Diagnosis.Assessment_ID=#form.txtAssId# and Diagnosis.Diagnosis LIKE '%#cookie.M1012one1#%' and M1012_Link LIKE '%#M1012#%' select CPT,Short_Procedure from #Request.prefix_db_lookup#.surgical_codes where surgical_codes.Procedure LIKE '%#cookie.M1012one1#%' INSERT INTO #Request.prefix_db_agency#.Diagnosis(Assessment_ID,Assessment_Tracker_ID,Patient_ID,Agency_ID,Diagnosis,ICD,Code_Type, Short_Diagnosis,Text_ICD,M1012_Link,Dx_Order) VALUES ('#form.txtAssId#','#AssID.Assessment_Tracker_ID#','#AssID.Patient_ID#', '#AssID.Agency_ID#','#cookie.M1012one1#','#M1012list1.CPT#','CPT', '#Left(M1012list1.Short_Procedure,45)#','#M1012list1.CPT#','#M1012#','#form.drpM1012one1#') UPDATE #Request.prefix_db_agency#.Diagnosis SET Dx_Order = '#form.drpM1012one1#' WHERE Assessment_ID= #form.txtAssId# and Diagnosis LIKE '%#cookie.M1012one1#%' and M1012_Link LIKE '%#M1012#%' select Count(Diagnosis.Diagnosis) as M1012twoCount from #Request.prefix_db_agency#.Diagnosis where Diagnosis.Assessment_ID=#form.txtAssId# and Diagnosis.Diagnosis LIKE '%#cookie.M1012one2#%' and M1012_Link LIKE '%#M1012#%' select CPT,Short_Procedure from #Request.prefix_db_lookup#.surgical_codes where surgical_codes.Procedure LIKE '%#cookie.M1012one2#%' INSERT INTO #Request.prefix_db_agency#.Diagnosis(Assessment_ID,Assessment_Tracker_ID,Patient_ID,Agency_ID,Diagnosis,ICD,Code_Type, Short_Diagnosis,Text_ICD,M1012_Link,Dx_Order) VALUES ('#form.txtAssId#','#AssID.Assessment_Tracker_ID#','#AssID.Patient_ID#', '#AssID.Agency_ID#','#cookie.M1012one2#','#M1012list2.CPT#','CPT', '#Left(M1012list2.Short_Procedure,45)#','#M1012list2.CPT#','#M1012#','#form.drpM1012one2#') UPDATE #Request.prefix_db_agency#.Diagnosis SET Dx_Order = '#form.drpM1012one2#' WHERE Assessment_ID= #form.txtAssId# and Diagnosis LIKE '%#cookie.M1012one2#%' and M1012_Link LIKE '%#M1012#%' select Count(Diagnosis.Diagnosis) as M1012threeCount from #Request.prefix_db_agency#.Diagnosis where Diagnosis.Assessment_ID=#form.txtAssId# and Diagnosis.Diagnosis LIKE '%#cookie.M1012one3#%' and M1012_Link LIKE '%#M1012#%' select CPT,Short_Procedure from #Request.prefix_db_lookup#.surgical_codes where surgical_codes.Procedure LIKE '%#cookie.M1012one3#%' INSERT INTO #Request.prefix_db_agency#.Diagnosis(Assessment_ID,Assessment_Tracker_ID,Patient_ID,Agency_ID,Diagnosis,ICD,Code_Type, Short_Diagnosis,Text_ICD,M1012_Link,Dx_Order) VALUES ('#form.txtAssId#','#AssID.Assessment_Tracker_ID#','#AssID.Patient_ID#', '#AssID.Agency_ID#','#cookie.M1012one3#','#M1012list3.CPT#','CPT', '#Left(M1012list3.Short_Procedure,45)#','#M1012list3.CPT#','#M1012#','#form.drpM1012one3#') UPDATE #Request.prefix_db_agency#.Diagnosis SET Dx_Order = '#form.drpM1012one3#' WHERE Assessment_ID= #form.txtAssId# and Diagnosis LIKE '%#cookie.M1012one3#%' and M1012_Link LIKE '%#M1012#%' select Count(Diagnosis.Diagnosis) as M1012fourCount from #Request.prefix_db_agency#.Diagnosis where Diagnosis.Assessment_ID=#form.txtAssId# and Diagnosis.Diagnosis LIKE '%#cookie.M1012one4#%' and M1012_Link LIKE '%#M1012#%' select CPT,Short_Procedure from #Request.prefix_db_lookup#.surgical_codes where surgical_codes.Procedure LIKE '%#cookie.M1012one4#%' INSERT INTO #Request.prefix_db_agency#.Diagnosis(Assessment_ID,Assessment_Tracker_ID,Patient_ID,Agency_ID,Diagnosis,ICD,Code_Type, Short_Diagnosis,Text_ICD,M1012_Link,Dx_Order) VALUES ('#form.txtAssId#','#AssID.Assessment_Tracker_ID#','#AssID.Patient_ID#', '#AssID.Agency_ID#','#cookie.M1012one4#','#M1012list4.CPT#','CPT', '#Left(M1012list4.Short_Procedure,45)#','#M1012list4.CPT#','#M1012#','#form.drpM1012one4#') UPDATE #Request.prefix_db_agency#.Diagnosis SET Dx_Order = '#form.drpM1012one4#' WHERE Assessment_ID= #form.txtAssId# and Diagnosis LIKE '%#cookie.M1012one4#%' and M1012_Link LIKE '%#M1012#%' delete from #Request.prefix_db_agency#.Diagnosis where Diagnosis.Assessment_ID=#form.txtAssId# and Diagnosis.Diagnosis not in(#cookie.M1012deleletCookie#) and M1012_Link LIKE '%#M1012#%' delete from #Request.prefix_db_agency#.Diagnosis where Diagnosis.Assessment_ID=#form.txtAssId# and M1012_Link LIKE '%#M1012#%' select Count(Diagnosis.Diagnosis) as M1016oneCount from #Request.prefix_db_agency#.Diagnosis where Diagnosis.Assessment_ID=#form.txtAssId# and Diagnosis.Diagnosis LIKE '%#cookie.M1016one1#%' and M0210_Link LIKE '%#M1016#%' select ICD,Code_Type,Pathway_Type,Short_Diagnosis from #Request.prefix_db_lookup#.Dx_list_ICD10 WHERE Dx_list_ICD10.Diagnosis LIKE '%#cookie.M1016one1#%' select ICD,Code_Type,Pathway_Type,Short_Diagnosis from #Request.prefix_db_lookup#.Diagnosis_List WHERE Diagnosis_List.Diagnosis LIKE '%#cookie.M1016one1#%' INSERT INTO #Request.prefix_db_agency#.Diagnosis(Assessment_ID,Assessment_Tracker_ID,Patient_ID,Agency_ID,Diagnosis,ICD,Code_Type,Pathway_Type, Short_Diagnosis,Text_ICD,M0210_Link,Dx_Order) VALUES ('#form.txtAssId#','#AssID.Assessment_Tracker_ID#','#AssID.Patient_ID#', '#AssID.Agency_ID#','#cookie.M1016one1#','#M1016list1.ICD#','#M1016list1.Code_Type#','#M1016list1.Pathway_Type#', '#M1016list1.Short_Diagnosis#','#M1016list1.ICD#','#M1016#','#form.drpM1016one1#') UPDATE #Request.prefix_db_agency#.Diagnosis SET Dx_Order = '#form.drpM1016one1#' WHERE Assessment_ID= #form.txtAssId# and Diagnosis LIKE '%#cookie.M1016one1#%' and M0210_Link LIKE '%#M1016#%' select Count(Diagnosis.Diagnosis) as M1016twoCount from #Request.prefix_db_agency#.Diagnosis where Diagnosis.Assessment_ID=#form.txtAssId# and Diagnosis.Diagnosis LIKE '%#cookie.M1016one2#%' and M0210_Link LIKE '%#M1016#%' select ICD,Code_Type,Pathway_Type,Short_Diagnosis from #Request.prefix_db_lookup#.Dx_list_ICD10 WHERE Dx_list_ICD10.Diagnosis LIKE '%#cookie.M1016one2#%' select ICD,Code_Type,Pathway_Type,Short_Diagnosis from #Request.prefix_db_lookup#.Diagnosis_List WHERE Diagnosis_List.Diagnosis LIKE '%#cookie.M1016one2#%' INSERT INTO #Request.prefix_db_agency#.Diagnosis(Assessment_ID,Assessment_Tracker_ID,Patient_ID,Agency_ID,Diagnosis,ICD,Code_Type,Pathway_Type, Short_Diagnosis,Text_ICD,M0210_Link,Dx_Order) VALUES ('#form.txtAssId#','#AssID.Assessment_Tracker_ID#','#AssID.Patient_ID#', '#AssID.Agency_ID#','#cookie.M1016one2#','#M1016list2.ICD#','#M1016list2.Code_Type#','#M1016list2.Pathway_Type#', '#M1016list2.Short_Diagnosis#','#M1016list2.ICD#','#M1016#','#form.drpM1016one2#') UPDATE #Request.prefix_db_agency#.Diagnosis SET Dx_Order = '#form.drpM1016one2#' WHERE Assessment_ID= #form.txtAssId# and Diagnosis LIKE '%#cookie.M1016one2#%' and M0210_Link LIKE '%#M1016#%' select Count(Diagnosis.Diagnosis) as M1016threeCount from #Request.prefix_db_agency#.Diagnosis where Diagnosis.Assessment_ID=#form.txtAssId# and Diagnosis.Diagnosis LIKE '%#cookie.M1016one3#%' and M0210_Link LIKE '%#M1016#%' select ICD,Code_Type,Pathway_Type,Short_Diagnosis from #Request.prefix_db_lookup#.Dx_list_ICD10 WHERE Dx_list_ICD10.Diagnosis LIKE '%#cookie.M1016one3#%' select ICD,Code_Type,Pathway_Type,Short_Diagnosis from #Request.prefix_db_lookup#.Diagnosis_List WHERE Diagnosis_List.Diagnosis LIKE '%#cookie.M1016one3#%' INSERT INTO #Request.prefix_db_agency#.Diagnosis(Assessment_ID,Assessment_Tracker_ID,Patient_ID,Agency_ID,Diagnosis,ICD,Code_Type,Pathway_Type, Short_Diagnosis,Text_ICD,M0210_Link,Dx_Order) VALUES ('#form.txtAssId#','#AssID.Assessment_Tracker_ID#','#AssID.Patient_ID#', '#AssID.Agency_ID#','#cookie.M1016one3#','#M1016list3.ICD#','#M1016list3.Code_Type#','#M1016list3.Pathway_Type#', '#M1016list3.Short_Diagnosis#','#M1016list3.ICD#','#M1016#','#form.drpM1016one3#') UPDATE #Request.prefix_db_agency#.Diagnosis SET Dx_Order = '#form.drpM1016one3#' WHERE Assessment_ID= #form.txtAssId# and Diagnosis LIKE '%#cookie.M1016one3#%' and M0210_Link LIKE '%#M1016#%' select Count(Diagnosis.Diagnosis) as M1016fourCount from #Request.prefix_db_agency#.Diagnosis where Diagnosis.Assessment_ID=#form.txtAssId# and Diagnosis.Diagnosis LIKE '%#cookie.M1016one4#%' and M0210_Link LIKE '%#M1016#%' select ICD,Code_Type,Pathway_Type,Short_Diagnosis from #Request.prefix_db_lookup#.Dx_list_ICD10 WHERE Dx_list_ICD10.Diagnosis LIKE '%#cookie.M1016one4#%' select ICD,Code_Type,Pathway_Type,Short_Diagnosis from #Request.prefix_db_lookup#.Diagnosis_List WHERE Diagnosis_List.Diagnosis LIKE '%#cookie.M1016one4#%' INSERT INTO #Request.prefix_db_agency#.Diagnosis(Assessment_ID,Assessment_Tracker_ID,Patient_ID,Agency_ID,Diagnosis,ICD,Code_Type,Pathway_Type, Short_Diagnosis,Text_ICD,M0210_Link,Dx_Order) VALUES ('#form.txtAssId#','#AssID.Assessment_Tracker_ID#','#AssID.Patient_ID#', '#AssID.Agency_ID#','#cookie.M1016one4#','#M1016list4.ICD#','#M1016list4.Code_Type#','#M1016list4.Pathway_Type#', '#M1016list4.Short_Diagnosis#','#M1016list4.ICD#','#M1016#','#form.drpM1016one4#') UPDATE #Request.prefix_db_agency#.Diagnosis SET Dx_Order = '#form.drpM1016one4#' WHERE Assessment_ID= #form.txtAssId# and Diagnosis LIKE '%#cookie.M1016one4#%' and M0210_Link LIKE '%#M1016#%' select Count(Diagnosis.Diagnosis) as M1016fiveCount from #Request.prefix_db_agency#.Diagnosis where Diagnosis.Assessment_ID=#form.txtAssId# and Diagnosis.Diagnosis LIKE '%#cookie.M1016one5#%' and M0210_Link LIKE '%#M1016#%' select ICD,Code_Type,Pathway_Type,Short_Diagnosis from #Request.prefix_db_lookup#.Dx_list_ICD10 WHERE Dx_list_ICD10.Diagnosis LIKE '%#cookie.M1016one5#%' select ICD,Code_Type,Pathway_Type,Short_Diagnosis from #Request.prefix_db_lookup#.Diagnosis_List WHERE Diagnosis_List.Diagnosis LIKE '%#cookie.M1016one5#%' INSERT INTO #Request.prefix_db_agency#.Diagnosis(Assessment_ID,Assessment_Tracker_ID,Patient_ID,Agency_ID,Diagnosis,ICD,Code_Type,Pathway_Type, Short_Diagnosis,Text_ICD,M0210_Link,Dx_Order) VALUES ('#form.txtAssId#','#AssID.Assessment_Tracker_ID#','#AssID.Patient_ID#', '#AssID.Agency_ID#','#cookie.M1016one5#','#M1016list5.ICD#','#M1016list5.Code_Type#','#M1016list5.Pathway_Type#', '#M1016list5.Short_Diagnosis#','#M1016list5.ICD#','#M1016#','#form.drpM1016one5#') UPDATE #Request.prefix_db_agency#.Diagnosis SET Dx_Order = '#form.drpM1016one5#' WHERE Assessment_ID= #form.txtAssId# and Diagnosis LIKE '%#cookie.M1016one5#%' and M0210_Link LIKE '%#M1016#%' select Count(Diagnosis.Diagnosis) as M1016sixCount from #Request.prefix_db_agency#.Diagnosis where Diagnosis.Assessment_ID=#form.txtAssId# and Diagnosis.Diagnosis LIKE '%#cookie.M1016one6#%' and M0210_Link LIKE '%#M1016#%' select ICD,Code_Type,Pathway_Type,Short_Diagnosis from #Request.prefix_db_lookup#.Dx_list_ICD10 WHERE Dx_list_ICD10.Diagnosis LIKE '%#cookie.M1016one6#%' select ICD,Code_Type,Pathway_Type,Short_Diagnosis from #Request.prefix_db_lookup#.Diagnosis_List WHERE Diagnosis_List.Diagnosis LIKE '%#cookie.M1016one6#%' INSERT INTO #Request.prefix_db_agency#.Diagnosis(Assessment_ID,Assessment_Tracker_ID,Patient_ID,Agency_ID,Diagnosis,ICD,Code_Type,Pathway_Type, Short_Diagnosis,Text_ICD,M0210_Link,Dx_Order) VALUES ('#form.txtAssId#','#AssID.Assessment_Tracker_ID#','#AssID.Patient_ID#', '#AssID.Agency_ID#','#cookie.M1016one6#','#M1016list6.ICD#','#M1016list6.Code_Type#','#M1016list6.Pathway_Type#', '#M1016list6.Short_Diagnosis#','#M1016list6.ICD#','#M1016#','#form.drpM1016one6#') UPDATE #Request.prefix_db_agency#.Diagnosis SET Dx_Order = '#form.drpM1016one6#' WHERE Assessment_ID= #form.txtAssId# and Diagnosis LIKE '%#cookie.M1016one6#%' and M0210_Link LIKE '%#M1016#%' delete from #Request.prefix_db_agency#.Diagnosis where Diagnosis.Assessment_ID=#form.txtAssId# and Diagnosis.Diagnosis not in(#cookie.M1016deleletCookie#) and M0210_Link LIKE '%#M1016#%' delete from #Request.prefix_db_agency#.Diagnosis where Diagnosis.Assessment_ID=#form.txtAssId# and M0210_Link LIKE '%#M1016#%' update #Request.prefix_db_agency#.Pathway_Details set deleted = 'yes' 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 pathway_details.Assessment_ID=#form.txtAssId# and pathway_details.Pathway_Details_ID=#UpdateID#