ICD10 spanish version?

Management and Administration
#21

@Fernando_Guerra , mejor cambia el nombre a las tablas originales para resguardo y luego ejecuta los script sql que te envié. Crearán tablas nuevas.
Saludos.
Luis
(Sorry to the forum for writing in Spanish)

#22

Thanks so much Luis, I’ve just installed OpenEMR v7 in a hosting space, I’m so happy ! First I’ll try it in my local VirtualBox Ubuntu 20 then I’ll let you know

Muchas gracias Luis un fuerte abrazo

2 Likes
#23

It works ok !
Thanks !!!

1 Like
#24

Thank you Luis,

This scripts will replace “english version” of ICD10. In my case, I am running MariaDB in my server, I can connect to it using DBeaver.

I had to drop table and create it again. I noticed that some codes exceeds 7 characters, so I modified the column size to 10.

I recommend to drop the table as first step

DROP TABLE IF EXISTS icd10_dx_order_code;

DROP TABLE IF EXISTS icd10_pcs_order_code;

Then create it again

CREATE TABLE icd10_dx_order_code (
  dx_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  dx_code varchar(10) DEFAULT NULL,
  formatted_dx_code varchar(10) DEFAULT NULL,
  valid_for_coding char(1) DEFAULT NULL,
  short_desc varchar(60) DEFAULT NULL,
  long_desc text DEFAULT NULL,
  active tinyint(4) DEFAULT 0,
  revision int(11) DEFAULT 0,
 UNIQUE KEY dx_id (dx_id),
 KEY formatted_dx_code (formatted_dx_code),
 KEY active (active)
) ENGINE=InnoDB CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

CREATE TABLE icd10_pcs_order_code (
  pcs_id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  pcs_code varchar(10) DEFAULT NULL,
  valid_for_coding char(1) DEFAULT NULL,
  short_desc varchar(60) DEFAULT NULL,
  long_desc text DEFAULT NULL,
  active tinyint(4) DEFAULT 0,
  revision int(11) DEFAULT 0,
  UNIQUE KEY pcs_id (pcs_id),
  KEY pcs_code (pcs_code),
  KEY active (active)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

and then run the batch insert script.

2 Likes