|
Name |
Type |
Discontinued? |
|
| 1 |
RECORD_ID |
NUMERIC |
No |
|
|
|
| The unique identifier (.1 item) for the work request 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_ID_NUM |
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_ID_TYPE_ID |
NUMERIC |
No |
|
|
|
| The ID Type (IIT) ID of the identifier. |
|
|
| 6 |
MPI_HX_ID_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_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_FROM_DATE |
DATETIME |
No |
|
|
|
| The effective "from" date - if it is new or updated - for the identifier. |
|
|
| 13 |
MPI_HX_TO_DATE |
DATETIME |
No |
|
|
|
| The effective "to" date - if it is new or updated - for the identifier. |
|
|
