fsgl wrote on Thursday, September 12, 2013:
My old CPT coding book indicated that the data files had been in ASCII format, therefore I would hazard a guess that the format has remained the same. I would also guess that the data set will have the codes, the descriptions, perhaps the modifiers in a separate location on the file and nothing else.
Kim Weesner had kindly supply us with a .sql file for a small collection of CPT II codes which will serve well for illustration purposes.
INSERT INTO openemr
.code_types
(ct_key
,ct_id
,ct_seq
,ct_mod
,ct_just
,ct_mask
,ct_fee
,
ct_rel
,ct_nofs
,ct_diag
)
VALUES (‘CPT II’,4,4,12,‘ICD9’,’’,1,0,0,0);
INSERT INTO openemr
.codes
(code_text, code_text_short, code, code_type, modifier,
units, fee, superbill, related_code, taxrates, cyp_factor, active, reportable)
VALUES
(‘Fall risk screening’,’’,‘1101F’,4,’’,NULL,NULL,’’,’’,’’,0,1,0),
(‘Most recent diastolic blood pressure >=90mm Hg’,’’,‘3080F’,4,’’,NULL,NULL,’’,’’,’’,0,1,0),
(‘Most recent diastolic blood pressure <80mm Hg’,’’,‘3078F’,4,’’,NULL,NULL,’’,’’,’’,0,1,0),
(‘Most recent systolic blood pressure >=140mm Hg’,’’,‘3077F’,4,’’,NULL,NULL,’’,’’,’’,0,1,0),
(‘Screening for depression performed’,’’,‘3725F’,4,’’,NULL,NULL,’’,’’,’’,0,1,0),
(‘Most recent systolic blood pressure <130mm Hg’,’’,‘3074F’,4,’’,NULL,NULL,’’,’’,’’,0,1,0),
(‘Tobacco use cessation intervention, pharm/therpy’,’’,‘4001F’,4,’’,NULL,NULL,’’,’’,’’,0,1,0),
(‘Positive microbuminuria test doc/rev w/labs’,’’,‘3062F’,4,’’,NULL,NULL,’’,’’,’’,0,1,0),
(‘Positive microbuminuria test documented/reviewed’,’’,‘3060F’,4,’’,NULL,NULL,’’,’’,’’,0,1,0),
(‘Most recent LDL-C 100-129 mg/dl’,’’,‘3049F’,4,’’,NULL,NULL,’’,’’,’’,0,1,0),
(‘BMI documented’,’’,‘3008F’,4,’’,NULL,NULL,’’,’’,’’,0,1,0),
(‘Dilated retinal eye exam interpreted by optomologist’,’’,‘2022F’,4,’’,NULL,NULL,’’,’’,’’,0,1,0),
(‘Review of all meds by prescriber’,’’,‘1160F’,4,’’,NULL,NULL,’’,’’,’’,0,1,0),
(‘Most recent diastolic blood pressure 80-89mm Hg’,’’,‘3079F’,4,’’,NULL,NULL,’’,’’,’’,0,1,0),
(‘Most recent systolic blood pressure 130-139mm Hg’,’’,‘3075F’,4,’’,NULL,NULL,’’,’’,’’,0,1,0),
(‘Tobacco screening, recv/cessation/counseling’,’’,‘4004F’,4,’’,NULL,NULL,’’,’’,’’,0,1,0),
(‘Tobacco use cessation intervention, counseling’,’’,‘4000F’,4,’’,NULL,NULL,’’,’’,’’,0,1,0),
(‘Negative microbuminuria test documented/reviewed’,’’,‘3061F’,4,’’,NULL,NULL,’’,’’,’’,0,1,0),
(‘Most recent LDL-C >130 mg/dl’,’’,‘3050F’,4,’’,NULL,NULL,’’,’’,’’,0,1,0),
(‘Most recent LDL-C <100 mg/dl’,’’,‘3048F’,4,’’,NULL,NULL,’’,’’,’’,0,1,0),
(‘Most recent HbA1c level greater than 9.0%’,’’,‘3046F’,4,’’,NULL,NULL,’’,’’,’’,0,1,0),
(‘Functional status assessed’,’’,‘1170F’,4,’’,NULL,NULL,’’,’’,’’,0,1,0),
(‘Most recent HbA1c level less than 7.0%’,’’,‘3044F’,4,’’,NULL,NULL,’’,’’,’’,0,1,0),
(‘Most recent HbA1c level between 7.0-9.0%’,’’,‘3045F’,4,’’,NULL,NULL,’’,’’,’’,0,1,0),
(‘Advanced care planning’,’’,‘1158F’,4,’’,NULL,NULL,’’,’’,’’,0,1,0),
(‘Medication list documented in records’,’’,‘1159F’,4,’’,NULL,NULL,’’,’’,’’,0,1,0),
(‘Pain severity quantified, pain present’,’’,‘1125F’,4,’’,NULL,NULL,’’,’’,’’,0,1,0),
(‘Advanced care plan or legal document’,’’,‘1157F’,4,’’,NULL,NULL,’’,’’,’’,0,1,0),
(‘Pain severity quantified, no pain present’,’’,‘1126F’,4,’’,NULL,NULL,’’,’’,’’,0,1,0),
(‘Discharge medication list reconciled w/current list’,’’,‘1111F’,4,’’,NULL,NULL,’’,’’,’’,0,1,0);
I took the file and imported it into the 4.1.2 Demo using the Import Configuration in Backup. These codes and associated columns were faithfully populated in Administration/Codes and in the codes tables as well. I was unable to import into Database using the Import tab (Error in processing request. Error Code: 500. Error Text: Internal Server Error.)
The AMA data set should be a one time import for most practices.
After the AMA data set had been unzipped, where should the user place this file?
The code types insertion should not be necessary because they had been preloaded. The columns for taxrates and cyp_factor are also unnecessary. The code_type should be should be 1. Is that correct?
With these modifications to Kim’s file, what script should be run in Command Prompt to render the .sql file? I assume that the use of Command Prompt obviates the need to use OpenOffice.
While using Command Prompt, will mysqlusername and mysqlpassword be asked?
It should not matter very much the location of the new .sql if Import Configuration is used. Is this method of Import ill-advised?