AP_CLAIM_EOB_CD_RS

Description:

This table contains details regarding the resolution of claim codes for AP claims.

Primary Key

Column Name	Ordinal Position
CLAIM_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	CLAIM_ID	NUMERIC	No
	The unique identifier of the accounts payable claim 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	EOB_CODE_ID	NUMERIC	No
	The unique identifier of the code that has been resolved from the claim.
4	RESOLUTION_C_NAME	VARCHAR	No
	The category identifier for the resolution specified when resolving the code. 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
5	ENTRY_DATE	DATETIME	No
	The date the resolved code was added to the claim.
6	ENTRY_USER_ID	VARCHAR	No
	The unique identifier of the user who added the resolved code to the claim.
7	ENTRY_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
8	RESOLUTION_DATE	DATETIME	No
	The date (without the time) the code was resolved from the claim.
9	RESOLUTION_USER_ID	VARCHAR	No
	The unique identifier of the user who resolved the claim code.
10	RESOLUTION_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
11	RESOLUTION_COMMENT	VARCHAR	No
	The comment specified when the code was added to the claim.
12	RSLVD_EOB_CODE_ID	NUMERIC	No
	The unique identifier of the code that has been resolved from the claim. This column is equivalent to EOB_CODE_ID.
13	RSLVD_EOB_DATETIME	DATETIME (Local)	No
	The date and time when the code was added to the claim.
14	RESOLUTION_DATETIME	DATETIME (Local)	No
	The date and time when the code was resolved.