| Issue Number | 3451 |
|---|---|
| Summary | Political Subunits/States in Ireland |
| Created | 2011-11-10 16:25:47 |
| Issue Type | Improvement |
| Submitted By | Beckwith, Margaret (NIH/NCI) [E] |
| Assigned To | Osei-Poku, William (NIH/NCI) [C] |
| Status | Closed |
| Resolved | 2011-12-14 12:40:46 |
| Resolution | Fixed |
| Path | /home/bkline/backups/jira/ocecdr/issue.107779 |
BZISSUE::5145
BZDATETIME::2011-11-10 16:25:47
BZCREATOR::Margaret Beckwith
BZASSIGNEE::William Osei-Poku
BZQACONTACT::Lakshmi Grama
I am including the email thread from Kim since I am not 100% sure what we need to do in the CDR. The top email is the most recent:
Hi Margaret-
The following changes should be made by CIAT for country and political
sub units in CDR:
1 - Country of Ireland: Rename to “The Republic of Ireland”
2 - Create the following political sub units for the country of
Ireland:
Cork
Dublin
Limerick
Waterford
3 - Those for countries then need to be added to the CTEP_States
mapping table, corresponding to:
Co Cork
Co Dublin
Co Limerick
Co Waterford
I think that should fix the issues we are having. We have the countries correct otherwise, but are missing these “states” in Ireland.
Thanks!
Kim
Kim Eckley, PMP
Lockheed Martin (Contractor)
301-519-6511
301-525-5988
From: Martha Hering HERINGM1@WESTAT.com
Sent: Tuesday, September 27, 2011 10:38 AM
To: Eckley, Kimberly A
Cc: Beckwith, Margaret (NIH/NCI) [E]; CTSU Systems
Subject: EXTERNAL: RE: Political Subunits/States in PDQ
Hello,
I spoke with our systems and it comes down to we are using a different list of codes for the country field than your system. Either CTEP or PDQ will have to agree to change or we need to map the data. My guess is mapping is the lesser of all evils in this case. Perhaps we can bring this up on the next CTRP call. I believe you attend those weekly meetings as well as our IT staff.
Thanks,
Martha Hering, RN, CCRP
CTSU Operations Manager
301-738-3531(ph)
1-888-691-8039(fax)
marthahering@westat.com
From: Eckley, Kimberly A kimberly.a.eckley@lmco.com
Sent: Thursday, September 15, 2011 12:29 PM
To: Martha Hering
Cc: Beckwith, Margaret (NIH/NCI) [E]; CTSU Systems
Subject: RE: Political Subunits/States in PDQ
Hi Martha-
Any additional info on this?
Thanks!
Kim
Kim Eckley, PMP
Lockheed Martin (Contractor)
301-519-6511
301-525-5988
From: Martha Hering HERINGM1@WESTAT.com
Sent: Wednesday, August 31, 2011 1:48 PM
To: Eckley, Kimberly A
Cc: Beckwith, Margaret (NIH/NCI) [E]; CTSU Systems
Subject: EXTERNAL: RE: Political Subunits/States in PDQ
Let me send this over to systems to look at the format of the file. ECOG does have sites in England and Ireland so the information is not necessarily incorrect. I am looking at the address information for some of these sites in RSS at it coming from CTEP as:
Cork University Hospital
Wilton Road
Cork, Co Cork __ IE
I think the “Co Cork” is coming across as the “state” and IE for the country code.
Thanks,
Martha
From: Eckley, Kimberly A kimberly.a.eckley@lmco.com
Sent: Wednesday, August 31, 2011 1:41 PM
To: Martha Hering
Cc: Beckwith, Margaret (NIH/NCI) [E]
Subject: Political Subunits/States in PDQ
Hi Martha-
Hope you can help me out with this.
In our data feed for ECOG-E1505, we are receiving sites in the UK, in
Ireland. The state is coming across as Co then the city name (Co
Limerick for example).
Should these “states” be reconsidered to be Ireland? These are causing
validation errors on our end and the sites are not updating.
Thanks,
Kim
Kimberly A. Eckley, PMP
Program Manager - NCI Clinical Trial Reporting Office
Lockheed Martin Corporation (Contractor)
301-519-6511 (office)
301-525-5988 (cell)
BZDATETIME::2011-11-10 16:41:33
BZCOMMENTOR::Bob Kline
BZCOMMENT::1
It looks like these are all things CIAT can do. The first involves editing CDR43788; the second involves adding new CDR PoliticalSubunit documents; the third involves filling in the mappings using the external mapping table administrative interface.
BZDATETIME::2011-11-10 16:43:57
BZCOMMENTOR::Margaret Beckwith
BZCOMMENT::2
Great! I wasn't sure if would require any kind of global change to anything.
BZDATETIME::2011-11-28 16:13:29
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::3
I have updated the country record for Ireland and created the new political sub units. I have also updated the mapping table.
BZDATETIME::2011-11-29 12:46:52
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::4
Here is an email we got from John Gillen (NLM) regarding the changes I just made:
> ---Original Message
> From: John Gillen jgillen@mail.nih.gov
> Sent: Tuesday, November 29, 2011 8:37 AM
> To: volker@mail.nih.gov; kimberly.a.eckley@lmco.com;
bkline@rksystems.com;
> Osei-Poku, William; Andrea.jackson@lmco.com
> Cc: Annice Bergeris (E-mail)
> Subject: NCI PRS Upload Errors
>
> We noticed that several records in this morning's NCI upload had
errors due to
> "The Republic of Ireland" as a country name. We are adding this in
our system
> as a synonym for the ISO standard name, "Ireland" – the errors
should not
> occur in tomorrow's upload. The preferred name "Ireland" will
appear on
> ClinicalTrials.gov.
>
> --JG
BZDATETIME::2011-12-05 12:06:24
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::5
Per our discussions on Thursday, I contacted Kim about the ISO standard name. I am attaching my email to her and her response:
> ---Original Message
> From: Eckley, Kimberly A kimberly.a.eckley@lmco.com
> Sent: Thursday, December 01, 2011 7:35 PM
> To: Osei-Poku, William
> Subject: Re: EXTERNAL: NCI PRS Upload Errors
>
> We were advised by CTEP that the name had changed. They had
mentioned that
> this was the new ISO standard but I had not seen it there myself. I
think the
> mapping table changes would be sufficient, but was passing along
their
> recommendations.
>
> Kim
> Sent from my BlackBerry - Please excuse brevity and typos.
>
> --— Original Message -----
> From: Osei-Poku, William wOsei-Poku@icfi.com
> Sent: Thursday, December 01, 2011 04:45 PM
> To: Eckley, Kimberly A
> Subject: RE: EXTERNAL: NCI PRS Upload Errors
>
> Kim,
> We discussed in the CDR development meeting today of switching the
country
> name back to the ISO name "Ireland" and handling all data changes
in the
> mapping table. Could you explain why there was the need to change
the name
> from Ireland to "The Republic of Ireland"? Also, we looked at the
mapping
> table and expected to see "The Republic of Ireland" but there was
no entry in
> the mapping table for it. There is an entry for "IE" instead.
> Thanks,
> William
>
BZDATETIME::2011-12-05 12:08:46
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::6
The ISO standard name is still "Ireland" and not "The Republic of Ireland" so I switched the country name back to "Ireland".
I am marking this issue as resolved.
BZDATETIME::2011-12-14 12:40:46
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::7
We decided last Thursday to close this issue since there is nothing
else to be done at this point.
Issue now closed.
Elapsed: 0:00:00.000814