Subject: RE: Information to setup CCEM for data entry
From: Alexander Turdziladze <[email-masked]>
To: Tamta Kobakhidze <[email-masked]>
Cc: Ketevan Tatoshvili <[email-masked]>
Date: Tue, 10 Sep 2013 12:02:09 +0000

თამთა,

ჩვენ თუ რამე უნდა გავაკეთოთ მითხარი გთხოვ JJ

გაიხარე,

ალეკო

Alexander Turdziladze

Chief of Party

Abt Associates Incorporated - Georgia

USAID Health System Strengthening Project
A. Tsereteli ave. #144 16th FL. Tblisi Georgia

Tel. (995 32) 510021 Ext.#1617
Mob: +995  593 226226

From: Benes, Oleg (DCE-VPI) [mailto:[email-masked]]
Sent: Tuesday, September 10, 2013 3:50 PM
To: Newland, Sophie; Bersonda, Dexter (SP External); Alexander Turdziladze; Tamta Komakhidze
Cc: [email-masked]; Kurtsikashvili, Giorgi (CCC-GEO); [email-masked]; Anderson, Richard (Consultant); Lorenson, Kristina; Soren Spanner ([email-masked])
Subject: RE: Information to setup CCEM for data entry

Dear Sophie,

Thank you for following up on it.

I would like to inform you that Dexter has kindly agreed to support Georgia on CCEM set-up, data entry, cleaning and analysis. WHO Euro will contract him to undertake a mission to Tbilisi starting 30 September. So, would appreciate much your support and suggestions to anticipate/address potential issues related to this mission.

In the mean time  I would like to share a summary of collected questionnaires by regions/districts prepared by national counterparts. Please let me know if you have any points for clarification or suggestions in this regard.

In addition, I would like to share a couple of comments coming from the national counterparts related to the list of facilities:

1.       Information on facility location names is available in the completed questionnaires;

2.       According to the provided summary table, there are 1409 health facilities providing immunization services within the framework of the national immunization programme. According to the Georgian Legislation, a health facility may represent an outpatient clinic (Polyclinic), an ambulatory (dispensary) or an individual practice physician, participating in delivery of government programs. There are all together about 270 polyclinics, dispensaries and maternity homes throughout Georgia. The other facilities are represented by individual practice physicians.

3.       In all questionnaires there are available identification numbers and names of all facilities, including individual practice physicians. Collected identification numbers represent the tax office registration numbers. They are used as well by NCDC for reimbursements.

I asked NCDC partners to produce the electronic list of facilities (Georgian or English) with their codes in advance of the mission dates, so that it could be integrated into CCEM.

Let’s see if that would work.

Looking forward for your comments and suggestions,

Best regards,

Oleg

From: Newland, Sophie [mailto:[email-masked]]
Sent: 10 September 2013 01:47
To: Benes, Oleg (DCE-VPI); Bersonda, Dexter (SP External); Alexander Turdziladze; Tamta Komakhidze
Cc: [email-masked]; Kurtsikashvili, Giorgi (CCC-GEO); [email-masked]; Anderson, Richard (Consultant); Lorenson, Kristina; Soren Spanner ([email-masked])
Subject: RE: Information to setup CCEM for data entry

Dear Friends,

Please advise me on outstanding action items that we (Richard, Tina, Sophie, Dexter) can pursue in support of getting CCEM set-up and ready for data entry, cleaning, and analysis.

Best regards,

Sophie

From: Benes, Oleg (DCE-VPI) [mailto:[email-masked]]
Sent: Thursday, August 22, 2013 2:45 AM
To: Newland, Sophie; Bersonda, Dexter (SP External); Alexander Turdziladze; Tamta Komakhidze
Cc: [email-masked]; Kurtsikashvili, Giorgi (CCC-GEO); [email-masked]; Anderson, Richard (Consultant); Lorenson, Kristina; Soren Spanner ([email-masked])
Subject: RE: Information to setup CCEM for data entry

Dear Sophie,

Thank you so much for the thorough review of potential issues with data entry. Few thoughts from my side:

1.       Q1 – For the data entry purpose we might consider as well the facility lists and codes that were expected to be collected in the “District summary worksheet of completed questionnaires” and “Facility summary worksheet of completed questionnaires” (attached)

Q2 – No problems from WHO side to stay with Georgian script for admin area and facility names

Q3 - These are two distinctive levels: Village shall be the lowest admin level while Rayon is a higher level (i.e. district). The questionnaire provided by Tina captures well the admin hierarchy.

