documentation:cdm:note
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision Next revision | Previous revision Last revision Both sides next revision | ||
|
documentation:cdm:note [2017/03/17 03:50] rimma_belenkaya |
documentation:cdm:note [2017/07/07 23:37] rimma_belenkaya1 |
||
|---|---|---|---|
| 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 7: | Line 12: | ||
| |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|CLOB|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_source_value|No|varchar(50)|The source value associated with the origin of the Note, as standardized using the note_tyype_concept_id| | ||
| |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 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 string(MAX) depending on RDBMS | ||
documentation/cdm/note.txt · Last modified: 2017/09/25 15:02 by clairblacketer
Page Tools
