Upgrade icd10 code set

[stephenwaite]

it’s that time of year again

this icd10 update is for dos >= 10-1-2017

1. you can go get the files from https://www.cms.gov/Medicare/Coding/ICD10/2018-ICD-10-CM-and-GEMs.html and place the files in the contrib/icd10 folder

2. then remove the 2017 files from that folder

3. then go to your favorite mysql prompt and run the following queries or copy and paste into the phpmyadmin sql query tool

   INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES ("ICD10", "CMS", "2017-10-01", "2018-ICD-10-PCS-Order-File.zip", "264b342310236f2b3927062d2c72cfe3"); INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES ("ICD10", "CMS", "2017-10-01", "2018-ICD-10-CM-General-Equivalence-Mappings.zip", "787a025fdcf6e1da1a85be779004f670"); INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES ("ICD10", "CMS", "2017-10-01", "2018-ICD-10-Code-Descriptions.zip", "6f9c77440132e30f565222ca9bb6599c"); INSERT INTO supported_external_dataloads (load_type, load_source, load_release_date, load_filename, load_checksum) VALUES ("ICD10", "CMS", "2017-10-01", "2018-ICD-10-PCS-General-Equivalence-Mappings.zip", "bb73c80e272da28712887d7979b1cebf");

4. finally run the external data load script and …

5. you are good to go

[brady.miller]

thanks @stephenwaite!

[ptalerico (Paul Talerico)]

Is the above process described by Stephen a shortcut for developers and code-saavy people, or can it also be done the way I did last year’s ICD10 update: “Administration: External Data Loads: ICD10”?

My plan was to do the latter, but I want to make sure I’m not going to destroy my database by doing so.

Also, the link in “Administration: External Data Loads: ICD10: Instructions” to the raw data feed release is apparently no longer active.

[stephenwaite]

hi @ptalerico, you should follow my steps above; please make a backup before just in case

if you right click on [url](this location) and open in a new tab does it work?

[ptalerico (Paul Talerico)]

Opening the link in a new tab did work, thank you. I’ll add that little tip to my arsenal of troubleshooting tips.

[ptalerico (Paul Talerico)]

In the event that others are as clueless as me as to which of the many files on the CMS website are to be downloaded, I linked the files referenced in Stephen’s instructions (above) to what I believe are the correct files on the CMS website. Please correct me if I’m wrong.

[ptalerico (Paul Talerico)]

[stephenwaite]

thanks @ptalerico

here are the links

https://www.cms.gov/Medicare/Coding/ICD10/Downloads/2018-ICD-10-PCS-Order-File.zip
https://www.cms.gov/Medicare/Coding/ICD10/Downloads/2018-ICD-10-CM-General-Equivalence-Mappings.zip
https://www.cms.gov/Medicare/Coding/ICD10/Downloads/2018-ICD-10-Code-Descriptions.zip
https://www.cms.gov/Medicare/Coding/ICD10/Downloads/2018-ICD-10-PCS-General-Equivalence-Mappings.zip

that you move into the contrib/icd10 folder

[Prakash_Jasoliya]

Can we upgrade ICD-10 from web GUI, instead of method mentioned on top?

[stephenwaite]

you first have to move the files into that directory, then you use the web gui

[Prakash_Jasoliya]

There is option available which says “Upgrade” Just refer attachment. I am just curious to find easiest method to upgrade ICD-10.

[stephenwaite]

those are last year’s codes that were bundled with OpenEMR v5.0; these are the 2018 updated codes

[Penguin8R (CG)]

Good work @stephenwaite ! Thank You & well done!

[Wizard353 (David D. Speck MD)]

I tried following the instructions described above, but got the following warnings (in red) when I prepared to load the October, 2017 version of the IDC-10 info through the Administration interface

UNSUPPORTED database load file:
2018-ICD-10-CM-General-Equivalence-Mappings.zip!
UNSUPPORTED database load file:
2018-ICD-10-Code-Descriptions.zip!
UNSUPPORTED database load file:
2018-ICD-10-PCS-General-Equivalence-Mappings.zip!
UNSUPPORTED database load file:
2018-ICD-10-PCS-Order-File.zip!

Should I go ahead any way, or is there something I can fix?

[stephenwaite]

hi @Wizard353, don’t forget to run the sql, Upgrade icd10 code set

[nursejeff (Jeff Guillory)]

Man I wish I knew what my “favorite mysql prompt” and “the phpmyadmin sql query tool” was.

NurseJeff

[stephenwaite]

it’s under admin->other->database on v5.0

[nursejeff (Jeff Guillory)]

Will the External Database Import Utility unzip these files.

So all I have to do is get these files in the right folder delete the 2017’s and click “upgrade”

NurseJeff

[stephenwaite]

yes, but you have to run that pesky sql command too before you click upgrade

[nursejeff (Jeff Guillory)]

Hi Stephen,

When I go to admin->other->database I get "admin->other->database, I get “PHP 5.5+ is required.”

Is that bad?

NurseJeff