Subject: Unknown diagnosis codes in Georgian DRG definitions
From: Järveläinen Jussi <[email-masked]>
To: Martti Virtanen <[email-masked]>
Cc: Ketevan Goginashvili <[email-masked]>, Maia maglakelidze-khomeriki <[email-masked]>, "[email-masked]" <[email-masked]>, "[email-masked]" <[email-masked]>, "[email-masked]" <[email-masked]>, Serpola Pekka <[email-masked]>
Date: Wed, 23 Jan 2019 11:51:31 +0000

Hello,

There seem to be still two missing dg codes from the logic definitions:
K436 and K437, found today in our own testing.

Discussed this with Georgian ministry and agreed on that this should be fixed, thus could you add these to the tables and send a new full set of tables, w/o other changes.

Best regards,

Jussi

From: Martti Virtanen

Sent: 21. tammikuuta 2019 11:53

To: Järveläinen Jussi

Subject: VS: Unknown diagnose codes in Georgian test data set and RTC=7 error cases

Hei!

Tässä pitäisi olla oikein.

Terv.

Martti

Martti Virtanen

CEO

Nordic Casemix Centre

Paciuksenkatu 19

00270 Helsinki

Finland

martti.virtanen(at)nordcase.org

+3585066728

Lähettäjä: Järveläinen Jussi <[email-masked]>

Lähetetty: perjantai 18. tammikuuta 2019 11.07

Vastaanottaja: Martti Virtanen <[email-masked]>

Aihe: RE: Unknown diagnose codes in Georgian test data set and RTC=7 error cases

Kiitos tiedosta, siis korjaat taulut ja toimitat uuden setin meille?

terv. Jussi

From: Martti Virtanen <[email-masked]>

Sent: 18. tammikuuta 2019 11:06

To: Järveläinen Jussi <[email-masked]>

Subject: VS: Unknown diagnose codes in Georgian test data set and RTC=7 error cases

Joo, plussilla ei ole käytännön merkitystä.

Terv.

Martti

Martti Virtanen

CEO

Nordic Casemix Centre

Paciuksenkatu 19

00270 Helsinki

Finland

martti.virtanen(at)nordcase.org

+3585066728

Lähettäjä: Järveläinen Jussi <[email-masked]>

Lähetetty: keskiviikko 16. tammikuuta 2019 15.31

Vastaanottaja: Martti Virtanen <[email-masked]>

Aihe: RE: Unknown diagnose codes in Georgian test data set and RTC=7 error cases

Hei,

Ja noissa muutamissa ilmeisesti koodeista poistettavat +:t  pitäisi lisätä AST-sarakkeeseen?

terv. Jussi

From: Järveläinen Jussi

Sent: 16. tammikuuta 2019 12:26

To: 'Martti Virtanen' <[email-masked]>; 'Ketevan Goginashvili' <[email-masked]>

Cc: [email-masked]; Serpola Pekka <[email-masked]>

Subject: RE: Unknown diagnose codes in Georgian test data set and RTC=7 error cases

Hello!

Thank-you for new tables.

In our testing we found that there are the following technical errors, that prohibit creating groupers correctly and also fail most test cases.

Illegal codes (extra characters + and ?, and header level procedure) in tables:

Table:                 Codes

icd.dbf:             G711+, M470+, M500?

csp.dbf:            ZX

dg_1.dbf:         G711+, M470+, M500?

complex.dbf:  M500?

Table: Testrule.dbf

* Could you remove extra (different than in the other NordDRG 2018-2019 versions) column
LOG_ID from this table (having this in the future also for NordDRG is another topic, we’ll change then…)

These are quire technical and should be simple fixes. We do not have dBase (ForPro etc.) tools and in principle we should not edit definition tables from NCC by ourselves.

Best regards,

Jussi

Jussi Järveläinen

Director, R&D

Prodacapo Finland

+358-50-5492236

prodacapo.com

www.logexgroup.com

Follow us at LinkedIn

From: Martti Virtanen <[email-masked]>

Sent: 15. tammikuuta 2019 14:29

To: Järveläinen Jussi <[email-masked]>; 'Ketevan Goginashvili' <[email-masked]>

Cc: [email-masked]

Subject: VS: Unknown diagnose codes in Georgian test data set and RTC=7 error cases

Sorry, the tables are in this attachment.

Martti

Martti Virtanen

CEO

Nordic Casemix Centre

Paciuksenkatu 19

00270 Helsinki

Finland

martti.virtanen(at)nordcase.org

+3585066728

Lähettäjä: Martti Virtanen <[email-masked]>

Lähetetty: maanantai 5. marraskuuta 2018 16.19

Vastaanottaja: 'Järveläinen Jussi' <[email-masked]>; 'Ketevan Goginashvili' <[email-masked]>

