done. http://care2x.org/wiki/index.php/How_to_integrate_ICD10_codes_in_another_language
At the moment the page is the same as in the mail, but it could be improved in the future. Greetings Kaloyan On Fri, 2006-05-12 at 10:31 -0400, Elpidio Latorilla wrote: > 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 <[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 > > > > > > > > > > ------------------------------------------------------- > 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
