|
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_ID_TYPE_ID |
NUMERIC |
No |
|
|
|
ID type for guarantor IDs. |
|
|
4 |
MPI_ID_TYPE_ID_ID_TYPE_NAME |
VARCHAR |
No |
|
|
|
|
5 |
MPI_ID |
VARCHAR |
No |
|
|
|
|
6 |
MPI_FROM_DATE |
DATETIME |
No |
|
|
|
Date the ID is effective from for the guarantor. |
|
|
7 |
MPI_TO_DATE |
DATETIME |
No |
|
|
|
Date the ID is effective to for the guarantor. |
|
|
8 |
MPI_RET_CHK_PP_ID |
NUMERIC |
No |
|
|
|
Stores the code used to assign a National Provider ID. |
|
|
9 |
MPI_RET_CHK_PP_ID_LPP_NAME |
VARCHAR |
No |
|
|
|
The name of the extension. |
|
|
10 |
MPI_RET_CHK_RULE_ID |
VARCHAR |
No |
|
|
|
Stores the rule used to assign a National Provider ID |
|
|
11 |
MPI_RET_CHK_RULE_ID_RULE_NAME |
VARCHAR |
No |
|
|
|
|