INV_CLM_ICN_LIST

Description:

This table holds information on all internal control numbers (ICN) associated with an invoice record in Resolute Professional Billing. This ICN list is compiled from multiple sources including manual overrides, claim status responses, and posted payments.

Primary Key

Column Name	Ordinal Position
INVOICE_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	INVOICE_ID	NUMERIC	No
	The unique identifier (.1 item) for the invoice 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	CLAIM_ICN	VARCHAR	No
	Contains an Internal Control Number (ICN) that was either received or overridden for this claim.
4	COVERAGE_ID	NUMERIC	No
	Contains the coverage ID associated with an Internal Control Number (ICN).
5	CROSSOVER_FLAG	NUMERIC	No
	Contains a numeric counter that identifies crossover Internal Control Numbers (ICNs).
6	INVOICE_NUM	VARCHAR	No
	Contains the invoice number that received an Internal Control Number (ICN).
7	ICN_SOURCE_C_NAME	VARCHAR	No
	Indicates the source workflow that saved an Internal Control Number (ICN) to this invoice. May contain organization-specific values: No Category Entries: Manual Override Payment Posting Claim Reconciliation
8	SOURCE_PMT_TX_ID	NUMERIC	No
	Indicates the payment (ETR) ID that added this Internal Control Number (ICN) to the invoice.
9	SOURCE_CLAIM_RECON_ID	VARCHAR	No
	Indicates the Claims Reconciliation Database (CRD) record ID that added this Internal Control Number (ICN) to the invoice.
10	ICN_UPDATE_UTC_DTTM	DATETIME (UTC)	No
	Displays the most recent time (in UTC) that this Internal Control Number (ICN) was updated.