The ENCOUNTER_MAPPING table maps the i2b2 ENCOUNTER_NUM to an encrypted number, ENCOUNTER_IDE, from the source system (the 'e' in "ide" is for encrypted).
The ENCOUNTER_IDE_SOURCE contains the name of the source system.
The ENCOUNTER_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 |
ENCOUNTER_IDE |
varchar(200) |
PK |
ENCOUNTER_IDE_SOURCE |
varchar(50) |
|
ENCOUNTER_NUM |
int |
|
PATIENT_IDE |
varchar(200) |
|
PATIENT_IDE_SOURCE |
varchar(50) |
|
ENCOUNTER_IDE_STATUS |
varchar(50) |
|
PROJECT_ID |
varchar(50) |
|
UPLOAD_DATE |
datetime |
|
DOWNLOAD_DATE |
datetime |
|
IMPORT_DATE |
datetime |
|
SOURCESYSTEM_CD |
varchar(50) |
|
UPLOAD_ID |
int |