export_adjustment_details

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

Primary Key: transaction_id

Identifiers

transaction_id

STRINGRequired

Unique Transaction ID

external_payment_id

STRING

External Payment ID / Check Number

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

updated_at

TIMESTAMP

Time at which the table 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

Other

source

STRING

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

carc

STRING

Claim Adjustment Reason Code

check_date

DATE

Check Date

adjustment_reason

STRING

Adjustment Reason / Write-Off Reason

payer_plan_group_id

STRING

Unique ID associated with the specific Payer Plan

posted_status

STRING

Whether ERA was posted to Candid

payment_posted_date

TIMESTAMP

Date at which the payment was posted

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