UPDATE #Request.prefix_db_agency#.Assessment_New SET Assessment_New.Start_of_Care_M0030=#CreateODBCDate(dateass1)#, Assessment_New.Start_of_Care_M0030= null, Assessment_New.Discharged_From_M0175='#hsafty#', Assessment_New.Inpatient_Discharge_Date_NA_M0180='#hdnbathing#', Assessment_New.Medical_or_Treatment_Change_M0200='#hdntoileting#', Assessment_New.Conditions_Prior_M0220='#hdntransferring#', Assessment_New.Therapies_Home_M0250='#hdnambulation#', Assessment_New.Surgical_ICD_485='#txtsurgical1#', Assessment_New.Surgical_ICD_485_Description='#txtsurgical#', Assessment_New.Surgical_ICD_Date_485=#CreateODBCDate(dateass2)#, Assessment_New.Surgical_ICD_Date_485= null, Assessment_New.Overall_Prognosis_M0260='#bedmobility1#', Assessment_New.Transferring_M0690p='#bedmobility2#', Assessment_New.Life_Exp_M0280='#bedmobility3#', Assessment_New.High_Risk_Factors_M0290='#bedmobility4#', Assessment_New.Vision_M0390='#bedmobility5#', Assessment_New.Hearing_M0400='#transfers1#', Assessment_New.Speech_M0410='#transfers2#', Assessment_New.Freq_of_Pain_M0420='#transfers3#', Assessment_New.Intrac_Pain_M0430='#transfers4#', Assessment_New.Open_Wounds_M0440='#transfers5#', Assessment_New.Pressure_Ulcer_M0445='#transfers6#', Assessment_New.Pressure_Ulcer_a_M0450='#sittings#', Assessment_New.Pressure_Ulcer_b_M0450='#standings#', Assessment_New.Pressure_Ulcer_c_M0450='#txtbergscore#', Assessment_New.Pressure_Ulcer_d_M0450='#txttinettiscore#', Assessment_New.Pressure_Ulcer_e_M0450='#gaitsurface#', Assessment_New.Pressure_Ulcer_Stage_M0460='#distance#', Assessment_New.HHRG_825_Score='#drpStage2#', Assessment_New.Pressure_Ulcer_Status_M0464='#hdnmuscle1#', Assessment_New.Stasis_Ulcer_M0468='#hdnmuscle2#', Assessment_New.Stasis_Ulcer_Num_M0470='#hdnmuscle3#', Assessment_New.Stasis_Ulcer_Hidden_M0474='#hdnmuscle4#', Assessment_New.Stasis_Ulcer_Status_M0476='#hdnmuscle5#', Assessment_New.Surgical_Wound_M0482='#hdnmuscle6#', Assessment_New.Surgical_Wound_Hidden_M0486='#elbow#', Assessment_New.Breathing_M0490='#Forearm#', Assessment_New.UTI_M0510='#Wrist#', Assessment_New.Urinary_INcont_when_M0530='#Shoulder#', Assessment_New.Ostomy_for_Bowel_M0550='#Hip#', Assessment_New.When_Confused_M0570='#Knee#', Assessment_New.Depressive_Feelings_M0590='#Ankel#', Assessment_New.Patient_Behav_freq_M0620='#CervicalSpine#', Assessment_New.Psy_Nursing_M0630='#painlevel#', Assessment_New.Grooming_M0640='#painchare1#', Assessment_New.Grooming_M0640p='#painthers#', Assessment_New.Dress_Upper_M0650='#ratecurrent#', Assessment_New.Dress_Upper_M0650p='#howlong#', Assessment_New.Dress_Lower_M0660='#chkwhatis1#', Assessment_New.Dress_Lower_M0660p='#Shortness#', Assessment_New.Bathing_M0670='#chkjoints#', Assessment_New.Bathing_M0670p='#chkadaptive#', Assessment_New.Toileting_M0680='#resonwhy#', Assessment_New.Toileting_M0680p='#gassessment10#', Assessment_New.Rehab_Prognosis_M0270='#potential#', Assessment_note='#Comments#', AssessmentType_New = 1, Admission_Status = 'Complete' AssessmentType_New = 0, Admission_Status = 'In Progress' 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#') 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 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#