I have entered CPT codes with standard fee in the Administration/Codes dialogue. But some of these fees are not being posted to the fee sheet when I select that Office Visit CPT code.
The Fee Sheet Lists dropdowns had some generic Office Visit CPT codes listed . . . without fees. Maybe this duplication is what has caused the glitch. But I deleted these generic codes from the Administration/List Editor/Fee Sheet lists, replacing them with my code entries. And the Standard Fee still isn’t printing for the office visit codes.
When I look in the database via phpMyAdmin, and look at the codes table, there are no fees listed. The “fee” column reads “NULL” for all the CPT codes.
Where is the table that lists the Fees that are associated with various CPT codes? What is it called? Perhaps if I could view this table, I could see if there are duplicate listings that are fouling me up, or something . . .
PROBABLE SOLUTION:
Fees are listed in the table “prices”, which can be viewed in phpMyAdmin by the menu choice Administration/Other/Database
From phpMyAdmin I exported CSV files of the table “prices” and the table “codes”. The “pr_id” field in the prices table correlates with the id in the codes table.
Inspecting these two CSV files in a spreadsheet program, I concluded that when I had made a new entry for the code 99213 and deleted the old entry in the codes list, the corresponding entry in the price list was not deleted. So I have more than one pr_id listing associated with a putative 99213 code id.
Using phpMyAdmin, I deleted the superfluous pr_id rows.
Now I’ll try posting another visit and see if the price for the 99213 code will register.
ACTUAL SOLUTION:
The above “probable solution” didn’t work. It’s a great way to clean up some of the glitches that were produced by my previous approach, but it didn’t fix the cause of the problem.
The problem here was occurring when I created a “fee sheet” list with procedures linked to CPT4 codes and prices. I didn’t have the problem when I searched for individual CPT4 codes and entered them that way. It only happened whe I entered them off of the “fee sheet” pop-up list. The “fee sheet” list’s link to the prices table is indirect (through the procedure codes that you link to) and appears to be kind of glitchy.
The actual solution is to set up a pop-up list of CPT4 procedures and prices by creating a “Service Category” list and then applying specific codes to that pop up list with via the Administration/Codes dialogue, rather than the “Fee Sheet” option. This “Service Category” list approach appears to work reliably.
ADDITIONAL NOTE:
I don’t recommend creating pop up diagnostic code options using the “Service Category” process described above. To enable an ICD-10 category option for the Service Category list, you have to go to the Administration/Lists/CodeTypes list and set the External setting for ICD10 to NO. But this appears to disable the EMR’s search function for searching your ICD-10 external data load. No no no.
Instead, if you want to create pop-up lists for diagnoses in the fee sheet window, use the “Fee Sheet” list. These diagnoses don’t have prices associated with them, so it works just fine.
IN SUMMARY:
To create pop up lists on the fee sheet window:
For E&M and Procedures (CPT4 codes) use the “Service Category” list process.
For Diagnosis (ICD-10 codes) use the “Fee Sheet” list process.