CDR Tickets

Issue Number 3569
Summary Report of tobacco-related glossary terms
Created 2012-11-29 16:01:46
Issue Type Improvement
Submitted By Beckwith, Margaret (NIH/NCI) [E]
Assigned To Englisch, Volker (NIH/NCI) [C]
Status Closed
Resolved 2012-12-07 14:47:49
Resolution Fixed
Path /home/bkline/backups/jira/ocecdr/issue.107897
Description

BZISSUE::5267
BZDATETIME::2012-11-29 16:01:46
BZCREATOR::Margaret Beckwith
BZASSIGNEE::Volker Englisch
BZQACONTACT::Robin Juthe

Rick requested a report of all tobacco-related glossary terms and definitions in order to reconcile our terms with those in the smokefree.gov dictionary. Could we generate a report using the vendor filter data, and searching on terms and definitons that contain the following strings:

tobacco
smoke
smoker
smoking
chemical
nicotine
tar
inhale
betel
chewing
cigar
cigarette
cessation
pipe
respiratory

Report format should be CDR ID, term name, definition.

Comment entered 2012-11-30 14:51:58 by Englisch, Volker (NIH/NCI) [C]

BZDATETIME::2012-11-30 14:51:58
BZCOMMENTOR::Volker Englisch
BZCOMMENT::1

I created this spreadsheet listing all the glossary terms containing at least one of the words on your "smoking list".
I've included the CDR-ID and the word that has been used for the match with the definition. I did not try to match the words on the GlossaryTermName, just matching on the definition.

Please have a look and let me know if you need anything modified.

Comment entered 2012-11-30 14:51:58 by Englisch, Volker (NIH/NCI) [C]

Attachment GlossaryTobacco20121130.csv has been added with description: Glossary Terms related to smoking

Comment entered 2012-12-03 14:36:36 by Englisch, Volker (NIH/NCI) [C]

BZDATETIME::2012-12-03 14:36:36
BZCOMMENTOR::Volker Englisch
BZCOMMENT::2

I created a program to extract the CDR-ID, TermName, and TermDefinition from the vendor output files and create a *.csv file.

The program is located at
\cdr\utilities\bin\GetGlossaryDef.py - R10867

Comment entered 2012-12-07 14:47:49 by Osei-Poku, William (NIH/NCI) [C]

BZDATETIME::2012-12-07 14:47:49
BZCOMMENTOR::William Osei-Poku
BZCOMMENT::3

Closing issue. Thank you!

Attachments
File Name Posted User
GlossaryTobacco20121130.csv 2012-11-30 14:51:58 Englisch, Volker (NIH/NCI) [C]

Elapsed: 0:00:00.001311