Hi Kaloyan,
this could be a good entry in the manual wiki.
Elpidio
Kaloyan Raev wrote:
>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 <meggle@merotech.de>:
>>
>>
>>
>>>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: care2002-africa-admin@lists.sourceforge.net />
>>>[mailto:care2002-africa-admin@lists.sourceforge.net] Im Auftrag von gaston
>>>ndoumbe
>>>Gesendet: Donnerstag, 11. Mai 2006 16:29
>>>An: Care2002-africa@lists.sourceforge.net />
>>>Betreff: [Care2002-africa] Fwd: Integration of ICD 10 codes in french
>>>
>>>
>>>
>>>
>>>---------- Forwarded message ----------
>>>From: gaston ndoumbe <gaston.ndoumbe@gmail.com>
>>>Date: May 10, 2006 4:49 PM
>>>Subject: Integration of ICD 10 codes in french
>>>To: Care2002-africa@lists.sourceforge.net />
>>>
>>>
>>>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 -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 -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
>
>
>
|