export_adjustment_details

Unique Transaction ID

External Payment ID / Check Number

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

Time when the adjustment transaction itself was updated

Timestamp of the most recently updated source record contributing to this table record. 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)

Claim Adjustment Reason Code

Check Date

Adjustment Reason / Write-Off Reason

Unique ID associated with the specific Payer Plan

Whether ERA was posted to Candid

Date at which the payment was posted

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

ID of the user who created the adjustment

Name of the user who created the adjustment

Date the associated payment was deposited

Gives the overall status of the claim as a whole, sourced from the ERA

Claim control number assigned by the payer, sourced from the ERA

ID of the user who posted the ERA

Name of the user who posted the ERA