Need to update ICD 10 codes - Suggestions needed


(Dora Reddy) #21

@stephenwaite We haven’t updated openemr since couple of years.

I have copied latest openemr 5.0.2 library/standard_tables_capture.inc file into our system.

Do i need to copy any other files from openemr 5.0.2?


(Stephen Waite) #22

don’t think so, do you have php-zip mod installed?


(Dora Reddy) #23

@stephenwaite Presently below version if zip installed on our server. Please suggest.


(Stephen Waite) #24

ok, the fix for the zip is in the yet to be released patch 2 but you could hand edit the code change from back port portal password (#2739) · stephenwaite/openemr@83d0804 · GitHub


(Daniel) #25

Thank you for the update. This will be very helpful!


(Dora Reddy) #26

@stephenwaite I can able to fix the issue and imported ICD10 data into our system.

Just for the confirmation below the number of records inserted in both tables.

Is the values correct? Can you please confirm.

SELECT count(*) FROM icd10_dx_order_code ORDER BY dx_id ASC
94765

SELECT count(*) FROM icd10_pcs_order_code ORDER BY pcs_id ASC
78439


(Stephen Waite) #27

hi @dorareddys, the count isn’t the best check since multiple versions can exist. Better to look for a new code for 2020 like I4811 or I48.11 in the icd10_dx_order_code table


(Daniel) #28

One thing to be careful is I am finding that when I do the ICD10 upgrade I only can query the new codes when I am on the fee sheet.

Here I search for I48% and I get the following response:

but when I look at the table I see this:

for some reason all the old codes are being set to ‘0’ under active. Any reasons why this would be?


(Dora Reddy) #29

I verified and code I48.11 was found in my icd10_dx_order_code table.

But my earlier icd10_dx_order_code table had 97729 records

New table contain less number of records 94765

Is it ok?


(Stephen Waite) #30

hi @growlingflea, yes, that’s by design. You wan to inactivate the old codes so they’re not chosen for future billing through the fee sheet as well as bring in any new codes.


(Stephen Waite) #31

you should be fine @dorareddys, guessing you had to truncate the table at some point which would explain why you probably have no prior revisions like @growlingflea


(Daniel) #32

But its inactivating codes that are still active. There are more than 4 active I48% codes, but the script inactivated the other active 8.


(Stephen Waite) #33

which is okay but it’s not loading them as active for revision 2

just tested on yet to be released patch 2 and it’s working ok


(Daniel) #34

What is the suggestion you have when I have folks who need the 2020 new codes as well as the codes that are active for other years?


(Stephen Waite) #35

setup a test site installed from latest rel-502 and load 2019, will have to move 2020 files out of contrib/icd10 temporarily

then bring in 2020, verify data, and then export for an import on your production

if folks need older codes active you’ll have to run custom sql statements am afraid