organization

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

ModelLegRole
us-core-organizationFHIRdefines this table
openEHR-EHR-CLUSTER.address.v1openEHRmerged in — Address
openEHR-EHR-CLUSTER.electronic_communication.v1openEHRmerged in — Electronic communication
openEHR-EHR-CLUSTER.organisation.v1openEHRmerged 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

ColumnTypeNullDescriptionFromSource
iduuid primary keynoOrganization.id——
created_attimestamptznoRow creation timestamp.——
updated_attimestamptznoRow update timestamp; maintained by the application.——
created_bytextnoActor who created the row.——
updated_bytextnoActor who last updated the row.——
npitextyesNational Provider Identifier (NPI)—Organization.identifier
cliatextyesClinical Laboratory Improvement Amendments (CLIA) Number for laboratories—Organization.identifier
naictextyesNAIC Code—Organization.identifier
identifier_value
identifier_system
text, text
text, text
yesIdentifies this organization across multiple systems—Organization.identifier
activebooleanyesWhether the organization's record is still in active use—Organization.active
nametextyesName used for the organization—Organization.name
phone_number
phone_use_code
email
email_use_code
text, text, text, text
text, text, text, text
yesA contact detail for the organization—Organization.telecom
address_line
address_city
address_district
address_state
address_postal_code
address_country
address_use_code
address_type_code
text, text, text, text, text, text, text, text
text, text, text, text, text, text, text, text
yesAn address for the organization—Organization.address
part_of_iduuidyesThe organization of which this organization forms a part—Organization.partOf
address_latitude_magnitude
address_latitude_units
quantity
numeric, text
yesLatitudeopenEHR-EHR-CLUSTER.address.v1/items[at0007]
address_longitude_magnitude
address_longitude_units
quantity
numeric, text
yesLongitudeopenEHR-EHR-CLUSTER.address.v1/items[at0008]
address_altitude_magnitude
address_altitude_units
quantity
numeric, text
yesAltitudeopenEHR-EHR-CLUSTER.address.v1/items[at0009]
address_commenttextyesCommentopenEHR-EHR-CLUSTER.address.v1/items[at0018]
address_map_urltextyesMap URLopenEHR-EHR-CLUSTER.address.v1/items[at0019]
address_geolocation_codetextyesGeolocation codeopenEHR-EHR-CLUSTER.address.v1/items[at0021]
phone_comment
email_comment
text, text
text, text
yesCommentopenEHR-EHR-CLUSTER.electronic_communication.v1/items[at0004]
commenttextyesCommentopenEHR-EHR-CLUSTER.organisation.v1/items[at0019]

Constraints

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

References

ColumnsTargetOn delete
part_of_idorganizationno action

Referenced by

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

Indexes

Child tables

4 tables hang off organization, one row per repetition.

organization_other_identifier

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

ColumnTypeNullDescriptionFromSource
iduuid primary keynoPrimary key.——
organization_iduuid → organizationno———
identifier_valuetextno———
identifier_systemtextyes———
identifier_usetextyes———
valid_fromtimestamptzyes———
valid_untiltimestamptzyes———

Unique

References

ColumnsTargetOn delete
organization_idorganizationcascade

organization_type

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

ColumnTypeNullDescriptionFromSource
iduuid primary keynoPrimary key.——
organization_iduuid → organizationno———
type
type_code
type_system
text, text, text
text, text, text
yesKind of organization—Organization.type

Constraints

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

References

ColumnsTargetOn delete
organization_idorganizationcascade

Indexes

organization_other_telecom

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

ColumnTypeNullDescriptionFromSource
iduuid primary keynoPrimary key.——
organization_iduuid → organizationno———
systemtextno———
valuetextno———
use_codetextyes———
rankintegeryes———
valid_fromtimestamptzyes———
valid_untiltimestamptzyes———
commenttextyesCommentopenEHR-EHR-CLUSTER.electronic_communication.v1/items[at0004]

References

ColumnsTargetOn delete
organization_idorganizationcascade

Indexes

organization_other_address

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

ColumnTypeNullDescriptionFromSource
iduuid primary keynoPrimary key.——
organization_iduuid → organizationno———
address_linetextyesnewline-delimited for multiple lines——
address_citytextyes———
address_districttextyes———
address_statetextyes———
address_postal_codetextyes———
address_countrytextyes———
use_codetextyes———
type_codetextyes———
valid_fromtimestamptzyes———
valid_untiltimestamptzyes———
address_latitude_magnitude
address_latitude_units
quantity
numeric, text
yesLatitudeopenEHR-EHR-CLUSTER.address.v1/items[at0007]
address_longitude_magnitude
address_longitude_units
quantity
numeric, text
yesLongitudeopenEHR-EHR-CLUSTER.address.v1/items[at0008]
address_altitude_magnitude
address_altitude_units
quantity
numeric, text
yesAltitudeopenEHR-EHR-CLUSTER.address.v1/items[at0009]
address_commenttextyesCommentopenEHR-EHR-CLUSTER.address.v1/items[at0018]
address_map_urltextyesMap URLopenEHR-EHR-CLUSTER.address.v1/items[at0019]
address_geolocation_codetextyesGeolocation codeopenEHR-EHR-CLUSTER.address.v1/items[at0021]

Constraints

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

ColumnsTargetOn delete
organization_idorganizationcascade

Indexes