This is an old revision of the document!
The NOTE table captures unstructured information that was recorded by a provider about a patient in free text notes on a given date.
Field | Required | Type | Description |
---|---|---|---|
note_id | Yes | integer | A unique identifier for each note. |
person_id | Yes | integer | A 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 | Yes | date | The date the note was recorded. |
note_datetime | No | datetime | The date and time the note was recorded. |
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_text | Yes | RBDMS Dependent | The content of the Note. |
provider_id | No | integer | A foreign key to the Provider in the PROVIDER table who took the Note. |
note_source_value | No | varchar(50) | The source value associated with the origin of the Note, as standardized using the note_tyype_concept_id |
visit_occurrence_id | No | integer | Foreign key to the Visit in the VISIT_OCCURRENCE table when the Note was taken. |