Kopio: [email-masked]' <[email-masked]>

Aihe: VS: Unknown diagnose codes in Georgian test data set and RTC=7 error cases

Dear Jussi and Ketevan

Most of the codes where either not marked as active or not included in the table of ICD-10 codes sent from Georgia.

Some existing codes may have errors in the data – maternal codes (O-codes) are not accepted for neonates and neonatal codes are not accepted for mother (or other adults)

My comments are below in the table marked with
red

There are a number of inactive codes that might be in use.

I attach a list of these codes. When you have checked these codes, please send me a list of eventual corrections so that I can make a corrected version of the definition tables.

Greetings

Martti

Martti Virtanen

CEO

Nordic Casemix Centre

Paciuksenkatu 19

00270 Helsinki

Finland

martti.virtanen(at)nordcase.org

+3585066728

Lähettäjä: Järveläinen Jussi <[email-masked]>

Lähetetty: tiistai 30. lokakuuta 2018 12.59

Vastaanottaja: Ketevan Goginashvili <[email-masked]>; 'Martti Virtanen ([email-masked])' <[email-masked]>

Aihe: Unknown diagnose codes in Georgian test data set and RTC=7 error cases

Hello!

As agreed on yesterday, attached a listing of diagnosis codes that didn’t group correctly when tested in VisualDRG, and cases where dg+pr combination was considered wrong or rare.

Part of errors (below) are symptom codes w/o etiology and postfixed w. *. You chould put these in data file without * character and include etiology and symptom in DG1A and DG1D fields separately, w/o special characters.
Technically grouper groups those codes w/o etiology if you remove just * character but returns diagnosis status error: “Symptom w/o etiology”.

Some few cases were too old or young O800 (delivery), that are not erroneous codes as such but data entry or other data errors.

I cannot say if these others are wrong in data or missing in grouping definitions.

Erroneus codes (causing RTC=1 were):

rtc1 code A099 NOT in icdcodes
Not marked as primary code (in the table sent form Georgia), thus inactive. I activate it now.

rtc1 code C141 NOT in icdcodes
Not included. Not WHO ICD-10 code. Inactivated code in some ICD-10 version ‘Malignant neoplasm of laryngopharynx’ . I add it to the Georgian version now.

rtc1 code C809 NOT in icdcodes
Not included (in the table sent form Georgia). C80 is included and a WHO code.

rtc1 code C814 NOT in icdcodes
Not marked as primary code (in the table sent form Georgia), thus inactive. I activate it now.

rtc1 code C823 NOT in icdcodes
Not marked as primary code (in the table sent form Georgia), thus inactive. I activate it now

rtc1 code C846 NOT in icdcodes
Not marked as primary code (in the table sent form Georgia), thus inactive. I activate it now

rtc1 code C847 NOT in icdcodes
Not marked as primary code (in the table sent form Georgia), thus inactive. I activate it now

rtc1 code C849 NOT in icdcodes
Not marked as primary code (in the table sent form Georgia), thus inactive. I activate it now

rtc1 code C884 NOT in icdcodes
Not marked as primary code (in the table sent form Georgia), thus inactive. I activate it now

rtc1 code C903 NOT in icdcodes
Not marked as primary code (in the table sent form Georgia), thus inactive. I activate it now

rtc1 code C918 NOT in icdcodes
Not marked as primary code (in the table sent form Georgia), thus inactive. I activate it now

rtc1 code C946 NOT in icdcodes
Not marked as primary code (in the table sent form Georgia), thus inactive. I activate it now

rtc1 code D180 exists in icdcodes
Is there a problem??

rtc1 code D630* NOT in icdcodes
* is not part of the code, the code without * is included.

rtc1 code D638* NOT in icdcodes
* is not part of the code, the code without * is included.

rtc1 code F130.0 NOT in icdcodes
.0  is not part of the code, the code without .0 is included.

rtc1 code G460* NOT in icdcodes
* is not part of the code, the code without * is included.

rtc1 code G468* NOT in icdcodes
* is not part of the code, the code without * is included.

rtc1 code G941* NOT in icdcodes
* is not part of the code, the code without * is included.

rtc1 code G992* NOT in icdcodes
* is not part of the code, the code without * is included.

rtc1 code H360* NOT in icdcodes
* is not part of the code, the code without * is included.

rtc1 code I798* NOT in icdcodes
* is not part of the code, the code without * is included.

rtc1 code J80 NOT in icdcodes
Not included (in the table sent form Georgia). Not original ICD-10 code, added later. I add it to the Georgian version now.

rtc1 code J91* NOT in icdcodes
* is not part of the code, the code without * is included.

rtc1 code K352 NOT in icdcodes                                                     Not marked as primary code (in the table sent form Georgia), thus inactive. I activate it now

