Skip to navigation

export_service_facility

Service facility information including location and contact details.

Primary Key: organization_service_facility_id

Identifiers

organization_service_facility_id
STRINGRequired

Unique ID for the service facility

external_id
STRING

Organization’s own service facility identifier

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 service facility

description
STRING

Description of the service facility

status
STRING

Status of the service facility

operational_status
STRING

Operational status of the facility

mode
STRING

Mode of the service facility

type
STRING

Type of service facility

physical_type
STRING

Physical type of the facility

address_address1
STRING

Service Facility Address Line

address_address2
STRING

Service Facility Additional Address Line

address_city
STRING

Service Facility City

address_state
STRING

Service Facility State

address_zip_code
STRING

Service Facility Zip Code

address_zip_plus_four_code
STRING

Service Facility Zip Code (additional numbers)

npi
STRING

Service facility NPI

address_string
STRING

Service facility’s full street address as a single string

aliases
JSON

Alternative names for the service facility

telecoms
JSON

Contact information (phone/fax/email)

Timestamps

created_at
TIMESTAMP

Time when the service facility was created

updated_at
TIMESTAMP

Time when the service facility 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.