Server (Cells) Design
Space shortcuts
Space Tools
Skip to end of metadata
Go to start of metadata

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



  • No labels

1 Comment

  1. The information on this schema is incorrect as of v1.7.12a. 

    The primary keys for encounter_mapping are ENCOUNTER_IDE, ENCOUNTER_IDE_SOURCE, PROJECT_ID, PATIENT_IDE, PATIENT_IDE_SOURCE.

    Reference: https://github.com/i2b2/i2b2-data/blob/v1.7.12a.0001/edu.harvard.i2b2.data/Release_1-7/NewInstall/Crcdata/scripts/crc_create_datamart_oracle.sql