Q4 – In Georgia they do not have the “Zone” administrative level, so it might be suppressed.

2.       Facility data and names: I-m looking forward to hear from the national counterparts on what is feasible. As far as I understand there should be no problems  to get the list (and codes) of villages, considering the available NCDC and HMIS information systems. I’m a bit concerned however that the NCDC list of registered facilities includes only 279 facilities while the HMIS database include 1557 facilities.

3.       Facility ID: In both the “District summary worksheet of completed questionnaires” and “Facility summary worksheet of completed questionnaires” there was provided a field for collecting the ID for each facility during data collection. It has not been specifically mentioned that it shall be NCDC ID however. We may ask national counterparts to scan and share with us a set of documents (forms and questionnaires) completed for one of the districts so that we have a better idea  on what kind of data have been  collected and how they have been recorded.

4.       Facilities v. individual providers. According to the facility questionnaire all providers shall be listed there, rather than completing specific questionnaires for each provider. Looking forward from Soren and national counterparts for further clarification  on provided recommendations and the performed practice.

Best regards,

Oleg

From: Newland, Sophie [mailto:[email-masked]]
Sent: 22 August 2013 00:53
To: Benes, Oleg (DCE-VPI); Bersonda, Dexter (SP External); Alexander Turdziladze; Tamta Komakhidze
Cc: [email-masked]; Kurtsikashvili, Giorgi (CCC-GEO); [email-masked]; Anderson, Richard (Consultant); Lorenson, Kristina; Soren Spanner ([email-masked])
Subject: RE: Information to setup CCEM for data entry

Hello Friends,

Please excuse my return to a very old email, but I think it has the most people on the distribution and may offer me a good cross-section for maximum feedback.

My goal: Enable Dexter to make the CCEM Georgia version ready for data entry by the end of the month

Dropbox link: https://www.dropbox.com/sh/j9lyfs2r9ndklws/2QLgSatSuS (Feel free to upload new materials if you think they will be helpful.)

General issues: Incomplete data for CCEM set-up, need to manage different languages/script, need to capture data from facilities and providers with different cold storage roles, need to support the practical steps of data entry from paper forms

Specific problems/questions:

1.       Need to get a complete set of geographic areas (in Georgian) to populate drop-down menus. Neither NCDC or eHMIS Excel lists (in Dropbox) have all three administrative levels that I see on the Georgia data collection forms shown to me by Tina  yesterday ( Region, District, Village ) or the ones we saw in mid-July (Region, Zone, District, sub-District).

a.       Question 1: Is there a complete set of administrative data available from the National Bureau of Statistics or other team and what do you want to see as the number and names of administrative levels?

Below is a clip on how it looks in the Malawi version of CCEM. (you don’t need the admin code in fi_admin_co column)

b.      Question 2: Should we make the administrative data in the drop-downs in Georgian script, while the CCEM operating language will stay in Russian? I think since data collection on the paper form is in Georgian, the eHMIS and NCDC datasets are in Georgia, that Georgian script makes the most sense.

c.       Question 3: The eHMIS data mentions Rayon in the provider list, is this the same as Village and should we use Village or Rayon?

d.      Question 4: Do we want to include/abandon an administrative level for Zone (seen on earlier version of the data collection forms)?

2.       I was wrong in my earlier position that we would pre-populate CCEM with facility data and names. Dexter will set up CCEM as much as he can to support data entry from the paper forms and then we (Dexter) can figure out how/if we can use the data in the provider/facility datasets from NCDC and eHMIS by cross referencing the facility names retroactively.  I think this is the only option.

