Message-ID: <1490194586.8630.1711714865166.JavaMail.confluence@ip-172-30-4-17.ec2.internal> Subject: Exported From Confluence MIME-Version: 1.0 Content-Type: multipart/related; boundary="----=_Part_8629_1960181265.1711714865163" ------=_Part_8629_1960181265.1711714865163 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable Content-Location: file:///C:/exported.html
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 val=
ues for different hospital locations that would be stored in the CODE_L=
OOKUP table. The first few records of the table might look like this: =
| =20
TABLE_CD | =20
COLUMN_CD | =20
CODE_CD | =20
NAME_CHAR | =20
1 | =20
VISIT_DIMENSION | =20
LOCATION_CD | =20
@ | =20
Not recorded | =20
2 | =20
VISIT_DIMENSION | =20
LOCATION_CD | =20
BWH | =20
Brigham and Womens Hospital | =20
3 | =20
VISIT_DIMENSION | =20
LOCATION_CD | =20
FH | =20
Faulkner Hospital | =20
4 | =20
VISIT_DIMENSION | =20
LOCATION_CD | =20
MGH | =20
Massachusetts General Hospital | =20
5 | =20
VISIT_DIMENSION | =20
LOCATION_CD | =20
NWH | =20
Newton Wellesley Hospital | =20
6 | =20
VISIT_DIMENSION | =20
LOCATION_CD | =20
SRH | =20
Spaulding Rehabilitation Hospital | =20
Star=
ting 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 | =20
COLUMN_CD | =20
CODE_CD | =20
NAME_CHAR | =20
PATIENT_DIMENSION | =20
INCOME_CD | =20
CRC_COLUMN_DESCRIPTOR | =20
Income | =20
VISIT_DIMENSION | =20
ACTIVE_STATUS_CD | =20
CRC_COLUMN_DESCRIPTOR | =20
Date Accuracy | =20
CODE_LOOKUP | =20
| =20
| =20
PK | =20
TABLE_CD | =20
varchar(100) | =20
PK | =20
COLUMN_CD | =20
varchar(100) | =20
PK | =20
CODE_CD | =20
varchar(50) | =20
| =20
NAME_CHAR | =20
varchar(650) | =20
| =20
LOOKUP_BLOB | =20
text | =20
| =20
UPDATE_DATE | =20
datetime | =20
| =20
DOWNLOAD_DATE | =20
datetime | =20
| =20
IMPORT_DATE | =20
datetime | =20
| =20
SOURCESYSTEM_CD | =20
varchar(50) | =20
| =20
UPLOAD_ID | =20
int | =20