export_adjustment_details
export_adjustment_details
All information related to balance-impacting adjustments on a claim.
Primary Key: transaction_id
Identifiers
Unique Transaction ID
Parent charge for the transaction, so it allows you to tie payments and adjustments to the original charge (billed A/R)
Unique ID associated with the specific Payer Plan
Timestamps
Time when the adjustment transaction was last updated.
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
Adjustment Details
Source of Adjustment (ERA, Manual Insurance Balance Adjustment, Patient Balance Adjustment, or Non-Insurance Payer Balance Adjustment)
Adjustment Reason / Write-Off Reason
Organization-defined custom Adjustment Reason / Write-Off Reason, configured as a sub-reason of adjustment_reason.
Note entered with the adjustment
Adjustment Reason Codes
Claim Adjustment Reason Code
The two-letter code that tells you who is responsible for the unpaid portion of a medical claim
Numerical code that tells you the reason for the adjustment
Additional, non-financial information about the processing of a claim to supplement or clarify the reason for a payment adjustment that is already identified by a Claim Adjustment Reason Code (CARC). Delivered as ARRAY<STRING> in BigQuery-direct datasets.
Derived Details
External Payment ID / Check Number
Whether ERA was posted to Candid
Check Date
Date at which the payment was posted
Date the associated payment was deposited
ID of the originating remit (ERA) this adjustment was posted from. It never changes. Matches remit_id in the Candid API. To group by check or EFT, use consolidated_remit_id. Empty when the adjustment is not linked to a remit, such as manual and patient balance adjustments.
ID of the primary remit this adjustment belongs to: one real-world check or EFT, which can group several originating remits (era_payment_id). This is the remit you balance against in Candid. It can change when Candid merges or splits remits, so group by it at query time rather than storing it as a permanent key. Empty when the adjustment is not linked to a remit, such as manual and patient balance adjustments.
Note entered when the remit this adjustment came from was manually posted in Candid. Empty for payer-sent ERAs and non-insurance transactions.
Payer of the 835 file / organization that issued the remit
The 2U segment code that is used to help specifically identify the insurance company that is underwriting what the payment is
X12 claim status code from the ERA (835) indicating the overall adjudication status of the claim (e.g., processed as primary, denied)
The payer’s internal reference number for the claim, as reported in the ERA
ID of the user who created the adjustment
Name of the user who created the adjustment
ID of the user who posted the ERA
Name of the user who posted the ERA
Stable date the adjustment was first posted to the ledger. Unlike payment_posted_date, this does not change if the adjustment is later reallocated to a different charge — use it for period-over-period accounting and denial analysis.
ID of the first charge on the service line this adjustment was posted against. Stable across charge rebills and reallocation.
Payer plan group of the first charge on the service line this adjustment was posted against.
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.