CDR Tickets

Issue Number 3532
Summary [CTRP] Mapping NCTID to CDRID
Created 2012-07-25 14:46:28
Issue Type Improvement
Submitted By Beckwith, Margaret (NIH/NCI) [E]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2012-10-01 08:37:48
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.107860
Description

BZISSUE::5227
BZDATETIME::2012-07-25 14:46:28
BZCREATOR::Margaret Beckwith
BZASSIGNEE::Bob Kline
BZQACONTACT::Kim Eckley

Kim has asked if it would be possible to provide CDRIDs (and CTEP/DCP IDs if possible) for a set of 340 trials that they have that don't have CDRIDs. The list is attached.

Here is Kim's email:

Hi Margaret-

A number of trials (340 to be exact) in CTRP that are CTEP or DCP trials do not have a CDRID related to them. I have the list attached here. We were hoping that using the NCTID, that the CDRIDs could be provided, as well as the CTEP or DCP ID if present.

Is this something PDQ can provide? Once we have the list, they will be added to our trials programmatically.

Thanks,

Kim

Comment entered 2012-07-25 14:46:28 by Beckwith, Margaret (NIH/NCI) [E]

Attachment Trials without CDR-IDs Loaded via Batch Upload -20120717.xlsx has been added with description: Trials without CDRIDs

Comment entered 2012-08-06 10:09:19 by Kline, Bob (NIH/NCI) [C]

BZDATETIME::2012-08-06 10:09:19
BZCOMMENTOR::Bob Kline
BZCOMMENT::1

Some of the trials are still in InScopeProtocol documents, and others are now CTGovProtocol documents. In the former, CTEP and DCP IDs are identified unambiguously. However, NLM's data structures eliminates ID type information, so we can't get the CTEP or DCP IDs for those trials. For this reason (among others) I created a separate sheet (so as not to wipe out CTEP or DCP IDs which CTRP had collected independently) rather than overlay the original sheet with replacement columns.

Comment entered 2012-08-06 10:09:19 by Kline, Bob (NIH/NCI) [C]

Attachment Report5227.xls has been added with description: Requested report

Comment entered 2012-08-09 14:50:16 by Kline, Bob (NIH/NCI) [C]

BZDATETIME::2012-08-09 14:50:16
BZCOMMENTOR::Bob Kline
BZCOMMENT::2

Report has been generated and posted to the issue.

Comment entered 2012-08-13 07:19:08 by eckleyk

BZDATETIME::2012-08-13 07:19:08
BZCOMMENTOR::Kim Eckley
BZCOMMENT::3

Thanks, Bob!

Comment entered 2012-08-30 17:03:46 by Beckwith, Margaret (NIH/NCI) [E]

BZDATETIME::2012-08-30 17:03:46
BZCOMMENTOR::Margaret Beckwith
BZCOMMENT::4

Issue closed.

Comment entered 2012-09-13 08:53:17 by eckleyk

BZDATETIME::2012-09-13 08:53:17
BZCOMMENTOR::Kim Eckley
BZCOMMENT::5

Bob-
Just a quick question on this now that I've had some time to do a little digging.

Trials 584341 and 535593 are both CTGov documents. I read your comment about CTGov striping distinctions for IDs, but both of these trials still have the IDs with distinction in the PDQAdminInfo section.

CDR0000584341
<PDQAdminInfo><PDQProtocolIDs>
<OtherID>
<IDType>DCP ID</IDType>
<IDString>URCC-06-06</IDString>

CDR0000535593
<PDQAdminInfo><PDQProtocolIDs>
<OtherID>
<IDType>CTEP ID</IDType>
<IDString>7354</IDString>

Is it possible to requery the list and look in that section of CTGov documents for the matching IDs?
Thanks!
Kim

Comment entered 2012-09-14 10:15:45 by Kline, Bob (NIH/NCI) [C]

BZDATETIME::2012-09-14 10:15:45
BZCOMMENTOR::Bob Kline
BZCOMMENT::6

I'll have to reindex all of the CTGovProtocol documents, as we've never been asked to use those elements for any reports before. Will take a while. I'll rewrite and run the report again after the reindexing job has completed.

Comment entered 2012-09-14 13:16:03 by Kline, Bob (NIH/NCI) [C]

BZDATETIME::2012-09-14 13:16:03
BZCOMMENTOR::Bob Kline
BZCOMMENT::7

Take a close look at this replacement report. If it provides what you need, please close this issue.

Comment entered 2012-09-14 13:16:03 by Kline, Bob (NIH/NCI) [C]

Attachment Report5227-a.xls has been added with description: Replacement report

Comment entered 2012-09-24 09:10:48 by Kline, Bob (NIH/NCI) [C]

BZDATETIME::2012-09-24 09:10:48
BZCOMMENTOR::Bob Kline
BZCOMMENT::8

Take a close look at the replacement report. If it provides what you need,
please close this issue.

Comment entered 2012-10-01 08:37:48 by eckleyk

BZDATETIME::2012-10-01 08:37:48
BZCOMMENTOR::Kim Eckley
BZCOMMENT::9

Thanks, Bob. It did help fill in some gaps.
Closing issue.

Attachments
File Name Posted User
Report5227.xls 2012-08-06 10:09:19
Report5227-a.xls 2012-09-14 13:16:03
Trials without CDR-IDs Loaded via Batch Upload -20120717.xlsx 2012-07-25 14:46:28

Elapsed: 0:00:00.001500