This shows you the differences between two versions of the page.
Next revision | Previous revision Next revision Both sides next revision | ||
documentation:cdm:care_site [2014/12/05 21:02] cgreich created |
documentation:cdm:care_site [2017/03/13 00:51] gowtham_rao [CARE_SITE table] |
||
---|---|---|---|
Line 1: | Line 1: | ||
- | ===== CARE_SITE ===== | + | ===== CARE_SITE table ===== |
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 description or name of the Care Site| | ||
|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.| |