User Tools

Site Tools


documentation:cdm:preview

Differences

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

Link to this comparison view

Next revision
Previous revision
documentation:cdm:preview [2017/03/17 03:46]
rimma_belenkaya created
documentation:cdm:preview [2017/03/17 04:07]
rimma_belenkaya
Line 1: Line 1:
 ===== NOTE table ===== ===== 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. 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 8: Line 13:
 |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_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_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|varchar(250)|The title of the Note as it appears in the source.|+|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.| |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.| |encoding_concept_id|Yes|integer|A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the note character encoding type.|
Line 18: Line 23:
   * 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/preview.txt ยท Last modified: 2017/03/17 04:07 by rimma_belenkaya