Patient 360
Each patient’s current demographics, plus the history of their coverage (including non-insurance payers and clinical trials) and notes, and their appointments, referrals, authorizations and record merges. Every table joins to export_patient on patient_id.
Tables
Notes
- Patients to encounters: match
export_patient.mrntoexport_encounter.patient_external_idwithin the sameorganization_id. - History tables have one row per version. Filter
is_latest_record = TRUEfor current state (is_latest_record_for_patienton the non-insurance payer history). That table also hasvalid_fromandvalid_tofor as-of queries. - Merges:
alternative_patient_mrnis the patient that was merged away, andprimary_patient_mrnis the patient that received its records. All of the alternative patient’s encounters and data move to the primary patient.