SELECT pAssessments.*,pPatients.Pt_First,pPatients.Pt_Last,pPatients.Med_Recon_Field, pEmployee.Emp_First, pEmployee.Emp_Last, (SELECT Admit_ID FROM #Request.prefix_db_agency#.pAdmit WHERE Patient_ID = pAssessments.Patient_ID AND Status = 0 ORDER BY M0030_START_CARE_DT DESC LIMIT 1) AS latest_admit FROM #Request.prefix_db_agency#.pAssessments pAssessments JOIN #Request.prefix_db_agency#.pAdmit pAdmit ON pAdmit.Admit_ID = pAssessments.Admit_ID AND pAdmit.Status = 0 JOIN #Request.prefix_db_agency#.pPatients pPatients ON pPatients.Patient_ID = pAssessments.Patient_ID AND pPatients.Status = 0 AND pPatients.Med_Recon_Field IN (1) AND pPatients.Med_Approve IN (0,2) LEFT OUTER JOIN #Request.prefix_db_agency#.assessment_assign ON assessment_assign.Assmt_ID = pAssessments.Assmt_ID AND assessment_assign.F26 = pAssessments.F26 JOIN #Request.prefix_db_lookup#.pEmployee ON pEmployee.Emp_ID = assessment_assign.Emp_ID AND pEmployee.Status = 0 LEFT OUTER JOIN #Request.prefix_db_agency#.employee_auth ON pEmployee.Emp_ID = employee_auth.eaID WHERE pAssessments.Status = 0 AND pAssessments.F25 = 1 AND employee_auth.r_Assmt_QA = 3 AND pAssessments.Assmt_ID = ( SELECT a2.Assmt_ID FROM #Request.prefix_db_agency#.pAssessments a2 WHERE a2.Admit_ID = pAssessments.Admit_ID AND a2.Status = 0 AND a2.F25 = 1 ORDER BY a2.F176 DESC, a2.Assmt_ID DESC LIMIT 1 ) AND pAssessments.Admit_ID NOT IN ( SELECT pAssessments.Admit_ID FROM #Request.prefix_db_agency#.pAssessments WHERE (pAssessments.F26 LIKE '9%' OR pAssessments.F26 LIKE '7%' OR pAssessments.F26 LIKE '8%') AND pAssessments.Status = 0 AND pAssessments.F25 = 1 ) AND assessment_assign.Emp_ID = GROUP BY pAssessments.Assmt_ID ORDER BY pPatients.Pt_Last ASC, pPatients.Pt_First ASC

Medication Reconciliation

Fetch latest report Back

Patient Name	Assesments Reason	Completed Date	Employee	Elapsed Days	Clinician's Approval status
#Pt_Last#, #Pt_First#	#F26#	#DateFormat(F176,"mm/dd/yyyy")#	#Emp_Last#, #Emp_First#	#diffdays#	Yes No

UPDATE #Request.prefix_db_lookup#.Agency SET orphans_meds_recon = WHERE Agency_ID = UPDATE #Request.prefix_db_lookup#.pEmployee SET Emp_orphans_meds_recon = #Emp_orphans_meds_recon# WHERE Emp_ID = #session.EmployeeID#