export_adjustment_details | Candid

All information related to balance-impacting adjustments on a claim.

Primary Key: transaction_id

Planned deprecation — 2026-09-30

table_record_updated_at will be removed on 2026-09-30 — use updated_at instead.

Identifiers

transaction_id

STRINGRequired

Unique Transaction ID

charge_id

STRING

Parent charge for the transaction, so it allows you to tie payments and adjustments to the original charge (billed A/R)

payer_plan_group_id

STRING

Unique ID associated with the specific Payer Plan

Timestamps

updated_at

TIMESTAMP

Time when the adjustment transaction was last updated. Use this for incremental ingestion.

table_record_updated_at

TIMESTAMP

Will be deprecated 2026-09-30 — use updated_at instead.

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

Adjustment Details

source

STRING

Source of Adjustment (ERA, Manual Insurance Balance Adjustment, Patient Balance Adjustment, or Non-Insurance Payer Balance Adjustment)

adjustment_reason

STRING

Adjustment Reason / Write-Off Reason

Adjustment Reason Codes

carc

STRING

Claim Adjustment Reason Code

claim_adjustment_group_code

STRING

The two-letter code that tells you who is responsible for the unpaid portion of a medical claim

adjustment_reason_code

STRING

Numerical code that tells you the reason for the adjustment

remark_codes

ARRAY<STRING>

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)

Derived Details

external_payment_id

STRING

External Payment ID / Check Number

posted_status

STRING

Whether ERA was posted to Candid

check_date

DATE

Check Date

payment_posted_date

TIMESTAMP

Date at which the payment was posted

deposit_date

DATE

Date the associated payment was deposited

era_payer_name

STRING

Payer of the 835 file / organization that issued the remit

era_payer_identifier

STRING

The 2U segment code that is used to help specifically identify the insurance company that is underwriting what the payment is

claim_status_code

INTEGER

X12 claim status code from the ERA (835) indicating the overall adjudication status of the claim (e.g., processed as primary, denied)

payer_claim_control_number

STRING

The payer’s internal reference number for the claim, as reported in the ERA

created_by

STRING

ID of the user who created the adjustment

created_by_name

STRING

Name of the user who created the adjustment

era_posted_by

STRING

ID of the user who posted the ERA

era_posted_by_name

STRING

Name of the user who posted the ERA

first_payment_posted_date

TIMESTAMP

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.

first_charge_id

STRING

ID of the first charge on the service line this adjustment was posted against. Stable across charge rebills and reallocation.

first_payer_plan_group_id

STRING

Payer plan group of the first charge on the service line this adjustment was posted against.