SELECT e.Emp_ID, e.Emp_Last as LastName, e.Emp_First as FirstName, e.Emp_Street1, e.Emp_City,
e.Emp_State, e.Emp_Zip, e.Emp_Telephone as Telephone1, ph.Phys_ID, ph.Phys_NPI AS NPI, p.Patient_ID,
p.Pt_Last, p.Pt_First, an.F25, p.Pt_Middle, pa.Refer_Phys_ID, pa.Admit_ID,
ph.Phys_First,ph.Phys_Last,ph.Phys_Street, ph.Phys_City, ph.Phys_State, ph.Phys_Zip, ph.Phys_Phone
FROM #Request.prefix_db_agency#.pAssessments an
JOIN #Request.prefix_db_agency#.pPatients p on an.Patient_Id = p.Patient_Id AND p.Status < 2
JOIN #Request.prefix_db_agency#.pAdmit pa on an.Patient_Id = pa.Patient_Id AND pa.Status = 0
JOIN #Request.prefix_db_lookup#.pPhysicians ph on ph.Phys_ID = pa.Render_Phys_ID AND ph.Status = 0
JOIN #Request.prefix_db_lookup#.pEmployee e on e.Emp_ID = ph.Emp_ID
WHERE e.Emp_Type = 'Physician'
AND an.Status = 0
AND an.F25 = 1
AND an.F26 like '1%'
AND an.F176 >= #CreateODBCDate(Form.From_Date)# AND an.F176 <= #CreateODBCDate(Form.To_Date)#
GROUP BY an.Assmt_ID
ORDER BY ph.Phys_Last ASC, ph.Phys_First ASC, p.Pt_Last ASC
Admissions by Physician (#Form.From_Date# to #Form.To_Date#)