Patients & Payers

Overview

This group contains patient merge tracking and payer metadata.

Patient Merge

export_patient_merge helps users track which patient records have been merged together. When a patient is merged, the alternative_patient_mrn represents the patient that was merged (the source), and the primary_patient_mrn represents the patient that received the merge (the target). All encounters and data associated with the alternative patient are consolidated under the primary patient.

Payers

export_payer contains metadata about all payers on Candid.

Table Relationships

Common Queries

Find Merged Patients

1
SELECT
2
  pm.primary_patient_mrn,
3
  pm.alternative_patient_mrn,
4
  pm.updated_at
5
FROM export_patient_merge pm
6
WHERE pm.deactivated = FALSE