export_patient_merge
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
Consolidated patient object (based on all inputs from EMRs)
Individual who made the change to the merged patient object
Timestamps
Time at which the merged patient entity was updated.
Organization
Unique ID for the organization as defined in the Candid system
Organization name (Company name)
Organization’s External ID - the ID that the organization uses to map to their own upstream system
Other
Sequential version of the patient merged object as it is in the Candid system
Whether the patient version has been deactivated
Patient Medical Record Number - the current MRN
Alternative Medical Record Number - prior MRN
Sync columns
Time when this row’s delivered data last changed. Use this for incremental ingestion.
Hash of this row’s delivered data. Changes whenever any value in the row changes.