a.       In the current CCEM Georgia version, we only have administrative data for Region and Districts, so we need to find out how to add Village (or Rayon or sub-district) (reference #1a above).

b.      The administrative area data  in the current Georgia CCEM version are in Latin script. Given that data entry will likely be in Georgian script and the eHMIS and NCDC datasets are in Georgian script, should we ask Dexter to recreate these drop down tables in Georgian script, assuming we can get these data (reference #1b above)?

3.       Need to think about facility ID

a.       May I see the final data forms used for data collection to help me think things through? They are probably in Georgian, but I can try to use Google translate or other to figure them out.

b.      I don’t think there was a field for collecting the NCDC ID for each facility during data collection. So I propose we use CCEM to generate a unique ID for each facility during data entry.

c.       Non-commitment on official facility ID: I think it would be minimal work (Dexter correct me if I am wrong) to add two new fields in CCEM Georgia version to allow us to include both the NCDC and eHMIS ID on the facility record. These fields will need to be populated (with Dexter’s assistance) after data entry, unless the data entry clerks can look these ID in reference documents up during data entry. Dexter can  help us think through how to populate these fields, if possible, using facility names and 1-2 of the administrative areas (neither the NCDC or eHMIS Excel files have all three administrative levels). This non-commitment to an ID provides the possibility of recognizing the NCDC ID but also enabling future interoperability with the eHMIS.

4.       How do we capture data in CCEM from Commissioned facilities v. individual providers. Please advise.

a.       I have looked through versions of the Health Facility Questionnaire from mid-July and I do not fully understand how data from an individual provider will be captured on the paper form and in turn be made useful to CCEM for analysis.

i.      The facility types on the Health Facility Questionnaire (Question #6) does not include a facility type for and individual provider.

ii.      An individual provider will be storing their vaccine at refrigerator in an official health facility, whose facility data will be collected on a different Health Facility Questionnaire and be entered into CCEM as a separate Facility record.  The Refrigerator Questionnaire data will be entered under the official health facility record. I do not see a way to link an individual provider with the facility where they store their vaccine, in particular for analysis. When CCEM calculates capacity requirements for the refrigerators at the official health facility, it will need to run an algorithm looking to add in the capacity  needs for every individual provider that has noted that it stores its vaccine at this facility, and that this link is communicated via the CCEM facility ID. I don’t think type of registry of the linkage with individual providers and the refrigerators/facilities where they store there vaccines is possible. But please share with me your thoughts and solutions.

iii.      As a possible solution, I wonder if the individual providers are recorded as a specific facility type, whether a new report in CCEM could be designed which calculates the storage capacity of individual providers located in a specific administrative area (e.g. district) and then compares their capacity requirements to the cold chain capacity available at a certain facility type in this region, likely to be the source of storage for individual providers (e.g. district vaccine store).

I am sure there is more to talk about, but I am going to stop for now and see if anyone responds to help answer my questions.

Best regards,

Sophie

From: Benes, Oleg (DCE-VPI) [mailto:[email-masked]]
Sent: Wednesday, July 10, 2013 3:48 PM
To: Newland, Sophie; Bersonda, Dexter (SP External); Alexander Turdziladze; Tamta Komakhidze
Cc: [email-masked]; Kurtsikashvili, Giorgi (CCC-GEO); [email-masked]; Anderson, Richard (Consultant); Lorenson, Kristina
Subject: RE: Information to setup CCEM for Georgia needs

Dear ALL,

One option that could be considered is translating facility names into English. I would like to ask Tamta (who will help with translation and interpretation) and national colleagues to advice whether that would be feasible and acceptable.

Best regards,

Oleg

.

From: Newland, Sophie [mailto:[email-masked]]
Sent: 11 July 2013 00:10
To: Bersonda, Dexter (SP External); Alexander Turdziladze; Benes, Oleg (DCE-VPI)
Cc: [email-masked]; Kurtsikashvili, Giorgi (CCC-GEO); [email-masked]; Anderson, Richard (Consultant); Lorenson, Kristina
Subject: RE: Information to setup CCEM for Georgia needs

Hi Dexter,

I think my question #3 relates to the assumption that we need to choose one language for the data tables (facility and equipment data). That even if the instructions and data labels in CCEM can switch between languages, the facility names are not going to switch from Georgian to Russian to English.

This comes up for me because I see at http://cloud.moh.gov.ge, and it is mentioned in the email by Alexander, that in the mFL the facility names are in Georgian and yet we’re setting up CCEM in Russian.

I suppose the question about whether we can use facility names in Georgian instead of Russian. Is it OK to have the operating language of CCEM be Russian but the facility names be in Georgian?

Sophie

From: Dexter Bersonda [mailto:[email-masked]]
Sent: Wednesday, July 10, 2013 8:49 AM
To: Newland, Sophie; Alexander Turdziladze; 'Benes, Oleg (DCE-VPI)'
Cc: [email-masked]; 'Kurtsikashvili, Giorgi (CCC-GEO)'; [email-masked]; Anderson, Richard (Consultant); Lorenson, Kristina
Subject: Re: Information to setup CCEM for Georgia needs

Hello Sophie,

Both the scenarios you described below is feasible. We can either pre-populate CCEM with any available health facility data and let the data-entry clerks enter the rest afterwards by searching the MFL facility code, admin areas or facility names.

We can also let the data-entry clerks enter data first and then we could fill in the other data from the MFL.

I'm not sure I understood question #3 correctly. Tthe admin data and facility names would be useful even if they're in Georgian. Assuming that the facility names in CCEM are in Georgian we could potentially use them to link to the MFL data (apart from the MFL). Also I just tested it and it looks like users could still search through facility names, etc. even if they are in Georgian.

Best regards,
Dexter

From: "Newland, Sophie" <[email-masked]>
To: Alexander Turdziladze <[email-masked]>; "'Benes, Oleg (DCE-VPI)'" <[email-masked]>
Cc: "[email-masked]" <[email-masked]>; "'Kurtsikashvili, Giorgi (CCC-GEO)'" <[email-masked]>; "[email-masked]" <[email-masked]>; "Anderson, Richard (Consultant)" <[email-masked]>; "Lorenson, Kristina" <[email-masked]>; "Bersonda, Dexter (SP External)" <[email-masked]>
Sent: Wednesday, July 10, 2013 7:30 AM
Subject: RE: Information to setup CCEM for Georgia needs

Hello Alexander,

Many thanks for your willingness to talk with us and explore how/if this cold chain equipment inventory activity can build on the HMIS data to pre-populate the CCEM tool with administrative data, facility data, and official facility codes.

I am excited to hear that Abt Associates has been involved with this work in Georgia because in 2011 we (Kenya EPI, PATH, WHO, and UNICEF) benefited from similar work  by Abt in Kenya, where CCEM used the Master Facility List and codes developed by the Kenya MoH with the support of Abt Associates to pre-populate CCEM before the baseline cold chain equipment inventory data was collected and entered.  This was a win-win collaboration because Abt Associates was happy to see an information system use their important mFL work and highlight the value of this work to support interoperable systems. It benefits CCEM work underway in Kenya  today because CCEM data can be integrated into the national HMIS by virtue of the official MFL codes.

The Master Facility List work by Abt in Kenya is described at http://www.ehealth.or.ke/facilities/about.aspx. This is also the same website from which we were able to download a list of Kenya’s health facilities in Excel  to incorporate into CCEM. This important Master Facility List work is also behind the document at  http://www.who.int/healthinfo/systems/WHO_CreatingMFL_draft.pdf, which I am sure you know well.

I have looked at http://cloud.moh.gov.ge (impressive) and www.geostat.ge I was not able to identify a similar data source for CCEM. What would be helpful is to develop and import into CCEM is something similar to the attached Excel worksheet, in which the yellow highlighted columns might potentially come from the Georgia MFL. The remaining data will be collected. With access to this dataset, Dexter Bersonda, on this email, would be able to help the team in Georgia have a CCEM version with CCEM data ready for data entry.

A couple of questions, including one or two for Dexter:

1.      In Kenya, in the data collection teams took out the paper copy of the MFL for the areas where they collected data and they referenced the MFL code on the datasheets. If this is a possible scenario in Georgia, we may need to add a space on the data collection form so the data collector can record this information. Do we plan on their being access to an official MFL code during data entry?

2.      Dexter, I think you advised for data quality in Kenya to not prepopulate the facility data in CCEM from the MFL. Is this right, from what you remember? If I imagine a scenario, assuming there is a mFL we can access before data collection, if a data entry clerk has access to a MFL code on the Facility Questionnaire and a.) it is the right MFL facility code that they put into the search box, CCEM will find the facility record prepopulated with the admin areas, facility name, and GPS coordinates that you have put in the INV_FACILITY data table, the data entry clerk can then fill out population data, energy availability data, contact details, equipment data, etc. BUT b.) if they enter the wrong MFL facility code and then they see it is wrong by the facility name, they can use a work around by either entering a new facility record or find the right facility via name or admin data/facility type or AS WE DID IN KENYA c.) the data entry clerks don’t have CCEM prepopulated with mFL data, they can still enter an official mFL code and you can potentially use your awesome skills to post-populate data such as GPS coordinates from the mFL. Thoughts?

