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.
A row leaves this table once its adjustment is posted to the ledger. The posted row appears in export_transaction with the same adjustment_detail_id.
Primary Key: adjustment_detail_id
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
Time when the informational adjustment record was last updated.
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). Delivered as ARRAY<STRING> in BigQuery-direct datasets.
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
ID of the originating remit (ERA) this adjustment came from. It never changes. Matches remit_id in the Candid API. To group by check or EFT, use consolidated_remit_id.
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.
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
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.
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.