export_informational_adjustment_details
export_informational_adjustment_details
Additional information related to non-balance-impacting adjustments made to a claim. Enables comprehensive denial analysis by tracing denials back to their original ERAs and charges.
Primary Key: adjustment_detail_id
Planned deprecation — 2026-09-30
adjustment_updated_at and table_record_updated_at will be removed on 2026-09-30 — use updated_at instead.
Identifiers
Line-item details behind a payer adjustment (the rationale behind a specific claim adjustment / remark code). This is captured in the ‘i’ bubble on the service line in Candid
The Transaction ID for an adjustment
Patient ID within Candid
Unique ID associated with the encounter in the Candid system
Unique ID associated with the service line in the Candid system
Parent charge for the transaction, so it allows you to tie payments and adjustments to the original charge (billed A/R)
Timestamps
Time when the ERA-derived adjustment itself was created
Will be deprecated 2026-09-30 — use updated_at instead.
Will be deprecated 2026-09-30 — use updated_at instead.
Time when the informational adjustment record was last updated. Use this for incremental ingestion.
Organization
Organization’s unique ID in the Candid system
Organization Name
Organization’s External ID - the ID that the organization uses to map to their own upstream system
Informational Adjustment Details
Level of granularity of adjustment (provider, claim, or service line level). This can allow us to trace denials or adjustments made at a provider level, for example
Amount Cents
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)
Unique ID associated with the specific Payer Plan
Derived Details
External Payment ID / Check Number
Whether ERA was posted to Candid
Check Date
Date of when Payment was posted in Candid
Date the associated payment was deposited
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
User ID of the person who posted the adjustment
Name of the person who posted the adjustment
User ID of the person who posted the ERA
Name of the person who posted the ERA
Stable date the informational adjustment was first posted to the ledger. Unlike payment_posted_date, this does not change if the informational 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 informational adjustment was posted against. Stable across charge rebills and reallocation.
Payer plan group of the first charge on the service line this informational adjustment was posted against.