> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://docs.joincandidhealth.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://docs.joincandidhealth.com/_mcp/server.

# export_service_facility

> Service facility information including location and contact details

Service facility information including location and contact details.

**Primary Key:** `organization_service_facility_id`

## Identifiers

**`organization_service_facility_id`** `STRING` — required

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.

---