User Tools

Site Tools


documentation:cdm:note

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
documentation:cdm:note [2017/03/06 05:25]
rimma_belenkaya
documentation:cdm:note [2017/09/25 15:02] (current)
clairblacketer
Line 1: Line 1:
 ===== NOTE table ===== ===== NOTE table =====
 +**THIS IS OUTDATED. All documentation is now on the [[https://​github.com/​OHDSI/​CommonDataModel/​wiki|github wiki]]. Please refer there or to the [[projects:​workgroups:​cdm-wg|CDM working group]] for more information**
 +
 +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. 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^ ^Field^Required^Type^Description^
Line 7: Line 13:
 |note_datetime|No|datetime|The date and time 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_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_text|Yes|RBDMS dependent text|The content 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|No|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.| |provider_id|No|integer|A foreign key to the Provider in the PROVIDER table who took the Note.|
-|note_title|No|varchar(50)|The title of the Note as it appears in the source| 
 |visit_occurrence_id|No|integer|Foreign key to the Visit in the VISIT_OCCURRENCE table when the Note was taken.| |visit_occurrence_id|No|integer|Foreign key to the Visit in the VISIT_OCCURRENCE table when the Note was taken.|
 ==== Conventions ==== ==== Conventions ====
Line 15: Line 24:
   * 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 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 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+  * The type of note_text is CLOB or string(MAX) depending on RDBMS
  
documentation/cdm/note.1488777928.txt.gz · Last modified: 2017/03/06 05:25 by rimma_belenkaya