User Tools

Site Tools


documentation:cdm:note

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
documentation:cdm:note [2017/03/17 04:09]
rimma_belenkaya
documentation:cdm:note [2017/09/25 15:02]
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. ​ 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 14: Line 15:
 |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|string(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.|
documentation/cdm/note.txt ยท Last modified: 2017/09/25 15:02 by clairblacketer