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 CODE_LOOKUP Table

CODE_LOOKUP Table

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
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20

 

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

=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".

=20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20

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

=20



= =20
=20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20 =20

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

=20



------=_Part_8629_1960181265.1711714865163--