|
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. |
|
|
