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.