|
Name |
Type |
Discontinued? |
|
| 1 |
ENROLL_ID |
NUMERIC |
No |
|
|
|
| The unique identifier for the enrollment record. |
|
|
| 2 |
LINE |
INTEGER |
No |
|
|
|
| The line number for the information associated with this record. Multiple pieces of information can be associated with this record. |
|
|
| 3 |
MPI_HX_ID |
VARCHAR |
No |
|
|
|
| This item is the count of historical IDs attached to the record. |
|
|
| 4 |
MPI_HX_INSTANT_DTTM |
DATETIME (Attached) |
No |
|
|
|
| This item is the instant at which the IAT audit event record was last changed for the related historical ID. |
|
|
| 5 |
MPI_HX_ID_TYPE_ID |
NUMERIC |
No |
|
|
|
| This item is the ID Type/IIT record of the related historical ID. |
|
|
| 6 |
MPI_HX_ID_TYPE_ID_ID_TYPE_NAME |
VARCHAR |
No |
|
|
|
|
| 7 |
MPI_HX_USER_ID |
VARCHAR |
No |
|
|
|
| This item is the user record ID that triggered the ID change of the related historical ID. |
|
|
| 8 |
MPI_HX_USER_ID_NAME |
VARCHAR |
No |
|
|
|
| The name of the user record. This name may be hidden. |
|
|
| 9 |
MPI_HX_AUDIT_TYPE_C_NAME |
VARCHAR |
No |
|
|
|
| The audit type of the related historical ID (new, modified, merge, unmerge). |
| May contain organization-specific values: No |
| Category Entries: |
| NEW |
| CHANGE |
| DELETED |
| MERGE |
| UNMERGE |
| EXPIRED |
|
|
| 10 |
MPI_HX_NEW_ID |
VARCHAR |
No |
|
|
|
| This item is the historical ID resulting from the ID change. |
|
|
| 11 |
MPI_HX_DOTONE |
VARCHAR |
No |
|
|
|
| The unique ID of the MPI-enabled research study record. |
|
|
| 12 |
MPI_HX_FROM_DATE |
DATETIME |
No |
|
|
|
| This item is the historical "Effective From" date for the related historical ID. |
|
|
| 13 |
MPI_HX_TO_DATE |
DATETIME |
No |
|
|
|
| This item is the historical "Effective To" date for the related historical ID. |
|
|
