CDR Tickets

Issue Number 3391
Summary Liaison office report to identify trials that need updating in ctgov
Created 2011-07-14 09:21:43
Issue Type Improvement
Submitted By Osei-Poku, William (NIH/NCI) [C]
Assigned To Englisch, Volker (NIH/NCI) [C]
Status Closed
Resolved 2011-08-15 12:11:37
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.107719
Description

BZISSUE::5084
BZDATETIME::2011-07-14 09:21:43
BZCREATOR::William Osei-Poku
BZASSIGNEE::Volker Englisch
BZQACONTACT::William Osei-Poku

Since OCECDR-3384 is done, I am creating this issue to discuss the report, requested by the Liaison office, which identifies trials that need to be verified in clinicaltrials.gov.

Comment entered 2011-07-14 16:11:21 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2011-07-14 16:11:21
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::1

I just spoke with Judy and she said ctgov uses either the Last Modified Date or the Verification Date (Both found in the InScopeProtocol schema), whichever is latest. The report currently displays the Last Modified Date but not the Verification date.

Comment entered 2011-07-20 18:36:46 by Englisch, Volker (NIH/NCI) [C]

BZDATETIME::2011-07-20 18:36:46
BZCOMMENTOR::Volker Englisch
BZCOMMENT::2

The report request2862.py running as menu item
NCI Liaison Office Trial Contacts for Abstract Review
has been modified to include the display of the 'Date last verified'.

This is ready for review on MAHLER.

Comment entered 2011-08-03 21:37:30 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2011-08-03 21:37:30
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::3

(In reply to comment #2)
> The report request2862.py running as menu item
> NCI Liaison Office Trial Contacts for Abstract Review
> has been modified to include the display of the 'Date last verified'.
>
> This is ready for review on MAHLER.

Verified on Mahler. Please promote to Bach.

Comment entered 2011-08-04 11:15:34 by Englisch, Volker (NIH/NCI) [C]

BZDATETIME::2011-08-04 11:15:34
BZCOMMENTOR::Volker Englisch
BZCOMMENT::4

The following program has been copied to FRANCK and BACH:
Request2862.py - R10171

Please verify on BACH and close this bug.

Comment entered 2011-08-05 10:14:36 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2011-08-05 10:14:36
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::5

(In reply to comment #4)
> The following program has been copied to FRANCK and BACH:
> Request2862.py - R10171
>
> Please verify on BACH and close this bug.

Verified on Bach. Report sent to Liaison office. Closing issue. Thank you!

Comment entered 2011-08-08 16:34:38 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2011-08-08 16:34:38
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::6

The liaison office has requested that we include their EU numbers in the spreadsheet. The EU numbers are usually Alternate IDs but could also be Institutional/Original IDs (I believe). So it would be better to look at all OtherID elements in a trial. Could you add another ID column called Alternate IDs and show the IDs in that column only if it is an EU id? The EU ids are typically in the form - EU-XXXXXn (EU-20822, for example). If this is not possible, please display all Other IDs in the column.

Comment entered 2011-08-11 15:46:21 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2011-08-11 15:46:21
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::7

changed priority to P4.

Comment entered 2011-08-12 15:07:40 by Englisch, Volker (NIH/NCI) [C]

BZDATETIME::2011-08-12 15:07:40
BZCOMMENTOR::Volker Englisch
BZCOMMENT::8

The column has been added as requested.
Please note that the EU-ID is identified by the string 'EU-'. If an alternate ID exists but is entered in a different format, like 'eu-12345' or 'EU 12345' this field would be empty.

This is ready for review on MAHLER.

Comment entered 2011-08-15 10:23:34 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2011-08-15 10:23:34
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::9

(In reply to comment #8)
> The column has been added as requested.
> Please note that the EU-ID is identified by the string 'EU-'. If an alternate
> ID exists but is entered in a different format, like 'eu-12345' or 'EU 12345'
> this field would be empty.
>
> This is ready for review on MAHLER.

This looks great. Thank you! Please promote to Bach.

Comment entered 2011-08-15 11:09:58 by Englisch, Volker (NIH/NCI) [C]

BZDATETIME::2011-08-15 11:09:58
BZCOMMENTOR::Volker Englisch
BZCOMMENT::10

The following program has been copied to FRANCK and BACH:
Request2862.py - R10180

Please verify on BACH and close this bug.

Comment entered 2011-08-15 12:11:37 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2011-08-15 12:11:37
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::11

(In reply to comment #10)
> The following program has been copied to FRANCK and BACH:
> Request2862.py - R10180
>
> Please verify on BACH and close this bug.

Verified on Bach. Closing issue. Thank you!

Elapsed: 0:00:00.001696