select Pathway_Details_ID,Item_Number,Intervention_Code,Type,Description,Agency_ID,Patient_ID,Assessment_ID,Assessment_Tracker_ID,Record_Creation_Date,Created_By from #Request.prefix_db_agency#.Pathway_Details where Pathway_Details_Id=#InsertID# INSERT INTO #Request.prefix_db_agency#.PatientVisitDetails(Pathway_Details_ID,ScheduleItems_ID,Item_Number,Intervention_Code,Type,Description,Reading1,Agency_ID, Patient_ID,Assessment_ID,Assessment_Tracker_ID,Record_Creation_Date,Record_Created_By) VALUES ('#ids.Pathway_Details_ID#','#session.cs.ScheduleId#','#ids.Item_Number#','#ids.Intervention_Code#','#ids.Type#','#ids.Description#','#ids.Agency_ID#','#ids.Patient_ID#','#ids.Assessment_ID#','#ids.Assessment_Tracker_ID#','#DateFormat(ids.Record_Creation_Date,"yyyy-mm-dd")#','#ids.Created_By#') Update #Request.prefix_db_agency#.PatientVisitDetails set Performed='',general_assessment='' where Progress_Details_ID=#id# UPDATE #Request.prefix_db_agency#.Pathway_Details SET Resolved_Date = NULL where Pathway_Details_Id=#id# UPDATE #Request.prefix_db_agency#.Pathway_Details SET Resolved_Date = NULL where Pathway_Details_Id=#id# UPDATE #Request.prefix_db_agency#.Pathway_Details SET Resolved_Date = NULL where Pathway_Details_Id=#id# UPDATE #Request.prefix_db_agency#.Pathway_Details SET Resolved_Date = NULL where Pathway_Details_Id=#id# UPDATE #Request.prefix_db_agency#.Pathway_Details SET Resolved_Date = '#DateFormat(Now(),"yyyy-mm-dd")#', Record_Mod_Date = '#DateFormat(Now(),"yyyy-mm-dd")#', Record_Modified_By = '#session.EmployeeID#' WHERE Pathway_Details_Id= #mid(VarName,IndexOfOccurrence+1,len(VarName))# Update #Request.prefix_db_agency#.PatientVisitDetails set Notes='#Form[VarName]#' where Pathway_Details_ID=#mid(VarName,IndexOfOccurrence+1,len(VarName))# Update #Request.prefix_db_agency#.PatientVisitDetails set Notes='#Form[VarName]#' where Progress_Details_ID=#mid(VarName,IndexOfOccurrence+1,len(VarName))# Update #Request.prefix_db_agency#.PatientVisitDetails set Notes='#Form[VarName]#' where Progress_Details_ID=#mid(VarName,IndexOfOccurrence+1,len(VarName))# Update IGNORE #Request.prefix_db_agency#.PatientVisitDetails set Severity='#Form[VarName]#' where Pathway_Details_ID=#mid(VarName,IndexOfOccurrence+1,len(VarName))# Update IGNORE #Request.prefix_db_agency#.PatientVisitDetails set Severity='#Form[VarName]#' where Progress_Details_ID=#mid(VarName,IndexOfOccurrence+1,len(VarName))# Update IGNORE #Request.prefix_db_agency#.PatientVisitDetails set Severity='#Form[VarName]#' where Progress_Details_ID=#mid(VarName,IndexOfOccurrence+1,len(VarName))# UPDATE #Request.prefix_db_agency#.Pathway_Details SET Resolved_Date = '#DateFormat(Now(),"yyyy-mm-dd")#', Record_Mod_Date = '#DateFormat(Now(),"yyyy-mm-dd")#', Record_Modified_By = '#session.EmployeeID#' WHERE Pathway_Details_Id= #mid(VarName,IndexOfOccurrence+1,len(VarName))# Update IGNORE #Request.prefix_db_agency#.PatientVisitDetails set Severity='#Form[VarName]#' where Progress_Details_ID=#mid(VarName,IndexOfOccurrence+1,len(VarName))# Update IGNORE #Request.prefix_db_agency#.PatientVisitDetails set Notes='#Form[VarName]#' where Progress_Details_ID=#mid(VarName,IndexOfOccurrence+1,len(VarName))# Update IGNORE #Request.prefix_db_agency#.PatientVisitDetails set Reading1='#Form[VarName]#' where Progress_Details_ID=#mid(VarName,IndexOfOccurrence+1,len(VarName))# Update IGNORE #Request.prefix_db_agency#.patient_generalassessment set genaralassessment=trim('#Form[VarName]#') where Generalassessment_ID=#mid(VarName,IndexOfOccurrence+1,len(VarName))# Update #Request.prefix_db_agency#.patient_generalassessment set generalassessmentnotes=trim('#Form[VarName]#') where Generalassessment_ID=#mid(VarName,IndexOfOccurrence+1,len(VarName))# UPDATE #Request.prefix_db_agency#.Pathway_Details SET Resolved_Date = '#DateFormat(Now(),"yyyy-mm-dd")#', Record_Mod_Date = '#DateFormat(Now(),"yyyy-mm-dd")#', Record_Modified_By = '#session.EmployeeID#' WHERE Pathway_Details_Id= #mid(VarName,IndexOfOccurrence+1,len(VarName))# Update #Request.prefix_db_agency#.PatientVisitDetails set Severity='#Form[VarName]#' where Progress_Details_ID=#mid(VarName,IndexOfOccurrence+1,len(VarName))# Update #Request.prefix_db_agency#.PatientVisitDetails set Notes='#Form[VarName]#' where Progress_Details_ID=#mid(VarName,IndexOfOccurrence+1,len(VarName))# Update #Request.prefix_db_agency#.PatientVisitDetails set Reading1='#Form[VarName]#' where Progress_Details_ID=#mid(VarName,IndexOfOccurrence+1,len(VarName))# Update IGNORE #Request.prefix_db_agency#.Assessment_New a, #Request.prefix_db_agency#.ScheduleItems s, #Request.prefix_db_agency#.PatientVisitDetails p set a.MR_420 = p.Severity where a.Assessment_ID = s.Assessment_ID and s.Assessment_ID = p.Assessment_ID and p.ScheduleItems_ID = '#form.sid#' and p.Description like '%pain%' and p.Type = 'symptom' Update IGNORE #Request.prefix_db_agency#.Assessment_New a, #Request.prefix_db_agency#.ScheduleItems s, #Request.prefix_db_agency#.PatientVisitDetails p set a.MR_488 = p.Severity where a.Assessment_ID = s.Assessment_ID and s.Assessment_ID = p.Assessment_ID and p.ScheduleItems_ID = '#form.sid#' and p.Description like '%surgical w%' and p.Type = 'symptom' Update IGNORE #Request.prefix_db_agency#.Assessment_New a, #Request.prefix_db_agency#.ScheduleItems s, #Request.prefix_db_agency#.PatientVisitDetails p set a.MR_490 = p.Severity where a.Assessment_ID = s.Assessment_ID and s.Assessment_ID = p.Assessment_ID and p.ScheduleItems_ID = '#form.sid#' and p.Description like '%dyspnea%' and p.Type = 'symptom' Update IGNORE #Request.prefix_db_agency#.Assessment_New a, #Request.prefix_db_agency#.ScheduleItems s, #Request.prefix_db_agency#.PatientVisitDetails p set a.MR_780 = p.Severity where a.Assessment_ID = s.Assessment_ID and s.Assessment_ID = p.Assessment_ID and p.ScheduleItems_ID = '#form.sid#' and p.Description like '%medication m%' and p.Type = 'symptom' Update IGNORE #Request.prefix_db_agency#.Assessment_New a, #Request.prefix_db_agency#.ScheduleItems s, #Request.prefix_db_agency#.PatientVisitDetails p set a.MR_670 = p.Severity where a.Assessment_ID = s.Assessment_ID and s.Assessment_ID = p.Assessment_ID and p.ScheduleItems_ID = '#form.sid#' and p.Description like '%bathe%' and p.Type = 'symptom' Update IGNORE #Request.prefix_db_agency#.Assessment_New a, #Request.prefix_db_agency#.ScheduleItems s, #Request.prefix_db_agency#.PatientVisitDetails p set a.MR_690 = p.Severity where a.Assessment_ID = s.Assessment_ID and s.Assessment_ID = p.Assessment_ID and p.ScheduleItems_ID = '#form.sid#' and p.Description like '%transfer%' and p.Type = 'symptom' Update IGNORE #Request.prefix_db_agency#.Assessment_New a, #Request.prefix_db_agency#.ScheduleItems s, #Request.prefix_db_agency#.PatientVisitDetails p set a.MR_700 = p.Severity where a.Assessment_ID = s.Assessment_ID and s.Assessment_ID = p.Assessment_ID and p.ScheduleItems_ID = '#form.sid#' and p.Description like '%ambula%' and p.Type = 'symptom' select Visit_Date,Wnd_Type,ScheduleItems_ID,Pathway_Details_Id,Wnd_Stage from #Request.prefix_db_agency#.PatientVisitDetails where Progress_Details_ID='#id#' Update #Request.prefix_db_agency#.PatientVisitDetails set Wnd_Len_1 ='#Wnd_Len_1#', Wnd_Len_2 ='#Wnd_Len_2#', Wnd_Wid_1 ='#Wnd_Wid_1#', Wnd_Wid_2 ='#Wnd_Wid_2#', Wnd_Dep_1 ='#Wnd_Dep_1#', Wnd_Dep_2 ='#Wnd_Dep_2#' , Wnd_Surr_Tiss ='#Wnd_Surr_Tiss#', Wnd_Chara ='#Wnd_Chara#', Notes ='#Notes#' where Progress_Details_ID = #id# UPDATE #Request.prefix_db_agency#.Pathway_Details SET Resolved_Date = '#DateFormat(Now(),"yyyy-mm-dd")#', Record_Mod_Date = '#DateFormat(Now(),"yyyy-mm-dd")#' WHERE Pathway_Details_Id= '#getWoundInfo.Pathway_Details_Id#' Update #Request.prefix_db_agency#.PatientVisitDetails set Notes = '#form["Intmg_Inter" & id]#' where Progress_Details_ID = '#id#' update Successfully