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

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
The date is obtained from 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



  • No labels