rtc1 code K353 NOT in icdcodes
Wrong code and not primary code (in table sent from Georgia). Corrected code added and activated.

rtc1 code K433 NOT in icdcodes
Not included (in the table sent form Georgia). Not original ICD-10 code. I add to the Georgian version now

rtc1 code K436 NOT in icdcodes
Not included (in the table sent form Georgia). Not original ICD-10 code. I add to the Georgian version now

rtc1 code K437 NOT in icdcodes
Not included (in the table sent form Georgia). Not original ICD-10 code. I add to the Georgian version now

rtc1 code K640 NOT in icdcodes
Not included (in the table sent form Georgia). Not original ICD-10 code, original code I8420. I add to the Georgian version now

rtc1 code K642 NOT in icdcodes                                                     Not included (in the table sent form Georgia). Not original ICD-10 code, original code I8420. I add to the Georgian
version now

rtc1 code K643 NOT in icdcodes                                                     Not included (in the table sent form Georgia). Not original ICD-10 code, original code I8420. I add to the Georgian
version now

rtc1 code K648 NOT in icdcodes                                                     Not included (in the table sent form Georgia). Not original ICD-10 code, original code I840. I add to the Georgian
version now

rtc1 code K851 NOT in icdcodes
Not marked as primary code (in the table sent form Georgia), thus inactive. I activate it now

rtc1 code K852 NOT in icdcodes
Not marked as primary code (in the table sent form Georgia), thus inactive. I activate it now

rtc1 code K858 NOT in icdcodes
Not marked as primary code (in the table sent form Georgia), thus inactive. I activate it now

rtc1 code K859 NOT in icdcodes                                                     Not marked as primary code (in the table sent form Georgia), thus inactive. I activate it now

rtc1 code L00 NOT in icdcodes
Not included (in the table sent form Georgia). I add it to the Georgian version now.

rtc1 code L893 NOT in icdcodes
Not marked as primary code (in the table sent form Georgia), thus inactive. I activate it now

rtc1 code M500ãë NOT in icdcodes
ãë is not part of the code, the code without ãë is included.

rtc1 code M688* NOT in icdcodes
* is not part of the code, the code without * is included

rtc1 code M738* NOT in icdcodes
* is not part of the code, the code without * is included

rtc1 code M796 NOT in icdcodes
Not marked as primary code (in the table sent form Georgia), thus inactive. I activate it now

rtc1 code N185 NOT in icdcodes
Not included (in the table sent form Georgia). Not original ICD-10 code. I add to the Georgian version now

rtc1 code N19 NOT in icdcodes
Not included (in the table sent form Georgia). Not original ICD-10 code. I add to the Georgian version now

rtc1 code O031 exists in icdcodes
Is there a problem??

rtc1 code O601 NOT in icdcodes
Not marked as primary code (in the table sent form Georgia), thus inactive. I activate it now

rtc1 code O603 NOT in icdcodes
Not marked as primary code (in the table sent form Georgia), thus inactive. I activate it now

rtc1 code O800 exists in icdcodes
Is there a problem??

rtc1 code P285 exists in icdcodes
Is there a problem??

rtc1 code R500 exists in icdcodes
Is there a problem??

rtc1 code Z381 exists in icdcodes
Is there a problem??

Example:

Cases (in demo data sample) causing RTC 7 Rare or false combination of dg and pr

Encouter ID      1060784744

Diagnose 1.      I500 გულის
შეგუბებითი
უკმარისობა

Diagnose 2.      I500 გულის
შეგუბებითი
უკმარისობა

Diagnose 3.      R33 შარდის
შეკავება

Diagnose 4.

Diagnose 5.

Diagnose 6.

Diagnose 7.

Diagnose 8.

Diagnose 9.

Diagnose 10.

Procedure 1.   WAA899 სხვა
ინტენსიური
თერაპიის
მონიტორინგი

Procedure 2.

Procedure 3.

Procedure 4.

Procedure 5.

Procedure 6.

Procedure 7.

Procedure 8.

Procedure 9.

Procedure 10.                              WAA899
სხვა
ინტენსიური
თერაპიის
მონიტორინგი

Sex:                    Male

Age:                    31250

Discharge:        End of treatment

Length of stay (in days):          4

DRG:                   477 სხვა
იშვიათი
ან
არასწორი
კომბინაცია

MDC:                  99 არასპეციფიკური
და
მცდარი
ინფორმაცია

RTC:                    7 Rare of false combination of diagnosis and procedu

DRG weight:    1,1654

LOS limits:        0  -  0

Cost limits:       0  -  0 GEL

Revenue:         630,56 GEL

Additional patient information

Encouter ID      1118897702

Diagnose 1.      C504 სარძევე
ჯირკვლის
ზემო-გარეთა
კვადრანტის
ავთვისებიანი
სიმსივნე

