export_balance_transfer_details
export_balance_transfer_details
One row per balance transfer leg. A balance transfer moves the open balance on a charge from one responsible party to another (for example from a payer to the patient) and posts two or more ledger transactions: one taking the balance off the old party and one putting it on the new one. Each leg’s amount, direction and responsible party are on export_transaction (amount_cents, counter_party_type), joined on transaction_id.
Primary Key: transaction_id
Identifiers
Unique ID of this balance transfer leg. Joins to export_transaction, which carries its amount and responsible party.
Charge whose open balance was transferred. Matches charge_id on export_transaction.
Payer plan group of the payer on this leg, when recorded. Empty for patient and third-party payer legs.
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
Details
Always BALANCE TRANSFER, identifying the row as a balance transfer leg
Timestamps
Time when the balance transfer was last updated.
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.