Can we query the EOB?

For complex topics that regular users would not be interested in. For power users and database administrators.
Post Reply
User avatar
Jorgebon
Posts: 502
Joined: Mon Jun 18, 2007 2:25 pm
Location: Mayaguez, PR
Contact:

Can we query the EOB?

Post by Jorgebon » Thu May 08, 2014 7:43 pm

Does Open Dental save the information received in 835s to a table in the database that we can query or does it just read and display the information on the 835?
Jorge Bonilla DMD
Open Dental user since May 2005

User avatar
jsalmon
Posts: 1551
Joined: Tue Nov 30, 2010 12:33 pm
Contact:

Re: Can we query the EOB?

Post by jsalmon » Fri May 09, 2014 9:48 am

We only store it in it's raw format in the etransmessagetext table. Every time you open an 835 within Open Dental we "reprocess" the message in order to display it. This saves us from having to create a complicated db schema.
The best thing about a boolean is even if you are wrong, you are only off by a bit.

Jason Salmon
Open Dental Software
http://www.opendental.com

Post Reply