notes


If there is patient data for this table the file for this export will be found in the extracted zip folder location under the filename of notes.csv

If there are non-patient data column elements that are not part of the designated record set they will be marked in the Comment's column for that data element

Description

Clinical notes and comments for individual patient documents

Columns

Column Type Size Nulls Auto Default Children Parents Comments
date Unknown 0 null

Date and time the note was created
foreign_id Unknown 0 null
documents.id Defined in XML R

The documents.id key for the document this note is connected to
id Unknown 0 null

Surrogate id of the record used as the primary incrementing key
note Unknown 0 null

The notes or comments for the document referenced in foreign_id
owner Unknown 0 null
users.id Defined in XML R

Foreign key identifier to users of who initially created this note
revision Unknown 0 null

UNUSED

Relationships

Close relationships within degrees of separation