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