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 |
