This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
documentation:cdm:preview [2017/03/17 03:46] rimma_belenkaya created |
documentation:cdm:preview [2017/03/17 04:07] (current) 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 |