# Need to update ICD 10 codes - Suggestions needed **URL:** \ **Category:** Management and Administration\ **Created:** [November 5, 2019, 1:40pm UTC](https://community.open-emr.org/t/need-to-update-icd-10-codes-suggestions-needed/13106 "2019-11-05T13:40:10Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![dorareddys](https://community.open-emr.org/letter_avatar_proxy/v4/letter/d/4bbf92/32.png) [@dorareddys](https://community.open-emr.org/u/dorareddys)\ **Post date:** [November 5, 2019, 1:40pm UTC](https://community.open-emr.org/t/need-to-update-icd-10-codes-suggestions-needed/13106/1 "2019-11-05T13:40:10Z")
Hi All, We haven’t updated ICD 10 codes in our system since 2017 So what are the steps needed for importing all data. I see in [https://www.cms.gov/Medicare/Coding/ICD10/index.html](https://www.cms.gov/Medicare/Coding/ICD10/index.html) there are 2018,2019 and 2020 versions released how to import all these version codes in to our system. Please guide And what are the database tables names which contain all ICD 10 and SNOMED codes. ---
**Author:** ![stephenwaite](https://community.open-emr.org/user_avatar/community.open-emr.org/stephenwaite/32/15754_2.png) [@stephenwaite](https://community.open-emr.org/u/stephenwaite)\ **Post date:** [November 5, 2019, 6:38pm UTC](https://community.open-emr.org/t/need-to-update-icd-10-codes-suggestions-needed/13106/2 "2019-11-05T18:38:31Z")
hi @dorareddys, if you are running 5.0.2.1 (first patch installed) then you can move the [2020 files](https://github.com/openemr/openemr/commit/53b8ae655f3fc2d31f7380b66f49733b8965b2ba#diff-43dab7d2ea1c943ac0bdeb4722ff761f) in and the 2019 files out of the `contrib/icd10` folder and then import through admin-\>other-\>external data loads after you load the [checksums](https://github.com/openemr/openemr/commit/53b8ae655f3fc2d31f7380b66f49733b8965b2ba#diff-ca551192299cf2411135c1e2e4d9a0e2R6610-R6613) into the `supported_external_dataloads` table ---
**Author:** ![dorareddys](https://community.open-emr.org/letter_avatar_proxy/v4/letter/d/4bbf92/32.png) [@dorareddys](https://community.open-emr.org/u/dorareddys)\ **Post date:** [November 6, 2019, 6:32am UTC](https://community.open-emr.org/t/need-to-update-icd-10-codes-suggestions-needed/13106/3 "2019-11-06T06:32:03Z")
@stephenwaite Thanks for your reply. We have not updated our ICD 10 codes since 2017, is it ok to just update to 2020 files. ---
**Author:** ![stephenwaite](https://community.open-emr.org/user_avatar/community.open-emr.org/stephenwaite/32/15754_2.png) [@stephenwaite](https://community.open-emr.org/u/stephenwaite)\ **Post date:** [November 6, 2019, 12:38pm UTC](https://community.open-emr.org/t/need-to-update-icd-10-codes-suggestions-needed/13106/4 "2019-11-06T12:38:11Z")
hi @dorareddys, yes, if you’re running 5.0.2.1. ---
**Author:** ![dorareddys](https://community.open-emr.org/letter_avatar_proxy/v4/letter/d/4bbf92/32.png) [@dorareddys](https://community.open-emr.org/u/dorareddys)\ **Post date:** [November 6, 2019, 6:01pm UTC](https://community.open-emr.org/t/need-to-update-icd-10-codes-suggestions-needed/13106/5 "2019-11-06T18:01:34Z")
@stephenwaite Thanks for the reply. We haven’t updated code since 2017 So copying library/standard\_tables\_capture.inc from openemr 5.0.2.1 into our system is sufficient for upgrading icd 10 or do i need to copy any other files? Please suggest. ---
**Author:** ![stephenwaite](https://community.open-emr.org/user_avatar/community.open-emr.org/stephenwaite/32/15754_2.png) [@stephenwaite](https://community.open-emr.org/u/stephenwaite)\ **Post date:** [November 6, 2019, 10:35pm UTC](https://community.open-emr.org/t/need-to-update-icd-10-codes-suggestions-needed/13106/6 "2019-11-06T22:35:06Z")
hi @dorareddys, probably be fine but never hurts to test on a development system first 🙂 the development system can also be a great way to test your backup and restore process, not to mention the upgrade, lots of new stuff since 2017 🙂 ---
**Author:** ![dorareddys](https://community.open-emr.org/letter_avatar_proxy/v4/letter/d/4bbf92/32.png) [@dorareddys](https://community.open-emr.org/u/dorareddys)\ **Post date:** [November 8, 2019, 2:05pm UTC](https://community.open-emr.org/t/need-to-update-icd-10-codes-suggestions-needed/13106/7 "2019-11-08T14:05:02Z")
Thanks @stephenwaite for prompt responses. Let me understand on upgrading 2020 ICD 10 more clearly. **Step 1:** Download and Copy these 2 files **2020-ICD-10-CM-Codes.zip** and **2020-ICD-10-PCS-Order.zip** and place it in contrib folder. **Step 2:** need to place below 2 scripts in upgrade file and run them #IfNotRow4D supported\_external\_dataloads load\_type ICD10 load\_source CMS load\_release\_date 2019-10-01 load\_filename 2020-ICD-10-CM-Codes.zip INSERT INTO `supported_external_dataloads` (`load_type`, `load_source`, `load_release_date`, `load_filename`, `load_checksum`) VALUES (‘ICD10’, ‘CMS’, ‘2019-10-01’, ‘2020-ICD-10-CM-Codes.zip’, ‘745546b3c94af3401e84003e1b143b9b’); #EndIf #IfNotRow4D supported\_external\_dataloads load\_type ICD10 load\_source CMS load\_release\_date 2019-10-01 load\_filename 2020-ICD-10-PCS-Order.zip INSERT INTO `supported_external_dataloads` (`load_type`, `load_source`, `load_release_date`, `load_filename`, `load_checksum`) VALUES (‘ICD10’, ‘CMS’, ‘2019-10-01’, ‘2020-ICD-10-PCS-Order.zip’, ‘8dc136d780ec60916e9e1fc999837bc8’); #EndIf **Step 3:** Copying library/standard\_tables\_capture.inc from openemr 5.0.2.1 into our system **Step 4:** Goto External Data Loads and Select ICD 10 and Run Upgrade button. I’m i missed anything or Good to go. Please suggest. ---
**Author:** ![stephenwaite](https://community.open-emr.org/user_avatar/community.open-emr.org/stephenwaite/32/15754_2.png) [@stephenwaite](https://community.open-emr.org/u/stephenwaite)\ **Post date:** [November 8, 2019, 2:14pm UTC](https://community.open-emr.org/t/need-to-update-icd-10-codes-suggestions-needed/13106/8 "2019-11-08T14:14:58Z")
hi @dorareddys, step1 should also remove the 2019 files ---
**Author:** ![dorareddys](https://community.open-emr.org/letter_avatar_proxy/v4/letter/d/4bbf92/32.png) [@dorareddys](https://community.open-emr.org/u/dorareddys)\ **Post date:** [November 8, 2019, 2:28pm UTC](https://community.open-emr.org/t/need-to-update-icd-10-codes-suggestions-needed/13106/9 "2019-11-08T14:28:33Z")
@stephenwaite ok. Few more questions on ICD 10 codes 1. What are Billable ICD 10 codes? All codes from 2020-ICD-10-CM-Codes.zip are billable? and 2020-ICD-10-PCS-Order.zip are non-billable codes? 2. Is ICD 11 codes also released? If Yes Where can they available? Thanks for all your help. ---
**Author:** ![stephenwaite](https://community.open-emr.org/user_avatar/community.open-emr.org/stephenwaite/32/15754_2.png) [@stephenwaite](https://community.open-emr.org/u/stephenwaite)\ **Post date:** [November 8, 2019, 3:29pm UTC](https://community.open-emr.org/t/need-to-update-icd-10-codes-suggestions-needed/13106/10 "2019-11-08T15:29:42Z")
ICD-10-CM is used to justify procedure codes like CPT used in US billing while the other file quoting from CMS “The ICD-10-PCS is a procedure classification published by the United States for classifying procedures performed in hospital inpatient health care settings.” ICD-11 are released but there is no official US version yet ---
**Author:** ![growlingflea](https://community.open-emr.org/user_avatar/community.open-emr.org/growlingflea/32/15498_2.png) [@growlingflea](https://community.open-emr.org/u/growlingflea)\ **Post date:** [November 20, 2019, 6:14am UTC](https://community.open-emr.org/t/need-to-update-icd-10-codes-suggestions-needed/13106/11 "2019-11-20T06:14:56Z")
It seems that the 2020 files in master don’t have all the codes. I can’t find P04.81, which a customer was looking for. ---
**Author:** ![stephenwaite](https://community.open-emr.org/user_avatar/community.open-emr.org/stephenwaite/32/15754_2.png) [@stephenwaite](https://community.open-emr.org/u/stephenwaite)\ **Post date:** [November 20, 2019, 3:48pm UTC](https://community.open-emr.org/t/need-to-update-icd-10-codes-suggestions-needed/13106/12 "2019-11-20T15:48:17Z")
Hi @growlingflea, that was a new code in the 2019 set but it’s also in the 2020 files. Just used external data loads on the demo farm 🐄 ![Untitled](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/2/2e1f3b78b44923c2929706b7a36e97f6b440b1ac.png) ---
**Author:** ![growlingflea](https://community.open-emr.org/user_avatar/community.open-emr.org/growlingflea/32/15498_2.png) [@growlingflea](https://community.open-emr.org/u/growlingflea)\ **Post date:** [November 20, 2019, 5:23pm UTC](https://community.open-emr.org/t/need-to-update-icd-10-codes-suggestions-needed/13106/13 "2019-11-20T17:23:38Z")
Maybe I did this wrong. I downloaded the 2020 files from master branch in github: ![image](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/d/d4eadfd91bba2166060e6644c0cbdd4ffddfe1ac.png) I moved them into my contrib folder. Previously there were files from 2018. This is OpenEMR-501 ![image](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/b/bb4e9a41e936c81fff579459470b87092b21a816.png) I put the following in the phpmyadmin console: #IfNotRow4D supported\_external\_dataloads load\_type ICD10 load\_source CMS load\_release\_date 2019-10-01 load\_filename 2020-ICD-10-CM-Codes.zip INSERT INTO supported\_external\_dataloads (load\_type, load\_source, load\_release\_date, load\_filename, load\_checksum) VALUES (‘ICD10’, ‘CMS’, ‘2019-10-01’, ‘2020-ICD-10-CM-Codes.zip’, ‘745546b3c94af3401e84003e1b143b9b’); #EndIf #IfNotRow4D supported\_external\_dataloads load\_type ICD10 load\_source CMS load\_release\_date 2019-10-01 load\_filename 2020-ICD-10-PCS-Order.zip INSERT INTO supported\_external\_dataloads (load\_type, load\_source, load\_release\_date, load\_filename, load\_checksum) VALUES (‘ICD10’, ‘CMS’, ‘2019-10-01’, ‘2020-ICD-10-PCS-Order.zip’, ‘8dc136d780ec60916e9e1fc999837bc8’); #EndIf Then went to External Dataloads and I received confirmation that the files are correct. ![image](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/c/ca3c588095e8d6c8472740b9b8f081eaf72c275b.png) Then when I go to the search, this code does not show anything for the specified code: ![image](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/9/96b19560dc6e9ef6536ffec27b5fd094b8b30571.png) ---
**Author:** ![stephenwaite](https://community.open-emr.org/user_avatar/community.open-emr.org/stephenwaite/32/15754_2.png) [@stephenwaite](https://community.open-emr.org/u/stephenwaite)\ **Post date:** [November 20, 2019, 7:49pm UTC](https://community.open-emr.org/t/need-to-update-icd-10-codes-suggestions-needed/13106/14 "2019-11-20T19:49:45Z")
something went wrong, you’ll have to remove the 2020 entry from `standardized_tables_track` and redo after making code changes in `library/standard_tables_capture.inc` [2020 I10 dx update with a work around for nested folder (#2630) · stephenwaite/openemr@53b8ae6 · GitHub](https://github.com/stephenwaite/openemr/commit/53b8ae655f3fc2d31f7380b66f49733b8965b2ba#diff-a9c7b92fb95a43b40259b6c09de1644b) ---
**Author:** ![growlingflea](https://community.open-emr.org/user_avatar/community.open-emr.org/growlingflea/32/15498_2.png) [@growlingflea](https://community.open-emr.org/u/growlingflea)\ **Post date:** [November 20, 2019, 8:54pm UTC](https://community.open-emr.org/t/need-to-update-icd-10-codes-suggestions-needed/13106/15 "2019-11-20T20:54:55Z")
So this will work with 501 too? ---
**Author:** ![stephenwaite](https://community.open-emr.org/user_avatar/community.open-emr.org/stephenwaite/32/15754_2.png) [@stephenwaite](https://community.open-emr.org/u/stephenwaite)\ **Post date:** [November 20, 2019, 9:26pm UTC](https://community.open-emr.org/t/need-to-update-icd-10-codes-suggestions-needed/13106/16 "2019-11-20T21:26:52Z")
sure, the code change is to handle the nested folder in the 2020 cms icd zip file ---
**Author:** ![growlingflea](https://community.open-emr.org/user_avatar/community.open-emr.org/growlingflea/32/15498_2.png) [@growlingflea](https://community.open-emr.org/u/growlingflea)\ **Post date:** [November 25, 2019, 5:26pm UTC](https://community.open-emr.org/t/need-to-update-icd-10-codes-suggestions-needed/13106/17 "2019-11-25T17:26:41Z")
I followed the instructions here and it made all the older ICD10 codes disppear. Codes were unavailable via the billing and WMT modules. I re-tried the procedure again and then all ICD10 codes were unavailable but some of the tables were visible from phpmyadmin. I ended up having to copy all the ICD10 tables from a backup database and put them in the live database to get the codes back. Now its working as it did before the upgrade attempt. I’m wondering if there is a step that I missed? I am working with a copy of 501, and we have the files from 2018. Do I need to install the 2019 first, then the 2020 codes? From what I read it wasn’t necessary for 502, but would it be necessary for 501? Thanks!! ---
**Author:** ![stephenwaite](https://community.open-emr.org/user_avatar/community.open-emr.org/stephenwaite/32/15754_2.png) [@stephenwaite](https://community.open-emr.org/u/stephenwaite)\ **Post date:** [November 25, 2019, 9:29pm UTC](https://community.open-emr.org/t/need-to-update-icd-10-codes-suggestions-needed/13106/18 "2019-11-25T21:29:19Z")
hi @growlingflea, no, you can go straight to 2020 since it loads the whole new set not incrementally. ---
**Author:** ![dorareddys](https://community.open-emr.org/letter_avatar_proxy/v4/letter/d/4bbf92/32.png) [@dorareddys](https://community.open-emr.org/u/dorareddys)\ **Post date:** [December 5, 2019, 7:38am UTC](https://community.open-emr.org/t/need-to-update-icd-10-codes-suggestions-needed/13106/19 "2019-12-05T07:38:41Z")
@stephenwaite I’m getting 500 internal server error When i click upgrade. Followed the same steps. Attached the screenshot for reference. I’m using PHP version 5.6.31. ![icd10-import](https://discourse-uploads-openemr.s3.dualstack.us-east-1.amazonaws.com/original/2X/e/ebc33f63807825078d858120927f0eaff52c19d2.jpeg) ---
**Author:** ![stephenwaite](https://community.open-emr.org/user_avatar/community.open-emr.org/stephenwaite/32/15754_2.png) [@stephenwaite](https://community.open-emr.org/u/stephenwaite)\ **Post date:** [December 5, 2019, 5:08pm UTC](https://community.open-emr.org/t/need-to-update-icd-10-codes-suggestions-needed/13106/20 "2019-12-05T17:08:17Z")
hi @dorareddys, what openemr version are you running? [Next page](https://community.open-emr.org/t/need-to-update-icd-10-codes-suggestions-needed/13106.md?page=2)