Server (Cells) Design
Space shortcuts
Space Tools
Skip to end of metadata
Go to start of metadata

The Data Repository Cell (also called the Clinical Research Chart or CRC), is designed to hold data from clinical trials, medical record systems and laboratory systems, along with many other types of clinical data from heterogeneous sources. The CRC stores this data in the following tables:
Data Tables

  1. Patient
  2. Visit
  3. Observation

Lookup Tables

  1. Concept
  2. Provider
  3. Code

Mapping Tables

  1. Patient mapping
  2. Visit mapping

The three data tables, along with two of the lookup tables (concept and provider) make up the star schema of the warehouse. The code table is strictly a lookup table and is not part of the star schema. All of the tables that are part of the CRC are described in this document.

  • No labels