3.      Dexter/Alexander, if the mFL only has the administrative data and facility names in Georgian, is there any value to CCEM? This is similar to a problem we’re facing in Lao PDR. While CCEM instructions can switch between Russian (or Georgia) and English, French or Spanish, the data in the data tables will be static. I am not sure if there is a work around.

4.       I am very interested in knowing more about the Abt and Associates ‘finished inventory & stock management module for NCDC’. It would be interesting to learn about how this tool might be (if not made) interoperable with CCEM.

5.       Richard and I will be in Nigeria and Kenya next two weeks. Please let us know when you might have time for a Skype call. We will be three hours before you in Nigeria, so an 8 am (Abuja) and 11 am (Tbilisi) call might work out on Wednesday or Thursday of next week. Alternatively, we’ll only be one hour before you the following week, and could talk at 8 am (Nairobi) and 9 am (Tbilisi) on July 22,23,24.

Many thanks in advance,

Sophie

From: Alexander Turdziladze [mailto:[email-masked]]
Sent: Tuesday, July 09, 2013 6:41 AM
To: 'Benes, Oleg (DCE-VPI)'
Cc: [email-masked]; 'Kurtsikashvili, Giorgi (CCC-GEO)'; [email-masked]; Anderson, Richard (Consultant); Lorenson, Kristina; Newland, Sophie
Subject: RE: Information to setup CCEM for Georgia needs

