Hello,
As far as I know there is no guide How to integrate icd 10 codes in a
New Language in care2x. But I can give some technical information.
The ICD10 codes are stored in the database in separate table for each
language. The table is named "care_icd10_xx", where "xx" has to be
substituted with the language code (for French this is "fr").
The structure of the table is as follows:
Field Type
=============================
diagnosis_code varchar(12)
description text
class_sub varchar(5)
type varchar(10)
inclusive text
exclusive text
notes text
std_code char(1)
sub_level tinyint(4)
remarks text
extra_codes text
extra_subclass text
The three most important fields are:
- diagnosis_code - the icd10 code, example "A00"
- description - description of the icd10 code, example "Cholera"
- sub_level - determines the number of digits/signs in the code.
Example, for "A00" the sub_level is 3, for "A00.0", the sub_level is 4.
The database table is filled during the installation by a corresponding
CSV (comma-separated-values) file: icd10_xx.csv
The location of the icd10 csv files in the Subversion repository is:
/trunk/Care2002/installer/db/icd10
If you want to introduce icd10 codes for new language there are two
approaches:
1. You have the translation already (for example by a healthcare
institution) in some data format (ex. Excel). You have to convert the
data to a CSV file.
2. You want to translate icd10 from scratch. In this case you take an
existing CSV file (ex. icd10_en.csv) and translate the text in the new
language.
In both cases you end up with new icd10_xx.csv file. Then you have to
submit the file in the Subversion repository.
You have to also update the sql dumps that create the database structure
- to create the care_icd10_xx table that will hold the icd10 data for
the new xx language. The location of the sql dumps in Subversion is:
/trunk/Care2002/installer/db/sql
For French language you have to add the following in the
mysql_dump.sql:
CREATE TABLE care_icd10_fr (
diagnosis_code varchar(12) NOT NULL,
description text NOT NULL,
class_sub varchar(5) NOT NULL,
type varchar(10) NOT NULL,
inclusive text NOT NULL,
exclusive text NOT NULL,
notes text NOT NULL,
std_code char(1) NOT NULL,
sub_level tinyint(4) DEFAULT '0' NOT NULL,
remarks text NOT NULL,
extra_codes text NOT NULL,
extra_subclass text NOT NULL,
KEY diagnosis_code (diagnosis_code),
PRIMARY KEY (diagnosis_code)
);
and in the postgres7_dump.sql:
CREATE TABLE "care_icd10_bg" (
"diagnosis_code" character varying(12),
"description" text,
"class_sub" character varying(5),
"type" character varying(10),
"inclusive" text,
"exclusive" text,
"notes" text,
"std_code" character(1),
"sub_level" smallint DEFAULT '0',
"remarks" text,
"extra_codes" text,
"extra_subclass" text
);
CREATE INDEX icd10bg_code ON care_icd10_bg USING btree (diagnosis_code);
Updating the sql dumps and adding the csv file will automatically update
the installer to give the possibility to install the icd10 codes for the
new language.
Greetings
Kaloyan
On Thu, 2006-05-11 at 20:17 +0200, Marc Cuggia wrote:
> Hi,
> I've started this job last year. I would like to find people speaking
> french to
> correctly translate Care2x and to integrate ICD10 in french.
>
> If somebody is ok, contact me.
>
> Marc
>
>
>
> Quoting Robert Meggle <[EMAIL PROTECTED]>:
>
> > Hi All,
> >
> > There was an interesting question from Gaston Ndoumbe in the mailing ist
> > Care2002-africa. Maybe others still working on that issue and can give him a
> > helping hand.
> >
> > Robert
> >
> >
> > _____
> >
> > Von: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] Im Auftrag von gaston
> > ndoumbe
> > Gesendet: Donnerstag, 11. Mai 2006 16:29
> > An: [EMAIL PROTECTED]
> > Betreff: [Care2002-africa] Fwd: Integration of ICD 10 codes in french
> >
> >
> >
> >
> > ---------- Forwarded message ----------
> > From: gaston ndoumbe <[EMAIL PROTECTED]>
> > Date: May 10, 2006 4:49 PM
> > Subject: Integration of ICD 10 codes in french
> > To: [EMAIL PROTECTED]
> >
> >
> > HI I would like to know if somebody knows where i can find a guide How to
> > integrate icd 10 codes in a New Language in care2x (french to be specific)
> >
> > thx for your help
> >
> > --
> > Gaston Ndoumbe
> >
> >
> > --
> > Gaston Ndoumbe
> >
> >
>
>
>
>
>
> -------------------------------------------------------
> Using Tomcat but need to do more? Need to support web services, security?
> Get stuff done quickly with pre-integrated technology to make your job easier
> Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
> http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
> _______________________________________________
> Care2002-developers mailing list
> Care2002-developers@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/care2002-developers
-------------------------------------------------------
Using Tomcat but need to do more? Need to support web services, security?
Get stuff done quickly with pre-integrated technology to make your job easier
Download IBM WebSphere Application Server v.1.0.1 based on Apache Geronimo
http://sel.as-us.falkag.net/sel?cmd=lnk&kid=120709&bid=263057&dat=121642
_______________________________________________
Care2002-developers mailing list
Care2002-developers@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/care2002-developers
