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.