Care Site
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 | FK Table | Description |
---|---|---|---|---|
care_site_id | Yes | bigint | A unique identifier for each Care Site. | |
care_site_name | Yes | varchar(255) | The name of the location. | |
place_of_service_concept_id | No | bigint | CONCEPT | The type of location this is (e.g. hospital, ICU ward, etc). |
location_id | No | bigint | LOCATION | The address of the care site. |
care_site_source_value | No | varchar(50) | The care site name in the source EHR. | |
place_of_service_source_value | No | varchar(50) | The place of service in the source EHR. | |
last_updated_datetime | Yes | datetime | Initially this is the time the row was written to OMOP. If the row is subsequently updated, it then becomes the most recent update time. | |
deleted_datetime | No | datetime | NULL
initially. Set to the time when the row was marked for deletion. A value in this column sent to the central data source will result in this row being deleted from the combined dataset. |
Conventions
- Care Site is a description of a healthcare delivery location.
- There are hierarchical and business relationships between Care Sites. For example, beds can belong to bays, which can belong to wards, which can belong to clinics or departments, etc.
- The relationships between Care Sites are defined in the FACT_RELATIONSHIP table.