Skip to navigation

export_non_insurance_payer

Non-insurance (third-party) payer information.

Primary Key: id

Identifiers

id
STRINGRequired

Unique ID for the non-insurance payer

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

Details

name
STRING

Name of the non-insurance payer

description
STRING

Description of the non-insurance payer

category
STRING

Category of the non-insurance payer

enabled
BOOLEAN

Whether the non-insurance payer is enabled

is_deleted
BOOLEAN

Whether the non-insurance payer was deleted in the Candid system. Deleted non-insurance payers remain in this table as tombstones so incremental consumers can remove them.

clinical_trials
JSON

Array of clinical trials configured on this non-insurance payer (clinical_trial_id, clinical_trial_number, clinical_trial_name, clinical_trial_phase, clinical_trial_type, is_deactivated). Join on clinical_trial_id to the clinical_trials arrays on export_patient and export_patient_non_insurance_payer_history.

Timestamps

created_at
TIMESTAMP

Time when the non-insurance payer was created

updated_at
TIMESTAMP

Time when the non-insurance payer or any of its clinical trials was last updated.

Sync columns

_cds_row_version
TIMESTAMP

Time when this row’s delivered data last changed. Use this for incremental ingestion.

_cds_row_fingerprint
STRING

Hash of this row’s delivered data. Changes whenever any value in the row changes.