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

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 latest updates have been made to a payment transaction / balance transfer at the service line, claim, or provider level

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

Claim Information

claim_status_code

INTEGER

Gives the overall status of the claim as a whole

Other

payment_posted_date

TIMESTAMP

Date of when Payment was posted in Candid

check_date

DATE

Check Date

payment_type

STRING

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

payer_plan_group_id

STRING

Unique ID associated with the specific Payer Plan

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