7.5 Outstanding patient due amounts by provider. Jeff Buchbinder

center

FreeMED CONCAT(phy.phylname,', ', phy.phyfname, ' ', phy.phymname) AS 'Provider Name', phy.id AS 'Provider ID', ROUND(SUM(proc.procbalcurrent), 2) AS 'Total Outstanding' procrec AS proc, physician AS phy proc.procbalcurrent > 0 AND proc.procphysician = phy.id proc.procphysician 'Provider Name' 0 0 1 1 1 30 60 left 30 60 left 30 60 left 480 268 1 1 columns

0 0 0

15 0 288 72 11 36 2 10 A3 14 1 1 1 1 1