Table 1.
Partial columns of PATIENT_ID_MAP table, which holds all PIDs and P-PIDs that a participant might have per clinical systems or studies along with a UID
| UID | P-PID | Study name | PID-type | PID |
|---|---|---|---|---|
| DW01 | 1009 | Clinical System | MRN | M0123 |
| DW01 | 1015 | Clinical Trial 1 | PID | CTRA901 |
| DW01 | 5001 | Clinical Trial 2 | PID | CTRB501 |
| DW02 | 2019 | Clinical System | MRN | M0977 |
| DW02 | 8020 | Clinical Trial 1 | PID | CTRX881 |
| DW02 | 7079 | Clinical Trial 2 | PID | CTRY015 |
PID: participant identifiers, P-PID: pseudonyms of participant identifiers, UID: unique identifier, MRN: medical record number.