> 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_informational_adjustment_details

> Additional information related to non-balance-impacting adjustments made to a claim

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`

> **Warning**
>
> **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

**`adjustment_detail_id`** `STRING` — required

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

---

**`adjustment_id`** `STRING`

The Transaction ID for an adjustment

---

**`patient_id`** `STRING`

Patient ID within Candid

---

**`encounter_id`** `STRING`

Unique ID associated with the encounter in the Candid system

---

**`service_line_id`** `STRING`

Unique ID associated with the service line in the Candid system

---

**`charge_id`** `STRING`

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

---

## Timestamps

**`adjustment_timestamp`** `TIMESTAMP`

Time when the ERA-derived adjustment itself was created

---

**`adjustment_updated_at`** `TIMESTAMP`

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

---

**`table_record_updated_at`** `TIMESTAMP`

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

---

**`updated_at`** `TIMESTAMP`

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

---

## Organization

**`organization_id`** `STRING`

Organization's unique ID in the Candid system

---

**`organization_name`** `STRING`

Organization Name

---

**`external_organization_id`** `STRING`

Organization's External ID - the ID that the organization uses to map to their own upstream system

---

## Informational Adjustment Details

**`adjustment_type`** `STRING`

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`** `INTEGER`

Amount Cents

---

## 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)

---

**`payer_plan_group_id`** `STRING`

Unique ID associated with the specific Payer Plan

---

## 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 of when Payment was posted in Candid

---

**`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`

User ID of the person who posted the adjustment

---

**`created_by_name`** `STRING`

Name of the person who posted the adjustment

---

**`era_posted_by`** `STRING`

User ID of the person who posted the ERA

---

**`era_posted_by_name`** `STRING`

Name of the person who posted the ERA

---

**`first_payment_posted_date`** `TIMESTAMP`

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.

---

**`first_charge_id`** `STRING`

ID of the first charge on the service line this informational 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 informational adjustment was posted against.

---