Fee Schedule comparison by procedure codes

For users or potential users.
Post Reply
rajg
Posts: 15
Joined: Fri Apr 10, 2015 12:38 pm

Fee Schedule comparison by procedure codes

Post by rajg » Wed Mar 06, 2019 8:29 pm

Is there a user query or report that shows a Fee Schedule comparison per carrier by procedure codes in a table similar to lists -> procedure code table in opendent?

User avatar
cmcgehee
Posts: 711
Joined: Tue Aug 25, 2015 5:06 pm
Location: Salem, Oregon

Re: Fee Schedule comparison by procedure codes

Post by cmcgehee » Thu Mar 07, 2019 8:00 am

I looked for a query on https://opendentalsoft.com:1943/ODQuery ... yList.aspx but didn't find any that matched what you're asking for. You can submit a query request for us to write a custom report for you.
Chris McGehee
Open Dental Software
http://www.opendental.com

rajg
Posts: 15
Joined: Fri Apr 10, 2015 12:38 pm

Re: Fee Schedule comparison by procedure codes

Post by rajg » Fri Mar 08, 2019 12:42 pm

@cmcgehee

I will try to come up with my own query. Please clarify following.

feesched table has feeschednum key that tells me the carrier and fee table has feesched (Same as feeschednum in feesched table) that tells me the fee for that provider for a particular code. If not, any additional information is appreciated.

User avatar
cmcgehee
Posts: 711
Joined: Tue Aug 25, 2015 5:06 pm
Location: Salem, Oregon

Re: Fee Schedule comparison by procedure codes

Post by cmcgehee » Mon Mar 11, 2019 8:56 am

Would you describe in a little more detail the question that you're asking?
Chris McGehee
Open Dental Software
http://www.opendental.com

rajg
Posts: 15
Joined: Fri Apr 10, 2015 12:38 pm

Re: Fee Schedule comparison by procedure codes

Post by rajg » Mon Mar 11, 2019 4:04 pm

I am trying to create a table/spreadsheet that will show me what each insurance plan pays for a particular procedure code. This is similar to lists-> procedure codes that shows three fee schedules at a time. I am trying to create a table that will show all the fee schedules for our office in one spreadsheet.

I exported fee and feeschedule tables using mysqlqorkbench and was able to figure out that FeeSchedNum was the key for a specific plan but still unable to get all fees from fee table. I am using to exported tables and then vlookup in libreoffice to create my own spreadsheet. It seems that opendent is using oldcode to store ADA codes but feenum seems to be the primary key to this table. My problem is that when I filter on a specific procedure code, only a subset of fee schedules show up. Can you please point me to the correct tables and columns?

rajg
Posts: 15
Joined: Fri Apr 10, 2015 12:38 pm

Re: Fee Schedule comparison by procedure codes

Post by rajg » Mon Mar 11, 2019 11:35 pm

I found query https://opendentalsoft.com:1943/ODQuery ... yList.aspx #254 that I exported in to libreoffice. Then applied autofilter on procedure code to get what we wanted.

User avatar
cmcgehee
Posts: 711
Joined: Tue Aug 25, 2015 5:06 pm
Location: Salem, Oregon

Re: Fee Schedule comparison by procedure codes

Post by cmcgehee » Tue Mar 12, 2019 7:49 am

When working with the fee table, you wouldn't want to use the OldCode column at all. Instead use the CodeNum column to join on the procedurecode table. Then you can filter on procedurecode.ProcCode.
Chris McGehee
Open Dental Software
http://www.opendental.com

Post Reply