SELECT MenuLevel2Id,MenuNames,DefaultPageUrl FROM homecare_menulevel2 where parentid = 3 and Level1Access=1 and Level2Access=1 and Level3Access=1 and Level4Access=1 and Level5Access=1 and Level6Access=1 and Level7Access=1 and Level8Access=1 and Level9Access=1 SELECT COUNT(DISTINCT pPatients.Patient_ID) AS TotalRecords FROM #Request.prefix_db_agency#.pPatients LEFT OUTER JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Patient_ID = pPatients.Patient_ID AND pAdmit.Status = 0 WHERE (pPatients.Pt_Last LIKE OR pPatients.Patient_ID = ) AND pPatients.Status = AND pPatients.Status = AND pPatients.Status = AND pPatients.Status NOT IN (2,3) AND pPatients.Patient_ID IN ( SELECT pSchedules.Patient_ID FROM #Request.prefix_db_agency#.pSchedules WHERE pSchedules.Emp_ID = AND pSchedules.Status = 0 ) SELECT DISTINCT pPatients.Patient_ID, pPatients.Pt_Agy_ID, pPatients.Pt_Last, pPatients.Pt_First, pPatients.Pt_Middle, 0 as Primary_ReferringPhys_ID_M0072, pPatients.Status, pPatients.Pt_City, pPatients.Pt_Zip, pPtPayer.Payer_ID, pPayer.Pay_Name, pPtPayer.PtPayer_ID, pPtPayer.Payer_Responsibility, pAdmit.Emerg_Priority, pAdmit.Admit_ID, pAdmit.Admit_Type, pPtContacts.Contact_ID, pPtContacts.Last_Name, pPtContacts.First_Name, (SELECT pAssessments.Assmt_ID FROM #Request.prefix_db_agency#.pAssessments WHERE pAssessments.Patient_ID = pPatients.Patient_ID AND pAssessments.Admit_ID = COALESCE(pAdmit.Admit_ID, 0) AND pAssessments.status = 0 ORDER BY pAssessments.F176 DESC LIMIT 1) AS Assmt_ID, (SELECT pAssessments.AutoAssmt_ID FROM #Request.prefix_db_agency#.pAssessments WHERE pAssessments.Patient_ID = pPatients.Patient_ID AND pAssessments.Admit_ID = COALESCE(pAdmit.Admit_ID, 0) AND pAssessments.status = 0 ORDER BY pAssessments.F176 DESC LIMIT 1) AS AutoAssmt_ID, (SELECT pAssessments.F26 FROM #Request.prefix_db_agency#.pAssessments WHERE pAssessments.Patient_ID = pPatients.Patient_ID AND pAssessments.Admit_ID = COALESCE(pAdmit.Admit_ID, 0) AND pAssessments.status = 0 ORDER BY pAssessments.F176 DESC LIMIT 1) AS F26, (SELECT pAssessments.F176 FROM #Request.prefix_db_agency#.pAssessments WHERE pAssessments.Patient_ID = pPatients.Patient_ID AND pAssessments.Admit_ID = COALESCE(pAdmit.Admit_ID, 0) AND pAssessments.status = 0 ORDER BY pAssessments.F176 DESC LIMIT 1) AS F176, (SELECT pPtContacts.Contact_ID FROM #Request.prefix_db_agency#.pPtContacts WHERE pPtContacts.Patient_ID = pPatients.Patient_ID AND pPtContacts.status = 0 AND pPtContacts.Location = 'lives < 30 minutes away' ORDER BY pPtContacts.Record_Creation_Date DESC LIMIT 1) AS OffsetContact_ID FROM #Request.prefix_db_agency#.pPatients LEFT OUTER JOIN #Request.prefix_db_agency#.pPtPayer ON pPatients.Patient_ID = pPtPayer.Patient_ID AND pPtPayer.Status = 0 AND pPtPayer.Payer_Responsibility IN ('P - Primary') LEFT OUTER JOIN #Request.prefix_db_agency#.pPayer ON pPayer.Pay_ID = pPtPayer.Payer_ID LEFT OUTER JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Patient_ID = pPatients.Patient_ID AND pAdmit.Status = 0 LEFT OUTER JOIN #Request.prefix_db_agency#.pPtContacts ON pPtContacts.Patient_ID = pPatients.Patient_ID AND pPtContacts.Status = 0 AND pPtContacts.Emergency = 1 WHERE (pPatients.Pt_Last LIKE OR pPatients.Patient_ID = ) AND pPatients.Status IN (0) AND pPatients.Status = AND pPatients.Status = AND pPatients.Status NOT IN (2,3) AND pPatients.Patient_ID IN ( SELECT pSchedules.Patient_ID FROM #Request.prefix_db_agency#.pSchedules WHERE pSchedules.Emp_ID = AND pSchedules.Status = 0 ) ORDER BY pPatients.Patient_Id ASC, pPatients.Status ASC, pPatients.Pt_Last ASC, pPatients.Pt_First ASC, pAdmit.M0030_START_CARE_DT DESC, pPtPayer.Payer_Responsibility ASC SELECT SUM(CASE WHEN TRIM(pAdmit.Admit_Type) = 'Home Health - OASIS required' THEN 1 ELSE 0 END) AS HomeHealthOasisCount, SUM(CASE WHEN TRIM(pAdmit.Admit_Type) IN ('Home Health - evaluation only, no OASIS', 'Home Health-no OASIS', 'Home Health - no OASIS') THEN 1 ELSE 0 END) AS HomeHealthNoOasisCount, SUM(CASE WHEN TRIM(pAdmit.Admit_Type) = 'Palliative' THEN 1 ELSE 0 END) AS PalliativeCount, SUM(CASE WHEN TRIM(pAdmit.Admit_Type) = 'Hospice' THEN 1 ELSE 0 END) AS HospiceCount, SUM(CASE WHEN TRIM(pAdmit.Admit_Type) = 'Pediatric' THEN 1 ELSE 0 END) AS PediatricCount, SUM(CASE WHEN TRIM(pAdmit.Admit_Type) = 'Non-Medical' THEN 1 ELSE 0 END) AS NonMedicalCount FROM #Request.prefix_db_agency#.pPatients JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Patient_ID = pPatients.Patient_ID AND pAdmit.Status = 0 WHERE pPatients.Status IN (0,1,4) AND pPatients.Patient_ID IN ()

Patients Home Health-OASIS Home Health-no OASIS Palliative Hospice Pediatric Non-Medical

Reports New Patient New Patient AI AI Patient List

	Last, First Name [Agency ID]	Emergency Priority	Emergency Contact	Offsite Contact?	City, Zipcode	Team	Payer	Current Assessment
	#Pt_Last#, #Pt_First# [#Pt_Agy_ID#]	#Left(Emerg_Priority,20)#...	#Last_Name#, #First_Name#	Yes	#Pt_City#, #Left(Pt_Zip,5)#	Team	#Pay_Name#	#F26# 3 - Resumption 4 - Recertification 6 - Transfer no Discharge 7 - Transfer/Discharge 9 - Discharge #assessments# - #DateFormat(F176,"mm/dd/yyyy")#

New Patient New Patient AI AI Patient List

No Patients were found based on your search criteria.

Please click a Last Name letter or enter a Last Name letter in the Search box above to find Patient records.