Subject: FW: Georgian definition tables - further steps
From: "Mariana Mkurnali" <[email-masked]>
To: [email-masked]'; Mariam Darakhvelidze; Ketevan Goginashvili; Ekaterine Adamia; [email-masked]; [email-masked]'; [email-masked]'; Sopo Belkania; Tea Bakradze
Date: Thu, 31 May 2018 19:06:55 +0400

მოგესალმებით,

გთხოვთ, იხილოთ კრისტინას მიერ გუშინ გადმოგზავნილი მეილი დანართით. გთხოვთ, მომწეროთ თქვენთვის მისაღები თარიღი და დრო, რათა შევიკრიბოთ და შესაბამისი რეაგირება მოვახდინოთ კრისტინას მეილზე.

პატივისცემით,

მარიანა მკურნალი

საერთაშორისო ურთიერთობებისა და აპარატის საქმისწარმოების სამმართველოს უფროსი

ადამიანური რესურსების მართვისა და საერთაშორისო ურთიერთობების დეპარტამენტი

საქართველოს შრომის, ჯანმრთელობისა და სოციალური დაცვის სამინისტრო

აკ. წერეთლის გამზირი 144,  თბილისი, საქართველო,  0159

მობ:  +995 599 490942

From: Kahur Kristiina [mailto:[email-masked]]
Sent: 30 May, 2018 19:26
To: Mariana Mkurnali
Cc: Sopo Belkania; Ketevan Goginashvili
Subject: RE: Georgian definition tables - further steps

Hi agian,

I resend this email w/o attachment. I got the feedback from postmaster of MOLSHA, that the email below was not able to delivered to you three.

Hope it works now.

Kristiina

From: Kahur Kristiina
Sent: 30. toukokuuta 2018 17:29
To: Mariana Mkurnali <[email-masked]>
Subject: Georgian definition tables - further steps

Dear Mariana,

Below is the information we got today from Martti Virtanen (CEO, Nordic Casemix Cetnre).

What he has done is a big leap forward in the DRG implementation process because it is now very close to producing the Georgian grouper which you can start to use once it’s ready and installed in your systems.

The attached file is meant for Prodacapo, they will use it for creating the grouper software. So there is nothing you could to with this and there is no need for this either.

I encourage you to contact Prodacapo asap in order to inform them about the availability of definition tables and to forward this zip file to them.

Same time, move on with negotiations regarding the contract and software license (including the license fee which you will need to pay) with Prodacapo.

If there is anything you need the assistance with or any clarification regarding the further steps, please let us know.

Thanks

Kristiina

From: Martti Virtanen <[email-masked]>
Sent: 30. toukokuuta 2018 14:39
To: 'Ketevan Goginashvili' <[email-masked]>; Kahur Kristiina <[email-masked]>; 'Kristiina Kahur' <[email-masked]>
Cc: [email-masked]
Subject: VS: [email-masked] sent you files via WeTransfer

Dear all

Attached is the dBase version fo the definition tables for Georgian version of NordDRG for test use. Because of the way they have been used on first line in most tables is referenc to Latvia (Lat). That is only technical and the content is Georgian version (Geo) .

The tables are now delivere only as dBase tables, because this is the format we have been using internally in NordDRG work for production of the grouper.

In the future the format will be text-file (csv-file) which is readable with Excel as well as with many text editors.

FCG-Prodacapo is used to this format and they can produce a grouper from these files.

All texts are in English since FoxPro is not able to use Georgian alphabet.

Greetings

Martti

Lähettäjä: Martti Virtanen <[email-masked]>
Lähetetty: keskiviikko 30. toukokuuta 2018 14.33
Vastaanottaja: 'Ketevan Goginashvili' <[email-masked]>; ''Kahur Kristiina' ([email-masked])' <[email-masked]>; 'Kristiina Kahur' <[email-masked]>
Kopio: 'Maia maglakelidze-khomeriki <[email-masked]> ([email-masked])' <[email-masked]>
Aihe: VS: [email-masked] sent you files via WeTransfer

