documentation:cdm:care_site
Differences
This shows you the differences between two versions of the page.
| Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
| documentation:cdm:care_site [2017/03/13 00:58] – [Conventions] gowtham_rao | documentation: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:// | ||
| + | |||
| 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 |
| |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 | + | |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
