Skip to navigation

export_payer_plan_group

Payer Plans information.

Primary Key: payer_plan_group_id

Identifiers

payer_plan_group_id
STRINGRequired

Unique ID for the Payer Plans

payer_uuid
STRING

UUID of the associated payer

umbrella_payer_id
STRING

ID of the umbrella payer this payer plan group maps to

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

plan_group_name
STRING

Name of the plan group

plan_type
STRING

Type of plan (e.g. Commercial, Medicare, Medicaid)

is_deactivated
BOOLEAN

Whether the Payer Plan has been deactivated

umbrella_payer_name
STRING

Name of the umbrella payer this payer plan group maps to

Timestamps

umbrella_payer_updated_at
TIMESTAMP

Time when the umbrella payer was last updated

created_at
TIMESTAMP

Time when the Payer Plan was created

updated_at
TIMESTAMP

Time when the Payer Plan 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.