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

table_record_updated_at

TIMESTAMP

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

Claim Information

claim_status_code

INTEGER

Gives the overall status of the claim as a whole

Derived Details

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

deposit_date

DATE

Date the payment was deposited

payer_claim_control_number

STRING

Claim control number assigned by the payer, sourced from 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