UPDATE #Request.prefix_db_agency#.Assessment_New SET M0110 = '#M0110#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET Therapies_Home_M0250 = '#ChkIn#', M0250_Assess = '#ChkOvr#', Home_Safety_Assess = '#ChkHo#', Endocrine_Assess = '#ChkSleep#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET M0420_Assess = '#Chkpain#', M0440_Assess = '#Chkcolor#', M1306_Unhealed_Pressure = '#M1306#', Freq_of_Pain_M0420 = '#M1242#', Vision_M0390 = '#M1200#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET Pressure_Ulcer_b_M0450 = '#drpstage2#', Pressure_Ulcer_c_M0450 = '#drpstage3#', Pressure_Ulcer_d_M0450 = '#drpstage4#', Pressure_Ulcer_e_M0450 = '#drpd1#', M1308_d_2_Pressure = '#drpd2#', M1308_d_3_Pressure = '#drpd3#', M1308_d_32_Pressure = '#drpstage3value#', M1308_d_22_Pressure = '#drpd2value#', M1308_d_12_Pressure = '#drpd1value#', M1308_c_12_Pressure = '#drpstage4value#', M1308_b_12_Pressure = '#drpd3value#', M1308_a_12_Pressure = '#drpstage2value#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET Pressure_Ulcer_a_M0450 = '#M1322#', Pressure_Ulcer_Stage_M0460 = '#M1324#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET Stasis_Ulcer_Num_M0470 = '#M1332#', Stasis_Ulcer_Status_M0476 = '#M1334#', Stasis_Ulcer_M0468 ='#M1330#', Surgical_Wound_Status_M0488 = '#M1342#', M1350_Other_Wounds = '#M1350#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET Breathing_M0490 = '#M1400#', M0490_Assess = '#Chkdys#', M0520_Assess = '#Chkurinecol#', Ostomy_for_Bowel_M0550 = '#M1630#', Urinary_INcont_M0520 = '#M1610#', Bowel_Incont_M0540 = '#M1620#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET Dress_Upper_M0650 = '#M1810#', Dress_Lower_M0660 = '#M1820#', Bathing_M0670 = '#M1830#', M1840_Toilet = '#M1840#', Transferring_M0690 = '#M1850#', Ambulation_M0700 = '#M1860#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET M0826_Ther_Need = '#txtTher#', M0826_Ther_Need = 0, M0826_NA = '#chkNA#', Waiting_For_Eval = '#chkWait#', Assessment_Completed_M0090 = #CreateODBCDate(dateass)#, Inject_Meds_M0800 ='#M2030#' WHERE Assessment_ID = '#session.cs.AssessmentId#' 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# 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#.Dx_list_ICD10 WHERE Dx_list_ICD10.id=#DiagnosisID# 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) VALUES ('#session.cs.AssessmentId#','#AssID.Assessment_Tracker_ID#','#AssID.Patient_ID#', '#AssID.Agency_ID#','#M0230fetch.Diagnosis#','#M0230fetch.ICD#','#M0230fetch.Code_Type#','#M0230fetch.Pathway_Type#', '#M0230fetch.Short_Diagnosis#','#M0230fetch.ICD#','#m02301#','#M0230Severity#','#M0230Primary#', '#M0230Secondary#','1','#M0230fetch.Other_DG#') delete from #Request.prefix_db_agency#.Diagnosis where diagnosis.Assessment_ID=#session.cs.AssessmentId# and Diagnosis_ID=#DiagnosisID# 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# 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#' 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) values('#wndtype#', '#location#', '#stage#', '#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#') 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<>'' delete from #Request.prefix_db_agency#.PatientVisitDetails where Progress_Details_ID='#WoundID#' SELECT Dose FROM #Request.prefix_db_lookup#.meds_new_dose WHERE Dose_ID='#doseid#' SELECT Name FROM #Request.prefix_db_lookup#.meds_new WHERE Trade_ID='#tradeid#' INSERT INTO #Request.prefix_db_agency#.PatientMeds(Patient_ID,Medication_ID,Drug_Name,Dose,DateOrdered,Med_Status) VALUES ('#session.cs.patientid#','#tradeid#','#MName.Name#','#MDose.Dose#',CURDATE(),'active') INSERT INTO #Request.prefix_db_agency#.PatientMeds(Patient_ID,Drug_Name,DateOrdered) VALUES ('#session.cs.patientid#','????',CURDATE()) SELECT Name FROM #Request.prefix_db_lookup#.meds_new WHERE Trade_ID='#tradeid#' INSERT INTO #Request.prefix_db_agency#.PatientMeds(Patient_ID,Medication_ID,Drug_Name,DateOrdered,Med_Status) VALUES ('#session.cs.patientid#','#tradeid#','#TypeMName.Name#',CURDATE(),'active') delete from #Request.prefix_db_agency#.PatientMeds where Patient_ID='#session.cs.patientid#' and PatientMeds_ID not in(#hdnPatientMedsID#) UPDATE #Request.prefix_db_agency#.PatientMeds SET Notes='#PNotes#',Med_Status='#Pactive#',DateOrdered=NULL '#DateFormat(POrdered,"yyyy-mm-dd")#',Dose='#PDose#',Route='#PRoute#', Freq='#PFreq#',Drug_Name='#PName#', DateDCed=NULL'#DateFormat(PDiscontinued,"yyyy-mm-dd")#' ,Dose_Units='#PUnitType#',NewChanged='#PTnewChange#' WHERE Patient_ID='#session.cs.patientid#' and PatientMeds_ID='#Pmedid#' INSERT INTO #Request.prefix_db_agency#.PatientMeds(Patient_ID,Notes,Med_Status,DateOrdered,Dose,Route,Freq,Drug_Name,DateDCed,Dose_Units,NewChanged) VALUES ('#session.cs.patientid#','#PNotes#','#Pactive#',NULL'#DateFormat(POrdered,"yyyy-mm-dd")#' ,'#PDose#','#PRoute#','#PFreq#','#PName#',NULL '#DateFormat(PDiscontinued,"yyyy-mm-dd")#','#PUnitType#','#PTnewChange#')