Notifications
Clear all
Topic starter
I am trying to build a report that lists the all the dates that a statement has been generated for a patient. I see the Guarantor.LastStatement field but it just holds the last statement date...not all the dates statements have been generated.
I can the the data in CPS under Registration -> Payment Plan -> Statement Activity -> Printed (date), but I can't find where that information is store in the database tables. Anyone have any ideas?
We're on CPS 11.
Thanks!
Posted : January 12, 2015 9:45 am
Statement dates are contained in the EDISTATEMENT table. Link this table to the PATIENTPROFILE table via the GUARANTORID.
Good luck.
Posted : November 9, 2015 2:06 pm
