UPDATE #Request.prefix_db_agency#.Assessment_New SET M0110 = '#M0110#', Discharged_From_M0175 = '#NF#', M1000_Other = '#txtM1000#', Assessment_note='#Comments#', Strengths='#Strengths#', Goals='#Goals#', Care_Preference='#Care_Preference#', Risk_Factor='#Risk_Factor#', Interventions='#Interventions#', Inpatient_Discharge_Date_M0180 = #CreateODBCDate(dtM1005)#, Inpatient_Discharge_Date_M0180 = NULL, Inpatient_Discharge_Date_NA_M0180 = '#chuk#' WHERE Assessment_ID = '#session.cs.AssessmentId#' update #Request.prefix_db_agency#.Assessment_New set HHRG_175_Score="",HHRG_230_Score="",HHRG_250_Score="",HHRG_390_Score="",HHRG_420_Score="",HHRG_440_Score="" where assessment_id=#session.cs.AssessmentId# UPDATE #Request.prefix_db_agency#.Diagnosis SET Dx_Order = '#Order#' WHERE Diagnosis.Assessment_ID=#session.cs.AssessmentId# and Diagnosis_ID=#UpdateID# select ICD from #Request.prefix_db_agency#.Diagnosis where assessment_id=#session.cs.AssessmentId# and Dx_Order = '#Order#' update #Request.prefix_db_agency#.Assessment_New set HHRG_175_Score ='#geticd.ICD#' where assessment_id=#session.cs.AssessmentId# update #Request.prefix_db_agency#.Assessment_New set HHRG_230_Score ='#geticd.ICD#' where assessment_id=#session.cs.AssessmentId# update #Request.prefix_db_agency#.Assessment_New set HHRG_250_Score ='#geticd.ICD#' where assessment_id=#session.cs.AssessmentId# update #Request.prefix_db_agency#.Assessment_New set HHRG_390_Score ='#geticd.ICD#' where assessment_id=#session.cs.AssessmentId# update #Request.prefix_db_agency#.Assessment_New set HHRG_420_Score ='#geticd.ICD#' where assessment_id=#session.cs.AssessmentId# update #Request.prefix_db_agency#.Assessment_New set HHRG_440_Score ='#geticd.ICD#' where assessment_id=#session.cs.AssessmentId# UPDATE #Request.prefix_db_agency#.Assessment_New SET M1012_Inpat_DX_NA = '#chkM1012NA#', M1012_Inpat_DX_UK = '#chkM1012UK#', Assessment_note='#Comments#', Strengths='#Strengths#', Goals='#Goals#', Care_Preference='#Care_Preference#', Risk_Factor='#Risk_Factor#', Interventions='#Interventions#', M1016_DX_NA = '#chkM1016NA#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Diagnosis SET Dx_Order = '#Order#' WHERE Diagnosis.Assessment_ID=#session.cs.AssessmentId# and Diagnosis_ID=#UpdateID# UPDATE #Request.prefix_db_agency#.Diagnosis SET Dx_Order = '#Order#' WHERE Diagnosis.Assessment_ID=#session.cs.AssessmentId# and Diagnosis_ID=#UpdateID# UPDATE #Request.prefix_db_agency#.Assessment_New SET Conditions_Prior_M0220 = '#UN#', Assessment_note='#Comments#', Strengths='#Strengths#', Goals='#Goals#', Care_Preference='#Care_Preference#', Risk_Factor='#Risk_Factor#', Interventions='#Interventions#', control_infection='#control_infection#', prevention='#prevention#', antibiotics='#antibiotics#', Home_Safety_Assess = '#HO#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET M0250_Assess = '#CO#', Assessment_note='#Comments#', Strengths='#Strengths#', Goals='#Goals#', Care_Preference='#Care_Preference#', Risk_Factor='#Risk_Factor#', Interventions='#Interventions#', M1028_diagnosis = '#M1028#', Endocrine_Assess = '#CFZ#' 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 Assessment_ID ='#session.cs.AssessmentId#' and Diagnosis_ID ='#Id#' UPDATE #Request.prefix_db_agency#.Assessment_New SET Therapies_Home_M0250 = '#CI#', M1032_Frailty = '#CR#', Rehab_Prognosis_M0270 = '#drpM1034#', M1060_height = '#M1060_height#', M1060_weight = '#M1060_weight#', Assessment_note='#Comments#', Strengths='#Strengths#', Goals='#Goals#', Care_Preference='#Care_Preference#', Risk_Factor='#Risk_Factor#', Interventions='#Interventions#', High_Risk_Factors_M0290 = '#CHS#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET Vision_M0390 = '#drpM1200#', Hearing_M0400 = '#drpM1210#', M1220_Verbal_Under = '#drpM1220#', Assessment_note='#Comments#', Strengths='#Strengths#', Goals='#Goals#', Care_Preference='#Care_Preference#', Risk_Factor='#Risk_Factor#', Interventions='#Interventions#', Speech_M0410 = '#drpM1230#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET M1240_Pain_Assess = '#Ono#', Freq_of_Pain_M0420 = '#drpM1242#', SOC_420 = '#soc420#', Assessment_note='#Comments#', Strengths='#Strengths#', Goals='#Goals#', Care_Preference='#Care_Preference#', Risk_Factor='#Risk_Factor#', Interventions='#Interventions#', M0440_Assess = '#CO#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET M1300_Pressure = '#drpM1300#', M1302_Pressure = '#Opressure#', Assessment_note='#Comments#', Strengths='#Strengths#', Goals='#Goals#', Care_Preference='#Care_Preference#', Risk_Factor='#Risk_Factor#', Interventions='#Interventions#', M1306_Unhealed_Pressure = '#Ounhealed#' 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 = '#drpdlUnstage#', M1308_d_2_Pressure = '#drpd2UnStage#', Assessment_note='#Comments#', Strengths='#Strengths#', Goals='#Goals#', Care_Preference='#Care_Preference#', Risk_Factor='#Risk_Factor#', Interventions='#Interventions#', M1308_d_3_Pressure = '#drpd3UnStage#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET Pressure_Ulcer_Status_M0464 = '#Oulcerpressure#', Pressure_Ulcer_a_M0450 = '#M0450#', Assessment_note='#Comments#', Strengths='#Strengths#', Goals='#Goals#', Care_Preference='#Care_Preference#', Risk_Factor='#Risk_Factor#', Interventions='#Interventions#', Pressure_Ulcer_Stage_M0460 = '#M0460#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET Stasis_Ulcer_M0468 = '#drpM1330#', Stasis_Ulcer_Num_M0470 = '#radzero#', Stasis_Ulcer_Status_M0476 = '#radNewly#', Surgical_Wound_M0482 = '#drpM1340#', Surgical_Wound_Status_M0488 = '#radSurgicalNewly#', SOC_520 = '#soc520#', Assessment_note='#Comments#', Strengths='#Strengths#', Goals='#Goals#', Care_Preference='#Care_Preference#', Risk_Factor='#Risk_Factor#', Interventions='#Interventions#', M1350_Other_Wounds = '#radNo#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET Breathing_M0490 = '#radBreath#', SOC_490 = '#soc490#', Resp_Treatments_M0500 = '#CO#', Assessment_note='#Comments#', Strengths='#Strengths#', Goals='#Goals#', Care_Preference='#Care_Preference#', Risk_Factor='#Risk_Factor#', Interventions='#Interventions#', M0490_Assess = '#CD#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET M0520_Assess = '#CUU#', M0540_Assess = '#CBB#', M0550_Assess = '#CFF#', Urinary_INcont_M0520 = '#drpM1610#', Ostomy_for_Bowel_M0550 = '#drpM1630#', UTI_M0510 = '#radM1600NO#', Urinary_INcont_when_M0530 = '#radTimedvoiding#', Assessment_note='#Comments#', Strengths='#Strengths#', Goals='#Goals#', Care_Preference='#Care_Preference#', Risk_Factor='#Risk_Factor#', Interventions='#Interventions#', Bowel_Incont_M0540 = '#radVeryrarely#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET civil_status = '#civil_status#', concerns_issue = '#concerns_issue#', psychiatric_issue = '#psychiatric_issue#', stress_issue = '#stress_issue#', drug_problems = '#drug_problems#', Cog_Function_M0560 = '#drpM1700#', When_Confused_M0570 = '#radM1710Never#', When_Anxious_M0580 = '#radM1720Never#', M1730_Depression = '#drpM1730#', M1730a = '#radLittleNotatall#', Assessment_note='#Comments#', Strengths='#Strengths#', Goals='#Goals#', Care_Preference='#Care_Preference#', Risk_Factor='#Risk_Factor#', Interventions='#Interventions#', M1730b = '#radNotatall#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET M0610_Assess = '#CP#', Patient_Behav_Weekly_M0610 = '#CM#', Patient_Behav_freq_M0620 = '#radM1745Never#', Assessment_note='#Comments#', Strengths='#Strengths#', Goals='#Goals#', Care_Preference='#Care_Preference#', Risk_Factor='#Risk_Factor#', Interventions='#Interventions#', Psy_Nursing_M0630 = '#radM1750Never#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET M0650_Assess = '#CT#', Inhalant_Meds_M0790p = '#drptug1#', Grooming_M0640 = '#drpM1800#', Dress_Upper_M0650 = '#drpM1810#', Dress_Lower_M0660 = '#drpM1820#', Bathing_M0670 = '#drpM1830#', SOC_680 = '#soc680#', M1840_Toilet = '#drpM1840#', Assessment_note='#Comments#', Strengths='#Strengths#', Goals='#Goals#', Care_Preference='#Care_Preference#', Risk_Factor='#Risk_Factor#', Interventions='#Interventions#', M1845_Toilet = '#drpM1845#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE IGNORE #Request.prefix_db_agency#.Assessment_New SET Transferring_M0690 = '#drpM1850#', SOC_690 = '#soc690#', CGO170C_1_Mobility='#CGO170C_1_Mobility#', CGO170C_2_Mobility='#CGO170C_2_Mobility#', Inhalant_Meds_M0790p = '#drptug1#', Ambulation_M0700 = '#drpM1860#', SOC_700 = '#soc700#', Eating_M0710 = '#drpM1870#', Meal_Prep_M0720 = '#drpM1880#', Assessment_note='#Comments#', Strengths='#Strengths#', Goals='#Goals#', Care_Preference='#Care_Preference#', Risk_Factor='#Risk_Factor#', Interventions='#Interventions#', Use_Phone_M0770 = '#drpM1890#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET M1900a_SelfCare = '#rdnSelf#', Inhalant_Meds_M0790p = '#drptug1#', M1900b_Amb = '#rdnAmbulation#', M1900c_Transfer = '#rdnTransfer#', M1900d_House = '#rdnHouseHold#', Assessment_note='#Comments#', Strengths='#Strengths#', Goals='#Goals#', Care_Preference='#Care_Preference#', Risk_Factor='#Risk_Factor#', Interventions='#Interventions#', M1910_Fall_Risk = '#rdnM1910#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET M2000_Adverse = '#rdnM2000#', M2002_Med_FU = '#rdnM2002#', M2010_Med_Edu = '#drpM2010#', Oral_Meds_M0780 = '#drpM2020#', SOC_780 = '#soc780#', Inject_Meds_M0800 = '#drpM2030#', Oral_Meds_M0780p = '#rdnOral#', Assessment_note='#Comments#', Strengths='#Strengths#', Goals='#Goals#', Care_Preference='#Care_Preference#', Risk_Factor='#Risk_Factor#', Interventions='#Interventions#', Inject_Meds_m0800p = '#rdnInject#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET M2100a_Equip = '#rdnADL#', M2100b_Equip = '#rdnIADL#', M2100c_Equip = '#rdnMedAdmin#', M2100d_Equip = '#rdnMedtreatment#', M2100e_Equip = '#rdnEquipMgt#', M2100f_Equip = '#rdnSupervision#', M2100g_Equip = '#rdnAdvocacy#', Assessment_note='#Comments#', Strengths='#Strengths#', Goals='#Goals#', Care_Preference='#Care_Preference#', Risk_Factor='#Risk_Factor#', Interventions='#Interventions#', M2110_Assist_Freq = '#rdnM2110#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET M0063_Pattern ='#careplan#', M2250a_PhysNot = '#rdnSpecific#', M2250b_Diabetic = '#rdnDiabetic#', M2250c_FallsPrev = '#rdnFalls#', M2250d_Depress = '#rdnDepression#', M2250e_Pain = '#rdnPain#', M2250f_PressUlc = '#rdnPressure#', M2250g_PressUlcMoist = '#rdnMoist#', M0826_Ther_Need = '#txtTher#', Assessment_Completed_M0090 = #CreateODBCDate(dateass)#, Assessment_note='#Comments#', Strengths='#Strengths#', Goals='#Goals#', Care_Preference='#Care_Preference#', Risk_Factor='#Risk_Factor#', Interventions='#Interventions#', M0826_NA = '#chkNA#', AssessmentType_New = 1, Admission_Status='Complete', Waiting_For_Eval = '#chkWait#' WHERE Assessment_ID = '#session.cs.AssessmentId#' Select Assessment_Tracker_ID,Patient_ID,Agency_ID,Assessment_Completed_M0090 From #Request.prefix_db_agency#.Assessment_New where Assessment_ID='#session.cs.AssessmentId#' INSERT INTO #Request.prefix_db_agency#.Pathway_Details(Agency_ID,Patient_ID,Assessment_Tracker_ID,Assessment_ID,Skill,Description) VALUES('#AssID.Agency_ID#','#AssID.Patient_ID#', '#AssID.Assessment_Tracker_ID#','#session.cs.AssessmentId#', '#Skill#','#Desc#') update #Request.prefix_db_agency#.Assessment_New set HHRG_175_Score="",HHRG_230_Score="",HHRG_250_Score="",HHRG_390_Score="",HHRG_420_Score="",HHRG_440_Score="" where assessment_id=#session.cs.AssessmentId# UPDATE #Request.prefix_db_agency#.Diagnosis SET Dx_Order = '#Order#' WHERE Diagnosis.Assessment_ID=#session.cs.AssessmentId# and Diagnosis_ID=#UpdateID# select ICD from #Request.prefix_db_agency#.Diagnosis where assessment_id=#session.cs.AssessmentId# and Dx_Order = '#Order#' update #Request.prefix_db_agency#.Assessment_New set HHRG_175_Score ='#geticd.ICD#' where assessment_id=#session.cs.AssessmentId# update #Request.prefix_db_agency#.Assessment_New set HHRG_230_Score ='#geticd.ICD#' where assessment_id=#session.cs.AssessmentId# update #Request.prefix_db_agency#.Assessment_New set HHRG_250_Score ='#geticd.ICD#' where assessment_id=#session.cs.AssessmentId# update #Request.prefix_db_agency#.Assessment_New set HHRG_390_Score ='#geticd.ICD#' where assessment_id=#session.cs.AssessmentId# update #Request.prefix_db_agency#.Assessment_New set HHRG_420_Score ='#geticd.ICD#' where assessment_id=#session.cs.AssessmentId# update #Request.prefix_db_agency#.Assessment_New set HHRG_440_Score ='#geticd.ICD#' where assessment_id=#session.cs.AssessmentId# UPDATE #Request.prefix_db_agency#.Diagnosis SET Dx_Order = '#Order#' WHERE Diagnosis.Assessment_ID=#session.cs.AssessmentId# and Diagnosis_ID=#UpdateID# UPDATE #Request.prefix_db_agency#.Diagnosis SET Dx_Order = '#Order#' WHERE Diagnosis.Assessment_ID=#session.cs.AssessmentId# and Diagnosis_ID=#UpdateID# UPDATE #Request.prefix_db_agency#.Diagnosis SET Severity = '#severity#', Primary_Diagnosis = '#primary#', Secondary_Diagnosis = '#secondary#', Dx_Order = '#dxorder#' where Assessment_ID = '#session.cs.AssessmentId#' and Diagnosis_ID = '#Id#' 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(DISTINCT Pathway_Details_ID) 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 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#' UPDATE #Request.prefix_db_agency#.Assessment_New SET Fall_A='#Fall_A#', Fall_B='#Fall_B#', Fall_C='#Fall_C#', Fall_D='#Fall_D#', Fall_E='#Fall_E#', Fall_F='#Fall_F#', Fall_G='#Fall_G#', Fall_H='#Fall_H#', Fall_I='#Fall_I#' Where Assessment_New.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 from #Request.prefix_db_lookup#.Dx_list_ICD10 WHERE Dx_list_ICD10.id=#DiagnosisID# select Diagnosis,ICD,Code_Type,Pathway_Type,Short_Diagnosis from #Request.prefix_db_lookup#.diagnosis_list WHERE diagnosis_list.id=#DiagnosisID# ---> select Count(Diagnosis.Diagnosis_ID) as M1010RecordCount from #Request.prefix_db_agency#.Diagnosis where Diagnosis.Assessment_ID='#session.cs.AssessmentId#' and Diagnosis.Diagnosis LIKE '%#M1010fetch.Diagnosis#%' and M0190_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,M0190_Link,Dx_Order) VALUES ('#session.cs.AssessmentId#','#AssID.Assessment_Tracker_ID#','#AssID.Patient_ID#','#AssID.Agency_ID#', '#M1010fetch.Diagnosis#','#vcode#','#M1010fetch.Code_Type#','#M1010fetch.Pathway_Type#', '#M1010fetch.Short_Diagnosis#','#vcode#','#m02301#','#count#') 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, M0190_Link, Dx_Order ) VALUES ('#session.cs.AssessmentId#', '#AssID.Assessment_Tracker_ID#', '#AssID.Patient_ID#', '#AssID.Agency_ID#', '#M1010fetch.Diagnosis#', '#M1010fetchICD#', '#M1010fetch.Code_Type#', '#M1010fetch.Pathway_Type#', '#M1010fetch.Short_Diagnosis#', '#M1010fetchICD#', '#m02301#', '#count#' ) SELECT LAST_INSERT_ID() as LastInsertID UPDATE #Request.prefix_db_agency#.Diagnosis SET ICD10 = 1 WHERE Diagnosis_ID =#Last_Invoice_ID.LastInsertID# Select Assessment_Tracker_ID,Patient_ID,Agency_ID From #Request.prefix_db_agency#.Assessment_New where Assessment_ID= '#session.cs.AssessmentId#' select s.id,s.CPT,s.Procedure,s.Short_Procedure from #Request.prefix_db_lookup#.surgical_codes s where id=#DiagnosisID# select Count(Diagnosis.Diagnosis_ID) as M1012RecordCount from #Request.prefix_db_agency#.Diagnosis where Diagnosis.Assessment_ID='#session.cs.AssessmentId#' and Diagnosis.Diagnosis LIKE '%#M1012fetch.Procedure#%' and M1012_Link LIKE '%#m02301#%' SELECT Assessment_Completed_M0090 FROM #Request.prefix_db_agency#.Assessment_New where Assessment_ID = '#session.cs.AssessmentId#' INSERT INTO #Request.prefix_db_agency#.Diagnosis (Assessment_ID, Assessment_Tracker_ID, Patient_ID, Agency_ID, Diagnosis,ICD, Code_Type,Text_ICD,M1012_Link,Dx_Order) VALUES ('#session.cs.AssessmentId#', '#AssID.Assessment_Tracker_ID#', '#AssID.Patient_ID#', '#AssID.Agency_ID#', '#M1012fetch.Procedure#', '#M1012fetch.CPT#', 'CPT','#M1012fetch.CPT#','#m02301#','#count#') SELECT LAST_INSERT_ID() as LastInsertID UPDATE #Request.prefix_db_agency#.Diagnosis SET ICD10 = 1 WHERE Diagnosis_ID =#Last_Invoice_ID.LastInsertID# 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 from #Request.prefix_db_lookup#.Dx_list_ICD10 WHERE Dx_list_ICD10.id=#DiagnosisID# select Diagnosis,ICD,Code_Type,Pathway_Type,Short_Diagnosis from #Request.prefix_db_lookup#.diagnosis_list WHERE diagnosis_list.id=#DiagnosisID# select Count(Diagnosis.Diagnosis_ID) as M1016RecordCount from #Request.prefix_db_agency#.Diagnosis where Diagnosis.Assessment_ID='#session.cs.AssessmentId#' and Diagnosis.Diagnosis LIKE '%#M1016fetch.Diagnosis#%' and M0210_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,M0210_Link,Dx_Order) VALUES ('#session.cs.AssessmentId#','#AssID.Assessment_Tracker_ID#','#AssID.Patient_ID#','#AssID.Agency_ID#', '#M1016fetch.Diagnosis#','#vcode#','#M1016fetch.Code_Type#','#M1016fetch.Pathway_Type#', '#M1016fetch.Short_Diagnosis#','#vcode#','#m02301#','#count#') 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,M0210_Link,Dx_Order) VALUES ('#session.cs.AssessmentId#','#AssID.Assessment_Tracker_ID#','#AssID.Patient_ID#','#AssID.Agency_ID#', '#M1016fetch.Diagnosis#','#M1010fetchICD_1#','#M1016fetch.Code_Type#','#M1016fetch.Pathway_Type#', '#M1016fetch.Short_Diagnosis#','#M1010fetchICD_1#','#m02301#','#count#') SELECT LAST_INSERT_ID() as LastInsertID UPDATE #Request.prefix_db_agency#.Diagnosis SET ICD10 = 1 WHERE Diagnosis_ID =#Last_Invoice_ID.LastInsertID# 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,M0245a_Diagnosis,M0245_ICD) VALUES ('#session.cs.AssessmentId#','#AssID.Assessment_Tracker_ID#','#AssID.Patient_ID#', '#AssID.Agency_ID#','#M0230fetch.Diagnosis#','#M0230fetchICD#','#M0230fetch.Code_Type#','#M0230fetch.Pathway_Type#', '#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#', '#AssID.Agency_ID#', '#M0230fetch.Diagnosis#', '#M0230fetchICD#', '#M0230fetch.Code_Type#', '#M0230fetch.Pathway_Type#', '#M0230fetch.Short_Diagnosis#', '#M0230fetchICD#', '#m02301#', '#M0230Severity#', '#M0230Primary#', '#M0230Secondary#', '1', '#M0230fetch.Other_DG#' ,'#vcodediag#' ,'#vcodeicd#' ) SELECT LAST_INSERT_ID() as LastInsertID UPDATE #Request.prefix_db_agency#.Diagnosis SET ICD10 = 1 WHERE Diagnosis_ID =#Last_Invoice_ID.LastInsertID# 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 Dx_Order = '#Order#' WHERE Diagnosis.Assessment_ID=#session.cs.AssessmentId# and Diagnosis_ID=#UpdateID# select ICD from #Request.prefix_db_agency#.Diagnosis where assessment_id=#session.cs.AssessmentId# and Dx_Order = '#Order#' update #Request.prefix_db_agency#.Assessment_New set HHRG_175_Score ='#geticd.ICD#' where assessment_id=#session.cs.AssessmentId# update #Request.prefix_db_agency#.Assessment_New set HHRG_230_Score ='#geticd.ICD#' where assessment_id=#session.cs.AssessmentId# update #Request.prefix_db_agency#.Assessment_New set HHRG_250_Score ='#geticd.ICD#' where assessment_id=#session.cs.AssessmentId# update #Request.prefix_db_agency#.Assessment_New set HHRG_390_Score ='#geticd.ICD#' where assessment_id=#session.cs.AssessmentId# update #Request.prefix_db_agency#.Assessment_New set HHRG_420_Score ='#geticd.ICD#' where assessment_id=#session.cs.AssessmentId# update #Request.prefix_db_agency#.Assessment_New set HHRG_440_Score ='#geticd.ICD#' where assessment_id=#session.cs.AssessmentId# 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 Dx_Order = '#Order#' WHERE Diagnosis.Assessment_ID=#session.cs.AssessmentId# and Diagnosis_ID=#UpdateID# 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 Dx_Order = '#Order#' WHERE Diagnosis.Assessment_ID=#session.cs.AssessmentId# and Diagnosis_ID=#UpdateID# 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 Assessment_ID = '#session.cs.AssessmentId#' and Diagnosis_ID= '#Id#' delete from #Request.prefix_db_agency#.PatientVisitDetails where Progress_Details_ID='#WoundID#' SELECT count(DISTINCT Pathway_Details_ID) 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' 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#') 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#'