export_patient_note_history

Patient note history including all note versions with authorship and content details. Each row represents a specific version of a note linked to a patient. Notes on deactivated patients are not included.

When a newer version of a note arrives, the previous version’s is_latest_record changes to FALSE and its updated_at advances, so incremental pulls by updated_at pick up the change.

Primary Key: patient_note_history_pk

Identifiers

patient_note_history_pk

STRINGRequired

String primary key for the patient note history record (composite of patient_id, note_id, note_version)

patient_id

STRING

Unique ID associated with the patient in the Candid system

note_id

STRING

Unique ID of the note

note_version

INTEGER

Version number of the note

updating_user_id

STRING

ID of the user who made this update

Timestamps

updated_at

TIMESTAMP

Timestamp when this version was created

note_created_at

TIMESTAMP

Timestamp when the note was originally created

Organization

organization_id

STRING

User’s unique organization ID in the Candid system

organization_name

STRING

User’s Organization / Company Name

external_organization_id

STRING

Organization’s External ID

Note

deactivated

BOOLEAN

Whether this note version has been deactivated

note_type

STRING

Type/category of the note

note_value

STRING

Text content of the note

author_name

STRING

Name of the note author

author_email

STRING

Email of the note author

Other

is_latest_record

BOOLEAN

Whether this is the most recent version of the note (TRUE/FALSE)