SELECT p.*, pt.*,a.AutoAssmt_ID,a.Admit_ID,a.Assmt_ID,a.F26,a.F176, a.F320 AS QA_View FROM #Request.prefix_db_agency#.pProblem p LEFT OUTER JOIN #Request.prefix_db_lookup#.meds_pathway_lookup mdp ON mdp.Path_ID = p.Path_ID AND mdp.Agency_ID IS NULL JOIN #Request.prefix_db_agency#.pAssessments a ON a.Assmt_ID = p.Assmt_ID JOIN #Request.prefix_db_agency#.pPatients pt ON pt.Patient_ID = a.Patient_ID JOIN #Request.prefix_db_agency#.pAdmit ad ON ad.Admit_ID = a.Admit_ID JOIN ( SELECT Admit_ID FROM #Request.prefix_db_agency#.pAdmit WHERE Patient_ID = '#session.cs.patientid#' AND Status = 0 ORDER BY M0030_START_CARE_DT DESC LIMIT 1 ) AS latest_admit ON latest_admit.Admit_ID = a.Admit_ID WHERE ad.status = 0 AND pt.status IN (0,1,4) AND a.status = 0 AND p.status = 0 AND pt.Patient_ID = '#session.cs.patientid#' AND (a.F26 like '1%' OR a.F26 like '4%' OR a.F26 like 'Hospice admission' OR a.Assmt_ID = '#parent_OASIS.Assmt_ID#') AND a.F176 < #Now()# AND p.M0_No like 'M102%' GROUP BY p.Problem_ID,p.Assmt_ID ORDER BY p.Assmt_ID, a.F177 DESC, p.dx_order ASC SELECT IFNULL(MAX(Orphan_ID),0) AS Max_Orphan_ID FROm #Request.prefix_db_agency#.pMed_Recon SELECT * FROm #Request.prefix_db_agency#.pMed_Recon WHERE Assmt_ID = '#Assmt_ID#' AND Med_Dx_ID = #Problem_ID# AND status = 0 select * from #Request.prefix_db_agency#.pMed_Recon where status = 0 and Med_Dx_ID = '#Problem_ID#' AND Assmt_ID = '#Assmt_ID#' select pPtmeds.*,mdp.Approved from #Request.prefix_db_agency#.pPtmeds LEFT OUTER JOIN #Request.prefix_db_lookup#.meds_pathway_lookup mdp ON mdp.Trade_Num = pPtmeds.Drug_ID AND mdp.Path_ID = '#GtDX2.Path_ID#' where pPtmeds.status = 0 and pPtmeds.Patient_ID = '#Patient_ID#' GROUP BY pPtmeds.PtMeds_ID SELECT * FROM getMed_Recon WHERE Med_Dx_ID = '#GtDX2.Problem_ID#' AND PtMeds_ID = '#PtMeds_ID#' getmeds_recon.recordcount EQ 0> INSERT INTO #Request.prefix_db_agency#.pMed_Recon ( Orphan_ID, Assmt_ID, PtMeds_ID, Drug_Name, Med_Dx_ID, Diagnosis, Paired,automatic_paired, Date_Created, Created_By) VALUES (, , , , , , , , , ) , SELECT Assmt_ID FROM #Request.prefix_db_agency#.pAssessments WHERE Patient_ID = AND Status = AND (F26 like '1%' OR F26 like '4%') ORDER BY Assmt_ID DESC LIMIT 1 SELECT COUNT(*) AS careplan_count FROM #Request.prefix_db_agency#.pCareplan WHERE Assmt_ID = AND Status = UPDATE #Request.prefix_db_agency#.pPatients SET Med_Approve = 0, Med_Recon_Field = 0 WHERE Status IN (0,1,4) AND Patient_ID = '#session.cs.patientid#' SELECT IFNULL(MAX(Orphan_ID),0) AS Max_Orphan_ID FROm #Request.prefix_db_agency#.pMed_Recon SELECT * FROM #Request.prefix_db_agency#.pPtmeds WHERE pPtmeds.Patient_ID = AND PtMeds_ID NOT IN (SELECT PtMeds_ID FROM #Request.prefix_db_agency#.pMed_Recon WHERE Status = 0 AND Assmt_ID = ) AND pPtmeds.status = 0 GROUP BY PtMeds_ID ORDER BY pPtmeds.status ASC INSERT INTO #Request.prefix_db_agency#.pMed_Recon ( Orphan_ID, Assmt_ID, PtMeds_ID, Drug_Name, Med_Dx_ID, Diagnosis, Paired, automatic_paired, Date_Created, Created_By) VALUES (, , , , , , , , , ) , SELECT Assmt_ID FROM #Request.prefix_db_agency#.pAssessments WHERE Patient_ID = AND Status = ORDER BY Assmt_ID DESC LIMIT 1 SELECT COUNT(*) AS careplan_count FROM #Request.prefix_db_agency#.pCareplan WHERE Assmt_ID = AND Status = UPDATE #Request.prefix_db_agency#.pPatients SET Med_Approve = 0, Med_Recon_Field = 0 WHERE Status IN (0,1,4) AND Patient_ID = UPDATE #Request.prefix_db_agency#.pMed_Recon SET Status = 2 WHERE Status = 0 AND PtMeds_ID NOT IN ( SELECT PtMeds_ID FROM #Request.prefix_db_agency#.pPtmeds WHERE Patient_ID = AND Status = 0) AND Assmt_ID IN ()