organization

A formally or informally recognized grouping of people or organizations formed for the purpose of achieving some form of collective action. Includes companies, institutions, corporations, departments, community groups, healthcare practice groups, payer/insurer, etc. See the HL7 FHIR R4 spec for full details.

Previous version: organization

Tables in this resource:

• organization – Organization record (this page)
• organization_address – Addresses per organization
• organization_telecom – Contact details per organization
• organization_extension
• organization_extension_vcc_coding
• organization_references – Normalized references; see Reference Tables (partOf)

Primary Keys:

• organization_id

_{† Metriport Platform added}

Column	Data Type	Description
organization_id	varchar	Unique identifier for the organization
name	varchar	Name of the organization
address†	varchar	First and second address lines concatenated (from first address)
city†	varchar	City (from first address)
state†	varchar	State or province (from first address)
country†	varchar	Country (from first address)
zip_code†	varchar	ZIP or postal code (from first address)
phone†	varchar	First phone from telecom
email†	varchar	First email from telecom
meta_source	varchar	Source document filename from FHIR meta.source
data_source_ext†	varchar	Integration source of the data, derived from FHIR extension

Related Tables:

Child:

• location
• organization_address
• organization_extension
• organization_telecom

Version diff

Renamed

• address_line → address
• data_source → meta_source