User Tools

Site Tools


documentation:cdm:care_site

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
documentation:cdm:care_site [2017/03/13 00:58] – [Conventions] gowtham_raodocumentation:cdm:care_site [2017/09/25 15:08] (current) – clairblacketer
Line 1: Line 1:
 ===== CARE_SITE table ===== ===== CARE_SITE table =====
 +**THIS IS OUTDATED. All documentation is now on the [[https://github.com/OHDSI/CommonDataModel/wiki|github wiki]]. Please refer there or to the [[projects:workgroups:cdm-wg|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.). 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.).
  
 ^Field^Required^Type^Description^ ^Field^Required^Type^Description^
 |care_site_id|Yes|integer|A unique identifier for each Care Site.| |care_site_id|Yes|integer|A unique identifier for each Care Site.|
-|care_site_name|No|varchar(255)|The description or name of the Care Site|+|care_site_name|No|varchar(255)|The verbatim description or name of the Care Site as in data source|
 |place_of_service_concept_id|No|integer|A foreign key that refers to a Place of Service Concept ID in the Standardized Vocabularies.| |place_of_service_concept_id|No|integer|A foreign key that refers to a Place of Service Concept ID in the Standardized Vocabularies.|
-|location_id|No|integer|A foreign key to the geographic Location of the Care Site in the LOCATION table, where the detailed address information is stored.|+|location_id|No|integer|A foreign key to the geographic Location in the LOCATION table, where the detailed address information is stored.|
 |care_site_source_value|No|varchar(50)|The identifier for the Care Site in the source data, stored here for reference.| |care_site_source_value|No|varchar(50)|The identifier for the Care Site in the source data, stored here for reference.|
 |place_of_service_source_value|No|varchar(50)|The source code for the Place of Service as it appears in the source data, stored here for reference.| |place_of_service_source_value|No|varchar(50)|The source code for the Place of Service as it appears in the source data, stored here for reference.|
documentation/cdm/care_site.1489366704.txt.gz · Last modified: by gowtham_rao

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki