derekbrownjr wrote on Friday, December 09, 2011:
The “front office receipts” report currently is reporting data as submitted to the payments table. The payments module seems to be adding information only to the ar_session table. Is this disconnect intentional, or just a currently missing piece of the OEMR financial reporting?
Is this something that someone is working on? If not, what’s the end goal/intention for the database? Should the payments table be used?
derekbrownjr wrote on Tuesday, December 13, 2011:
Anyone aware of this area of OEMR?
juggernautsei wrote on Tuesday, December 13, 2011:
The question seems a little off.
Can we start from the beginning? Has the front office receptionist done a successful billing cycle?
Is she transmitting claims and to whom? Not sure why you are looking at the tables and not billing and payments.
Sherwin
openmedpractice.com
derekbrownjr wrote on Wednesday, December 14, 2011:
It is my understanding that the Front Office receipts report should be reporting on cash/payments taken by the front office receptionist (for co-pays, etc.). If he/she has put in the payments, they do not show in the Front Office receipts report. In looking at the code, the Payments module (where he/she puts in the payment) and the Front Office Receipts (the report of the payments) are looking at two separate locations in the database for data.
I need to know if this is the correct workflow, or if he/she should be putting in the payments elsewhere. I also need to know if this disconnect between the Payments module and the Front Office Receipts report is intentional, or if it needs to be fixed.
juggernautsei wrote on Wednesday, December 14, 2011:
When the front office is receiving payments are the payments being entered into the check out form?
Fees > Checkout
Sherwin
derekbrownjr wrote on Wednesday, December 14, 2011:
Yes, they are adding it to the checkout form, and still the payments are not showing up on the Front Office Rec. report.
derekbrownjr wrote on Wednesday, December 14, 2011:
I’d like to know what the payments table in the database is for. This is the database table that is being read by the Front Office receipts report, but this table has not been touched since we deployed OEMR. Not a single row has been added.
tmccormi wrote on Wednesday, December 14, 2011:
There is data being posted to the payments table (on my systems), as well as the billing table (as neg charges of type COPAY) and to the ar_activity table. (ar_sessions is a temporary work table I think).
However, I’m not sure if all the places that read financial info reads the payments table, some research is required.
-Tony
juggernautsei wrote on Thursday, December 15, 2011:
I looked and the same here. The co-pays are posted in the payment table.
Sherwin
derekbrownjr wrote on Friday, December 16, 2011:
Sherwin & Tony:
Do you have data populating in the Front Office Receipts report? I’m running the latest version of OEMR, and don’t see any data in the payments table. I will continue to test. My primary concern is not the payments table, but the Front Office Rec report. I don’t care how it gets there 
.
-Derek