CDR Tickets

Issue Number 3051
Summary [CTGov] New ad hoc query report to count transferred trials
Created 2009-12-21 12:58:56
Issue Type Improvement
Submitted By Osei-Poku, William (NIH/NCI) [C]
Assigned To Englisch, Volker (NIH/NCI) [C]
Status Closed
Resolved 2010-01-21 10:07:33
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.107379
Description

BZISSUE::4727
BZDATETIME::2009-12-21 12:58:56
BZCREATOR::William Osei-Poku
BZASSIGNEE::Volker Englisch
BZQACONTACT::Lakshmi Grama

4.We need another ad hoc query to give us a count of all transferred trials that have been made >publishable (after the transfer) within a certain date range.

From Lakshmi:

>Not sure I understand what this report – is this count of Inscope or CTGOV – I am confused by the “made ?>publishable” comment.

From William:

I meant CTGov trials. When the trials are converted, a non-publishable version of the CTGov document is created. When we have finished reviewing it and added the transfer date, we make it (CTGov trial) publishable. It is the count of these trials that we want. I mentioned publishable because I assumed it is the only way we can know that that we have finished processing the converted trial.

Comment entered 2009-12-21 15:01:51 by Englisch, Volker (NIH/NCI) [C]

BZDATETIME::2009-12-21 15:01:51
BZCOMMENTOR::Volker Englisch
BZCOMMENT::1

(In reply to comment #0)
> within a certain date range.

I'm not exactly sure what date range you are looking for:
Is this a date range for

  • the CTGovOwnershipTransferDate

  • the date the document has been made publishable

  • the date the document has been published

  • other?

Comment entered 2009-12-21 15:09:37 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2009-12-21 15:09:37
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::2

(In reply to comment #1)
> (In reply to comment #0)
> > within a certain date range.
>
> I'm not exactly sure what date range you are looking for:
> Is this a date range for
> - the CTGovOwnershipTransferDate
> - the date the document has been made publishable
> - the date the document has been published
> - other?

The date the document was made publishable. This report is to give us an idea of how many trials have been fully processed. So we want to be able to tell that between 12/01/09 to 12/15/09 we have made a certain number of trials publishable.

Comment entered 2009-12-21 15:41:32 by Englisch, Volker (NIH/NCI) [C]

BZDATETIME::2009-12-21 15:41:32
BZCOMMENTOR::Volker Englisch
BZCOMMENT::3

(In reply to comment #2)
> The date the document was made publishable.

In other words, you want to know when a former InScopeProtocol has been saved as a publishable version of a CTGovProtocol for the first time.
Is that correct?

Comment entered 2009-12-21 15:53:17 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2009-12-21 15:53:17
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::4

(In reply to comment #3)
> (In reply to comment #2)
> > The date the document was made publishable.
>
> In other words, you want to know when a former InScopeProtocol has been saved
> as a publishable version of a CTGovProtocol for the first time.
> Is that correct?

That is correct.

Comment entered 2010-01-15 15:38:41 by Englisch, Volker (NIH/NCI) [C]

BZDATETIME::2010-01-15 15:38:41
BZCOMMENTOR::Volker Englisch
BZCOMMENT::5

I've created the requested ad-hoc query under the name
Transferred Protocols with Date made first publishable

This is ready for review on BACH.

Comment entered 2010-01-21 10:07:33 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2010-01-21 10:07:33
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::6

(In reply to comment #5)
> I've created the requested ad-hoc query under the name
> Transferred Protocols with Date made first publishable
>
> This is ready for review on BACH.

Verified on Bach. Issue Closed. Thank you!

Elapsed: 0:00:00.001363