Icd 10cm and pcs database

Management and Administration
1

morenatoxx wrote on Sunday, December 04, 2016:

good morning,

is there anyone here who have all icd10 diagnosis and procedure codes in a form of csv or excel or know where i can get hold of them?? Please help me out, im in deep need of those 2 databases

2

bradymiller wrote on Tuesday, December 06, 2016:

Hi Morena,

These codes can be downloaded (I think are in csv form) here:
https://www.cms.gov/Medicare/Coding/ICD10/2017-ICD-10-CM-and-GEMs.html
https://www.cms.gov/Medicare/Coding/ICD10/2017-ICD-10-PCS-and-GEMs.html

-brady
OpenEMR

3

voipbound wrote on Sunday, March 12, 2017:

I downloaded these files but OEMR noted that these zip files are unsupported. What do we need to do to have OEMR supoorted?

TIA

4

cmswest wrote on Sunday, March 12, 2017:

here are the changes to the files:

make the code change (1 line is changed in library/standard_tables_capture.inc)

-	    if (!stripos($filename, ".txt") || stripos($filename,"diff")) {
+	    if (!stripos($filename, ".txt") || stripos($filename,"diff") || stripos($filename, "addenda")) {

move the new icd10 files into the contrib/icd10 folder and remove the old ones

contrib/icd10/2017-GEM-DC.zip
contrib/icd10/2017-GEM-PCS.zip
contrib/icd10/2017-ICD10-Code-Descriptions.zip
contrib/icd10/2017-PCS-Long-Abbrev-Titles.zip

run the sql statements in phpmyadmin

INSERT INTO `supported_external_dataloads` (`load_type`, `load_source`, `load_release_date`, `load_filename`, `load_checksum`) VALUES ('ICD10', 'CMS', '2016-10-01', '2017-PCS-Long-Abbrev-Titles.zip', '4669c47f6a9ca34bf4c14d7f93b37993');

INSERT INTO `supported_external_dataloads` (`load_type`, `load_source`, `load_release_date`, `load_filename`, `load_checksum`) VALUES ('ICD10', 'CMS', '2016-10-01', '2017-GEM-DC.zip', '5a0affdc77a152e6971781233ee969c1');

INSERT INTO `supported_external_dataloads` (`load_type`, `load_source`, `load_release_date`, `load_filename`, `load_checksum`) VALUES ('ICD10', 'CMS', '2016-10-01', '2017-ICD10-Code-Descriptions.zip', 'ed9c159cb4ac4ae4f145062e15f83291');

INSERT INTO `supported_external_dataloads` (`load_type`, `load_source`, `load_release_date`, `load_filename`, `load_checksum`) VALUES ('ICD10', 'CMS', '2016-10-01', '2017-GEM-PCS.zip', 'a4e08b08fb9a53c81385867c82aa8a9e');

run the external database upgrade for icd10 from the admin menu

good luck