|
Name |
Type |
Discontinued? |
|
1 |
ANSWER_ID |
VARCHAR |
No |
|
|
|
The unique identifier (.1 item) for the answer 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_IDENTITY_ID |
VARCHAR |
No |
|
|
|
The historical identifier - if any - that resulted from the audit event. |
|
|
4 |
MPI_HX_INSTANT_DTTM |
DATETIME (Attached) |
No |
|
|
|
The instant at which the audit event was logged for the identifier. |
|
|
5 |
MPI_HX_IDENTITY_TYPE_ID |
NUMERIC |
No |
|
|
|
The ID Type (IIT) ID of the identifier. |
|
|
6 |
MPI_HX_IDENTITY_TYPE_ID_ID_TYPE_NAME |
VARCHAR |
No |
|
|
|
|
7 |
MPI_HX_USER_ID |
VARCHAR |
No |
|
|
|
The User (EMP) ID that triggered the audit event for the identifier. |
|
|
8 |
MPI_HX_USER_ID_NAME |
VARCHAR |
No |
|
|
|
The name of the user record. This name may be hidden. |
|
|
9 |
MPI_HX_AUDIT_CHG_TYPE_C_NAME |
VARCHAR |
No |
|
|
|
The audit event type for the update made to the identifier. |
May contain organization-specific values: No |
Category Entries: |
NEW |
CHANGE |
DELETED |
MERGE |
UNMERGE |
EXPIRED |
|
|
10 |
MPI_HX_NEW_ID |
VARCHAR |
No |
|
|
|
The new identifier - if any - that resulted from the audit event. |
|
|
11 |
MPI_HX_DOTONE |
VARCHAR |
No |
|
|
|
The internal Chronicles ID of the record for which this audit event was logged. |
|
|
12 |
MPI_HX_ID_EFF_FROM_DATE |
DATETIME |
No |
|
|
|
The effective "from" date - if it is new or updated - for the identifier. |
|
|
13 |
MPI_HX_ID_EFF_TO_DATE |
DATETIME |
No |
|
|
|
The effective "to" date - if it is new or updated - for the identifier. |
|
|