The PATIENT_MAPPING table maps the i2b2 PATIENT_NUM to an encrypted number, PATIENT_IDE, from the source system (the 'e' in "ide" is for encrypted).
The PATIENT_IDE_SOURCE contains the name of the source system.
The PATIENT_IDE_STATUS gives the status of the patient number in the source system. For example, if it is Active, Inactive, Deleted, or Merged.

CODE_LOOKUP

 

 

PK

PATIENT_IDE

varchar(200)

PK

PATIENT_IDE_SOURCE

varchar(50)

 

PATIENT_NUM

int

 

PATIENT_IDE_STATUS

varchar(50)

 

PROJECT_ID

varchar(50)

 

UPDATE_DATE

datetime

 

DOWNLOAD_DATE

datetime

 

IMPORT_DATE

datetime

 

SOURCESYSTEM_CD

varchar(50)

 

UPLOAD_ID

int