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 Next revision Both sides next revision | ||
|
documentation:cdm:note [2017/03/06 05:35] rimma_belenkaya |
documentation:cdm:note [2017/03/17 03:50] rimma_belenkaya |
||
|---|---|---|---|
| Line 7: | Line 7: | ||
| |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_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_text|Yes|CLOB|The content of the Note.| |
| - | |note_title|No|varchar(50)|The title of the Note as it appears in the source.| | + | |
| - | |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.| | + | |
| |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 17: | Line 15: | ||
| * 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 | ||
documentation/cdm/note.txt · Last modified: 2017/09/25 15:02 by clairblacketer
Page Tools
