UPDATE #Request.prefix_db_agency#.Assessment_New SET #datalist[i]# = NULL "#datalist[i+1]#" ,AssessmentType_New = 1 ,Admission_Status='Complete' WHERE Assessment_ID = '#session.cs.AssessmentId#' SELECT * FROM Assessment_Answer_lookup WHERE DELETED <> 1 AND assessment_reason = '#assessment_reason#' GROUP BY answer_label SELECT * FROM Assessment_Questions_lookup WHERE DELETED <> 1 AND assessment_reason = '#assessment_reason#' SELECT * FROM #Request.prefix_db_agency#.Assessment_New WHERE Assessment_ID = '#session.cs.AssessmentId#' AND #get_all_answers.answer_label# IS NOT NULL INSERT INTO #Request.prefix_db_agency#.Pathway_Details(Agency_ID,Patient_ID,Assessment_ID,Description,Type,Skill,Care_PathWay) VALUES ('#session.AgencyId#','#session.cs.patientid#','#session.cs.AssessmentId#','#wndtype#','Wound','SSN','25') select LAST_INSERT_ID() as keyvalue insert into #Request.prefix_db_agency#.PatientVisitDetails (Wnd_Type, Wnd_Location, Wnd_Stage, Wnd_Status, Wnd_Len_1, Wnd_Len_2, Wnd_Wid_1, Wnd_Wid_2, Wnd_Dep_1, Wnd_Dep_2, Wnd_Surr_Tiss, Wnd_Chara, Notes, Agency_ID, Patient_ID, Assessment_ID, Record_Creation_Date, Pathway_Details_ID, Type) values('#wndtype#', '#location#', '#left(stage,100)#', '#status#', '#lengh1#', '#lengh2#', '#width1#', '#width2#', '#depth1#', '#depth2#', '#WS#', '#WC#', '#notes#', '#session.AgencyId#', '#session.cs.patientid#', '#session.cs.AssessmentId#', '#DateFormat(now(),"yyyy-mm-dd")#', '#LastPath.keyvalue#', 'Wound') SELECT count(Wnd_Type) as CouNt from #Request.prefix_db_agency#.PatientVisitDetails where Patient_ID='#session.cs.patientid#' and Assessment_ID='#session.cs.AssessmentId#' and Wnd_Location<>'' and Wnd_Type<>'' and trim(Type)='Wound' UPDATE #Request.prefix_db_agency#.Assessment_New SET M0420_Assess='#painlevel#', Pain1='#TB#', Pain2='#radthreshold#', Pain3='#radscale#', Pain4='#raddose#', Pain5='#PC#' Where Assessment_New.Assessment_ID= '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET Braden_1_Sensory='#drlPresureUlcersSensory#', Braden_2_Moisture='#drlPresureUlcersMoisture#', Braden_3_Activity='#drlPresureUlcersActivity#', Braden_4_Mobility='#drlPresureUlcersMobility#', Braden_5_Nutrition='#drlPresureUlcersNutrition#', Braden_6_Friction='#drlPresureUlcersFriction#' Where Assessment_New.Assessment_ID= '#session.cs.AssessmentId#' delete from #Request.prefix_db_agency#.PatientVisitDetails where Progress_Details_ID='#WoundID#' SELECT count(Wnd_Type) as CouNt from #Request.prefix_db_agency#.PatientVisitDetails where Patient_ID='#session.cs.patientid#' and Assessment_ID='#session.cs.AssessmentId#' and Wnd_Location<>'' and Wnd_Type<>'' and trim(Type)='Wound' INSERT INTO #Request.prefix_db_agency#.PatientVisitDetails(ScheduleItems_ID,Description,Agency_ID, Patient_ID,Assessment_ID,Assessment_Tracker_ID,Record_Creation_Date,Type,Notes,Reading1,Severity) VALUES ('#session.cs.ScheduleId#','#Type#','#Session.AgencyLogin#','#patientid#','#AssessmentID#','#AssessmentTrackerID#','#DateFormat(now(),"yyyy-mm-dd")#','vital sign','#Notes#','#Reading#','#Severity#') select LAST_INSERT_ID() as keyvalue SELECT Patient_ID,Agency_Id,Assessment_Tracker_ID,Assessment_Reason_M0100,Discharged_From_M0175, Assessment_Completed_M0090 ,Braden_1_Sensory, Braden_2_Moisture, Braden_3_Activity, Braden_4_Mobility, Braden_5_Nutrition, Braden_6_Friction,M1310_1,M1308_d_3_Pressure,M1308_d_2_Pressure,Pressure_Ulcer_b_M0450, Pressure_Ulcer_c_M0450,Pressure_Ulcer_d_M0450,Pressure_Ulcer_e_M0450,M1300_Pressure,Stasis_Ulcer_M0468, Surgical_Wound_M0482 FROM #Request.prefix_db_agency#.Assessment_New WHERE Assessment_ID='#session.cs.AssessmentId#' SELECT Wnd_Len_1,Wnd_Len_2,Wnd_Wid_1,Wnd_Wid_2,Wnd_Dep_1,Wnd_Dep_2 FROM #Request.prefix_db_agency#.PatientVisitDetails where assessment_id ='#session.cs.AssessmentId#' and type='Wound' and wnd_type is not null limit 1 SELECT Wnd_Type,Wnd_Stage,Wnd_Status FROM #Request.prefix_db_agency#.PatientVisitDetails where assessment_id ='#session.cs.AssessmentId#' and type='Wound' and wnd_type is not null UPDATE #Request.prefix_db_agency#.Assessment_New SET M1302_Pressure = '#cookie.M1302Pressure#', M1306_Unhealed_Pressure = '#cookie.M1306Unhealed#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET Pressure_Ulcer_Status_M0464='#cookie.PressureUlcerStatus#' WHERE Assessment_ID = '#session.cs.AssessmentId#' update #Request.prefix_db_agency#.Assessment_New Set M1310_Length = '#cookie.M1310Length#', M1310_1 = '#cookie.M13101#', M1312_Width = '#cookie.M1312Width#', M1312_1 = '#cookie.M13121#', M1314_Depth = '#cookie.M1314Depth#', M1314_1 = '#cookie.M13141#' WHERE Assessment_ID='#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET Pressure_Ulcer_Status_M0464='#cookie.PressureUlcerStatus#' WHERE Assessment_ID = '#session.cs.AssessmentId#' update #Request.prefix_db_agency#.Assessment_New Set Pressure_Ulcer_b_M0450 = '#cookie.PressureUlcerbM0450#', Pressure_Ulcer_c_M0450 = '#cookie.PressureUlcercM0450#', Pressure_Ulcer_d_M0450 = '#cookie.PressureUlcerdM0450#', Pressure_Ulcer_e_M0450 = '#cookie.PressureUlcereM0450#', M1308_d_2_Pressure = '#cookie.M1308d2Pressure#', M1308_d_3_Pressure = '#M1308_d_3_Pressure#' WHERE Assessment_ID='#session.cs.AssessmentId#' update #Request.prefix_db_agency#.Assessment_New Set M1308_a_12_Pressure = '#M1308_a_12_Pressure#', M1308_b_12_Pressure = '#M1308_b_12_Pressure#', M1308_c_12_Pressure = '#M1308_c_12_Pressure#', M1308_d_12_Pressure = '#M1308_d_12_Pressure#', M1308_d_22_Pressure = '#M1308_d_22_Pressure#', M1308_d_32_Pressure = '#M1308_d_32_Pressure#' WHERE Assessment_ID='#session.cs.AssessmentId#' update #Request.prefix_db_agency#.Assessment_New Set Pressure_Ulcer_a_M0450 = '#cookie.PressureUlceraM0450#', Pressure_Ulcer_Stage_M0460 = '#cookie.PressureUlcerStageM0460#' WHERE Assessment_ID='#session.cs.AssessmentId#' update #Request.prefix_db_agency#.Assessment_New Set M1302_Pressure = '#cookie.M1302Pressure#' WHERE Assessment_ID='#session.cs.AssessmentId#' update #Request.prefix_db_agency#.Assessment_New Set Pressure_Ulcer_Stage_M0460 = '#cookie.PressureUlcerStageM0460#' WHERE Assessment_ID='#session.cs.AssessmentId#' update #Request.prefix_db_agency#.Assessment_New Set Surgical_Wound_Status_M0488 = '#cookie.SurgicalWoundStatusM0488#' WHERE Assessment_ID='#session.cs.AssessmentId#' SELECT * FROM #Request.prefix_db_agency#.PatientVisitDetails where assessment_id ='#session.cs.AssessmentId#' and Wnd_Type='Stasis Ulcer' and type='Wound' SELECT count(Wnd_Status) as Wnd_StatusCount FROM #Request.prefix_db_agency#.PatientVisitDetails where assessment_id ='#session.cs.AssessmentId#' and Wnd_Type='Stasis Ulcer' and type='Wound' and Wnd_Status like '%NA%' SELECT count(Wnd_Status) as Wnd_StatusCount FROM #Request.prefix_db_agency#.PatientVisitDetails where assessment_id ='#session.cs.AssessmentId#' and Wnd_Type='Stasis Ulcer' and type='Wound' and Wnd_Status like '%0%' SELECT count(Wnd_Status) as Wnd_StatusCount FROM #Request.prefix_db_agency#.PatientVisitDetails where assessment_id ='#session.cs.AssessmentId#' and Wnd_Type='Stasis Ulcer' and type='Wound' and Wnd_Status like '%1%' SELECT count(Wnd_Status) as Wnd_StatusCount FROM #Request.prefix_db_agency#.PatientVisitDetails where assessment_id ='#session.cs.AssessmentId#' and Wnd_Type='Stasis Ulcer' and type='Wound' and Wnd_Status like '%2%' SELECT count(Wnd_Status) as Wnd_StatusCount FROM #Request.prefix_db_agency#.PatientVisitDetails where assessment_id ='#session.cs.AssessmentId#' and Wnd_Type='Stasis Ulcer' and type='Wound' and Wnd_Status like '%3%' update #Request.prefix_db_agency#.Assessment_New Set Stasis_Ulcer_M0468 = '1 - Yes, patient has BOTH observable and unobservable stasis ulcers' WHERE Assessment_ID='#session.cs.AssessmentId#' update #Request.prefix_db_agency#.Assessment_New Set Stasis_Ulcer_M0468 = '2 - Yes, patient has observable stasis ulcers ONLY' WHERE Assessment_ID='#session.cs.AssessmentId#' update #Request.prefix_db_agency#.Assessment_New Set Stasis_Ulcer_M0468 = '0 - No' WHERE Assessment_ID='#session.cs.AssessmentId#' update #Request.prefix_db_agency#.Assessment_New Set Stasis_Ulcer_M0468 = '3 - Yes, patient has unobservable stasis ulcers ONLY (known but not observable due to non-removable dressing)' WHERE Assessment_ID='#session.cs.AssessmentId#' update #Request.prefix_db_agency#.Assessment_New Set Stasis_Ulcer_Num_M0470 = '#Stasis_Ulcer_Num_M0470#' WHERE Assessment_ID='#session.cs.AssessmentId#' update #Request.prefix_db_agency#.Assessment_New Set Stasis_Ulcer_Status_M0476 = '#Stasis_Ulcer_Status_M0476#' WHERE Assessment_ID='#session.cs.AssessmentId#' update #Request.prefix_db_agency#.Assessment_New Set Stasis_Ulcer_Status_M0476 = '#Stasis_Ulcer_Status_M0476#' WHERE Assessment_ID='#session.cs.AssessmentId#' update #Request.prefix_db_agency#.Assessment_New Set Stasis_Ulcer_Status_M0476 = '#Stasis_Ulcer_Status_M0476#' WHERE Assessment_ID='#session.cs.AssessmentId#' update #Request.prefix_db_agency#.Assessment_New Set Stasis_Ulcer_Status_M0476 = '#Stasis_Ulcer_Status_M0476#' WHERE Assessment_ID='#session.cs.AssessmentId#' SELECT * FROM #Request.prefix_db_agency#.PatientVisitDetails where assessment_id ='#session.cs.AssessmentId#' and Wnd_Type='Surgical Wound' and type='Wound' SELECT count(Wnd_Status) as Wnd_StatusCount FROM #Request.prefix_db_agency#.PatientVisitDetails where assessment_id ='#session.cs.AssessmentId#' and Wnd_Type='Surgical Wound' and type='Wound' and Wnd_Status like '%NA%' SELECT count(Wnd_Status) as Wnd_StatusCount FROM #Request.prefix_db_agency#.PatientVisitDetails where assessment_id ='#session.cs.AssessmentId#' and Wnd_Type='Surgical Wound' and type='Wound' and Wnd_Status like '%0%' SELECT count(Wnd_Status) as Wnd_StatusCount FROM #Request.prefix_db_agency#.PatientVisitDetails where assessment_id ='#session.cs.AssessmentId#' and Wnd_Type='Surgical Wound' and type='Wound' and Wnd_Status like '%1%' SELECT count(Wnd_Status) as Wnd_StatusCount FROM #Request.prefix_db_agency#.PatientVisitDetails where assessment_id ='#session.cs.AssessmentId#' and Wnd_Type='Surgical Wound' and type='Wound' and Wnd_Status like '%2%' SELECT count(Wnd_Status) as Wnd_StatusCount FROM #Request.prefix_db_agency#.PatientVisitDetails where assessment_id ='#session.cs.AssessmentId#' and Wnd_Type='Surgical Wound' and type='Wound' and Wnd_Status like '%3%' update #Request.prefix_db_agency#.Assessment_New Set Surgical_Wound_M0482 = '1 - Yes, patient has at least one (observable) surgical wound' WHERE Assessment_ID='#session.cs.AssessmentId#' update #Request.prefix_db_agency#.Assessment_New Set Surgical_Wound_M0482 = '2 - Surgical wound known or likely but not observable due to non-removable dressing' WHERE Assessment_ID='#session.cs.AssessmentId#' update #Request.prefix_db_agency#.Assessment_New Set Surgical_Wound_M0482 = '0 - No' WHERE Assessment_ID='#session.cs.AssessmentId#' update #Request.prefix_db_agency#.Assessment_New Set Surgical_Wound_Status_M0488 = '#Surgical_Wound_Status_M0488#' WHERE Assessment_ID='#session.cs.AssessmentId#' update #Request.prefix_db_agency#.Assessment_New Set Surgical_Wound_Status_M0488 = '#Surgical_Wound_Status_M0488#' WHERE Assessment_ID='#session.cs.AssessmentId#' update #Request.prefix_db_agency#.Assessment_New Set Surgical_Wound_Status_M0488 = '#Surgical_Wound_Status_M0488#' WHERE Assessment_ID='#session.cs.AssessmentId#' update #Request.prefix_db_agency#.Assessment_New Set Surgical_Wound_Status_M0488 = '#Surgical_Wound_Status_M0488#' WHERE Assessment_ID='#session.cs.AssessmentId#'