UPDATE #Request.prefix_db_agency#.Assessment_New SET Rehab_Prognosis_M0270 ='#Rehab_Prognosis_M0270#', Inpatient_Facility_M0855 = '#Inpatient_Facility_M0855#', M0250_Assess = '#M0250_Assess#', Assessment_note = '#Comments#' 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 Therapies_Home_M0250 ='#Therapies_Home_M0250#', Endocrine_Assess = '#Endocrine_Assess#', M0440_Assess = '#M0440_Assess#', Assessment_note = '#Comments#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET M0490_Assess ='#M0490_Assess#', M0520_Assess = '#M0520_Assess#', M0540_Assess = '#M0540_Assess#', M0550_Assess='#M0550_Assess#', Assessment_note = '#Comments#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET M0610_Assess ='#M0610_Assess#', Meal_Prep_M0720 = '#Meal_Prep_M0720#', Home_Safety_Assess='#Home_Safety_Assess#', M0810_Assess = '#M0810_Assess#', Assessment_note = '#Comments#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET Urinary_INcont_when_M0530 ='#Urinary_INcont_when_M0530#', Urinary_INcont_M0520 ='#Urinary_INcont_M0520#', Bowel_Incont_M0540 ='#Bowel_Incont_M0540#', Ostomy_for_Bowel_M0550 ='#Ostomy_for_Bowel_M0550#', Cog_Function_M0560 ='#Cog_Function_M0560#', When_Confused_M0570 ='#When_Confused_M0570#', When_Anxious_M0580 ='#When_Anxious_M0580#', Depressive_Feelings_M0590 ='#Depressive_Feelings_M0590#', Patient_Behav_Weekly_M0610 ='#Patient_Behav_Weekly_M0610#', Patient_Behav_freq_M0620 ='#Patient_Behav_freq_M0620#', 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#', Dress_Lower_M0660 ='#Dress_Lower_M0660#', Dress_Lower_M0660p ='#Dress_Lower_M0660p#', Bathing_M0670 ='#Bathing_M0670#', Bathing_M0670p ='#Bathing_M0670p#', Toileting_M0680 ='#Toileting_M0680#', Toileting_M0680p ='#Toileting_M0680p#', Transferring_M0690 ='#Transferring_M0690#', Transferring_M0690p ='#Transferring_M0690p#', Ambulation_M0700 ='#Ambulation_M0700#', Ambulation_M0700p ='#Ambulation_M0700p#', Eating_M0710 ='#Eating_M0710#', Eating_M0710p ='#Eating_M0710p#', Meal_Prep_M0720p ='#Meal_Prep_M0720p#', Transport_M0730 ='#Transport_M0730#', Transport_M0730p ='#Transport_M0730p#', Laundry_M0740 ='#Laundry_M0740#', Laundry_M0740p ='#Laundry_M0740p#', Housekeeping_M0750 ='#Housekeeping_M0750#', Housekeeping_M0750p ='#Housekeeping_M0750p#', Shopping_M0760 ='#Shopping_M0760#', Shopping_M0760p ='#Shopping_M0760p#', Use_Phone_M0770 ='#Use_Phone_M0770#', Use_Phone_M0770p ='#Use_Phone_M0770p#', Oral_Meds_M0780 ='#Oral_Meds_M0780#', Oral_Meds_M0780p ='#Oral_Meds_M0780p#', Inhalant_Meds_M0790 ='#Inhalant_Meds_M0790#', Inhalant_Meds_M0790p ='#Inhalant_Meds_M0790p#', Inject_Meds_M0800 ='#Inject_Meds_M0800#', Inject_Meds_m0800p ='#Inject_Meds_m0800p#', Patient_Manage_Equip_M0810 ='#Patient_Manage_Equip_M0810#', Caregiver_Manage_Equip_M0820 ='#Caregiver_Manage_Equip_M0820#', Therapy_Need_M0825 ='#Therapy_Need_M0825#', Emergent_Care_M0830 ='#Emergent_Care_M0830#', AssessmentType_New ='#Assessment_Type#' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET Urinary_INcont_when_M0530 ='#Urinary_INcont_when_M0530#', Urinary_INcont_M0520 ='#Urinary_INcont_M0520#', Bowel_Incont_M0540 ='#Bowel_Incont_M0540#', Ostomy_for_Bowel_M0550 ='#Ostomy_for_Bowel_M0550#', Cog_Function_M0560 ='#Cog_Function_M0560#', When_Confused_M0570 ='#When_Confused_M0570#', When_Anxious_M0580 ='#When_Anxious_M0580#', Depressive_Feelings_M0590 ='#Depressive_Feelings_M0590#', Patient_Behav_Weekly_M0610 ='#Patient_Behav_Weekly_M0610#', Patient_Behav_freq_M0620 ='#Patient_Behav_freq_M0620#', 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#', Dress_Lower_M0660 ='#Dress_Lower_M0660#', Dress_Lower_M0660p ='#Dress_Lower_M0660p#', Bathing_M0670 ='#Bathing_M0670#', Bathing_M0670p ='#Bathing_M0670p#', Toileting_M0680 ='#Toileting_M0680#', Toileting_M0680p ='#Toileting_M0680p#', Transferring_M0690 ='#Transferring_M0690#', Transferring_M0690p ='#Transferring_M0690p#', Ambulation_M0700 ='#Ambulation_M0700#', Ambulation_M0700p ='#Ambulation_M0700p#', Eating_M0710 ='#Eating_M0710#', Eating_M0710p ='#Eating_M0710p#', Meal_Prep_M0720p ='#Meal_Prep_M0720p#', Transport_M0730 ='#Transport_M0730#', Transport_M0730p ='#Transport_M0730p#', Laundry_M0740 ='#Laundry_M0740#', Laundry_M0740p ='#Laundry_M0740p#', Housekeeping_M0750 ='#Housekeeping_M0750#', Housekeeping_M0750p ='#Housekeeping_M0750p#', Shopping_M0760 ='#Shopping_M0760#', Shopping_M0760p ='#Shopping_M0760p#', Use_Phone_M0770 ='#Use_Phone_M0770#', Use_Phone_M0770p ='#Use_Phone_M0770p#', Oral_Meds_M0780 ='#Oral_Meds_M0780#', Oral_Meds_M0780p ='#Oral_Meds_M0780p#', Inhalant_Meds_M0790 ='#Inhalant_Meds_M0790#', Inhalant_Meds_M0790p ='#Inhalant_Meds_M0790p#', Inject_Meds_M0800 ='#Inject_Meds_M0800#', Inject_Meds_m0800p ='#Inject_Meds_m0800p#', Patient_Manage_Equip_M0810 ='#Patient_Manage_Equip_M0810#', Caregiver_Manage_Equip_M0820 ='#Caregiver_Manage_Equip_M0820#', Therapy_Need_M0825 ='#Therapy_Need_M0825#', Emergent_Care_M0830 ='#Emergent_Care_M0830#', AssessmentType_New ='#Assessment_Type#', Admission_Status='Complete' WHERE Assessment_ID = '#session.cs.AssessmentId#' UPDATE #Request.prefix_db_agency#.Assessment_New SET M0420_Assess ='#M0420_Assess#', Emergent_Care_M0830='#Emergent_Care_M0830#', Emergent_Care_Reason_M0840 = '#Emergent_Care_Reason_M0840#', Nursing_Home_M0900 ='#Nursing_Home_M0900#', Discharge_Disposition_M0870 = '#Discharge_Disposition_M0870#', Inpatient_Facility_M0855 ='#Inpatient_Facility_M0855#' 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 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# 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#