CDR Tickets

Issue Number 3222
Summary [CTGov] Trials to be manually converted
Created 2010-09-10 11:53:09
Issue Type Improvement
Submitted By Osei-Poku, William (NIH/NCI) [C]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2010-09-17 10:13:36
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.107550
Description

BZISSUE::4910
BZDATETIME::2010-09-10 11:53:09
BZCREATOR::William Osei-Poku
BZASSIGNEE::Bob Kline
BZQACONTACT::William Osei-Poku

Please manually convert the following InScope trials into CTGov trials. In all cases, we attempted to convert them through the normal process but they failed to be converted.
1. Force conversion of CDR524078 (NCT00388960)
(Duplicate - CDR517382 - (NCT00388960) will remain blocked.)
2. Force conversion of CDR562439 (NCT00378794)
(Duplicate - CDR511856 (NCT00378794) will remain blocked.)
3. Force conversion of CDR491241 (NCT00346255).
(Duplicate - CDR683236 (NCT00346255) will be blocked when conversion is completed.)

I tried to find out what their dispositions are in the ctgov_import table by executing a simple query:

SELECT disposition
FROM ctgov_import
WHERE nlm_id = 'NCT00346255'

What I get in return is a single digit number representing the disposition. Do you have the mapping for the dispositions handy so that I can do a quick check before sending them your way?

Comment entered 2010-09-10 12:04:04 by Kline, Bob (NIH/NCI) [C]

BZDATETIME::2010-09-10 12:04:04
BZCOMMENTOR::Bob Kline
BZCOMMENT::1

SELECT d.name
FROM ctgov_disposition d
JOIN ctgov_import i
ON i.disposition = d.id
WHERE i.nlm_id = 'NCT00346255'
========================================================
imported

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

BZDATETIME::2010-09-10 12:17:13
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::2

Thank you! This is even better. I have saved it as 'CTGov trial disposition' in the ad hoc query interface.

Comment entered 2010-09-16 10:36:03 by Kline, Bob (NIH/NCI) [C]

BZDATETIME::2010-09-16 10:36:03
BZCOMMENTOR::Bob Kline
BZCOMMENT::3

(In reply to comment #0)

> Please manually convert the following InScope trials into CTGov trials.

Done.

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

BZDATETIME::2010-09-17 10:13:36
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::4

(In reply to comment #3)
> (In reply to comment #0)
>
> > Please manually convert the following InScope trials into CTGov trials.
>
> Done.

Verified. Issued Closed. Thanks!

Elapsed: 0:00:00.001706