CLAIM_INVOICE
Description:
Stores information about AP claim invoices.

Primary Key
Column Name Ordinal Position
CLAIM_INVC_ID 1

Column Information
Name Type Discontinued?
1 CLAIM_INVC_ID VARCHAR No
The unique identifier (.1 item) for the invoice record.
2 CREATION_DATE DATETIME No
Stores the date the invoice was created.
3 DUE_DATE DATETIME No
Stores the date when the invoice is due.
4 INV_STAT_C_NAME VARCHAR No
Stores the category identifier of the invoice's status.
May contain organization-specific values: No
Category Entries:
Created
Printed
Payment Received
Closed
Cancelled
Approved
Rejected
Released
Disputed
Not Printed - Paperless
5 CLAIM_ACCT_ID VARCHAR No
Stores the unique identifier of the AP claim billing account for this invoice.
6 INVOICE_NUMBER VARCHAR No
Stores the invoice number.
7 INVOICE_TYPE_C_NAME VARCHAR No
The category identifier of the invoice type.
May contain organization-specific values: No
Category Entries:
Premium Billing
AP Claim
Capitation Contract
8 RESP_CLASS_TYPE_C_NAME VARCHAR No
The category identifier of the responsibility class for this invoice.
May contain organization-specific values: No
Category Entries:
Insurance
Health Reimbursement Account
9 BATCH_RUN_CSN_ID NUMERIC No
The contact serial number of the batch run that creates this invoice.