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
- Patient
- Visit
- Observation
Lookup Tables
- Concept
- Provider
- Code
Mapping Tables
- Patient mapping
- 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.
