CDR Tickets

Issue Number 3244
Summary Spreadsheet for SWOG mapping CDRIDs to PDQ Primary IDs and CTEP IDS
Created 2010-10-08 11:27:36
Issue Type Improvement
Submitted By Grama, Lakshmi (NIH/NCI) [E]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2010-11-18 11:51:16
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.107572
Description

BZISSUE::4933
BZDATETIME::2010-10-08 11:27:36
BZCREATOR::Lakshmi Grama
BZASSIGNEE::Bob Kline
BZQACONTACT::William Osei-Poku

Could we get a spreadsheet with the following information for the trials listed in the attached spreadsheet

For each row with CDRID, the matching PDQ Primary ID and the CTEP/DCP ID and the NCT number. Also provide the Primary Lead Org Status and Status Date.

They need this to help them determine which records they need to review per the FDAAA update.

Comment entered 2010-10-08 11:31:16 by Grama, Lakshmi (NIH/NCI) [E]

BZDATETIME::2010-10-08 11:31:16
BZCOMMENTOR::Lakshmi Grama
BZCOMMENT::1

Actually before starting work on this, I thought I would check with CIAT if they already had a report that did this.

Comment entered 2010-10-08 11:52:04 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2010-10-08 11:52:04
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::2

(I have attached a copy of the report for SWOG)

Yes. It looks like we have a report like the one you described above. The only difference is that we do not have a separate field for CTEP/DCP ID. All alternate ids are grouped under one column -'Alternate IDs'.

The report has three tabs:
Lead Org (Active)
Site (Active)
Lead Org (Not Active)

You can find the report here : CIAT/OCCM Staff > Reports > Persons and Organizations > Organization Protocol Review

Comment entered 2010-10-08 11:52:04 by Osei-Poku, William (NIH/NCI) [C]

Attachment OrganizationProtocolsSpreadsheet-20101008114337(1).xls has been added with description: SWOG report

Comment entered 2010-10-08 12:10:07 by Grama, Lakshmi (NIH/NCI) [E]

BZDATETIME::2010-10-08 12:10:07
BZCOMMENTOR::Lakshmi Grama
BZCOMMENT::3

I think the report is good. Is there a way we can make it so that the PDQ UI is the full CDR identifier that we send to CTGOV.

Comment entered 2010-10-08 12:27:34 by Kline, Bob (NIH/NCI) [C]

BZDATETIME::2010-10-08 12:27:34
BZCOMMENTOR::Bob Kline
BZCOMMENT::4

(In reply to comment #3)

> Is there a way we can make it so that the PDQ UI is the full CDR identifier
> that we send to CTGOV.

Change implemented on Mahler; ready for user testing.

Comment entered 2010-10-08 12:35:30 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2010-10-08 12:35:30
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::5

(In reply to comment #4)
> (In reply to comment #3)
>
> > Is there a way we can make it so that the PDQ UI is the full CDR identifier
> > that we send to CTGOV.
>
> Change implemented on Mahler; ready for user testing.

Verified on Mahler. Please promote to Bach.

Comment entered 2010-10-08 12:46:26 by Kline, Bob (NIH/NCI) [C]

BZDATETIME::2010-10-08 12:46:26
BZCOMMENTOR::Bob Kline
BZCOMMENT::6

Promoted to Bach.

Comment entered 2010-10-08 12:58:48 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2010-10-08 12:58:48
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::7

Verified on Bach. New report attached.

Comment entered 2010-10-08 12:58:48 by Osei-Poku, William (NIH/NCI) [C]

Attachment SWOG Protocols.xls has been added with description: SWOG Protocols

Comment entered 2010-10-25 13:24:25 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2010-10-25 13:24:25
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::8

Lakshmi:
Should I close this issue?

Comment entered 2010-11-18 11:51:16 by Beckwith, Margaret (NIH/NCI) [E]

BZDATETIME::2010-11-18 11:51:16
BZCOMMENTOR::Margaret Beckwith
BZCOMMENT::9

I spoke with Lakshmi and she said this was done and could be closed. Closing issue.

Attachments
File Name Posted User
OrganizationProtocolsSpreadsheet-20101008114337(1).xls 2010-10-08 11:52:04 Osei-Poku, William (NIH/NCI) [C]
SWOG Protocols.xls 2010-10-08 12:58:48 Osei-Poku, William (NIH/NCI) [C]

Elapsed: 0:00:00.001704