View Source

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