export_non_insurance_payer
export_non_insurance_payer
Non-insurance (third-party) payer information.
Primary Key: id
Identifiers
Unique ID for the non-insurance payer
Organization
User’s unique organization ID in the Candid system
User’s Organization / Company Name
Organization’s External ID - the ID that the organization uses to map to their own upstream system
Details
Name of the non-insurance payer
Description of the non-insurance payer
Category of the non-insurance payer
Whether the non-insurance payer is enabled
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.
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
Time when the non-insurance payer was created
Time when the non-insurance payer or any of its clinical trials was last updated.
Sync columns
Time when this row’s delivered data last changed. Use this for incremental ingestion.
Hash of this row’s delivered data. Changes whenever any value in the row changes.