NOTE table

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_textYesRBDMS 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