| Issue Number | 3145 |
|---|---|
| Summary | Rerun Report from #4182 for FY 2009 |
| Created | 2010-05-12 15:45:03 |
| Issue Type | Bug |
| Submitted By | Grama, Lakshmi (NIH/NCI) [E] |
| Assigned To | Kline, Bob (NIH/NCI) [C] |
| Status | Closed |
| Resolved | 2010-05-14 09:33:58 |
| Resolution | Fixed |
| Path | /home/bkline/backups/jira/ocecdr/issue.107473 |
BZISSUE::4832
BZDATETIME::2010-05-12 15:45:03
BZCREATOR::Lakshmi Grama
BZASSIGNEE::Bob Kline
BZQACONTACT::Lakshmi Grama
We need to run this report for the Office of Complementary and Alternative Medicine for FY 2009.
BZDATETIME::2010-05-12 15:56:01
BZCOMMENTOR::Bob Kline
BZCOMMENT::1
Attachment occam-report-20100512.xls has been added with description: Report for 2008-10-01 through 2009-09-30
BZDATETIME::2010-05-12 15:56:22
BZCOMMENTOR::Bob Kline
BZCOMMENT::2
Done.
BZDATETIME::2010-05-12 16:21:54
BZCOMMENTOR::Lakshmi Grama
BZCOMMENT::3
I just realized that we will have some problems with this report since we have CTGOV trials (transferred trials) that need to be included. Can you send me the criteria for this report?
BZDATETIME::2010-05-12 16:42:07
BZCOMMENTOR::Bob Kline
BZCOMMENT::4
(In reply to comment #3)
> Can you send me the criteria for this report?
Here's what you gave for the original criteria (pulled from the program's header comment):
Report for Office of Cancer Complementary and Alternative
Medicine (OCCAM).
#
"The Office of Cancer Complementary and Alternative Medicine needs a report
similar to the special Office of Science Policy report that we generate. The
report, in Excel format will be in the same format as the OSP report for
cancer types. The criteria for selction for this report though is not
eligible diagnoses or condition, but InterventionType. Bob and I discussed
this report yesterday.
#
Criteria
#
NCI sponsored trials that were active at any point in FY 2005 that have
'complementary and alternative therapy (42022)' as the InterventionType
(either directly or as a parent of an InterventionType term). Could you also
add Phase to the standard Excel report format."
Unfortunately, NLM doesn't give us status history in the CTGovProtocol documents.
BZDATETIME::2010-05-12 16:56:12
BZCOMMENTOR::Lakshmi Grama
BZCOMMENT::5
Would it be possible to check to see if we transferred ownership of any trials before Oct 1, 2009? We might need to do some searching and I will also need to tell her that in the future we will not be able to run these reports.
BZDATETIME::2010-05-12 17:19:48
BZCOMMENTOR::Bob Kline
BZCOMMENT::6
I suppose it's possible that we could parse every version created during the year for every CTGovProtocol document. You'd need to determine if it would be possible to get our hands on the data that goes into each of the report columns (or at least the ones they can't live without).
BZDATETIME::2010-05-12 17:35:02
BZCOMMENTOR::Bob Kline
BZCOMMENT::7
(In reply to comment #5)
> Would it be possible to check to see if we transferred ownership of
any trials
> before Oct 1, 2009?
We were definitely transferring ownership of trials before that date.
BZDATETIME::2010-05-14 09:33:40
BZCOMMENTOR::Lakshmi Grama
BZCOMMENT::8
Closing issue - we will not be able to generate such reports in the future.
BZDATETIME::2010-05-14 09:33:58
BZCOMMENTOR::Lakshmi Grama
BZCOMMENT::9
Forgot to change status
| File Name | Posted | User |
|---|---|---|
| occam-report-20100512.xls | 2010-05-12 15:56:01 |
Elapsed: 0:00:00.001346