This shows you the differences between two versions of the page.
Both sides previous revision Previous revision Next revision | Previous revision | ||
documentation:cdm:note_nlp [2017/07/07 23:53] rimma_belenkaya1 |
documentation:cdm:note_nlp [2017/09/25 15:02] (current) clairblacketer |
||
---|---|---|---|
Line 1: | Line 1: | ||
===== NOTE_NLP table ===== | ===== NOTE_NLP table ===== | ||
+ | **THIS IS OUTDATED. All documentation is now on the [[https://github.com/OHDSI/CommonDataModel/wiki|github wiki]]. Please refer there or to the [[projects:workgroups:cdm-wg|CDM working group]] for more information** | ||
+ | |||
This table was added with version 5.2 (1-Feb-2017) of the OMOP CDM. | This table was added with version 5.2 (1-Feb-2017) of the OMOP CDM. | ||
Line 19: | Line 21: | ||
|nlp_date_time|No|datetime|The date and time of the note processing.| | |nlp_date_time|No|datetime|The date and time of the note processing.| | ||
|term_exists|No|Boolean|Term_exists is defined as a flag that indicates if the patient actually has or had the condition. Any of the following modifiers would make Term_exists false: Negation = true; Subject = [anything other than the patient]; Conditional = true; Rule_out = true; Uncertain = very low certainty or any lower certainties. A complete lack of modifiers would make Term_exists true. For the modifiers that are there, they would have to have these values: Negation = false; Subject = patient; Conditional = false; Rule_out = false; Uncertain = true or high or moderate or even low (could argue about low).| | |term_exists|No|Boolean|Term_exists is defined as a flag that indicates if the patient actually has or had the condition. Any of the following modifiers would make Term_exists false: Negation = true; Subject = [anything other than the patient]; Conditional = true; Rule_out = true; Uncertain = very low certainty or any lower certainties. A complete lack of modifiers would make Term_exists true. For the modifiers that are there, they would have to have these values: Negation = false; Subject = patient; Conditional = false; Rule_out = false; Uncertain = true or high or moderate or even low (could argue about low).| | ||
- | |note_type_concept_id|Yes|integer|A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the type, origin or provenance of the Note.| | + | |term_temporal|No|string(50)|Term_temporal is to indicate if a condition is “present” or just in the “past”. The following would be past: History = true; Concept_date = anything before the time of the report.| |
- | |value_as_concept_id|No|integer|A foreign key to the predefined Concept in the Standardized Vocabularies describing optional qualitative value for the term.| | + | |term_modifiers|No|string(2000)|Describes compactly all the modifiers extracted by nlp system. For example, “son has rash” → “negated=no,subject=family,certainty=undef,conditional=false,general=false”. Value will be saved as one of the modifiers.| |
- | |value_as_number|No|float|A numeric value describing optional quantitative value for the term.| | + | |
- | |value _as_string|No|string(60)|A string describing optional qualitative value for the term.| | + | |
- | |unit_concept_id|No|integer|A foreign key to the predefined Concept in the Standardized Vocabularies reflecting an optional unit of of the extracted term value.| | + | |
- | |term_temporal|No|string(50)|An optional time expression associated with the extracted term.| | + | |
- | |term_modifiers|No|string(25)|A compact description of all the modifiers extracted by the NLP system.| | + | |