RECONCILE_EXT_ERROR_INFO

Description:

This table contains external errors received from a trading partner when doing encounter reporting.

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, etc.
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	SVC_LINE_NUMBER	VARCHAR	No
	The service line number that the external error is related to. If the error applies to the entire claim this is not set.
6	EXTERNAL_ERROR_CODE_C_NAME	VARCHAR	No
	The external error code category ID for the external error received from a trading partner. May contain organization-specific values: Yes
7	EXTERNAL_ERROR_DESCRIPTION	VARCHAR	No
	The trading partner's description of the error that was received back.
8	DUPLICATE_EPIC_ICN	VARCHAR	No
	Identifies a prior duplicate claim submission. This identifier is the Epic submitted control number from the original 837 submission which a trading partner has identified this new claim submission as a duplicate of.
9	DUPLICATE_EPIC_CLAIM_ID	NUMERIC	No
	Identifies a prior duplicate claim submission. This is the unique identifier (.1 item) for the claim in Epic this is a duplicate of.
10	DUPLICATE_PAYER_REF_NUM	VARCHAR	No
	Identifies a prior duplicate claim submission. This is the reference number in the trading partner's system assigned to the prior submission this claim is a duplicate of.
11	DUPLICATE_SVC_LINE_NUMBER	VARCHAR	No
	Identifies which service line of a prior duplicate submission this line was a duplicate of.
12	IS_LINE_REJ_YN	VARCHAR	No
	A flag that indicates whether or not this service line was rejected. May contain organization-specific values: No Category Entries: No Yes