General Information
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 |