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

Sorry, the tables are in this attachment.

Martti

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

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.

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

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

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

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

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

Best regards,

Jussi