Diagnose 2.      E042 არატოქსიური
მრავალკვანძოვანი
ჩიყვი

Diagnose 3.

Diagnose 4.

Diagnose 5.

Diagnose 6.

Diagnose 7.

Diagnose 8.

Diagnose 9.

Diagnose 10.

Procedure 1.   BASA60 სრული
თიროიდექტომია

Procedure 2.   LCSD00 ჰისტერექტომია

Procedure 3.

Procedure 4.

Procedure 5.

Procedure 6.

Procedure 7.

Procedure 8.

Procedure 9.

Procedure 10.                              BASA60
სრული
თიროიდექტომია

Sex:                    Female

Age:                    20813

Discharge:        End of treatment

Length of stay (in days):          7

DRG:                   477 სხვა
იშვიათი
ან
არასწორი
კომბინაცია

MDC:                  99 არასპეციფიკური
და
მცდარი
ინფორმაცია

RTC:                    7 Rare of false combination of diagnosis and procedu

DRG weight:    1,1654

LOS limits:        0  -  0

Cost limits:       0  -  0 GEL

Revenue:         630,56 GEL

Additional patient information

Encouter ID      114080009

Diagnose 1.      Z420 შემდგომი
დახმარება
თავისა
და
კისრის
არეში
აღდგენითი
ქირურგიული
ჩარევის
გამოყენებით

Diagnose 2.

Diagnose 3.

Diagnose 4.

Diagnose 5.

Diagnose 6.

Diagnose 7.

Diagnose 8.

Diagnose 9.

Diagnose 10.

Procedure 1.   AASK00 კრანიოპლასტიკა

Procedure 2.

Procedure 3.

Procedure 4.

Procedure 5.

Procedure 6.

Procedure 7.

Procedure 8.

Procedure 9.

Procedure 10.

Sex:                    Female

Age:                    19431

Discharge:        End of treatment

Length of stay (in days):          9

DRG:                   468 ძალიან
იშვიათი
ან
არასწორი
კომბინაციები

MDC:                  99 არასპეციფიკური
და
მცდარი
ინფორმაცია

RTC:                    7 Rare of false combination of diagnosis and procedu

DRG weight:    1,9343

LOS limits:        0  -  0

Cost limits:       0  -  0 GEL

Revenue:         1 046,59 GEL

Additional patient information

Encouter ID      1127020545

Diagnose 1.      K650 მწვავე
პერიტონიტი

Diagnose 2.

Diagnose 3.

Diagnose 4.

Diagnose 5.

Diagnose 6.

Diagnose 7.

Diagnose 8.

Diagnose 9.

Diagnose 10.

Procedure 1.   JKSA20 ქოლეცისტექტომია

Procedure 2.

Procedure 3.

Procedure 4.

Procedure 5.

Procedure 6.

Procedure 7.

Procedure 8.

Procedure 9.

Procedure 10.

Sex:                    Male

Age:                    22855

Discharge:        End of treatment

Length of stay (in days):          9

DRG:                   477 სხვა
იშვიათი
ან
არასწორი
კომბინაცია

MDC:                  99 არასპეციფიკური
და
მცდარი
ინფორმაცია

RTC:                    7 Rare of false combination of diagnosis and procedu

DRG weight:    1,1654

LOS limits:        0  -  0

Cost limits:       0  -  0 GEL

Revenue:         630,56 GEL

Additional patient information

Encouter ID      113591472

Diagnose 1.      K922 გასტრო-ინტესტინური
სისხლდენა,
დაუზუსტებელი

Diagnose 2.      K801 ნაღვლის
ბუშტის
ქვები
სხვა
სახის
ქოლეცისტიტთან
ერთად

Diagnose 3.

Diagnose 4.

Diagnose 5.

Diagnose 6.

Diagnose 7.

Diagnose 8.

Diagnose 9.

Diagnose 10.

Procedure 1.   JKSD96 სხვა
ბილიოდიგესტიური
ანასტომოზი
ამოკვეთის
გარეშე

Procedure 2.

Procedure 3.

Procedure 4.

Procedure 5.

Procedure 6.

Procedure 7.

Procedure 8.

Procedure 9.

Procedure 10.                              JKSA20
ქოლეცისტექტომია

Sex:                    Female

Age:                    28663

Discharge:        End of treatment

Length of stay (in days):          16

DRG:                   477 სხვა
იშვიათი
ან
არასწორი
კომბინაცია

MDC:                  99 არასპეციფიკური
და
მცდარი
ინფორმაცია

RTC:                    7 Rare of false combination of diagnosis and procedu

DRG weight:    1,1654

LOS limits:        0  -  0

Cost limits:       0  -  0 GEL

Revenue:         630,56 GEL

Additional patient information

Best regards,

Jussi