The OBSERVATION_FACT table has only required columns. The PATIENT_DIMENSION and VISIT_DIMENSION tables have both required and optional columns. All the tables have the following five technically-oriented or administrative columns.
Column Name |
Data Type |
Nullable |
Definition |
UPDATE_DATE |
datetime |
Yes |
Date the row was update by the source system |
DOWNLOAD_DATE |
datetime |
Yes |
Date the data was downloaded from the source system |
IMPORT_DATE |
datetime |
Yes |
Date the data was imported into the CRC |
SOURCESYSTEM_CD |
datetime |
Yes |
A coded value for the data source system |
UPLOAD_ID |
datetime |
Yes |
A numeric id given to the upload |