Dear Oleg,

Thank you very much for your mail. Sophie and Richard could contact me any convenient time for them, but I just want to notify, tomorrow from second half of the day including Friday 12th of July, I will be out of the office and will have limited access to internet.

I will meet with Kristina during her visit in Georgia and after meeting we can discuss all technical details regarding the requested data together with Sophie and Richard.

Does it sounds well?

Thanks,

Alexander

Alexander Turdziladze

Chief of Party

Abt Associates Incorporated - Georgia

USAID Health System Strengthening Project
A. Tsereteli ave. #144 16th FL. Tblisi Georgia

Tel. (995 32) 510021 Ext.#1617
Mob: +995  593 226226

From: Benes, Oleg (DCE-VPI) [mailto:[email-masked]]
Sent: Tuesday, July 09, 2013 5:15 PM
To: Alexander Turdziladze
Cc: [email-masked]; Kurtsikashvili, Giorgi (CCC-GEO); [email-masked]; Anderson, Richard (Consultant); Lorenson, Kristina; Newland, Sophie
Subject: RE: Information to setup CCEM for Georgia needs

Dear Alexander,

Let me introduce to you Ms. Sophie Newland from PATH, and Mr. Richard Anderson, a PATH Consultant who may wish to provide you’re a technical introduction on CCEM.

As mentioned previously, Kristina Lorenson will attending the workshop in Georgia to review the country support needs to implement a standardized cold chain inventory. Since Kristina may not be in the position to provide a technical introduction on CCEM, Sophie and Richard expressed their readiness to get in contact with you and discuss CCEM technical details.

They also ask whether it would be possible to get the facility names, codes, and maybe GIS coordinates sooner rather than latter, so that data are imported into CCEM.

Best regards,

Oleg

From: Alexander Turdziladze [mailto:[email-masked]]
Sent: 08 July 2013 08:29
To: Benes, Oleg (DCE-VPI); Kurtsikashvili, Giorgi (CCC-GEO); [email-masked]
Cc: [email-masked]
Subject: RE: Information to setup CCEM for Georgia needs

Dear Oleg,

Thank you very much for your mail. From our side we will do our best for successful  collaboration!!!

Have a nice day,

Best Regards,

Alexander

Alexander Turdziladze

Chief of Party

Abt Associates Incorporated - Georgia

USAID Health System Strengthening Project
A. Tsereteli ave. #144 16th FL. Tblisi Georgia

Tel. (995 32) 510021 Ext.#1617
Mob: +995  593 226226

From: Benes, Oleg (DCE-VPI) [mailto:[email-masked]]
Sent: Friday, July 05, 2013 8:37 PM
To: Alexander Turdziladze; Kurtsikashvili, Giorgi (CCC-GEO); [email-masked]
Cc: [email-masked]
Subject: RE: Information to setup CCEM for Georgia needs

Dear Alexander,

Thank you for sharing  the information on “information portal” modules. Unfortunately, I could not access the link below from the office. Will try from home.

I’m pretty sure that the list of facilities may be of interest for different country activities supported by WHO. In our example, in order to conduct the cold chain inventory, we have to establish first the list of sites that provide immunization services and or vaccine storage and transportation. From WHO side I would be glad if this additional resource helps to improve management of different components of the national immunization programme. And I would like to hope that in the future such a functionality will facilitate international data exchange as well.

Have a nice weekend,

Oleg

From: Alexander Turdziladze [mailto:[email-masked]]
Sent: 04 July 2013 19:17
To: Benes, Oleg (DCE-VPI); Kurtsikashvili, Giorgi (CCC-GEO); [email-masked]
Cc: [email-masked]
Subject: RE: Information to setup CCEM for Georgia needs

Dear Oleg,

