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 |
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.
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?
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.
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?
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.
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.
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