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 | ||
|
documentation:cdm:note [2017/03/06 05:59] 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 8: | Line 14: | ||
| |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|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.| | |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.| | |language_concept_id|Yes|integer|A foreign key to the predefined Concept in the Standardized Vocabularies reflecting the language of the note.| | ||
| Line 18: | 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.1488779945.txt.gz · Last modified: 2017/03/06 05:59 by rimma_belenkaya
Page Tools