I am sending few screenshot from one of our modules “information portal”, where are (or should be) information regarding cold chain equipment. Concept of Information portal is that is should become very soon single source of information for everybody related to healthcare in Georgia. This is used for planning purpose by Ministry of Health.

What do you think, does it make sense to use this portal for WHO purpose as well?  If you will have time, please take look on www.clould.moh.gov.ge

Thanks,

Alexander

Alexander Turdziladze

Chief of Party

Abt Associates Incorporated - Georgia

USAID Health System Strengthening Project
A. Tsereteli ave. #144 16th FL. Tblisi Georgia

Tel. (995 32) 510021 Ext.#1617
Mob: +995  593 226226

From: Benes, Oleg (DCE-VPI) [mailto:[email-masked]]
Sent: Wednesday, July 03, 2013 4:21 PM
To: Alexander Turdziladze; Kurtsikashvili, Giorgi (CCC-GEO); [email-masked]
Cc: [email-masked]
Subject: RE: Information to setup CCEM for Georgia needs

Dear Alexander,

Thank you so much for your support and cooperation. That sounds reasonable to me.

I think it can be addressed during the mission, since data entry will start in a couple of weeks after that. So it would allow some additional time to incorporate all data into the software.

Best regards,

Oleg

From: Alexander Turdziladze [mailto:[email-masked]]
Sent: 03 July 2013 14:15
To: Benes, Oleg (DCE-VPI); Kurtsikashvili, Giorgi (CCC-GEO); [email-masked]
Cc: [email-masked]
Subject: RE: Information to setup CCEM for Georgia needs

Dear Oleg,

Thank you very much for your mail. I will ask our team to prepare all materials. During the meeting with missions, we can go through every topic and accordingly we will provide all needed information – Does it sounds well? Or you need it before mission will come in Georgia?

Please let me know your troughs,

Best regards,

Alexander

Alexander Turdziladze

Chief of Party

Abt Associates Incorporated - Georgia

USAID Health System Strengthening Project
A. Tsereteli ave. #144 16th FL. Tblisi Georgia

Tel. (995 32) 510021 Ext.#1617
Mob: +995  593 226226

From: Benes, Oleg (DCE-VPI) [mailto:[email-masked]]
Sent: Tuesday, July 02, 2013 3:55 PM
To: Alexander Turdziladze; Kurtsikashvili, Giorgi (CCC-GEO); [email-masked]
Cc: [email-masked]
Subject: RE: Information to setup CCEM for Georgia needs

Dear Alexander,

I do think that the most important is that the used system meets country demands.

My understanding is that having the HMIS facility  and codes database may represent an important step forward on planning the cold chain inventory work and would facilitate data entry.

Therefore I would encourage national counterparts using it.

Translation of names can be done with NCDC support – there is a hired translator that will support the mission.

For the purpose of cold chain inventory, we would be interested in information on all facilities dealing with vaccines and immunization.

As soon as there is not available information on health insurance providers, we may leave this subject out.

Best regards,

Oleg

From: Alexander Turdziladze [mailto:[email-masked]]
Sent: 01 July 2013 14:59
To: Benes, Oleg (DCE-VPI); Kurtsikashvili, Giorgi (CCC-GEO); [email-masked]
Cc: [email-masked]
Subject: RE: Information to setup CCEM for Georgia needs

Dear Oleg,

We are using internal coding system in HMIS for identification administrative areas. Please let us know if HMIS coding system is ok for you, we can share list of regions and sub areas with WHO without problem, but somebody needs to translate list from Georgian to English or any other language.

I would like to inform that very soon Government of Georgia is going to approve decree, by which whole immunization process will be managed trough Immunization module created by HSSP (it was expected even previous week). Only after this will happen, we can provide information regarding all facilities and their details, including GPS coordinates for health facilities who are part of immunization process.

Unfortunately we don’t have information regarding contracted providers under private insurance, we have information regarding providers who participates in Government financed health care programs.

Please let us know your troughs,

Looking forward for your reply,

Best Regards,

Alexander

Alexander Turdziladze

Chief of Party

Abt Associates Incorporated - Georgia

USAID Health System Strengthening Project
A. Tsereteli ave. #144 16th FL. Tblisi Georgia

Tel. (995 32) 510021 Ext.#1617
Mob: +995  593 226226

From: Benes, Oleg (DCE-VPI) [mailto:[email-masked]]
Sent: Monday, July 01, 2013 12:36 PM
To: Kurtsikashvili, Giorgi (CCC-GEO); Alexander Turdziladze; [email-masked]
Cc: [email-masked]
Subject: RE: Information to setup CCEM for Georgia needs

