HSB_MPI_ID_HX

Description: |
This table includes Identity ID history information for the Episode (HSB) master file.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
SUMMARY_BLOCK_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | SUMMARY_BLOCK_ID | NUMERIC | No |
The unique ID assigned to the episode record.
2 | LINE | INTEGER | No |
The line number for this related response group.
3 | MPI_HX_ID | VARCHAR | No |
The historical MPI ID of the corresponding historical MPI ID type for the record.
4 | MPI_HX_INSTANT | DATETIME (Attached) | No |
The date and time the MPI ID was placed on the record's historical ID table.
5 | MPI_HX_ID_TYPE | NUMERIC | No |
The MPI ID type of the historical MPI ID linked to the record.
6 | MPI_HX_ID_TYPE_ID_TYPE_NAME | VARCHAR | No |
The name of the ID Type.
7 | MPI_HX_USER_ID | VARCHAR | No |
The user that performed the audit action on the historical MPI 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 action the user performed on the historical MPI ID.
May contain organization-specific values: No
Category Entries:
NEW
CHANGE
DELETED
MERGE
UNMERGE
EXPIRED
10 | MPI_HX_NEW_ID | VARCHAR | No |
The new MPI ID that was added to the record.
11 | MPI_HX_DOTONE | VARCHAR | No |
The internal ID of the record when the user performed the action.
12 | MPI_HX_FROM_DATE | DATETIME | No |
The effective from date of the historical MPI ID on the record.
13 | MPI_HX_TO_DATE | DATETIME | No |
The effective to date of the historical MPI ID on the record.