INVOICE

Description: |
This table includes the basic data for the invoice (INV) record. It contains one row for each used INV record (excluding unused pre-allocated invoices). Note that a row in this table can correspond to multiple claims sent.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
INVOICE_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | INVOICE_ID | NUMERIC | No |
The Invoice ID.
2 | PAT_ID | VARCHAR | No |
The patient ID associated with this invoice.
3 | ACCOUNT_ID | NUMERIC | No |
The account ID that is associated with this invoice.
4 | SERV_AREA_ID_LOC_NAME | VARCHAR | No |
The name of the revenue location.
5 | LOC_ID_LOC_NAME | VARCHAR | No |
The name of the revenue location.
6 | POS_ID_LOC_NAME | VARCHAR | No |
The name of the revenue location.
7 | DEPARTMENT_ID_EXTERNAL_NAME | VARCHAR | No |
The external name of the department record. This is often used in patient correspondence such as reminder letters.
8 | UB_COVERED_DAYS | INTEGER | No |
The number of covered days for a uniform billing claim.
9 | UB_NON_COVERED_DAYS | INTEGER | No |
The number of non-covered days for a uniform billing claim.
10 | UB_COINSURANCE_DAYS | INTEGER | No |
The number of coinsurance days for the uniform billing claim.
11 | UB_PRINCIPA_DIAG_ID_DX_NAME | VARCHAR | No |
The name of the diagnosis.
12 | UB_TYPE_OF_BILL_STR | VARCHAR | No |
Stores the type of bill that was sent out on the claim.
13 | PROV_ID_PROV_NAME | VARCHAR | No |
The name of the service provider. This item may be hidden in a public view of the CLARITY_SER table.
14 | ACCT_SERIAL_NUM | INTEGER | No |
Stores the account serial number associated with the invoice.
15 | PAT_SERIAL_NUM | INTEGER | No |
Stores the patient serial number associated with the invoice.
16 | RQG_ID | NUMERIC | No |
Stores the requisition grouper ID associated with the invoice when there is no patient record.
17 | TAX_ID | VARCHAR | No |
Stores the tax ID associated with the invoice.
18 | TAX_ID_TYPE | VARCHAR | No |
Stores the type of tax ID associated with the invoice.
19 | TREATMENT_PLAN_ID | VARCHAR | No |
Stores the treatment plan ID associated with the invoice.
20 | INSURANCE_AMT | NUMERIC | No |
Stores the insurance amount for the invoice.
21 | SELF_PAY_AMT | NUMERIC | No |
Stores the initial self-pay amount for the invoice.
22 | INIT_INSURANCE_BAL | NUMERIC | No |
Stores the initial insurance amount for the invoice.
23 | INIT_SELF_PAY_BAL | NUMERIC | No |
Stores the initial self-pay amount for the invoice.
24 | BILL_AREA_ID | NUMERIC | No |
Stores the bill area associated with the invoice.
25 | BILL_AREA_ID_BILL_AREA_NAME | VARCHAR | No |
The record name of this bill area, financial subdivision, or financial division.
26 | PB_HOSP_ACT_ID | NUMERIC | No |
The Professional Billing Hospital Account ID.
27 | RECORD_STATUS_C_NAME | VARCHAR | No |
This column shows the status of the invoice record.
May contain organization-specific values: No
Category Entries:
Active
Inactive
Deleted
Inactive and Deleted
Hidden
Inactive and Hidden
Deleted and Hidden
Inactive Deleted and Hidden