| Issue Number | 3050 |
|---|---|
| Summary | [CTGov] New ad hoc query report to track transferred trials |
| Created | 2009-12-21 12:55:11 |
| Issue Type | Improvement |
| Submitted By | Osei-Poku, William (NIH/NCI) [C] |
| Assigned To | Englisch, Volker (NIH/NCI) [C] |
| Status | Closed |
| Resolved | 2010-01-11 13:07:19 |
| Resolution | Fixed |
| Path | /home/bkline/backups/jira/ocecdr/issue.107378 |
BZISSUE::4726
BZDATETIME::2009-12-21 12:55:11
BZCREATOR::William Osei-Poku
BZASSIGNEE::Volker Englisch
BZQACONTACT::William Osei-Poku
We want to be able to track transferred protocols that have not been reviewed because we have not received a transfer date from NLM or somehow we have not been able to work on them. This will be helpful in managing workflow. We will need an ad hoc query to identify InScopeProtocol documents that have been converted into CTGov documents but do not have a transfer date.
From Lakshmi:
OK
BZDATETIME::2009-12-21 14:17:25
BZCOMMENTOR::Volker Englisch
BZCOMMENT::1
The query has been saved on BACH under the name
Transfer Protocols without TransferDate
This is ready for review on BACH.
BZDATETIME::2009-12-21 14:56:07
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::2
(In reply to comment #1)
> The query has been saved on BACH under the name
> Transfer Protocols without TransferDate
>
> This is ready for review on BACH.
Could you also display the following columns please?
Primary ID|NCT ID| lead Org Name| PRS Username | Grant No|
BZDATETIME::2009-12-30 17:06:49
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::3
It appears this report is only picking up InScope trials and not CTGov trials.
BZDATETIME::2009-12-30 17:36:32
BZCOMMENTOR::Volker Englisch
BZCOMMENT::4
I didn't think it was possible to transfer a protocol without the transfer date.
Could you please give me an example?
BZDATETIME::2010-01-04 07:48:52
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::5
(In reply to comment #4)
> I didn't think it was possible to transfer a protocol without the
transfer
> date.
>
> Could you please give me an example?
Here is one example - CDR0000630617
The real transfer happens in the PRS. Generally, what we do in the CDR is to prepare the protocols to be transferred and we actually enter the transfer date manually, after the trials have been transferred in the PRS, and we have been notified of the date the transfer took place.
BZDATETIME::2010-01-06 18:27:13
BZCOMMENTOR::Volker Englisch
BZCOMMENT::6
(In reply to comment #3)
> It appears this report is only picking up InScope trials and not
CTGov trials.
I'm having a problem to consider a report 'ad-hoc' that is supposed
to pick up both, the InScope and CTGov trials along with the information
as specified in comment #2. I have therefore split the request into a
report for InScopeProtocols only and CTGovProtocols.
The report for InScopeProtocols has been updated as requested.
BZDATETIME::2010-01-06 18:43:01
BZCOMMENTOR::Volker Englisch
BZCOMMENT::7
For the CTGov version of this report what would you expect to see for the LeadOrgName?
BZDATETIME::2010-01-06 18:46:06
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::8
(In reply to comment #7)
> For the CTGov version of this report what would you expect to see
for the
> LeadOrgName?
The LeadSponsor.
BZDATETIME::2010-01-07 10:56:19
BZCOMMENTOR::Volker Englisch
BZCOMMENT::9
I've placed the 'CTGov' version of the report in the ad-hoc query
interface with the name
Transfer Protocols without TransferDate (CTGov)
Please verify on BACH.
BZDATETIME::2010-01-11 13:07:19
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::10
(In reply to comment #9)
> I've placed the 'CTGov' version of the report in the ad-hoc query
interface
> with the name
> Transfer Protocols without TransferDate (CTGov)
>
> Please verify on BACH.
Verified on Bach. Issue Closed. Thank you!
Elapsed: 0:00:00.001304