CARE_SITE table

THIS IS OUTDATED. All documentation is now on the github wiki. Please refer there or to the CDM working group for more information

The CARE_SITE table contains a list of uniquely identified institutional (physical or organizational) units where healthcare delivery is practiced (offices, wards, hospitals, clinics, etc.).

FieldRequiredTypeDescription
care_site_idYesintegerA unique identifier for each Care Site.
care_site_nameNovarchar(255)The verbatim description or name of the Care Site as in data source
place_of_service_concept_idNointegerA foreign key that refers to a Place of Service Concept ID in the Standardized Vocabularies.
location_idNointegerA foreign key to the geographic Location in the LOCATION table, where the detailed address information is stored.
care_site_source_valueNovarchar(50)The identifier for the Care Site in the source data, stored here for reference.
place_of_service_source_valueNovarchar(50)The source code for the Place of Service as it appears in the source data, stored here for reference.

Conventions