export_charge_details

Information associated with a particular charge.

Primary Key: transaction_id

Identifiers

transaction_id
STRINGRequired

Unique Transaction ID in the Candid system

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

Billing Provider

billing_provider_npi
STRING

Billing Provider NPI number

billing_provider_tax_id
STRING

Billing Provider Tax ID

billing_provider_id
STRING

Unique Billing Provider ID

Rendering Provider

rendering_provider_npi
STRING

Rendering Provider NPI

rendering_provider_id
STRING

Unique Rendering Provider ID

Service Facility

service_facility_name
STRING

Service Facility Name

service_facility_address1
STRING

Service Facility Address

service_facility_city
STRING

Service Facility City

service_facility_state
STRING

Service Facility State

service_facility_zip_code
STRING

Service Facility Zip Code

service_facility_id
STRING

Unique Service Facility ID

Other

service_date
TIMESTAMP

Date in which the patient encounter took place

cpt
STRING

Procedure Code

quantity
NUMERIC

Quantity of Services Rendered

place_of_service_code
STRING

Two-digit code indicating the setting where healthcare services were provided and / or rendered

payer_plan_group_id
STRING

Unique ID associated with the specific Payer Plan

status
STRING

Status of the Charge - Billed or Pre-Submission

modifiers
ARRAY<STRING>

List of modifiers