It’s kind of ugly, but here’s another demonstration of data import for the codes table.
I copy and pasted the new CVX codes from the CDC website into OpenOffice Calc and wrote the concatenate formula in column G.
Same basic approach could be used for CPT codes.
Sounds like need a fix for the codes table ‘short descriptions’ length and addition of the new CVX codes in database.sql and the upgrade sql script. Also looks like need a Active/Inactive mechanism here, which has not yet really been incorporated, that would only allow adding new ‘active’ vaccines while still allow viewing/mapping of ‘inactive’ vaccines.
Yes, I using immunizations to report all given vaccines. I use it to export immunizations to report to state registry, MI.
As you might know it is very complicated process to relate drugs inventory and consumables from immunizations. As well as billing codes and administrations in the Fee sheet need some automation to relate the given Immunization to the billing codes ICD9 and CPT4 + fees
Thanks for the table update.
Mohamed Massoud
Concatenation in OpenOffice Calc is no walk in the park. The Help section of the application is clear as mud regarding the function and syntax. Online tutorials are better.
Have to put on the best pair of glasses for this stuff!
This is the formula:
$C$1& “’”& A2& “’”& “,’”& B2& “,”& “1”& “);”
Output:
INSERT INTO codes (code_text, code, code_type) VALUES( ’ Comprehensive Exam, New ','92004,1);
How does one get rid of the space demarcated by the red square and add a single quote in the area shown by the red circle of the attachment?
Will this work in the .sql file?
Changed the Insert string to this:
INSERT INTO codes (code_text, code, code_type) VALUES
Changed the formula to this:
$C$1& “(”& “’”& A2& “’”& “,’”& B2& “’”& “,”& “1”& “);”
New output:
INSERT INTO codes (code_text, code, code_type) VALUES (’ Comprehensive Exam, New ',‘92004’,1);
This way, one could generate the “VALUES” clause just by specifying the range of cells containing the value and not need to worry about the comma and quote stuff.
Dr. Massoud,
I’ve written some code for Dr. Kay which allows defining vaccination schedules (sets of vaccines for a given age). In those schedules, in addition to the CVX code, a CPT4 and ICD9 code is also associated with each entry. So if one chooses an immunization through that interface, when the save button is pressed, appropriate billing entries are also created on the fee sheet for the active encounter.
There’s no connection to inventory though, and there’s no “maintenance” interface to update the codes. (I just do it directly in the MySQL tables for now.)
I’m curious what format the MI state registry uses for immunization data. Dr. Kay is in CA, and they expect HL7 in a format that I don’t believe OpenEMR is capable of generating at the moment.
You are correct about a space after the left parenthesis in the Insert statement. The space after the prime was the result of not lining up the descriptions flush with the left side of the Column A.
I realized the problem with the the set of quotes surrounding the prime as you were posting.
Thank you for the link to the Macros (understood a third of it, fantastic; starting to be fun) and all the help getting the CPT import mini-article written. Mission accomplished.