Dear all

I have now created a FoxPro version of the Georgian intervention classification with mapping to NCSP+.

Also in the intervention classification I found a small number of dublicate codes.

The  codes/rows without Georgian codes are marked with red highlight and are obviously excluded from the working file.

In addition the file contains the codes for headings that should not be used in coding and cannot be used in DRG-assignment. These codes that are marked with green highligth in the attached table. They are also removed from the mapping.

Yellow highlight indicates error in the mapping from Georgia. There are a few dublicate codes that are obviously removed. A number of codes were mapped to inactive NCSP+ codes. These would not affect the DRG assigment and therefore the mapping has been corrected to active NCSP+ codes.

The yellow highlight thus indicates situations were the Georgian mapping must be corrrected for future use.

The Georgian alphabet does not function in Foxpro. Therefore i use english translation. However, I hope we will in the future we will be able to use the Georgian text. Even now, I could  check some of the problems by using google translator with the your original text. So please retain the Georgian text also in futur versions.

Greetings

Martti Virtanen

Lähettäjä: Martti Virtanen <[email-masked]>
Lähetetty: maanantai 28. toukokuuta 2018 23.12
Vastaanottaja: 'Ketevan Goginashvili' <[email-masked]>; ''Kahur Kristiina' ([email-masked])' <[email-masked]>; 'Kristiina Kahur' <[email-masked]>
Kopio: 'Maia maglakelidze-khomeriki <[email-masked]> ([email-masked])' <[email-masked]>
Aihe: VS: [email-masked] sent you files via WeTransfer

Dear all

I have no greated a FoxPro version of the ICD-10 file with the linkage to ICD+ codes.

FoxPro is the old database system that we still use (untill we get new system running later this year)

I am sorry, but FoxPro is not able to read the Georgian alphabet and therfore I will only use English in the system. In yuour own system you can obviously use Georgian by linking the codes to the correct codes.

I found a number of doublets in the Georgian ICD-10 and I have cleaned them out. Now every code has a linkage in ICD-10-plus which means that they will all get mapped properties in NordDRG and can be used in grouping.

You should however now clean your onw files. Therefore I attach te list mapped codes (ICD10 2018 GEO eng.txt) and the doublets (ICD-10 dublets.txt)

Greetings

Martti Virtanen

Lähettäjä: Ketevan Goginashvili <[email-masked]>
Lähetetty: sunnuntai 18. maaliskuuta 2018 12.24
Vastaanottaja: 'Kahur Kristiina' ([email-masked]) <[email-masked]>; Kristiina Kahur <[email-masked]>; [email-masked]' <[email-masked]>
Kopio: 'Maia maglakelidze-khomeriki <[email-masked]> ([email-masked])' <[email-masked]>
Aihe: FW: [email-masked] sent you files via WeTransfer

Dear Kristiina,

Maia and NCDC have corrected some mistakes in ICD and NCSP (see link below). These are final version for definition tables.

With best regards, Keti

Ketevan Goginashvili, MPH

Head of Health Policy Division

Health Care Department

Ministry of Labor, Health and Social Affairs

144 Tsereteli Ave

Tbilisi 0119, Georgia

Tel: +995 32 251 00 38 ext 1108

Mob: 995 577717984

From: WeTransfer [mailto:[email-masked]]
Sent: 14 March, 2018 17:57
To: Ketevan Goginashvili
Subject: [email-masked] sent you files via WeTransfer

These files will be deleted on 2018-03-21

[email-masked]
sent you some files

2 files, 28.6 MB in total ・ Will be deleted on 21 March, 2018

Download link
https://wetransfer.com/downloads/d38269aef85d3e4d6c27d003cee8485520180314135616/ccd7461355ddf4d30bcb41bb8c9b7ced20180314135616/d38a37

2 files
NCSP_GEO_last.xlsx
ICD10_plus GEO (12.03.2018).xlsx

To make sure our emails arrive, please add [email-masked] to your contacts.

Get more out of WeTransfer, get Plus

About WeTransfer   ・   Help   ・   Legal