VALUE_EDIT_HISTORY

Description: |
All values associated with a claim are stored in the Claim External Value record. The VALUE_EDIT_HISTORY table holds the dates and times of all changes to the claim.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
RECORD_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | RECORD_ID | NUMERIC | No |
The unique identifier for the claim record.
2 | LINE | INTEGER | No |
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3 | USER_EDIT_INST_DTTM | DATETIME (UTC) | No |
The Coordinated Universal Time (UTC) date and time of the user's edit session.
4 | USER_EDIT_TYP_C_NAME | VARCHAR | No |
This item holds the type of information in the edit - initial values or user edits.
May contain organization-specific values: No
Category Entries:
Initial value
User edit
Reset edited values
5 | USER_EDIT_ID | VARCHAR | No |
This item holds the user ID who performed the edit.
6 | USER_EDIT_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
7 | USER_EDIT_CMT | VARCHAR | No |
This item holds a comment entered by the user describing the edit.