CDR Tickets

Issue Number 3418
Summary Update NCT IDs
Created 2011-09-20 14:44:13
Issue Type Improvement
Submitted By Osei-Poku, William (NIH/NCI) [C]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2011-10-04 10:10:04
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.107746
Description

BZISSUE::5111
BZDATETIME::2011-09-20 14:44:13
BZCREATOR::William Osei-Poku
BZASSIGNEE::Bob Kline
BZQACONTACT::William Osei-Poku

NLM has either swapped or changed NCT IDs for the following trials. Please
update the NCT IDs:

CDR ID Active NCT ID (Make Active) NCT ALIAS (Make Alias)
353367 NCT00057005 NCT00601380
642660 NCT00972309 NCT00908258
662618 NCT01112527 NCT01036477
703290 NCT01403285 NCT01386463
587542 NCT00776295 NCT00609583

I am attaching the spreadsheet. In all cases, the NCT IDs in column 'B' should
be made the active NCT IDs and the IDs in column 'C' should be made aliases.

Comment entered 2011-09-20 14:44:13 by Osei-Poku, William (NIH/NCI) [C]

Attachment NCT ID SWAPS092011.xls has been added with description: NCT ID swaps

Comment entered 2011-09-30 17:13:23 by Kline, Bob (NIH/NCI) [C]

BZDATETIME::2011-09-30 17:13:23
BZCOMMENTOR::Bob Kline
BZCOMMENT::1

I have performed the surgery on the ctgov_import table and run the import job by hand. Please check to confirm that the results are what you expected.

Comment entered 2011-10-04 10:10:04 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2011-10-04 10:10:04
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::2

(In reply to comment #1)
> I have performed the surgery on the ctgov_import table and run the import job
> by hand. Please check to confirm that the results are what you expected.

Verified. Closing Issue.

Attachments
File Name Posted User
NCT ID SWAPS092011.xls 2011-09-20 14:44:13 Osei-Poku, William (NIH/NCI) [C]

Elapsed: 0:00:00.001760