User Tools

Site Tools


documentation:cdm:note

NOTE table

THIS IS OUTDATED. All documentation is now on the github wiki. Please refer there or to the 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.

FieldRequiredTypeDescription
note_idYesintegerA unique identifier for each note.
person_idYesintegerA 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 YesdateThe date the note was recorded.
note_datetimeNodatetimeThe date and time the note was recorded.
note_type_concept_idYesintegerA foreign key to the predefined Concept in the Standardized Vocabularies reflecting the type, origin or provenance of the Note.
note_class_concept_idYesintegerA foreign key to the predefined Concept in the Standardized Vocabularies reflecting the HL7 LOINC Document Type Vocabulary classification of the note.
note_titleNostring(250)The title of the Note as it appears in the source.
note_textNoRBDMS dependent textThe content of the Note.
encoding_concept_idYesintegerA foreign key to the predefined Concept in the Standardized Vocabularies reflecting the note character encoding type.
language_concept_idYesintegerA foreign key to the predefined Concept in the Standardized Vocabularies reflecting the language of the note.
provider_idNointegerA foreign key to the Provider in the PROVIDER table who took the Note.
visit_occurrence_idNointegerForeign key to the Visit in the VISIT_OCCURRENCE table when the Note was taken.

Conventions

  • The NOTE table contains free text (in ASCII, or preferably in UTF8 format) taken by a healthcare Provider.
  • 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 type of note_text is CLOB or string(MAX) depending on RDBMS
documentation/cdm/note.txt · Last modified: 2017/09/25 15:02 by clairblacketer