Update #Request.prefix_db_agency#.Diagnosis d, #Request.prefix_db_lookup#.Dx_list_ICD10_PDGM p set d.PDGM_Primary = p.PDGM, d.PDGM_Comorbidity = p.Comorbidity, d.PDGM_Subchapter = p.Subchapter where d.Assessment_ID = #Assessment_ID# and d.ICD = p.ICD select an.*, ds.ICD, ds.Diagnosis, ds.Severity, ds.M0230_Link, ds.Dx_Order, ds.DG_Usage, ds.Pathway_Type, ds.PDGM_Primary, ds.PDGM_Comorbidity, patient.Last_Name_M0040,patient.First_Name_M0040,patient.DOB_M0066,patient.Gender_M0069, patient.Patient_ID, vn.Level_1, vn.Level_2, vn.Level_3, vn.Level_4, vn.DG_Description, vn.Pathway, vn.Priority from #Request.prefix_db_agency#.Diagnosis ds LEFT OUTER JOIN #Request.prefix_db_lookup#.vetted_table vn on vn.ICD = ds.ICD JOIN #Request.prefix_db_agency#.Assessment_New an on an.Assessment_ID = ds.Assessment_ID JOIN #Request.prefix_db_agency#.patient on ds.Patient_ID = patient.Patient_ID where ds.patient_ID = #session.cs.patientid# AND an.Assessment_ID = '#Assessment_ID#' AND ds.M0230_Link like '%M0230%' AND ds.M0230_Link is not null AND ds.Disabled = 0 Update #Request.prefix_db_agency#.PatientMeds set Flag = '0' where Patient_ID = #session.cs.patientid# Delete from #Request.prefix_db_agency#.Coding_Results where Patient_ID = #session.cs.patientid# AND Assessment_ID = #Assessment_ID# INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Results (Assessment_ID,Patient_ID,Message_ID,M0_Item_Medication,Order_ID,Dx_Order,ICD,Diagnosis,Pathway_ID,OASIS,Medications,Casemix,Mani,TextField_1,TextField_2,Created_by,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#messageid#','(M1021)''(M1023)','#Priority#','#Dx_Order#','#ICD#','#Diagnosis#','#Pathway#','#OASIS#','#drugname#','#DG_Description#','#Severity#','#PDGM_Primary#','#PDGM_Comorbidity#','#Created_by#','#DateFormat(Now(),"yyyy-mm-dd")#') INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Results (Assessment_ID,Patient_ID,Message_ID,M0_Item_Medication,Order_ID,Dx_Order,ICD,Diagnosis,Pathway_ID,OASIS,Medications,Casemix,Mani,TextField_1,TextField_2,Created_by,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#messageid#','(M1021)''(M1023)','#Priority#','#Dx_Order#','#ICD#','#Diagnosis#','#Pathway#','#OASIS#','#drugname#','#DG_Description#','#Severity#','#PDGM_Primary#','#PDGM_Comorbidity#','#Created_by#','#DateFormat(Now(),"yyyy-mm-dd")#') INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Results (Assessment_ID,Patient_ID,Message_ID,M0_Item_Medication,Order_ID,Dx_Order,ICD,Diagnosis,Pathway_ID,OASIS,Medications,Casemix,Mani,TextField_1,TextField_2,Question_ID,Created_by,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#messageid#','(M1021)''(M1023)','#Priority#','#Dx_Order#','#ICD#','#Diagnosis#','#Pathway#','#OASIS#','#drugname#','#DG_Description#','#Severity#','#PDGM_Primary#','#PDGM_Comorbidity#','#Question_ID#','#Created_by#','#DateFormat(Now(),"yyyy-mm-dd")#') Update #Request.prefix_db_agency#.Diagnosis set DG_Usage = '#OASIS#' where Assessment_ID = #Assessment_ID# and ICD = '#ICD#' INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Results (Assessment_ID,Patient_ID,Message_ID,M0_Item_Medication,Order_ID,Dx_Order,ICD,Diagnosis,Pathway_ID,OASIS,Medications,Casemix,Mani,TextField_1,TextField_2,Created_by,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#messageid#','(M1021)''(M1023)','#Priority#','#Dx_Order#','#ICD#','#Diagnosis#','#Pathway#','#OASIS#','#drugname#','#DG_Description#','#Severity#','#PDGM_Primary#','#PDGM_Comorbidity#','#Created_by#','#DateFormat(Now(),"yyyy-mm-dd")#') select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Results (Assessment_ID,Patient_ID,Message_ID,M0_Item_Medication,Order_ID,Dx_Order,ICD,Diagnosis,Pathway_ID,OASIS,Medications,Casemix,Mani,TextField_1,TextField_2,Question_ID,Created_by,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#messageid#','(M1021)''(M1023)','#Priority#','#Dx_Order#','#ICD#','#Diagnosis#','#Pathway#','#OASIS#','#drugname#','#DG_Description#','#Severity#','#PDGM_Primary#','#PDGM_Comorbidity#','#Question_ID#','#Created_by#','#DateFormat(Now(),"yyyy-mm-dd")#') Update #Request.prefix_db_agency#.Diagnosis set DG_Usage = '#OASIS#' where Assessment_ID = #Assessment_ID# and ICD = '#ICD#' select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Results (Assessment_ID,Patient_ID,Message_ID,M0_Item_Medication,Order_ID,Dx_Order,ICD,Diagnosis,Pathway_ID,OASIS,Medications,Casemix,Mani,TextField_1,TextField_2,Question_ID,Created_by,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#messageid#','(M1021)''(M1023)','#Priority#','#Dx_Order#','#ICD#','#Diagnosis#','#Pathway#','#OASIS#','#drugname#','#DG_Description#','#Severity#','#PDGM_Primary#','#PDGM_Comorbidity#','#Question_ID#','#Created_by#','#DateFormat(Now(),"yyyy-mm-dd")#') Update #Request.prefix_db_agency#.Diagnosis set DG_Usage = '#OASIS#' where Assessment_ID = #Assessment_ID# and ICD = '#ICD#' select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Results (Assessment_ID,Patient_ID,Message_ID,M0_Item_Medication,Order_ID,Dx_Order,ICD,Diagnosis,Pathway_ID,OASIS,Medications,Casemix,Mani,TextField_1,TextField_2,Question_ID,Created_by,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#messageid#','(M1021)''(M1023)','#Priority#','#Dx_Order#','#ICD#','#Diagnosis#','#Pathway#','#OASIS#','#drugname#','#DG_Description#','#Severity#','#PDGM_Primary#','#PDGM_Comorbidity#','#Question_ID#','#Created_by#','#DateFormat(Now(),"yyyy-mm-dd")#') Update #Request.prefix_db_agency#.Diagnosis set DG_Usage = '#OASIS#' where Assessment_ID = #Assessment_ID# and ICD = '#ICD#' select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Results (Assessment_ID,Patient_ID,Message_ID,M0_Item_Medication,Order_ID,Dx_Order,ICD,Diagnosis,Pathway_ID,OASIS,Medications,Casemix,Mani,TextField_1,TextField_2,Question_ID,Created_by,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#messageid#','(M1021)''(M1023)','#Priority#','#Dx_Order#','#ICD#','#Diagnosis#','#Pathway#','#OASIS#','#drugname#','#DG_Description#','#Severity#','#PDGM_Primary#','#PDGM_Comorbidity#','#Question_ID#','#Created_by#','#DateFormat(Now(),"yyyy-mm-dd")#') Update #Request.prefix_db_agency#.Diagnosis set DG_Usage = '#OASIS#' where Assessment_ID = #Assessment_ID# and ICD = '#ICD#' )> select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Results (Assessment_ID,Patient_ID,Message_ID,M0_Item_Medication,Order_ID,Dx_Order,ICD,Diagnosis,Pathway_ID,OASIS,Medications,Casemix,Mani,TextField_1,TextField_2,Created_by,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#messageid#','(M1021)''(M1023)','#Priority#','#Dx_Order#','#ICD#','#Diagnosis#','#Pathway#','#OASIS#','#drugname#','#DG_Description#','#Severity#','#PDGM_Primary#','#PDGM_Comorbidity#','#Created_by#','#DateFormat(Now(),"yyyy-mm-dd")#') select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Results (Assessment_ID,Patient_ID,Message_ID,M0_Item_Medication,Order_ID,Dx_Order,ICD,Diagnosis,Pathway_ID,OASIS,Medications,Casemix,Mani,TextField_1,TextField_2,Created_by,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#messageid#','(M1021)''(M1023)','#Priority#','#Dx_Order#','#ICD#','#Diagnosis#','#Pathway#','#OASIS#','#drugname#','#DG_Description#','#Severity#','#PDGM_Primary#','#PDGM_Comorbidity#','#Created_by#','#DateFormat(Now(),"yyyy-mm-dd")#') select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Results (Assessment_ID,Patient_ID,Message_ID,M0_Item_Medication,Order_ID,Dx_Order,ICD,Diagnosis,Pathway_ID,OASIS,Medications,Casemix,Mani,TextField_1,TextField_2,Question_ID,Created_by,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#messageid#','(M1021)''(M1023)','#Priority#','#Dx_Order#','#ICD#','#Diagnosis#','#Pathway#','#OASIS#','#drugname#','#DG_Description#','#Severity#','#PDGM_Primary#','#PDGM_Comorbidity#','#Question_ID#','#Created_by#','#DateFormat(Now(),"yyyy-mm-dd")#') Update #Request.prefix_db_agency#.Diagnosis set DG_Usage = '#OASIS#' where Assessment_ID = #Assessment_ID# and ICD = '#ICD#' select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Results (Assessment_ID,Patient_ID,Message_ID,M0_Item_Medication,Order_ID,Dx_Order,ICD,Diagnosis,Pathway_ID,OASIS,Medications,Casemix,Mani,TextField_1,TextField_2,Created_by,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#messageid#','(M1021)''(M1023)','#Priority#','#Dx_Order#','#ICD#','#Diagnosis#','#Pathway#','#OASIS#','#drugname#','#DG_Description#','#Severity#','#PDGM_Primary#','#PDGM_Comorbidity#','#Created_by#','#DateFormat(Now(),"yyyy-mm-dd")#') INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Results (Assessment_ID,Patient_ID,Message_ID,M0_Item_Medication,Order_ID,Dx_Order,ICD,Diagnosis,Pathway_ID,OASIS,Medications,Casemix,Mani,TextField_1,TextField_2,Created_by,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#messageid#','(M1021)''(M1023)','999','#Dx_Order#','#ICD#','#Diagnosis#','#Pathway#','#OASIS#','#drugname#','#DG_Description#','#Severity#','#PDGM_Primary#','#PDGM_Comorbidity#','#Created_by#','#DateFormat(Now(),"yyyy-mm-dd")#') select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Results (Assessment_ID,Patient_ID,Message_ID,M0_Item_Medication,Order_ID,Dx_Order,ICD,Diagnosis,Pathway_ID,OASIS,Medications,Casemix,Mani,TextField_1,TextField_2,Created_by,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#messageid#','(M1021)''(M1023)','#Priority#','#Dx_Order#','#ICD#','#Diagnosis#','#Pathway#','#OASIS#','#drugname#','#DG_Description#','#Severity#','#PDGM_Primary#','#PDGM_Comorbidity#','#Created_by#','#DateFormat(Now(),"yyyy-mm-dd")#') select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = '0808') AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Results (Assessment_ID,Patient_ID,Message_ID,M0_Item_Medication,Order_ID,Dx_Order,ICD,Diagnosis,Pathway_ID,OASIS,Medications,Casemix,Mani,TextField_1,TextField_2,Created_by,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#messageid#','(M1021)''(M1023)','#Priority#','#Dx_Order#','#ICD#','#Diagnosis#','#Pathway#','#OASIS#','#drugname#','#DG_Description#','#Severity#','#PDGM_Primary#','#PDGM_Comorbidity#','#Created_by#','#DateFormat(Now(),"yyyy-mm-dd")#') select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Results (Assessment_ID,Patient_ID,Message_ID,M0_Item_Medication,Order_ID,Dx_Order,ICD,Diagnosis,Pathway_ID,OASIS,Medications,Casemix,Mani,TextField_1,TextField_2,Created_by,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#messageid#','(M1021)''(M1023)','#Priority#','#Dx_Order#','#ICD#','#Diagnosis#','#Pathway#','#OASIS#','#drugname#','#DG_Description#','#Severity#','#PDGM_Primary#','#PDGM_Comorbidity#','#Created_by#','#DateFormat(Now(),"yyyy-mm-dd")#') select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Results (Assessment_ID,Patient_ID,Message_ID,M0_Item_Medication,Order_ID,Dx_Order,ICD,Diagnosis,Pathway_ID,OASIS,Medications,Casemix,Mani,TextField_1,TextField_2,Created_by,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#messageid#','(M1021)''(M1023)','#Priority#','#Dx_Order#','#ICD#','#Diagnosis#','#Pathway#','#OASIS#','#drugname#','#DG_Description#','#Severity#','#PDGM_Primary#','#PDGM_Comorbidity#','#Created_by#','#DateFormat(Now(),"yyyy-mm-dd")#') select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Results (Assessment_ID,Patient_ID,Message_ID,M0_Item_Medication,Order_ID,Dx_Order,ICD,Diagnosis,Pathway_ID,OASIS,Medications,Casemix,Mani,TextField_1,TextField_2,Created_by,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#messageid#','(M1021)''(M1023)','#Priority#','#Dx_Order#','#ICD#','#Diagnosis#','#Pathway#','#OASIS#','#drugname#','#DG_Description#','#Severity#','#PDGM_Primary#','#PDGM_Comorbidity#','#Created_by#','#DateFormat(Now(),"yyyy-mm-dd")#') select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Results (Assessment_ID,Patient_ID,Message_ID,M0_Item_Medication,Order_ID,Dx_Order,ICD,Diagnosis,Pathway_ID,OASIS,Medications,Casemix,Mani,TextField_1,TextField_2,Question_ID,Created_by,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#messageid#','(M1021)''(M1023)','#Priority#','#Dx_Order#','#ICD#','#Diagnosis#','#Pathway#','#OASIS#','#drugname#','#DG_Description#','#Severity#','#PDGM_Primary#','#PDGM_Comorbidity#','#Question_ID#','#Created_by#','#DateFormat(Now(),"yyyy-mm-dd")#') Update #Request.prefix_db_agency#.Diagnosis set DG_Usage = '#OASIS#' where Assessment_ID = #Assessment_ID# and ICD = '#ICD#' select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Results (Assessment_ID,Patient_ID,Message_ID,M0_Item_Medication,Order_ID,Dx_Order,ICD,Diagnosis,Pathway_ID,OASIS,Medications,Casemix,Mani,TextField_1,TextField_2,Question_ID,Created_by,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#messageid#','(M1021)''(M1023)','#Priority#','#Dx_Order#','#ICD#','#Diagnosis#','#Pathway#','#OASIS#','#drugname#','#DG_Description#','#Severity#','#PDGM_Primary#','#PDGM_Comorbidity#','#Question_ID#','#Created_by#','#DateFormat(Now(),"yyyy-mm-dd")#') Update #Request.prefix_db_agency#.Diagnosis set DG_Usage = '#OASIS#' where Assessment_ID = #Assessment_ID# and ICD = '#ICD#' select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Results (Assessment_ID,Patient_ID,Message_ID,M0_Item_Medication,Order_ID,Dx_Order,ICD,Diagnosis,Pathway_ID,OASIS,Medications,Casemix,Mani,TextField_1,TextField_2,Question_ID,Created_by,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#messageid#','(M1021)''(M1023)','#Priority#','#Dx_Order#','#ICD#','#Diagnosis#','#Pathway#','#OASIS#','#drugname#','#DG_Description#','#Severity#','#PDGM_Primary#','#PDGM_Comorbidity#','#Question_ID#','#Created_by#','#DateFormat(Now(),"yyyy-mm-dd")#') Update #Request.prefix_db_agency#.Diagnosis set DG_Usage = '#OASIS#' where Assessment_ID = #Assessment_ID# and ICD = '#ICD#' select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Results (Assessment_ID,Patient_ID,Message_ID,M0_Item_Medication,Order_ID,Dx_Order,ICD,Diagnosis,Pathway_ID,OASIS,Medications,Casemix,Mani,TextField_1,TextField_2,Question_ID,Created_by,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#messageid#','(M1021)''(M1023)','#Priority#','#Dx_Order#','#ICD#','#Diagnosis#','#Pathway#','#OASIS#','#drugname#','#DG_Description#','#Severity#','#PDGM_Primary#','#PDGM_Comorbidity#','#Question_ID#','#Created_by#','#DateFormat(Now(),"yyyy-mm-dd")#') Update #Request.prefix_db_agency#.Diagnosis set DG_Usage = '#OASIS#' where Assessment_ID = #Assessment_ID# and ICD = '#ICD#' select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Results (Assessment_ID,Patient_ID,Message_ID,M0_Item_Medication,Order_ID,Dx_Order,ICD,Diagnosis,Pathway_ID,OASIS,Medications,Casemix,Mani,TextField_1,TextField_2,Question_ID,Created_by,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#messageid#','(M1021)''(M1023)','#Priority#','#Dx_Order#','#ICD#','#Diagnosis#','#Pathway#','#OASIS#','#drugname#','#DG_Description#','#Severity#','#PDGM_Primary#','#PDGM_Comorbidity#','#Question_ID#','#Created_by#','#DateFormat(Now(),"yyyy-mm-dd")#') Update #Request.prefix_db_agency#.Diagnosis set DG_Usage = '#OASIS#' where Assessment_ID = #Assessment_ID# and ICD = '#ICD#' select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Results (Assessment_ID,Patient_ID,Message_ID,M0_Item_Medication,Order_ID,Dx_Order,ICD,Diagnosis,Pathway_ID,OASIS,Medications,Casemix,Mani,TextField_1,TextField_2,Question_ID,Created_by,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#messageid#','(M1021)''(M1023)','#Priority#','#Dx_Order#','#ICD#','#Diagnosis#','#Pathway#','#OASIS#','#drugname#','#DG_Description#','#Severity#','#PDGM_Primary#','#PDGM_Comorbidity#','#Question_ID#','#Created_by#','#DateFormat(Now(),"yyyy-mm-dd")#') Update #Request.prefix_db_agency#.Diagnosis set DG_Usage = '#OASIS#' where Assessment_ID = #Assessment_ID# and ICD = '#ICD#' select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Results (Assessment_ID,Patient_ID,Message_ID,M0_Item_Medication,Order_ID,Dx_Order,ICD,Diagnosis,Pathway_ID,OASIS,Medications,Casemix,Mani,TextField_1,TextField_2,Question_ID,Created_by,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#messageid#','(M1021)''(M1023)','#Priority#','#Dx_Order#','#ICD#','#Diagnosis#','#Pathway#','#OASIS#','#drugname#','#DG_Description#','#Severity#','#PDGM_Primary#','#PDGM_Comorbidity#','#Question_ID#','#Created_by#','#DateFormat(Now(),"yyyy-mm-dd")#') Update #Request.prefix_db_agency#.Diagnosis set DG_Usage = '#OASIS#' where Assessment_ID = #Assessment_ID# and ICD = '#ICD#' select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Results (Assessment_ID,Patient_ID,Message_ID,M0_Item_Medication,Order_ID,Dx_Order,ICD,Diagnosis,Pathway_ID,OASIS,Medications,Casemix,Mani,TextField_1,TextField_2,Question_ID,Created_by,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#messageid#','(M1021)''(M1023)','#Priority#','#Dx_Order#','#ICD#','#Diagnosis#','#Pathway#','#OASIS#','#drugname#','#DG_Description#','#Severity#','#PDGM_Primary#','#PDGM_Comorbidity#','#Question_ID#','#Created_by#','#DateFormat(Now(),"yyyy-mm-dd")#') Update #Request.prefix_db_agency#.Diagnosis set DG_Usage = '#OASIS#' where Assessment_ID = #Assessment_ID# and ICD = '#ICD#' select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Results (Assessment_ID,Patient_ID,Message_ID,M0_Item_Medication,Order_ID,Dx_Order,ICD,Diagnosis,Pathway_ID,OASIS,Medications,Casemix,Mani,TextField_1,TextField_2,Question_ID,Created_by,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#messageid#','(M1021)''(M1023)','#Priority#','#Dx_Order#','#ICD#','#Diagnosis#','#Pathway#','#OASIS#','#drugname#','#DG_Description#','#Severity#','#PDGM_Primary#','#PDGM_Comorbidity#','#Question_ID#','#Created_by#','#DateFormat(Now(),"yyyy-mm-dd")#') Update #Request.prefix_db_agency#.Diagnosis set DG_Usage = '#OASIS#' where Assessment_ID = #Assessment_ID# and ICD = '#ICD#' select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Results (Assessment_ID,Patient_ID,Message_ID,M0_Item_Medication,Order_ID,Dx_Order,ICD,Diagnosis,Pathway_ID,OASIS,Medications,Casemix,Mani,TextField_1,TextField_2,Question_ID,Created_by,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#messageid#','(M1021)''(M1023)','#Priority#','#Dx_Order#','#ICD#','#Diagnosis#','#Pathway#','#OASIS#','#drugname#','#DG_Description#','#Severity#','#PDGM_Primary#','#PDGM_Comorbidity#','#Question_ID#','#Created_by#','#DateFormat(Now(),"yyyy-mm-dd")#') Update #Request.prefix_db_agency#.Diagnosis set DG_Usage = '#OASIS#' where Assessment_ID = #Assessment_ID# and ICD = '#ICD#' INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Results (Assessment_ID,Patient_ID,Message_ID,M0_Item_Medication,Order_ID,Dx_Order,ICD,Diagnosis,Pathway_ID,OASIS,Medications,Casemix,Mani,TextField_1,TextField_2,Question_ID,Created_by,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#messageid#','(M1021)''(M1023)','#Priority#','#Dx_Order#','#ICD#','#Diagnosis#','#Pathway#','#OASIS#','#drugname#','#DG_Description#','#Severity#','#PDGM_Primary#','#PDGM_Comorbidity#','#Question_ID#','#Created_by#','#DateFormat(Now(),"yyyy-mm-dd")#') Update #Request.prefix_db_agency#.Diagnosis set DG_Usage = '#OASIS#' where Assessment_ID = #Assessment_ID# and ICD = '#ICD#' select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Results (Assessment_ID,Patient_ID,Message_ID,M0_Item_Medication,Order_ID,Dx_Order,ICD,Diagnosis,Pathway_ID,OASIS,Medications,Casemix,Mani,TextField_1,TextField_2,Created_by,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#messageid#','(M1021)''(M1023)','#Priority#','#Dx_Order#','#ICD#','#Diagnosis#','#Pathway#','#OASIS#','#drugname#','#DG_Description#','#Severity#','#PDGM_Primary#','#PDGM_Comorbidity#','#Created_by#','#DateFormat(Now(),"yyyy-mm-dd")#') select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Results (Assessment_ID,Patient_ID,Message_ID,M0_Item_Medication,Order_ID,Dx_Order,ICD,Diagnosis,Pathway_ID,OASIS,Medications,Casemix,Mani,TextField_1,TextField_2,Question_ID,Created_by,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#messageid#','(M1021)''(M1023)','#Priority#','#Dx_Order#','#ICD#','#Diagnosis#','#Pathway#','#OASIS#','#drugname#','#DG_Description#','#Severity#','#PDGM_Primary#','#PDGM_Comorbidity#','#Question_ID#','#Created_by#','#DateFormat(Now(),"yyyy-mm-dd")#') Update #Request.prefix_db_agency#.Diagnosis set DG_Usage = '#OASIS#' where Assessment_ID = #Assessment_ID# and ICD = '#ICD#' INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Results (Assessment_ID,Patient_ID,Message_ID,M0_Item_Medication,Order_ID,Dx_Order,ICD,Diagnosis,Pathway_ID,OASIS,Medications,Casemix,Mani,TextField_1,TextField_2,Created_by,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#messageid#','(M1021)''(M1023)','#Priority#','#Dx_Order#','#ICD#','#Diagnosis#','#Pathway#','#OASIS#','#drugname#','#DG_Description#','#Severity#','#PDGM_Primary#','#PDGM_Comorbidity#','#Created_by#','#DateFormat(Now(),"yyyy-mm-dd")#') INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Results (Assessment_ID,Patient_ID,Message_ID,M0_Item_Medication,Order_ID,Dx_Order,ICD,Diagnosis,Pathway_ID,OASIS,Medications,Casemix,Mani,TextField_1,TextField_2,Created_by,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#messageid#','(M1021)''(M1023)','#Priority#','#Dx_Order#','#ICD#','#Diagnosis#','#Pathway#','#OASIS#','#drugname#','#DG_Description#','#Severity#','#PDGM_Primary#','#PDGM_Comorbidity#','#Created_by#','#DateFormat(Now(),"yyyy-mm-dd")#') select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Results (Assessment_ID,Patient_ID,Message_ID,M0_Item_Medication,Order_ID,Dx_Order,ICD,Diagnosis,Pathway_ID,OASIS,Medications,Casemix,Mani,TextField_1,TextField_2,Created_by,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#messageid#','(M1021)''(M1023)','#Priority#','#Dx_Order#','#ICD#','#Diagnosis#','#Pathway#','#OASIS#','#drugname#','#DG_Description#','#Severity#','#PDGM_Primary#','#PDGM_Comorbidity#','#Created_by#','#DateFormat(Now(),"yyyy-mm-dd")#') select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Results (Assessment_ID,Patient_ID,Message_ID,M0_Item_Medication,Order_ID,Dx_Order,ICD,Diagnosis,Pathway_ID,OASIS,Medications,Casemix,Mani,TextField_1,TextField_2,Created_by,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#messageid#','(M1021)''(M1023)','#Priority#','#Dx_Order#','#ICD#','#Diagnosis#','#Pathway#','#OASIS#','#drugname#','#DG_Description#','#Severity#','#PDGM_Primary#','#PDGM_Comorbidity#','#Created_by#','#DateFormat(Now(),"yyyy-mm-dd")#') ---> select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Results (Assessment_ID,Patient_ID,Message_ID,M0_Item_Medication,Order_ID,Dx_Order,ICD,Diagnosis,Pathway_ID,OASIS,Medications,Casemix,Mani,TextField_1,TextField_2,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#messageid#','(M1021)''(M1023)',#Priority#,'#Dx_Order#','#ICD#','#Diagnosis#','#Pathway#','#OASIS#','#drugname#','#DG_Description#','#Severity#','#PDGM_Primary#','#PDGM_Comorbidity#','#DateFormat(Now(),"yyyy-mm-dd")#') select PatientMeds.PatientMeds_ID, PatientMeds.Patient_ID, Meds_New.Name, PatientMeds.Drug_Name FROM #Request.prefix_db_agency#.PatientMeds JOIN #Request.prefix_db_lookup#.Meds_New on Meds_New.Trade_ID = PatientMeds.Medication_ID WHERE (Meds_New.Class_ID = #class1# OR Meds_New.Class_ID = #class2# OR Meds_New.Class_ID = #class3# OR Meds_New.Class_ID = #class4#) AND PatientMeds.Patient_ID = '#Patient_ID#' AND PatientMeds.Med_Status = 'active' AND PatientMeds.Medication_ID != 0 ' /> UPDATE #Request.prefix_db_agency#.PatientMeds SET flag = 1 WHERE PatientMeds_ID = '#PatientMeds_ID#' INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Results (Assessment_ID,Patient_ID,Message_ID,M0_Item_Medication,Order_ID,Dx_Order,ICD,Diagnosis,Pathway_ID,OASIS,Medications,Casemix,Mani,TextField_1,TextField_2,Created_by,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#messageid#','(M1021)''(M1023)','#Priority#','#Dx_Order#','#ICD#','#Diagnosis#','#Pathway#','#OASIS#','#drugname#','#DG_Description#','#Severity#','#PDGM_Primary#','#PDGM_Comorbidity#','#Created_by#','#DateFormat(Now(),"yyyy-mm-dd")#') INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Results (Assessment_ID,Patient_ID,Message_ID,M0_Item_Medication,Order_ID,Dx_Order,ICD,Diagnosis,Pathway_ID,OASIS,Medications,Casemix,Mani,TextField_1,TextField_2,Created_by,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#messageid#','(M1021)''(M1023)','#Priority#','#Dx_Order#','#ICD#','#Diagnosis#','#Pathway#','#OASIS#','#drugname#','#DG_Description#','#Severity#','#PDGM_Primary#','#PDGM_Comorbidity#','ICD NOT supported by medication profile','#DateFormat(Now(),"yyyy-mm-dd")#') INSERT IGNORE INTO #Request.prefix_db_agency#.Coding_Results (Assessment_ID,Patient_ID,Message_ID,M0_Item_Medication,Order_ID,Dx_Order,ICD,Diagnosis,Pathway_ID,OASIS,Medications,Casemix,Mani,TextField_1,TextField_2,Created_by,Created_Date) VALUES (#Assessment_ID#,#Patient_ID#,'#messageid#','(M1021)''(M1023)','#Priority#','#Dx_Order#','#ICD#','#Diagnosis#','#Pathway#','#OASIS#','#drugname#','#DG_Description#','#Severity#','#PDGM_Primary#','#PDGM_Comorbidity#','Replace with actively treated non-generic co-morbidity.','#DateFormat(Now(),"yyyy-mm-dd")#')