Can somebody please help me in mapping these to the table ‘codes’ in MySQL. I understand the code_type is going to be 1 for CPT codes, but not sure how to populate columns ‘modifier’, ‘units’, ‘fee’ and ‘superbill’.
you need at least three fields populated.
code_text, code, code_type
for a big dump you can create a file that goes like this
insert into codes (code_text,code,code_type) VALUES
(‘the code description’,‘the code itsleft’,‘the code type #’),
(‘the code description’,‘the code itsleft’,‘the code type #’),
(‘the code description’,‘the code itsleft’,‘the code type #’),
(‘the code description’,‘the code itsleft’,‘the code type #’);
if you have the codes you can use a text editor to prepare such file.
If you have a price list and you are going to populate the other colums, be sure that they are listed in the fist set where you specify the colums, and be sure that the listing of values matches the order of the listing of columns.
Thank you Andes!
I appreciate your help with following questions.
Can OpenEMR use RVUs? if so which column in the table it goes into ‘units’ or ‘fee’?
Honestly I don’t know the difference between two RVUs.
Since there are two RVUs (NRVU and FRVU) in the data file any idea which RVU should be used for OpenEMR/FreeB to function correctly?
I don’t think you want to load RVUs. They have something to do with computing fees, but are not the fees themselves.
See http://www.refercare.org/openemr/ for some scripts that I wrote for loading ICD9, HCPCS and CPT codes and fees. If you do not have the technical skills to customize and use these, then I recommend you hire someone (like me, perhaps) to take care of it for you.