Sidebar
documentation:cdm:preview
NOTE table
This table changed in version 5.2 of the OMOP CDM. The fields note_datetime, note_class_concept_id, note_title, encoding_concept_id, language_concept_id were added.
The NOTE table captures unstructured information that was recorded by a provider about a patient in free text notes on a given date.
| Field | Required | Type | Description |
|---|---|---|---|
| note_id | Yes | integer | A unique identifier for each note. |
| person_id | Yes | integer | A foreign key identifier to the Person about whom the Note was recorded. The demographic details of that Person are stored in the PERSON table. |
| note_date | Yes | date | The date the note was recorded. |
| note_datetime | 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. |
| note_class_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. |
| note_title | No | string(250) | The title of the Note as it appears in the source. |
| note_text | Yes | RBDMS dependent text | The content of the Note. |
| encoding_concept_id | Yes | integer | A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the note character encoding type. |
| language_concept_id | Yes | integer | A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the language of the note. |
| provider_id | No | integer | A foreign key to the Provider in the PROVIDER table who took the Note. |
| visit_occurrence_id | No | integer | Foreign key to the Visit in the VISIT_OCCURRENCE table when the Note was taken. |
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 string(MAX) depending on RDBMS
documentation/cdm/preview.txt · Last modified: 2017/03/17 04:07 by rimma_belenkaya
