This shows you the differences between two versions of the page.
Next revision | Previous revision | ||
documentation:cdm:note [2014/12/05 20:43] cgreich created |
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 5: | Line 11: | ||
|person_id|Yes|integer|A foreign key identifier to the Person about whom the Note was recorded. The demographic details of that Person are stored in the PERSON table.| | |person_id|Yes|integer|A foreign key identifier to the Person about whom the Note was recorded. The demographic details of that Person are stored in the PERSON table.| | ||
|note_date |Yes|date|The date the note was recorded.| | |note_date |Yes|date|The date the note was recorded.| | ||
- | |note_time|No|time|The 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 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 string(MAX) depending on RDBMS | ||