---
title: "organization"
description: "The US Core Organization Profile inherits from the FHIR [Organization](https://hl7.org/fhir/R4/organization.html) resource; refer to it for scope and usage definitions."
---

The US Core Organization Profile inherits from the FHIR [Organization](https://hl7.org/fhir/R4/organization.html) resource; refer to it for scope and usage definitions. This profile sets minimum expectations for the Organization resource to record, search, and fetch patient or provider organization information. It specifies which core elements, extensions, vocabularies, and value sets **SHALL** be present and constrains how the elements are used. Providing the floor for standards development for specific use cases promotes interoperability and adoption.

## Source

| Model | Leg | Role |
|---|---|---|
| `us-core-organization` | FHIR | defines this table |
| `openEHR-EHR-CLUSTER.address.v1` | openEHR | merged in — Address |
| `openEHR-EHR-CLUSTER.electronic_communication.v1` | openEHR | merged in — Electronic communication |
| `openEHR-EHR-CLUSTER.organisation.v1` | openEHR | merged in — Organisation |

> This table is the union of 4 source models. Columns carrying a **From** value came from a model that merged into it, so the same row satisfies both specifications.

## Columns

| Column | Type | Null | Description | From | Source |
|---|---|---|---|---|---|
| `id` | `uuid primary key` | no | Organization.id | — | — |
| `created_at` | `timestamptz` | no | Row creation timestamp. | — | — |
| `updated_at` | `timestamptz` | no | Row update timestamp; maintained by the application. | — | — |
| `created_by` | `text` | no | Actor who created the row. | — | — |
| `updated_by` | `text` | no | Actor who last updated the row. | — | — |
| `npi` | `text` | yes | National Provider Identifier (NPI) | — | `Organization.identifier` |
| `clia` | `text` | yes | Clinical Laboratory Improvement Amendments (CLIA) Number for laboratories | — | `Organization.identifier` |
| `naic` | `text` | yes | NAIC Code | — | `Organization.identifier` |
| `identifier_value`<br />`identifier_system` | text, text<br />`text`, `text` | yes | Identifies this organization  across multiple systems | — | `Organization.identifier` |
| `active` | `boolean` | yes | Whether the organization's record is still in active use | — | `Organization.active` |
| `name` | `text` | yes | Name used for the organization | — | `Organization.name` |
| `phone_number`<br />`phone_use_code`<br />`email`<br />`email_use_code` | text, text, text, text<br />`text`, `text`, `text`, `text` | yes | A contact detail for the organization | — | `Organization.telecom` |
| `address_line`<br />`address_city`<br />`address_district`<br />`address_state`<br />`address_postal_code`<br />`address_country`<br />`address_use_code`<br />`address_type_code` | text, text, text, text, text, text, text, text<br />`text`, `text`, `text`, `text`, `text`, `text`, `text`, `text` | yes | An address for the organization | — | `Organization.address` |
| `part_of_id` | `uuid` | yes | The organization of which this organization forms a part | — | `Organization.partOf` |
| `address_latitude_magnitude`<br />`address_latitude_units` | quantity<br />`numeric`, `text` | yes | Latitude | `openEHR-EHR-CLUSTER.address.v1` | `/items[at0007]` |
| `address_longitude_magnitude`<br />`address_longitude_units` | quantity<br />`numeric`, `text` | yes | Longitude | `openEHR-EHR-CLUSTER.address.v1` | `/items[at0008]` |
| `address_altitude_magnitude`<br />`address_altitude_units` | quantity<br />`numeric`, `text` | yes | Altitude | `openEHR-EHR-CLUSTER.address.v1` | `/items[at0009]` |
| `address_comment` | `text` | yes | Comment | `openEHR-EHR-CLUSTER.address.v1` | `/items[at0018]` |
| `address_map_url` | `text` | yes | Map URL | `openEHR-EHR-CLUSTER.address.v1` | `/items[at0019]` |
| `address_geolocation_code` | `text` | yes | Geolocation code | `openEHR-EHR-CLUSTER.address.v1` | `/items[at0021]` |
| `phone_comment`<br />`email_comment` | text, text<br />`text`, `text` | yes | Comment | `openEHR-EHR-CLUSTER.electronic_communication.v1` | `/items[at0004]` |
| `comment` | `text` | yes | Comment | `openEHR-EHR-CLUSTER.organisation.v1` | `/items[at0019]` |

## Constraints

```sql
check (identifier_system is null or identifier_value is not null)
check ((address_latitude_magnitude is null and address_latitude_units is null) or (address_latitude_magnitude is not null and address_latitude_units is not null))
check (address_latitude_magnitude is null or (address_latitude_units = 'deg' and address_latitude_magnitude between -90 and 90))
check ((address_longitude_magnitude is null and address_longitude_units is null) or (address_longitude_magnitude is not null and address_longitude_units is not null))
check (address_longitude_magnitude is null or (address_longitude_units = 'deg' and address_longitude_magnitude between -180 and 180))
check ((address_altitude_magnitude is null and address_altitude_units is null) or (address_altitude_magnitude is not null and address_altitude_units is not null))
```

## Unique

- `npi`

## References

| Columns | Target | On delete |
|---|---|---|
| `part_of_id` | [`organization`](/docs/tables/organization) | no action |

## Referenced by

37 tables reference `organization`, via `organization_id`. The first 15 alphabetically:

- [`adverse_reaction_event_information_source`](/docs/tables/adverse_reaction_event_information_source) via `organization_id`
- [`adverse_reaction_screening_specific_adverse_reaction_add_eb257e`](/docs/tables/adverse_reaction_screening_specific_adverse_reaction_add_eb257e) via `organization_id`
- [`care_team_participant`](/docs/tables/care_team_participant) via `member_organization_id`
- [`coverage`](/docs/tables/coverage) via `payor_organization_id`
- [`death_summary_structured_place_of_death`](/docs/tables/death_summary_structured_place_of_death) via `organization_id`
- [`document_reference`](/docs/tables/document_reference) via `authenticator_organization_id`
- [`document_reference`](/docs/tables/document_reference) via `custodian_id`
- [`document_reference_author`](/docs/tables/document_reference_author) via `organization_id`
- [`encounter`](/docs/tables/encounter) via `service_provider_id`
- [`exposure_screening_specific_exposure_additional_details`](/docs/tables/exposure_screening_specific_exposure_additional_details) via `organization_id`
- [`imaging_exam_result`](/docs/tables/imaging_exam_result) via `distribution_list_organization`
- [`imaging_exam_result_imaging_service`](/docs/tables/imaging_exam_result_imaging_service) via `organization_id`
- [`imaging_exam_result_examination_request_details_requester`](/docs/tables/imaging_exam_result_examination_request_details_requester) via `organization_id`
- [`investigation_screening_specific_investigation_additiona_45e74e`](/docs/tables/investigation_screening_specific_investigation_additiona_45e74e) via `organization_id`
- [`laboratory_test_result_receiving_laboratory`](/docs/tables/laboratory_test_result_receiving_laboratory) via `organization_id`

## Indexes

- `organization_part_of_id_idx` on `part_of_id`

## Child tables

4 tables hang off `organization`, one row per repetition.

### `organization_other_identifier`

Child table — one row per repetition, deleted with its parent.

| Column | Type | Null | Description | From | Source |
|---|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — | — |
| `organization_id` | `uuid` → [`organization`](/docs/tables/organization) | no | — | — | — |
| `identifier_value` | `text` | no | — | — | — |
| `identifier_system` | `text` | yes | — | — | — |
| `identifier_use` | `text` | yes | — | — | — |
| `valid_from` | `timestamptz` | yes | — | — | — |
| `valid_until` | `timestamptz` | yes | — | — | — |

#### Unique

- `organization_id, identifier_system, identifier_value`

#### References

| Columns | Target | On delete |
|---|---|---|
| `organization_id` | [`organization`](/docs/tables/organization) | cascade |

### `organization_type`

Child table — one row per repetition, deleted with its parent.

| Column | Type | Null | Description | From | Source |
|---|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — | — |
| `organization_id` | `uuid` → [`organization`](/docs/tables/organization) | no | — | — | — |
| `type`<br />`type_code`<br />`type_system` | text, text, text<br />`text`, `text`, `text` | yes | Kind of organization | — | `Organization.type` |

#### Constraints

```sql
check ((type_code is null and type_system is null) or (type_code is not null and type_system is not null))
```

#### References

| Columns | Target | On delete |
|---|---|---|
| `organization_id` | [`organization`](/docs/tables/organization) | cascade |

#### Indexes

- `organization_type_organization_id_idx` on `organization_id`

### `organization_other_telecom`

Child table — one row per repetition, deleted with its parent.

| Column | Type | Null | Description | From | Source |
|---|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — | — |
| `organization_id` | `uuid` → [`organization`](/docs/tables/organization) | no | — | — | — |
| `system` | `text` | no | — | — | — |
| `value` | `text` | no | — | — | — |
| `use_code` | `text` | yes | — | — | — |
| `rank` | `integer` | yes | — | — | — |
| `valid_from` | `timestamptz` | yes | — | — | — |
| `valid_until` | `timestamptz` | yes | — | — | — |
| `comment` | `text` | yes | Comment | `openEHR-EHR-CLUSTER.electronic_communication.v1` | `/items[at0004]` |

#### References

| Columns | Target | On delete |
|---|---|---|
| `organization_id` | [`organization`](/docs/tables/organization) | cascade |

#### Indexes

- `organization_other_telecom_organization_id_idx` on `organization_id`

### `organization_other_address`

Child table — one row per repetition, deleted with its parent.

| Column | Type | Null | Description | From | Source |
|---|---|---|---|---|---|
| `id` | `uuid primary key` | no | Primary key. | — | — |
| `organization_id` | `uuid` → [`organization`](/docs/tables/organization) | no | — | — | — |
| `address_line` | `text` | yes | newline-delimited for multiple lines | — | — |
| `address_city` | `text` | yes | — | — | — |
| `address_district` | `text` | yes | — | — | — |
| `address_state` | `text` | yes | — | — | — |
| `address_postal_code` | `text` | yes | — | — | — |
| `address_country` | `text` | yes | — | — | — |
| `use_code` | `text` | yes | — | — | — |
| `type_code` | `text` | yes | — | — | — |
| `valid_from` | `timestamptz` | yes | — | — | — |
| `valid_until` | `timestamptz` | yes | — | — | — |
| `address_latitude_magnitude`<br />`address_latitude_units` | quantity<br />`numeric`, `text` | yes | Latitude | `openEHR-EHR-CLUSTER.address.v1` | `/items[at0007]` |
| `address_longitude_magnitude`<br />`address_longitude_units` | quantity<br />`numeric`, `text` | yes | Longitude | `openEHR-EHR-CLUSTER.address.v1` | `/items[at0008]` |
| `address_altitude_magnitude`<br />`address_altitude_units` | quantity<br />`numeric`, `text` | yes | Altitude | `openEHR-EHR-CLUSTER.address.v1` | `/items[at0009]` |
| `address_comment` | `text` | yes | Comment | `openEHR-EHR-CLUSTER.address.v1` | `/items[at0018]` |
| `address_map_url` | `text` | yes | Map URL | `openEHR-EHR-CLUSTER.address.v1` | `/items[at0019]` |
| `address_geolocation_code` | `text` | yes | Geolocation code | `openEHR-EHR-CLUSTER.address.v1` | `/items[at0021]` |

#### Constraints

```sql
check ((address_latitude_magnitude is null and address_latitude_units is null) or (address_latitude_magnitude is not null and address_latitude_units is not null))
check (address_latitude_magnitude is null or (address_latitude_units = 'deg' and address_latitude_magnitude between -90 and 90))
check ((address_longitude_magnitude is null and address_longitude_units is null) or (address_longitude_magnitude is not null and address_longitude_units is not null))
check (address_longitude_magnitude is null or (address_longitude_units = 'deg' and address_longitude_magnitude between -180 and 180))
check ((address_altitude_magnitude is null and address_altitude_units is null) or (address_altitude_magnitude is not null and address_altitude_units is not null))
```

#### References

| Columns | Target | On delete |
|---|---|---|
| `organization_id` | [`organization`](/docs/tables/organization) | cascade |

#### Indexes

- `organization_other_address_organization_id_idx` on `organization_id`