Dear Giorgi,

CCEM allows introducing up to 4 administrative levels for each facility:

1.      Region

2.      Zone

3.      District

4.      Sub-district

I checked with Roman and he has kindly shared the attached file with the table of administrative areas.

It includes only two administrative levels: Region and District. May I ask you to confirm that it represents the current administrative division of the country and can be shared with PATH partners to be integrated in CCEM.

The attached file does not include the list of health facilities providing immunization services as well as the list of the public health centres involved in vaccine storage abnd distribution, and their codes of affiliation to the districts/regions.

Would appreciate much if that information is obtained with Alexander support.

I would also like to ask for your advice whether it makes since and it is feasible  to have the division of health facilities by health insurance providers as well. That would allow further analysis and estimation of needs by health insurance providers. Any support on that coming from Alexander side is most welcome.

Best regards,

Oleg

From: Kurtsikashvili, Giorgi (CCC-GEO)
Sent: 30 June 2013 13:20
To: Benes, Oleg (DCE-VPI); Alexander Turdziladze; [email-masked]
Cc: [email-masked]
Subject: Re: Information to setup CCEM for Georgia needs

Dear Oleg,

We are not sure that fully understand what kind of support is asked from Alexander in the email bellow. Could you please provide more details?

May you please also check it with Roman, as admin levels with codes may be available in our CISID as well?

Thank you and best regards,

Giorgi

--

Giorgi Kurtsikashvili, M.D.

Country Programme Coordinator

DCE-VPI

WHO Country Office in Georgia

9 M. Asatiani Street, Tbilisi, 0177, Georgia

Fax.: +995 32 299 80 73

Tel.:  +995 32 210 30 74

Mobile: +995 599 76 44 43                          mailto:[email-masked]

From: , "Oleg (DCE-VPI)" <[email-masked]>
Date: Friday, June 28, 2013 12:06 PM
To: Alexander Turdziladze <[email-masked]>, GK <[email-masked]>, "[email-masked]" <[email-masked]>
Cc: "[email-masked]" <[email-masked]>
Subject: RE: Information to setup CCEM for Georgia needs

Dear Alexander, Giorgi

Please see attached a sample file for the table of administrative areas that is required for CCEM.

This format could be followed in generating the table of admin areas in Georgia which a CCEM expert will import into CCEM. You can add and rename columns if necessary.

Would appreciate much your support on getting the above data.

I also received an Excel file with the list of language strings used in CCEM containing the English and French translations. There are about 1200 strings. We will initiate their translation into Russian to make accessible the software to a number of countries in the Region. But with same success it could be translated to Georgian as well.

Best regards,

Oleg

From: Alexander Turdziladze [mailto:[email-masked]]
Sent: 27 June 2013 21:50
To: Benes, Oleg (DCE-VPI); Kurtsikashvili, Giorgi (CCC-GEO); [email-masked]
Cc: [email-masked]
Subject: RE: Information to setup CCEM for Georgia needs

Dear Oleg,

Thank you very much for information, I will definitely review CCEM.

We are looking forward for meeting with mission and future potential cooperation

Have a nice evening,

Best Regards,

Alexander

Alexander Turdziladze

Chief of Party

Abt Associates Incorporated - Georgia

USAID Health System Strengthening Project
A. Tsereteli ave. #144 16th FL. Tblisi Georgia

Tel. (995 32) 510021 Ext.#1617
Mob: +995  593 226226

From: Benes, Oleg (DCE-VPI) [mailto:[email-masked]]
Sent: Thursday, June 27, 2013 7:27 PM
To: Alexander Turdziladze; Kurtsikashvili, Giorgi (CCC-GEO); [email-masked]
Cc: [email-masked]
Subject: RE: Information to setup CCEM for Georgia needs

Dear Alexander,

Thank you so much for your prompt support and follow up.

Yes, definitely it would be possible to have a meeting with the experts. Will keep in touch for further details.

And I’m very happy to hear you almost finished inventory & stock management modules for NCDC. This mission may represent a nice opportunity to review once more the achievements and identify opportunities for further cooperation.

CCEM – represents Cold Chain Equipment Manger software developed by PATH in cooperation with other partners to support countries conduct cold chain inventory assessments process assessment data and use them for further cold chain planning.

More details you may find following the link below

http://www.path.org/publications/detail.php?i=1569

Should you have any further questions or clarifications, please do not hesitate to contact me.

Best regards,

Oleg

Oleg BENES

Technical Officer,

Vaccine-preventable Diseases & Immunization,

