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