export_transaction
export_transaction
All data associated with a single transaction. Can be joined to other financial detail tables with transaction_id.
Primary Key: transaction_id
Identifiers
Unique transaction ID
The original charge transaction that this void is reversing. This will only be completed if it is a voiding charge transaction (so it is reversing a charge).
The ID here references the charge transaction which reverses this charge. This is added to a charge transaction if it is later voided.
Organization ID, claim ID, or service line ID to tell you which specific place it’s allocated
External patient ID, counterparty ID for payer = payer UUID
ID of the custom batch period created
Unique ID associated with the encounter in the Candid system
Unique service line ID
Parent charge for the transaction, so it allows you to tie payments and adjustments to the original charge (billed A/R)
Identifier of every unique charge to easily map payments and adjustments to charge transactions
Timestamps
Timestamp of when the Transaction / payment record was created or entered into the Candid system. Though it is often identical to batch date, transaction date reflects when the record was created in Candid, meaning that if historical data is uploaded, transaction date reflects when the data was uploaded to Candid rather than when the payment took place.
Financial period for which the transaction should count - mutable field based on when you would want to account for a transaction. While this typically aligns with the date a payment or charge is posted, it can be manually adjusted (backdated) to reflect when a transaction truly occurred. This is primarily used to group early-month transactions into a previous month’s close or to accurately record historical accounts receivable data.
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
Financial
Amount in cents. Note on the signage: Charge transaction types will always be a positive amount. Payments will usually be negative. However, in cases of reversals (for insurance counter party) or refunds (for patient counter party), the amount cents will be positive.
Transaction Details
Type of Transfer: Charge, Payment, Balance Transfer, or Adjustment. Note on Balance Transfers: Balance Transfers are a specific transaction type used to move financial liability between different counterparties (such as moving a balance from an Insurance Payer to a Patient). Unlike a payment or a charge, which might stand alone, balance transfers always come in pairs - ie a charge is deducted from Payer (Counterparty A) and added to Patient (Counterparty B). This ensures the ledger remains balanced.
Other
Organization, claim, or service line - it tells you to what extent a payment is allocated
Patient, payer, non-insurance, organization
Unique ID associated with the specific Payer Plan