CDR Tickets

Attachment Panreatic CDR IDs.xls has been added with description: Pancreatic Cancer Trials CDRID

BZDATETIME::2010-07-16 11:54:27
BZCOMMENTOR::Bob Kline
BZCOMMENT::1

Attachment Request4878.xls has been added with description: Requested report

BZDATETIME::2010-07-16 11:55:43
BZCOMMENTOR::Bob Kline
BZCOMMENT::2

(In reply to comment #0)

> Would appreciate getting the report by Monday.

Don't forget I'm out of town for a week beginning tomorrow morning.

BZDATETIME::2010-07-16 11:59:17
BZCOMMENTOR::Lakshmi Grama
BZCOMMENT::3

Sorry wrong spreadsheet - you must have wondered why I needed this for so few records. Will attach the new file

Also, can you format it similar to the OSPA report that you do.

BZDATETIME::2010-07-16 12:02:12
BZCOMMENTOR::Lakshmi Grama
BZCOMMENT::4

Attachment Panreatic CDR IDs.xls has been added with description: Full list

BZDATETIME::2010-07-16 12:06:21
BZCOMMENTOR::Lakshmi Grama
BZCOMMENT::5

Question about a row in the report that is missing PI (538204) - were you using my values in a case sensitive way? Please verify with the Inscope schema values since I did not have time to do that

BZDATETIME::2010-07-16 12:08:13
BZCOMMENTOR::Bob Kline
BZCOMMENT::6

(In reply to comment #3)

> Also, can you format it similar to the OSPA report that you do.

I believe the report we send to OSPA is an XML file, not a spreadsheet. Is that what you want?

BZDATETIME::2010-07-16 12:09:20
BZCOMMENTOR::Bob Kline
BZCOMMENT::7

(In reply to comment #5)
> Question about a row in the report that is missing PI (538204) - were you using
> my values in a case sensitive way? Please verify with the Inscope schema values
> since I did not have time to do that

Yes, I noticed that your role values didn't match the case of the schema, so I wrote the report to ignore case for those values.

BZDATETIME::2010-07-16 12:10:17
BZCOMMENTOR::Lakshmi Grama
BZCOMMENT::8

We have an OSPA report accessible through the Admin system - Protocols/Report for the Office of Science Policy

BZDATETIME::2010-07-16 14:05:24
BZCOMMENTOR::Bob Kline
BZCOMMENT::9

I put "NOT SPECIFIED" for the ones that had no PI names; you can do a search and replace if you prefer some other string.

Attachment Request4878.xls has been added with description: Replacement report

BZDATETIME::2010-07-16 16:52:30
BZCOMMENTOR::Lakshmi Grama
BZCOMMENT::10

Looks good. I think there may be some missing pieces of info that I will fill in manually for trials that we have converted to CTGOV trials - Expected Enrollment is missing in CTGOV trials. Perhaps that information will be included when we promote the additional data elements import issue. Thanks for your help.

BZDATETIME::2010-07-16 17:13:10
BZCOMMENTOR::Bob Kline
BZCOMMENT::11

(In reply to comment #10)
> Looks good. I think there may be some missing pieces of info that I will fill
> in manually for trials that we have converted to CTGOV trials - Expected
> Enrollment is missing in CTGOV trials. Perhaps that information will be
> included when we promote the additional data elements import issue.

Don't think so. I believe we're already importing that if it's present in what we get from NLM. Just checked NCT00899132 and there's no expected_enrollment element.

> Thanks for your help.

No problem. See you in a little over a week.

BZDATETIME::2010-08-05 13:03:13
BZCOMMENTOR::Bob Kline
BZCOMMENT::12

Lakshmi:

What's the status of this issue? Were you going to do some further review? Or can this just be closed?

BZDATETIME::2010-08-05 13:04:04
BZCOMMENTOR::Lakshmi Grama
BZCOMMENT::13

Closing issue