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