patient remains the source of truth for the patient’s own demographics; this table carries only the responsible-party fields, which have no EHR equivalent.
This table’s columns and relationships are shown in the Hosted Database schema.
patient_guarantor.patient_id joins to patient.id and is null when the Elation Billing patient does not map to an EHR patient. The responsible party’s SSN is intentionally not exposed.- Responsible-party contact details for billing follow-up
- Patients whose guarantor is someone other than themselves
- Guarantor mailing addresses for statements
Responsible-party (guarantor) details
Pulls the full responsible-party record - contact details and mailing address - for each patient’s Elation Billing account. Addand pg.patient_id = <patient_id> to look up a single patient.