UPDATE #Request.prefix_db_agency#.Assessment_New SET Surgical_ICD_485 = '#txtsurgical1#', Surgical_ICD_485_Description = '#txtsurgical#', M0063_Pattern ='#careplan#', Assessment_New.Surgical_ICD_Date_485=#CreateODBCDate(dateass2)#, Assessment_New.Surgical_ICD_Date_485= null, Psy_Nursing_M0630 = '#rdnAdmitted#', Grooming_M0640 = '#rdncardio#', Assessment_New.Grooming_M0640p=#CreateODBCDate(dtM640)#, Assessment_New.Grooming_M0640p= null, Dress_Upper_M0650 = '#rdnf2100#', Assessment_New.Dress_Upper_M0650p=#CreateODBCDate(dtM650)#, Assessment_New.Dress_Upper_M0650p= null, Dress_Lower_M0660 = '#rdnf2200#', Assessment_New.Dress_Lower_M0660p=#CreateODBCDate(dtM660)#, Assessment_New.Dress_Lower_M0660p= null, Bathing_M0670 = '#rdnf3000#', Assessment_New.Bathing_M0670p=#CreateODBCDate(dtM670)#, Assessment_New.Bathing_M0670p= null, Toileting_M0680 = '#rdnI0100#', Toileting_M0680p = '#rdnj0900#', Assessment_New.Transferring_M0690=#CreateODBCDate(dtM690)#, Assessment_New.Transferring_M0690= null, Transferring_M0690p = '#rdnj0900c#', Ambulation_M0700 = '#rdnj0900d#', Breathing_M0490 = '#rdnj0905#', Ambulation_M0700p = '#rdnj0910a#', Assessment_New.Eating_M0710=#CreateODBCDate(dtM710)#, Assessment_New.Eating_M0710= null, Eating_M0710p = '#chkComprehen#', Meal_Prep_M0720 = '#rdnj2030#', Assessment_New.Meal_Prep_M0720p=#CreateODBCDate(dtM720)#, Assessment_New.Meal_Prep_M0720p= null, Transport_M0730 = '#rdnj2030c#', Transport_M0730p = '#rdnj2040#', Assessment_New.Laundry_M0740=#CreateODBCDate(dtM740)#, Assessment_New.Laundry_M0740= null, Laundry_M0740p = '#rdn2040c#', Housekeeping_M0750 = '#rdnn0500#', Assessment_New.Housekeeping_M0750p=#CreateODBCDate(dtM750)#, Assessment_New.Housekeeping_M0750p= null, Shopping_M0760 = '#rdnn0510a#', Shopping_M0760p = '#rdnn0520a#', Assessment_New.Use_Phone_M0770=#CreateODBCDate(dtM770)#, Assessment_New.Use_Phone_M0770= null, Assessment_New.Oral_Meds_M0780=#CreateODBCDate(dtM780)#, Assessment_New.Oral_Meds_M0780= null, Hospice_Assess = '#rdnKarnofsky#', Home_Safety_Assess = '#chkComprehensive#', Therapies_Home_M0250 = '#chkTherapies#', M0250_Assess = '#ChkOverweight#', Endocrine_Assess = '#chkEndocrine#', M0420_Assess = '#rdnPain#', pain1 = '#ChkThrobbing#', pain2 = '#rdnThreshold#', pain3 = '#rdnRate#', pain4 = '#rdnLong#', pain5 = '#Chkact#', M0440_Assess= '#chkSkin#', M0490_Assess = '#chkDyspnea#', M0520_Assess = '#chkUrinecolor#', M0540_Assess = '#chkBowelSound#', M0650_Assess = '#chkMusclo#', M0610_Assess = '#chkPT#', Urinary_INcont_M0520 = '#chkPoor#', Patient_Behav_freq_M0620 = '#chkMental#', Urinary_INcont_when_M0530 = '#chkFinanical#', Bowel_Incont_M0540 = '#chkpatdep#', Ostomy_for_Bowel_M0550 = '#chkSpiritual#', Cog_Function_M0560 = '#chkHome#', M0550_Assess = '#chkFlatulence#', Assessment_note='#Comments#', AssessmentType_New = 1, Admission_Status = 'Complete' AssessmentType_New = 0, Admission_Status = 'In Progress' where Assessment_ID='#session.cs.AssessmentId#' Select Assessment_Tracker_ID,Patient_ID,Agency_ID From #Request.prefix_db_agency#.Assessment_New where Assessment_ID= '#session.cs.AssessmentId#' SELECT Assessment_Completed_M0090 FROM #Request.prefix_db_agency#.Assessment_New where Assessment_ID = '#session.cs.AssessmentId#' select Diagnosis,ICD,Code_Type,Pathway_Type,Short_Diagnosis,Other_DG from #Request.prefix_db_lookup#.diagnosis_list WHERE diagnosis_list.id=#DiagnosisID# select Count(Diagnosis.Diagnosis_ID) as M0230RecordCount from #Request.prefix_db_agency#.Diagnosis where Diagnosis.Assessment_ID='#session.cs.AssessmentId#' and Diagnosis.Diagnosis LIKE '%#M0230fetch.Diagnosis#%' and M0230_Link LIKE '%#m02301#%' 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,M0230_Link,Severity,Primary_Diagnosis,Secondary_Diagnosis,Dx_Order,DG_Type,M0245a_Diagnosis,M0245_ICD) VALUES ('#session.cs.AssessmentId#','#AssID.Assessment_Tracker_ID#','#AssID.Patient_ID#', '#session.AgencyLogin#','#M0230fetch.Diagnosis#','#typecode#','#M0230fetch.Code_Type#','#Replace(M0230fetch.Pathway_Type, "'", '', 'ALL')#', '#M0230fetch.Short_Diagnosis#','#typecode#','#m02301#','#M0230Severity#','#M0230Primary#', '#M0230Secondary#','1','#M0230fetch.Other_DG#','#vcodediag#','#vcodeicd#') 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,M0230_Link,Severity,Primary_Diagnosis,Secondary_Diagnosis,Dx_Order,DG_Type,M0245a_Diagnosis,M0245_ICD) VALUES ('#session.cs.AssessmentId#','#AssID.Assessment_Tracker_ID#','#AssID.Patient_ID#', '#session.AgencyLogin#','#M0230fetch.Diagnosis#','#M0230fetchICD#','#M0230fetch.Code_Type#','#Replace(M0230fetch.Pathway_Type, "'", '', 'ALL')#', '#M0230fetch.Short_Diagnosis#','#M0230fetchICD#','#m02301#','#M0230Severity#','#M0230Primary#', '#M0230Secondary#','1','#M0230fetch.Other_DG#','#vcodediag#','#vcodeicd#') 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#.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' 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 delete from #Request.prefix_db_agency#.Diagnosis where Diagnosis.Assessment_ID=#session.cs.AssessmentId# and Diagnosis_ID=#DiagnosisID# UPDATE #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#