| Issue Number | 3172 |
|---|---|
| Summary | [Terminology] Create Ad-hoc report for EVS for Drug Dictionary Updates |
| Created | 2010-06-03 13:20:04 |
| Issue Type | Improvement |
| Submitted By | Grama, Lakshmi (NIH/NCI) [E] |
| Assigned To | Kline, Bob (NIH/NCI) [C] |
| Status | Closed |
| Resolved | 2010-06-10 13:34:39 |
| Resolution | Fixed |
| Path | /home/bkline/backups/jira/ocecdr/issue.107500 |
BZISSUE::4859
BZDATETIME::2010-06-03 13:20:04
BZCREATOR::Lakshmi Grama
BZASSIGNEE::Bob Kline
BZQACONTACT::William Osei-Poku
Larry Wright has asked for a report to double check definitions for drug terms
For terms that have a semantic type of "Drug/Agent" that are not marked as obsolete and have a definition, please create a report as follows:
simple text file, tab delimited, with CDR ID, CDR Preferred Term, Definition, and NCIt Code.
We have ad-hoc report to identify those drug terms that have no definitions.
BZDATETIME::2010-06-03 15:04:34
BZCOMMENTOR::Bob Kline
BZCOMMENT::1
I replaced embedded newlines in the definitions with "\n" and I created multiple lines for terms which have more than one definition, repeating the NCIt code, CDR ID, and preferred name for each definition. I took the NCIt code from the first OtherName/SourceInformation/VocabularySource/SourceTermId element whose sibling SourceCode element had the value "NCI Thesaurus." I extracted the text content from the SourceTermId element (recursively) without XML markup tags.
Attachment Request4859.txt has been added with description: Requested report
BZDATETIME::2010-06-03 15:04:56
BZCOMMENTOR::Bob Kline
BZCOMMENT::2
Report is attached to issue.
BZDATETIME::2010-06-10 13:34:39
BZCOMMENTOR::Bob Kline
BZCOMMENT::3
Closed at Lakshmi's request.
| File Name | Posted | User |
|---|---|---|
| Request4859.txt | 2010-06-03 15:04:34 |
Elapsed: 0:00:00.001335