documentation:cdm:note_nlp
This is an old revision of the document!
NOTE_NLP table
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 | 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 | Yes | integer | A foreign key to the predefined Concept in the Standardized Vocabularies reflecting . |
| snippet | No | varchar(250) | A small window of text surrounding the term. |
| chars | No | varchar(50) | Character offset of the extracted term in the input note. |
| lexical_variant | No | varchar(250) | Raw text extracted from the NLP tool. |
| note_nlp_concept_id | No | varchar(250) | A foreign key 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. |
| nlp_system | No | varchar(250) | A name and a 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 | datetime | A summary modifier that signifies presence or absence of the term for a given patient. |
| 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 | Yes | integer | A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the HL7 LOINC Document Type Vocabulary classification of the note. |
| value_as_number | No | varchar(250) | The title of the Note as it appears in the source. |
| value _as_string | Yes | RBDMS dependent text | The content of the Note. |
| unit_concept_id | Yes | integer | A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the note character encoding type. |
| term_temporal | Yes | integer | A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the language of the note. |
| term_modifiers | No | integer | A foreign key to the Provider in the PROVIDER table who took the Note. |
Conventions
- The NOTE table contains free text (in ASCII, or preferably in UTF8 format) taken by a healthcare Provider.
- The Visit during which the note was written is recorded through a reference to the VISIT_OCCURRENCE table. This information is not always available.
- The Provider making the note is recorded through a reference to the PROVIDER table. This information is not always available.
- The type of note_text is CLOB or VARCHAR(MAX) depending on RDBMS
documentation/cdm/note_nlp.1488781440.txt.gz · Last modified: by rimma_belenkaya