|
Name |
Type |
Discontinued? |
|
1 |
ACCT_ID |
NUMERIC |
No |
|
|
|
The unique identifier for the account record. |
|
|
2 |
LINE |
INTEGER |
No |
|
|
|
The line number for the information associated with this row. Multiple pieces of information can be associated with this row. |
|
|
3 |
MPI_HX_ID |
VARCHAR |
No |
|
|
|
The historical IDs for the guarantor. |
|
|
4 |
MPI_HX_ID_TYPE_ID |
NUMERIC |
No |
|
|
|
The historic type of ID for the guarantor. |
|
|
5 |
MPI_HX_ID_TYPE_ID_ID_TYPE_NAME |
VARCHAR |
No |
|
|
|
|
6 |
MPI_HX_USER_ID |
VARCHAR |
No |
|
|
|
The historic user who updated the ID for the guarantor. |
|
|
7 |
MPI_HX_USER_ID_NAME |
VARCHAR |
No |
|
|
|
The name of the user record. This name may be hidden. |
|
|
8 |
MPI_HX_AUDIT_TYPE_C_NAME |
VARCHAR |
No |
|
|
|
The historic type of change for the guarantor ID. |
May contain organization-specific values: No |
Category Entries: |
NEW |
CHANGE |
DELETED |
MERGE |
UNMERGE |
EXPIRED |
|
|
9 |
MPI_HX_NEW_ID |
VARCHAR |
No |
|
|
|
The historical ID that was added for the guarantor. |
|
|
10 |
MPI_HX_DOTONE |
VARCHAR |
No |
|
|
|
The guarantor record ID where the ID change was made. |
|
|
11 |
MPI_HX_FROM_DATE |
DATETIME |
No |
|
|
|
The historical effective date for the guarantor ID. |
|
|
12 |
MPI_HX_TO_DATE |
DATETIME |
No |
|
|
|
The historical end date for the guarantor ID. |
|
|