SELECT pPatients.Patient_ID, pAssessments.F26, pAssessments.F197, pAssessments.F176, pAssessments.F181,
pAssessments.F177, pAssessments.F178, DATE_FORMAT(pAssessments.F176, '%m/%d/%Y') AS completed_date,
pPatients.Pt_Last AS PatientLast, pPatients.Pt_First AS PatientFirst, pPatients.Pt_Gender,
pPatients.Pt_DOB, pPatients.Pt_Zip, pAssessments.F25, pPayer.Pay_Name, pPayer.GL_Account
FROM #Request.prefix_db_agency#.pAssessments
JOIN #Request.prefix_db_agency#.pAdmit on pAdmit.Admit_ID = pAssessments.Admit_ID AND pAssessments.status= 0
JOIN #Request.prefix_db_agency#.pPatients on pPatients.Patient_ID = pAssessments.Patient_ID
LEFT OUTER JOIN #Request.prefix_db_agency#.pPtPayer ON pPtPayer.Patient_ID= pPatients.Patient_ID
AND pPtPayer.Payer_Responsibility = 'P - Primary' AND pPtPayer.status= 0
LEFT OUTER JOIN #Request.prefix_db_agency#.pPayer ON pPtPayer.Payer_ID = pPayer.Pay_ID AND pPayer.status= 0
WHERE pPatients.Status = 0
AND pAssessments.status= 0
AND pAssessments.F26 != 'H&P Review'
AND pAssessments.status = 0
AND pAssessments.F176 BETWEEN #CreateODBCDate(url.From_Date)# AND #CreateODBCDate(url.To_Date)#
AND pPayer.GL_Account IN (
)
AND LEFT(pPatients.Pt_Zip,5) IN (
SELECT ZipCode FROM #Request.prefix_db_lookup#.zip_cbsa
WHERE County IN (
)
)
AND pPayer.Pay_ID IN (
)
AND pAssessments.F27 IN (
)
AND pPatients.Pt_Gender IN (
)
AND (
(pPatients.Pt_DOB IS NOT NULL AND DATEDIFF(CURDATE(), pPatients.Pt_DOB) < 365)
(pPatients.Pt_DOB IS NOT NULL AND DATEDIFF(CURDATE(), pPatients.Pt_DOB) BETWEEN 365 AND 1460)
(pPatients.Pt_DOB IS NOT NULL AND DATEDIFF(CURDATE(), pPatients.Pt_DOB) BETWEEN 1825 AND 5110)
(pPatients.Pt_DOB IS NOT NULL AND DATEDIFF(CURDATE(), pPatients.Pt_DOB) BETWEEN 5475 AND 8760)
(pPatients.Pt_DOB IS NOT NULL AND DATEDIFF(CURDATE(), pPatients.Pt_DOB) BETWEEN 9125 AND 16060)
(pPatients.Pt_DOB IS NOT NULL AND DATEDIFF(CURDATE(), pPatients.Pt_DOB) BETWEEN 16425 AND 23360)
(pPatients.Pt_DOB IS NOT NULL AND DATEDIFF(CURDATE(), pPatients.Pt_DOB) BETWEEN 23725 AND 27010)
(pPatients.Pt_DOB IS NOT NULL AND DATEDIFF(CURDATE(), pPatients.Pt_DOB) BETWEEN 27375 AND 30660)
(pPatients.Pt_DOB IS NOT NULL AND DATEDIFF(CURDATE(), pPatients.Pt_DOB) >= 31025)
OR
)
AND pAdmit.Admit_Type IN (
)
AND pPatients.Pt_Race IN (
)
GROUP BY pAssessments.Assmt_ID
Order by PatientLast, PatientFirst, F178, F177, F26
Please Right Click Here and choose "Save Target As..." to download the Exported data file and save it to your computer.