Skip to navigation

export_adjustment_details

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

Primary Key: transaction_id

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.

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

custom_adjustment_reason
STRING

Organization-defined custom Adjustment Reason / Write-Off Reason, configured as a sub-reason of adjustment_reason.

transaction_note
STRING

Note entered with the adjustment

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
JSON

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.

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_payment_id
STRING

ID of the originating remit (ERA) this adjustment was posted from. It never changes. Matches remit_id in the Candid API. To group by check or EFT, use consolidated_remit_id. Empty when the adjustment is not linked to a remit, such as manual and patient balance adjustments.

consolidated_remit_id
STRING

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. Empty when the adjustment is not linked to a remit, such as manual and patient balance adjustments.

manual_remit_note
STRING

Note entered when the remit this adjustment came from was manually posted in Candid. Empty for payer-sent ERAs and non-insurance transactions.

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.

Sync columns

_cds_row_version
TIMESTAMP

Time when this row’s delivered data last changed. Use this for incremental ingestion.

_cds_row_fingerprint
STRING

Hash of this row’s delivered data. Changes whenever any value in the row changes.