User Tools

Site Tools


documentation:cdm:preview

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

  • 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/preview.txt · Last modified: 2017/03/17 04:07 by rimma_belenkaya