AP_CLM_PX_PROCESS_CODE_HX

Description:

History of process/explanation of benefits (EOB) code changes to the claim's service line transaction.

Primary Key

Column Name	Ordinal Position
TX_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	TX_ID	NUMERIC	No
	The unique identifier for the transaction 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	PROCESS_CODE_ID	NUMERIC	No
	The ID of the service level process code that is being added or resolved. This is also sometimes called the claim code or EOB code. This networks to the NPD master file.
4	ADDED_UTC_DTTM	DATETIME (UTC)	No
	The date and time the code was added in the UTC time zone.
5	ADDED_BY_USER_ID	VARCHAR	No
	User who added the service level code
6	ADDED_BY_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
7	ADDED_COMMENT	VARCHAR	No
	Comment on why the code was added
8	RESOLUTION_C_NAME	VARCHAR	No
	The reason the code was resolved. May contain organization-specific values: Yes Category Entries: Paid by Other Insurance Referral Found No Referral Change Approved Change Denied Superfluous Claim - Not Processed Previous Claim Erroneous - Use Current Claim Cleared Third-party Pricing Completed
9	RESOLUTION_UTC_DTTM	DATETIME (UTC)	No
	The date and time the code was resolved in the UTC time zone.
10	RESOLUTION_BY_USER_ID	VARCHAR	No
	User who resolved the code.
11	RESOLUTION_BY_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
12	ADDED_DTTM	DATETIME (Local)	No
	The date and time the code was added in the local time zone.
13	RESOLUTION_DTTM	DATETIME (Local)	No
	The date and time the code was resolved in the local time's time zone.