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.