SELECT pAuths.*,pAssessments.F176, pAssessments.F25, pAssessments.F26, pAssessments.F179,pAssessments.F177,
pAssessments.F178,pPayer.Pay_Name
FROM #Request.prefix_db_agency#.pAuths
LEFT OUTER JOIN #Request.prefix_db_agency#.pAssessments ON pAssessments.Assmt_ID = pAuths.Assmt_ID AND pAssessments.Status = 0
LEFT OUTER JOIN #Request.prefix_db_agency#.pAdmit ON pAdmit.Admit_ID = pAssessments.Admit_ID AND pAdmit.Status = 0
JOIN #Request.prefix_db_agency#.pPatients ON pPatients.Patient_Id = pAuths.Patient_Id
JOIN #Request.prefix_db_agency#.pRevenue_Code ON pRevenue_Code.Rev_CodeID = pAuths.Rev_ID
JOIN #Request.prefix_db_agency#.pPtPayer ON pPtPayer.PtPayer_ID = pAuths.PtPayer_ID
JOIN #Request.prefix_db_agency#.pPayer ON pPayer.Pay_ID = pPtPayer.Payer_ID
LEFT OUTER
JOIN #Request.prefix_db_lookup#.pEmployee ON pAuths.Created_by = pEmployee.Emp_ID
WHERE pAuths.Patient_Id =
AND pAuths.Status =
AND pPatients.Status =
AND pRevenue_Code.Status = 0
AND pPtPayer.Status = 0
AND pPayer.Status = 0
GROUP BY Auth_ID
ORDER BY Date_Start Desc