INCOMING_CLM_ACTION_HX

Description:

History of actions taken on incoming claims.

Primary Key

Column Name	Ordinal Position
CLAIM_RECON_ID	1
CONTACT_DATE_REAL	2
LINE	3

Column Information

	Name	Type	Discontinued?
1	CLAIM_RECON_ID	VARCHAR	No
	The unique identifier (.1 item) for the claim status update record.
2	CONTACT_DATE_REAL	FLOAT	No
	A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact.
3	LINE	INTEGER	No
	The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
4	CONTACT_DATE	DATETIME	No
	The date of this contact in calendar format.
5	INCOMING_CLM_ACTION_C_NAME	VARCHAR	No
	This item contains the user actions taken on an incoming claim. May contain organization-specific values: No Category Entries: Accept Reject Complete Rejection Cancel Rejection Errors Added Errors Removed Error Resolved Error Resolution Undone Automatic Action Batch Apply All Batch Apply Clean Batch Scan
6	INCOMING_CLM_ACT_INST_UTC_DTTM	DATETIME (UTC)	No
	This item contains the instant an action was taken on an incoming claim.
7	INCOMING_CLM_ACTION_USER_ID	VARCHAR	No
	This item contains the ID of the user that took an action on an incoming claim.
8	INCOMING_CLM_ACTION_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
9	INCOMING_CLM_ACTION_COMMENT	VARCHAR	No
	This item contains a comment associated with the action taken on an incoming claim.
10	INCOMING_CLM_ACT_OTCM_C_NAME	NUMERIC	No
	The item contains the outcome of an action on the incoming claim. This only applies to Accept, Complete Rejection, Batch Apply All and Batch Apply Clean actions. May contain organization-specific values: No Category Entries: Accepted Rejected Has Errors Held