UPDATE #Request.prefix_db_agency#.Assessment_New SET Ambulation_M0700 ='#Ambulation_M0700#', Ambulation_M0700p = '#Ambulation_M0700p#', After_Discharge_Services_M0880 ='#After_Discharge_Services_M0880#', Bowel_Incont_M0540 = '#Bowel_Incont_M0540#', Therapies_Home_M0250 = '#Therapies_Home_M0250#' , Assessment_note = '#Comments#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET Hearing_M0400 ='#Hearing_M0400#', Speech_M0410 = '#Speech_M0410#', Freq_of_Pain_M0420 = '#Freq_of_Pain_M0420#', Assessment_note = '#Comments#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET Intrac_Pain_M0430 ='#Intrac_Pain_M0430#', Pressure_Ulcer_M0445 = '#Pressure_Ulcer_M0445#', Open_Wounds_M0440 = '#Open_Wounds_M0440#', Assessment_note = '#Comments#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET Overall_Prognosis_M0260 ='#Overall_Prognosis_M0260#', Transferring_M0690p = '#Transferring_M0690p#', Life_Exp_M0280 = '#Life_Exp_M0280#', High_Risk_Factors_M0290 = '#High_Risk_Factors_M0290#', Vision_M0390 = '#Vision_M0390#', Assessment_note = '#Comments#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET Pressure_Ulcer_a_M0450 ='#Pressure_Ulcer_a_M0450#', Pressure_Ulcer_b_M0450 = '#Pressure_Ulcer_b_M0450#', Pressure_Ulcer_e_M0450 = '#Pressure_Ulcer_e_M0450#', Pressure_Ulcer_Stage_M0460 = '#Pressure_Ulcer_Stage_M0460#', Assessment_note = '#Comments#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET Pressure_Ulcer_c_M0450 = '#Pressure_Ulcer_c_M0450#', Pressure_Ulcer_d_M0450 = '#Pressure_Ulcer_d_M0450#', Inject_Meds_m0800p = '#Inject_Meds_m0800p#', Pressure_Ulcer_Status_M0464 ='#Pressure_Ulcer_Status_M0464#', Breathing_M0490 ='#Breathing_M0490#', Stasis_Ulcer_Num_M0470 ='#Stasis_Ulcer_Num_M0470#', Stasis_Ulcer_Hidden_M0474 ='#Stasis_Ulcer_Hidden_M0474#', Stasis_Ulcer_Status_M0476 ='#Stasis_Ulcer_Status_M0476#', Surgical_Wound_M0482 ='#Surgical_Wound_M0482#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET Caregiver_Manage_Equip_M0820 = '#GetToken(Arr_Elbow, 1, ',')#',null, Cog_Function_M0560 = '#GetToken(Arr_Elbow, 2, ',')#',null, Conditions_Prior_M0220 = '#GetToken(Arr_Elbow, 3, ',')#',null, Depressive_Feelings_M0590 = '#GetToken(Arr_Elbow, 4, ',')#',null, Discharge_Disposition_M0870 = '#GetToken(Arr_Elbow, 5, ',')#',null, Eating_M0710 = '#GetToken(Arr_Elbow, 6, ',')#',null, Eating_M0710p = '#GetToken(Arr_Elbow, 7, ',')#',null, Emergent_Care_M0830 = '#GetToken(Arr_Elbow, 8, ',')#',null, Emergent_Care_Reason_M0840 = '#GetToken(Arr_Elbow, 9, ',')#',null, Endocrine_Assess = '#GetToken(Arr_Elbow, 10, ',')#',null, Home_Safety_Assess = '#GetToken(Arr_Elbow, 11, ',')#', null, Hospice_Assess = '#GetToken(Arr_Elbow, 12, ',')#',null, Hospital_Reason_List_M0895 = '#GetToken(Arr_Elbow, 13, ',')#',null, Hospital_Reason_M0890 = '#GetToken(Arr_Elbow, 14, ',')#',null, Housekeeping_M0750 = '#GetToken(Arr_Elbow, 15, ',')#',null, Housekeeping_M0750p = '#GetToken(Arr_Elbow, 16, ',')#',null, Inhalant_Meds_M0790 = '#GetToken(Arr_Shoulder, 1, ',')#',null, Inhalant_Meds_M0790p = '#GetToken(Arr_Shoulder, 2, ',')#',null, Inject_Meds_M0800 = '#GetToken(Arr_Shoulder, 3, ',')#',null, Inpatient_Facility_M0855 = '#GetToken(Arr_Shoulder, 4, ',')#',null, Laundry_M0740 = '#GetToken(Arr_Shoulder, 5, ',')#',null, Laundry_M0740p = '#GetToken(Arr_Shoulder, 6, ',')#',null, M0250_Assess = '#GetToken(Arr_Shoulder, 7, ',')#',null, M0420_Assess = '#GetToken(Arr_Shoulder, 8, ',')#',null, M0440_Assess = '#GetToken(Arr_Hip, 1, ',')#',null, M0490_Assess = '#GetToken(Arr_Hip, 2, ',')#',null, M0520_Assess = '#GetToken(Arr_Hip, 3, ',')#',null, M0540_Assess = '#GetToken(Arr_Hip, 4, ',')#',null, M0550_Assess = '#GetToken(Arr_Hip, 5, ',')#',null, M0610_Assess = '#GetToken(Arr_Hip, 6, ',')#',null, M0650_Assess = '#GetToken(Arr_Hip, 7, ',')#',null, M0810_Assess = '#GetToken(Arr_Hip, 8, ',')#',null, Meal_Prep_M0720 = '#GetToken(Arr_Hip, 9, ',')#',null, Meal_Prep_M0720p = '#GetToken(Arr_Hip, 10, ',')#',null, Medical_or_Treatment_Change_M0200 = '#GetToken(Arr_Hip, 11, ',')#',null, Nursing_Home_M0900 = '#GetToken(Arr_Hip, 12, ',')#',null, Oral_Meds_M0780 = '#GetToken(Arr_Hip, 13, ',')#',null, Oral_Meds_M0780p = '#GetToken(Arr_Hip, 14, ',')#',null, Ostomy_for_Bowel_M0550 = '#GetToken(Arr_Hip, 15, ',')#',null, Patient_Behav_freq_M0620 = '#GetToken(Arr_Hip, 16, ',')#',null, Patient_Behav_Weekly_M0610 = '#GetToken(Arr_Knee, 1, ',')#',null, Patient_Manage_Equip_M0810 = '#GetToken(Arr_Knee, 2, ',')#',null, Resp_Treatments_M0500 = '#GetToken(Arr_Knee, 3, ',')#',null, Shopping_M0760 = '#GetToken(Arr_Knee, 4, ',')#',null, Shopping_M0760p = '#GetToken(Arr_Knee, 5, ',')#',null, Stasis_Ulcer_M0468 = '#GetToken(Arr_Knee, 6, ',')#',null, Surgical_Wound_Hidden_M0486 = '#GetToken(Arr_Knee, 7, ',')#',null, Surgical_Wound_OB_M0484 = '#GetToken(Arr_Knee, 8, ',')#',null, Surgical_Wound_Status_M0488 = '#GetToken(Arr_Ankle, 1, ',')#',null, Therapy_Need_M0825 = '#GetToken(Arr_Ankle, 2, ',')#',null, Toileting_M0680p = '#GetToken(Arr_Ankle, 3, ',')#',null, Transferring_M0690 = '#GetToken(Arr_Ankle, 4, ',')#',null, Transport_M0730 = '#GetToken(Arr_Ankle, 5, ',')#',null, Transport_M0730p = '#GetToken(Arr_Ankle, 6, ',')#',null, Urinary_INcont_M0520 = '#GetToken(Arr_Ankle, 7, ',')#',null, Urinary_INcont_when_M0530 = '#GetToken(Arr_Ankle, 8, ',')#',null, Use_Phone_M0770 = '#GetToken(Cervical_Spine, 1, ',')#',null, Use_Phone_M0770p = '#GetToken(Cervical_Spine, 2, ',')#',null, UTI_M0510 = '#GetToken(Cervical_Spine, 3, ',')#',null, When_Anxious_M0580 = '#GetToken(Cervical_Spine, 4, ',')#',null, Assessment_note = '#M0250_Assess#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET Dress_Lower_M0660p ='#Dress_Lower_M0660p#', Bathing_M0670 = '#Bathing_M0670#', When_Confused_M0570 = '#When_Confused_M0570#', Discharged_From_M0175 = '#Discharged_From_M0175#', Assessment_note = '#M0440_Assess#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET Bathing_M0670p ='#Bathing_M0670p#', Toileting_M0680 = '#Toileting_M0680#', Rehab_Prognosis_M0270 = '#Rehab_Prognosis_M0270#', AssessmentType_New = '#AssessmentType_New#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET Bathing_M0670p ='#Bathing_M0670p#', Toileting_M0680 = '#Toileting_M0680#', Rehab_Prognosis_M0270 = '#Rehab_Prognosis_M0270#', Admission_Status='Complete', AssessmentType_New = '#AssessmentType_New#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET Psy_Nursing_M0630 ='#Psy_Nursing_M0630#', Grooming_M0640 = '#Grooming_M0640#', Grooming_M0640p ='#Grooming_M0640p#', Dress_Upper_M0650 = '#Dress_Upper_M0650#', Dress_Upper_M0650p ='#Dress_Upper_M0650p#' 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 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,M0230_Link) VALUES ('#session.cs.AssessmentId#','#AssID.Assessment_Tracker_ID#','#AssID.Patient_ID#','#session.AgencyLogin#', '#M1010fetch.Diagnosis#','#vcode#','#M1010fetch.Code_Type#','#Replace(M1010fetch.Pathway_Type, "'", '', 'ALL')#', '#M1010fetch.Short_Diagnosis#','#vcode#','#m02301#','#count#','#session.cs.AssessmentId# M0230') 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,M0230_Link) VALUES ('#session.cs.AssessmentId#','#AssID.Assessment_Tracker_ID#','#AssID.Patient_ID#','#session.AgencyLogin#', '#M1010fetch.Diagnosis#','#M1010fetchICD#','#M1010fetch.Code_Type#','#Replace(M1010fetch.Pathway_Type, "'", '', 'ALL')#', '#M1010fetch.Short_Diagnosis#','#M1010fetchICD#','#m02301#','#count#','#session.cs.AssessmentId# M0230') select Dx_Order from #Request.prefix_db_agency#.Diagnosis where assessment_id=#session.cs.AssessmentId# select ICD from #Request.prefix_db_agency#.Diagnosis where assessment_id=#session.cs.AssessmentId# and Dx_Order ='#setscore.Dx_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# 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# 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