SELECT pPatients.Patient_ID, pAssessments.F26, pAssessments.F197, pAssessments.F176, pAssessments.F181, pAssessments.F177, pAssessments.F178, 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.status = 0 AND pAssessments.F26 != 'H&P Review' AND pAssessments.F176 BETWEEN #CreateODBCDate(Form.From_Date)# AND #CreateODBCDate(Form.To_Date)# AND pAssessments.F27 IN ( ) 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 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
Active Patients - List of Assessments
Active Patients - List of Assessments
&From_Date=#form.From_Date#&To_Date=#form.To_Date#">
Patient Name Payer Completed Assessment Certification Transmission
Status		 Status
#PatientLast#, #PatientFirst# #Pay_Name# #DateFormat(F176,"mm/dd/yyyy")# #F26# #DateFormat(F177,"mm/dd/yyyy")# - #DateFormat(F178,"mm/dd/yyyy")# transmitted not transmitted completedin progress