Candid Health is an open data platform and makes it easy to retrieve datasets out of Candid Health in a first-class way. The intention of this Data Share is to provide access to datasets that can be easily synchronized into other data platforms for customer and partner needs outside of the Candid Health platform.

Cloud-native access to these shared BigQuery datasets is provided through service account credentials. In addition to using one of BigQuery’s client libraries, external tools such as Fivetran or Airbyte can be configured with those credentials to provide direct access to and automatically synchronize the datasets. Available datasets and their schemas are listed below.

Please email support@joincandidhealth.com for more information and access to the feature.

Table Information

Encounter & Service Line Metadata

Schemas

Financial Transactions Data

The core of the financial transactions data model is the export_transaction table. This table will have most of the information you need to analyze your financial transactions. If you need to access more detailed data about one type of transaction, you can join the export_transaction table to one of the associated detail tables using an inner join:

1
SELECT
2
  *
3
FROM export_transaction
4
JOIN export_adjustment_details
5
  ON export_transaction.transaction_type = 'ADJUSTMENT'
6
  AND export_transaction.transaction_id = export_adjustment_details.transaction_id

Full diagram of relationships and JOIN predicates:

Informational Adjustments are not associated with financial transactions and can be directly associated with Service Lines or Encounters

Service Line Charges can be joined to Transactions through the charge_id and also to Service Lines through the service_line_id:

1
SELECT
2
  *
3
FROM export_transaction
4
JOIN export_service_line_charge
5
  ON export_transaction.charge_id = export_service_line_charge.id
6
JOIN export_service_line
7
  ON export_service_line_charge.service_line_id = export_service_lineservice_line_id

In diagram form:

Schemas