Total Amount In Collections

Once we change a Patient’s Billing Options to “date turned over to collections”, this patient now appears as the color red in the Active Patients List.
Is there a way to determine the amount of balance that all those patients in red have–in total?

SELECT
   SUM(postedbal - ageunapplied) AS "AmtInCollections"
FROM
   sos.ptpayors a
   JOIN sos.payors b ON a.payornum = b.payornum
WHERE
   b.collectdate IS NOT NULL

Leave a Reply

Your email address will not be published.

You may use these HTML tags and attributes:

<a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

This site uses Akismet to reduce spam. Learn how your comment data is processed.