This is an old revision of the document!
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(250) | A small window of text surrounding the term. |
lexical_variant | No | varchar(250) | A small window of text surrounding the term. |
note_nlp_concept_id | No | varchar(250) | A small window of text surrounding the term. |
nlp_system | No | varchar(250) | A small window of text surrounding the term. |
nlp_date | Yes | date | The date the note was recorded. |
nlp_date_time | No | datetime | The date the note was recorded. |
term_exists | No | datetime | The date and time the note was recorded. |
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. |