documentation:cdm:note_nlp
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Next revision Both sides next revision | ||
|
documentation:cdm:note_nlp [2017/03/17 04:12] rimma_belenkaya |
documentation:cdm:note_nlp [2017/07/07 23:53] rimma_belenkaya1 |
||
|---|---|---|---|
| Line 7: | Line 7: | ||
| ^Field^Required^Type^Description^ | ^Field^Required^Type^Description^ | ||
| - | |note_nlp_id|Yes|integer|A unique identifier for each term extracted from a note.| | + | |note_nlp_id|Yes|Big Integer|A unique identifier for each term extracted from a note.| |
| |note_id|Yes|integer|A foreign key to the Note table note the term was extracted from.| | |note_id|Yes|integer|A foreign key to the Note table note the term was extracted from.| | ||
| |section_concept_id|No|integer|A foreign key to the predefined Concept in the Standardized Vocabularies representing the section of the extracted term.| | |section_concept_id|No|integer|A foreign key to the predefined Concept in the Standardized Vocabularies representing the section of the extracted term.| | ||
| - | |snippet|No|varchar(250)|A small window of text surrounding the term.| | + | |snippet|No|string(250)|A small window of text surrounding the term.| |
| - | |chars|No|varchar(50)|Character offset of the extracted term in the input note.| | + | |offset|No|string(50)|Character offset of the extracted term in the input note.| |
| - | |lexical_variant|Yes|varchar(250)|Raw text extracted from the NLP tool.| | + | |lexical_variant|Yes|string(250)|Raw text extracted by the NLP tool.| |
| - | |note_nlp_concept_id|No|integer|A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the normalized concept for the extracted term. Domain of the term is represented as part of the Concept table.| | + | |note_nlp_concept_id|No|integer|Foreign key to Concept table. Represents the normalized concept for extracted term. Domain of the term is represented as part of the Concept table.| |
| - | |nlp_system|No|varchar(250)|Name and version of the NLP system that extracted the term.| | + | |note_nlp_source_concept_id|No|integer|A foreign key to a Concept that refers to the code in the source vocabulary used by the NLP system.| |
| + | |nlp_system|No|string(250)|Name and version of the NLP system that extracted the term.| | ||
| |nlp_date|Yes|date|The date of the note processing.| | |nlp_date|Yes|date|The date of the note processing.| | ||
| |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|varchar(1)|A summary modifier that signifies presence or absence of the term for a given patient.| | + | |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.| | |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.| | ||
| |value_as_concept_id|No|integer|A foreign key to the predefined Concept in the Standardized Vocabularies describing optional qualitative value for the term.| | |value_as_concept_id|No|integer|A foreign key to the predefined Concept in the Standardized Vocabularies describing optional qualitative value for the term.| | ||
| |value_as_number|No|float|A numeric value describing optional quantitative value for the term.| | |value_as_number|No|float|A numeric value describing optional quantitative value for the term.| | ||
| - | |value _as_string|No|varchar(60)|A string describing optional qualitative 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.| | |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|varchar(50)|An optional time expression associated with the extracted term.| | + | |term_temporal|No|string(50)|An optional time expression associated with the extracted term.| |
| - | |term_modifiers|No|varchar(25)|A compact description of all the modifiers extracted by the NLP system.| | + | |term_modifiers|No|string(25)|A compact description of all the modifiers extracted by the NLP system.| |
documentation/cdm/note_nlp.txt · Last modified: 2017/09/25 15:02 by clairblacketer
Page Tools
