This is an old revision of the document!
This table was added with version 5.2 (1-Feb-2017) of the OMOP CDM.
—
The NOTE table encodes all output of NLP on clinical notes. Each row represents a single extracted term from a note.
Field | Required | Type | Description |
---|---|---|---|
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. |
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 | string(250) | A small window of text surrounding the term. |
offset | No | string(50) | Character offset of the extracted term in the input note. |
lexical_variant | Yes | string(250) | Raw text extracted by the NLP tool. |
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. |
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_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). |
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_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. |