This shows you the differences between two versions of the page.
Both sides previous revision Previous revision | |||
documentation:cdm:preview [2017/03/17 03:59] rimma_belenkaya |
documentation:cdm:preview [2017/03/17 04:07] rimma_belenkaya |
||
---|---|---|---|
Line 1: | Line 1: | ||
===== NOTE table ===== | ===== NOTE table ===== | ||
- | This table changed in version 5.2 of the OMOP CDM. The field procedure_datetime was added. | + | 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. |
---- | ---- | ||
Line 13: | 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 23: | 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 |