export_payment_details

All data associated with a payment. Can be joined to the Transaction table by transaction_id.

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 payment transaction itself was updated

table_record_updated_at

TIMESTAMP

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

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

Payment Details

payment_type

STRING

Type of Payment (ERA, Patient Payment, Non-Insurance Payment)

Derived Details

external_payment_id

STRING

External Payment ID / Check Number

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

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