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

The CODE_LOOKUP table contains coded values for different columns in the CRC. For example, in the VISIT_DIMENSION table there is the LOCATION_CD column that may have different values for different hospital locations that would be stored in the CODE_LOOKUP table. The first few records of the table might look like this:

 

TABLE_CD

COLUMN_CD

CODE_CD

NAME_CHAR

1

VISIT_DIMENSION

LOCATION_CD

@

Not recorded

2

VISIT_DIMENSION

LOCATION_CD

BWH

Brigham and Womens Hospital

3

VISIT_DIMENSION

LOCATION_CD

FH

Faulkner Hospital

4

VISIT_DIMENSION

LOCATION_CD

MGH

Massachusetts General Hospital

5

VISIT_DIMENSION

LOCATION_CD

NWH

Newton Wellesley Hospital

6

VISIT_DIMENSION

LOCATION_CD

SRH

Spaulding Rehabilitation Hospital



Starting from version 1.6.00, the description of custom columns is also stored in this table. To store the column descriptor, the value of CODE_CD column should be "CRC_CUSTOM_DESCRIPTOR".

TABLE_CD

COLUMN_CD

CODE_CD

NAME_CHAR

PATIENT_DIMENSION

INCOME_CD

CRC_COLUMN_DESCRIPTOR

Income

VISIT_DIMENSION

ACTIVE_STATUS_CD

CRC_COLUMN_DESCRIPTOR

Date Accuracy



CODE_LOOKUP

 

 

PK

TABLE_CD

varchar(100)

PK

COLUMN_CD

varchar(100)

PK

CODE_CD

varchar(50)

 

NAME_CHAR

varchar(650)

 

LOOKUP_BLOB

text

 

UPDATE_DATE

datetime

 

DOWNLOAD_DATE

datetime

 

IMPORT_DATE

datetime

 

SOURCESYSTEM_CD

varchar(50)

 

UPLOAD_ID

int



  • No labels