Skip to navigation

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

transaction_id
STRINGRequired

Unique ID of this balance transfer leg. Joins to export_transaction, which carries its amount and responsible party.

charge_id
STRING

Charge whose open balance was transferred. Matches charge_id on export_transaction.

payer_plan_group_id
STRING

Payer plan group of the payer on this leg, when recorded. Empty for patient and third-party payer legs.

Organization

organization_id
STRING

User’s unique organization ID in the Candid system

organization_name
STRING

User’s Organization / Company Name

external_organization_id
STRING

Organization’s External ID - the ID that the organization uses to map to their own upstream system

Details

transfer_reason
STRING

Always BALANCE TRANSFER, identifying the row as a balance transfer leg

Timestamps

updated_at
TIMESTAMP

Time when the balance transfer was last updated.

Sync columns

_cds_row_version
TIMESTAMP

Time when this row’s delivered data last changed. Use this for incremental ingestion.

_cds_row_fingerprint
STRING

Hash of this row’s delivered data. Changes whenever any value in the row changes.