export_adjustment_details

Unique Transaction ID

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

Unique ID associated with the specific Payer Plan

Time when the adjustment transaction itself was updated

Timestamp of the most recently updated source record contributing to this row. Used to detect newly ingested or updated records for incremental processing.

User’s unique organization ID in the Candid system

User’s Organization / Company Name

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

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

Adjustment Reason / Write-Off Reason

Claim Adjustment Reason Code

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

Numerical code that tells you the reason for the adjustment

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)

External Payment ID / Check Number

Whether ERA was posted to Candid

Check Date

Date at which the payment was posted

Date the associated payment was deposited

Payer of the 835 file / organization that issued the remit

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

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

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

ID of the user who created the adjustment

Name of the user who created the adjustment

ID of the user who posted the ERA

Name of the user who posted the ERA