Division of Communicable Diseases, Health Security & Environment

WHO Regional Office for Europe
UN City
Marmorvej 51
DK-2100 Copenhagen Ø
Denmark

Tel:     +45 453 366 18

Mobile : +45 304 500 43

Fax:     +45 3917 1863

E-mail:  [email-masked]

http://www.euro.who.int/vaccine

From: Alexander Turdziladze [mailto:[email-masked]]
Sent: 27 June 2013 17:08
To: Kurtsikashvili, Giorgi (CCC-GEO); Benes, Oleg (DCE-VPI); [email-masked]
Cc: [email-masked]
Subject: RE: Information to setup CCEM for Georgia needs

Dear George,

Thank you very much for your mail.

Please see my question and answers bellow

Best Regards,

Alexander

Alexander Turdziladze

Chief of Party

Abt Associates Incorporated - Georgia

USAID Health System Strengthening Project
A. Tsereteli ave. #144 16th FL. Tblisi Georgia

Tel. (995 32) 510021 Ext.#1617
Mob: +995  593 226226

From: Kurtsikashvili, Giorgi (CCC-GEO) [mailto:[email-masked]]
Sent: Thursday, June 27, 2013 4:52 PM
To: Benes, Oleg (DCE-VPI); [email-masked]; Alexander Turdziladze
Cc: [email-masked]
Subject: RE: Information to setup CCEM for Georgia needs
Importance: High

Dear Oleg,

The only thing that I may advice is website: www.geostat.ge

However, coping this email to our colleagues from eHealth project, kindly ask their help with this information.

Dear Alexander and Ketevan,

We are working together with the NCDC to carry out of inventory study for immunization equipment in Georgia. It is proposed that two consultants will come to Georgia and initiate this process in July. They need some information in advance for proper planning of this activity.

A.T – we are very much interested to meet with the experts during their stay in Georgia. We almost finished inventory & stock management module for NCDC

We would highly appreciate your kind help and support to obtain this information, if possible.

Thank you very much in advance,

Giorgi

--

Giorgi Kurtsikashvili, M.D.

Country Programme Coordinator

DCE-VPI

WHO Country Office in Georgia

9 M. Asatiani Street, Tbilisi, 0177, Georgia

Fax.: +995 32 299 80 73

Tel.:  +995 32 210 30 74

Mobile: +995 599 76 44 43                          mailto:[email-masked]

From: Benes, Oleg (DCE-VPI)
Sent: Thursday, June 27, 2013 4:38 PM
To: Kurtsikashvili, Giorgi (CCC-GEO)
Subject: Information to setup CCEM for Georgia needs

Dear Giorgi,

Our PATH partners may consider to setup the CCEM software to Georgia needs.

A.T – what is CCEM?

The following questions have been raised to facilitate the process:

1.      Is it possible to see a table of administrative areas in Georgia, for example a table of Provinces, Districts, Sub-districts, Parishes (if we were in Uganda)? A PATH expert could import these into CCEM in advance of the workshop in July.

A.T – we have such list. Please could you let us know data format requirements

2.      Is there a list of health facilities in Georgia  that PATH expert could load into CCEM – with their administrative location. Is there GIS data for these facilities? Is there population data for these facilities? Is there a national unique ID for these facilities or should we have CCEM generate a unique ID?

A.T – yes we have list of providers, with TAX ID, this is unique identifier. Unfortunately lists are only in Georgian. Every facility has GPS coordinates. Please visit website http://cloud.moh.gov.ge

I would assume that the above information shall be available at the national level, considering the development of e-health information system.

May I ask you to check if it would been available.

Actually it would be important to keep administrative affiliation of each facility, so that data can be further analyzed  by administrative structures.

A.T – yes

A special topic is availability of GIS data.

The standard CCEM questionnaire provides possibility to collect and record GPS coordinates of each facility for further GIS analysis. Please check if such information is available or if national counterparts would be interested to have it.

A.T – Please visit   http://cloud.moh.gov.ge

If they are interested , then we may need to explore the opportunities to collect such data. Actually it would assume using GPS devices in each district.

Best regards,

Oleg

Oleg BENES

Technical Officer,

Vaccine-preventable Diseases & Immunization,

Division of Communicable Diseases, Health Security & Environment

WHO Regional Office for Europe
UN City
Marmorvej 51
DK-2100 Copenhagen Ø
Denmark

Tel:     +45 453 366 18

Mobile : +45 304 500 43

Fax:     +45 3917 1863

E-mail:  [email-masked]

http://www.euro.who.int/vaccine