Notifications
Clear all
Topic starter
Hello
Which columns in CPS would contain this information? I found a firstfileddate in the visit table but am struggling to find a payment date. Would it be the created or lastmodified column in the payment table associated with the batches for procedures for the visit?
Posted : September 15, 2020 2:45 am
PaymentMethod is the table.
If we are talking turnaround for insurance payments... You can use your first filed date from the patient visit table then use the Check Date field from the paymentmethod table to find a difference.
Posted : September 16, 2020 3:26 am
Topic starter
Thanks. I too expected the payment method to give me the answer. Unfortunately our check date field tends to be null.
I'm finding the lasttransactiondateofentry also in the visit table to be useful. In come cases there is no payment made (or a 0 payyment) but that date reflects when that was done
Posted : September 17, 2020 1:14 am
