SELECT * FROM #Request.prefix_db_agency#.pAdmit LEFT OUTER JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_ID = pAdmit.Patient_ID LEFT OUTER JOIN #Request.prefix_db_lookup#.Agency ON Agency.Agency_ID = pPatients.Loc_ID LEFT OUTER JOIN #Request.prefix_db_lookup#.pEmployee ON pEmployee.Emp_ID = pAdmit.Created_by WHERE (pAdmit.Approved = "No" OR pAdmit.Approved = "yes") AND pAdmit.status = '0' AND pPatients.status = '0' Group by pAdmit.Admit_ID ORDER BY pAdmit.Date_Create
Not Approved Admissions
System Admin

Not Approved Admissions

Patient Physician-ordered Start of Care Date Clinical condition Requiring Home care per Rendering Physician Physician Orders for Nursing Physician Orders for Therapy Physician Orders for Aide Patient's Living Situation Advance Directive Code Status Emergency Priority Hombound Status per Rendering Physician Employee Name Date Approved
#Pt_Last#, #Pt_First# #M0102_PHYSN_ORDRD_SOCROC_DT# #MD_Clinical_Condition# #Nursing# #Therapy# #Aide# #M1100_PTNT_LVG_STUTN# #Advance_Directive# #Code_Status# #Emerg_Priority# #MD_Homebound# #Emp_First# #Date_Create# #Approved#
There are currently no Admissions.