Hello: I’m trying to make heads and tails out of the various billing tables and reports… such as Reports > Front Receipts which does not seem to show Co-Pays…
Can someone help me understand in plain English which tables (and why) Charges, Inventory charges, Co-Pays, Patient & Insurance Payments, Discounts & Adjustments are kept? and what does ar_sessions table represent?
I’ve been struggling with this for a while as the php is hard to follow…
A good bird’s eye view of Database Structure is the first step. Hone in on the likely “suspects” and see where the data actually land. The Structure tab of each table gives a quick glimpse of the columns.
ar_activity = posting of individual payments (ar is accounts receivable)
ar_sessions = posting of each insurance payment as a whole
drug_sales = posting of dispensary items payments
insurance_data = data related to the insurance portion of Patient Summary with the copay
Rationale for architecture
Some of it is obvious. Accounts receivable stuff should be in the ar tables. Sometimes it is at the discretion of the developer. The reason for the assignment of which table for what data may be known only to that person. Like cartography, once the lay of the land is known, the cartographer’s original mindset is less important, because one is less likely to get lost .