export_patient_merge

Synchronizes and tracks patient identities across multiple EMRs, ensuring a cleaner single source of truth for patient data.

Primary Key: patient_merge_id

Identifiers

patient_merge_id
STRINGRequired

Consolidated patient object (based on all inputs from EMRs)

updating_user_id
STRING

Individual who made the change to the merged patient object

Timestamps

updated_at
TIMESTAMP

Time at which the merged patient entity was updated

Organization

organization_id
STRING

Unique ID for the organization as defined in the Candid system

organization_name
STRING

Organization name (Company name)

Other

version
INTEGER

Sequential version of the patient merged object as it is in the Candid system

deactivated
BOOLEAN

Whether the patient version has been deactivated

primary_patient_mrn
STRING

Patient Medical Record Number - the current MRN

alternative_patient_mrn
STRING

Alternative Medical Record Number - prior MRN