export_patient
export_patient
Patient demographic and identification data. One row per patient, reflecting the patient’s current state. Deactivated patients are included with deactivated = TRUE.
mrn matches patient_external_id on encounter-level tables (export_encounter, export_patient_monetary_transaction) within the same organization_id.
Primary Key: patient_id
Identifiers
Unique ID associated with the patient in the Candid system
Medical Record Number - the foreign key to map patient to user’s own system
Timestamps
Time at which the patient record was last updated in the database
Time at which the patient record was created in the database
Timestamp at which the patient was recorded as deceased, if applicable
Organization
User’s unique organization ID in the Candid system
User’s Organization / Company Name
Organization’s External ID - the ID that the organization uses to map to their own upstream system
Patient Information
Whether the patient record has been deactivated
Patient’s date of birth
Patient’s last name (uppercase)
Patient’s first name (uppercase)
Patient’s Social Security Number
Patient’s primary address line 1
Patient’s primary address line 2
Patient’s city of residence
Patient’s state of residence
Patient’s ZIP code
Patient’s country of residence
County of the patient’s primary address
Patient’s phone number
Type of phone number (e.g., HOME, CELL, WORK)
Patient’s email address
Patient’s gender identity
Patient’s biological sex
Patient’s race
Patient’s ethnicity
Patient’s marital status
Patient’s preferred language
Whether the patient is recorded as deceased
Array of the patient’s advanced directives (e.g., LIVING_WILL, DO_NOT_RESUSCITATE, DURABLE_POWER_OF_ATTORNEY)
Patient’s HIPAA code
Tags associated with the patient record
Array of customer-defined metadata schema instances, each with a schema id and its arbitrary key/value pairs; shape varies by metadata schema
Name of the user who created the patient record
Billing
Flag indicating if the patient should not be invoiced
Reason why the patient should not be invoiced
Whether the patient is self-pay (no active insurance or non-insurance payer coverage)
Employer name of the primary coverage’s subscriber
Attending Provider
Array of attending provider information including NPI and name
First name of the first attending provider (alphabetical by NPI)
Last name of the first attending provider (alphabetical by NPI)
Full name of the first attending provider in title case
NPI of the first attending provider (alphabetical by NPI)
Referring Provider
Array of referring provider information including NPI and name
First name of the first referring provider (alphabetical by NPI)
Last name of the first referring provider (alphabetical by NPI)
Full name of the first referring provider in title case
NPI of the first referring provider (alphabetical by NPI)
Service Facility
ID of the patient’s primary service facility
Name of the patient’s primary service facility
Non-Insurance Payers & Clinical Trials
Number of non-insurance payer associations linked to the patient
Array of non-insurance payer associations with details
Number of clinical trials the patient is associated with
Array of clinical trial details associated with the patient (non_insurance_payer_id, clinical_trial_id, clinical_trial_arm, clinical_trial_start_date, clinical_trial_end_date, clinical_trial_number, clinical_trial_name). Join on non_insurance_payer_id and clinical_trial_id to export_non_insurance_payer.clinical_trials.
Emergency Contact
Array of the patient’s emergency contacts, each including name, relationship, and phone
First name of the patient’s first listed emergency contact (uppercase)
Last name of the patient’s first listed emergency contact (uppercase)
Full name of the patient’s first listed emergency contact in title case
Relationship of the patient’s first listed emergency contact to the patient
Phone number of the patient’s first listed emergency contact