SELECT
pPatients.Patient_ID, pPatients.Pt_Last AS PatientLast, pPatients.Pt_First AS PatientFirst,
MIN(pPayer.Pay_Name) AS Pay_Name, MIN(pPtPayer.PtPayer_ID) AS PtPayer_ID,
pEmployee.Emp_Last, pEmployee.Emp_First,
pAdmit.Case_Manager
FROM #Request.prefix_db_agency#.pAdmit pAdmit
JOIN #Request.prefix_db_agency#.pPatients pPatients ON pPatients.Patient_ID = pAdmit.Patient_ID
AND pPatients.Status = 0
JOIN #Request.prefix_db_agency#.pPtPayer ON pPtPayer.Patient_ID = pPatients.Patient_ID
AND pPtPayer.PtPayer_ID IS NOT NULL
AND pPtPayer.status = 0
JOIN #Request.prefix_db_agency#.pPayer ON pPayer.Pay_ID = pPtPayer.Payer_ID
AND pPayer.Status = 0
LEFT OUTER JOIN #Request.prefix_db_agency#.Eligibility ON Eligibility.PtPayer_ID = pPtPayer.PtPayer_ID
AND Eligibility.Status = 0
AND (Eligibility.Expiration_Date >=
OR (Eligibility.Expiration_Date IS NULL AND Eligibility.Start_Date IS NOT NULL))
LEFT OUTER JOIN #Request.prefix_db_lookup#.pEmployee ON pEmployee.Emp_ID = pAdmit.Case_Manager
LEFT OUTER JOIN #Request.prefix_db_agency#.employee_auth ON pEmployee.Emp_ID = employee_auth.eaID
WHERE pAdmit.Status = 0
AND Eligibility.Elig_ID IS NULL
AND pAdmit.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 pPatients.Loc_ID = '#session.agencyid#'
AND COALESCE(pAdmit.Case_Manager, 2) =
GROUP BY pPatients.Patient_ID, pPatients.Pt_Last, pPatients.Pt_First, pEmployee.Emp_Last, pEmployee.Emp_First, pAdmit.Case_Manager
ORDER BY pPatients.Pt_Last ASC, pPatients.Pt_First ASC
Missing Eligibility
payer requirement for eligibility in Setup > Payers
UPDATE #Request.prefix_db_agency#.Dash_emp_count SET status = 1
WHERE status = 0 AND Header =
AND Emp_ID =
INSERT INTO #Request.prefix_db_agency#.Dash_emp_count (Daily_QA_Date, Emp_ID, Emp_Count, Header, Created_Date, status)
VALUES (
,
,
,
,
,
)