> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://docs.joincandidhealth.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://docs.joincandidhealth.com/_mcp/server.

# export_adjustment_details

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

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

**Primary Key:** `transaction_id`

> **Warning**
>
> **Planned deprecation — 2026-09-30**
>
> `table_record_updated_at` will be removed on 2026-09-30 — use `updated_at` instead.

## Identifiers

**`transaction_id`** `STRING` — required

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.

---