User Tools

Site Tools


documentation:cdm:note_nlp

NOTE_NLP table

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.

FieldRequiredTypeDescription
note_nlp_idYesintegerA unique identifier for each term extracted from a note.
note_idYesintegerA foreign key to the Note table note the term was extracted from.
note_nlp_concept_idNointegerA 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.
section_concept_idNointegerA foreign key to the predefined Concept in the Standardized Vocabularies representing the section of the extracted term.
snippetNostring(250)A small window of text surrounding the term.
character_offsetNostring(50)Character offset of the extracted term in the input note.
lexical_variantYesstring(250)Raw text extracted by the NLP tool.
nlp_systemNostring(250)Name and version of the NLP system that extracted the term.
nlp_dateYesdateThe date of the note processing.
nlp_date_timeNodatetimeThe date and time of the note processing.
term_existsNostring(1)A summary modifier that signifies presence or absence of the term for a given patient.
note_type_concept_idYesintegerA foreign key to the predefined Concept in the Standardized Vocabularies reflecting the type, origin or provenance of the Note.
value_as_concept_idNointegerA foreign key to the predefined Concept in the Standardized Vocabularies describing optional qualitative value for the term.
value_as_numberNofloatA numeric value describing optional quantitative value for the term.
value _as_stringNostring(60)A string describing optional qualitative value for the term.
unit_concept_idNointegerA foreign key to the predefined Concept in the Standardized Vocabularies reflecting an optional unit of of the extracted term value.
term_temporalNostring(50)An optional time expression associated with the extracted term.
term_modifiersNostring(25)A compact description of all the modifiers extracted by the NLP system.
documentation/cdm/note_nlp.txt · Last modified: 2017/03/17 04:17 by rimma_belenkaya