Query to capture Patient Payment

[glamorgan]

Guys,

I am looking for MySQL query that will fetch payments made by the current patient, the result should also include the procedure name and the cost of the procedure.

Any bets?

Thanks in advance.

[jordansparks]

Payments are not generally attached to procedures at the database level. So if there's no association, I don't see how a query could possibly be written to obtain that information. In other words, how does the database know which procedures the patient is paying for? We could add a feature to automate it according to FIFO on the patient estimate portion. But then if insurance pays slightly less than expected, the amounts might need to be adjusted.