HSP_BKT_INV_NUM

Description:

This table contains hospital liability bucket invoice numbers information from the Hospital Liability Buckets (HLB) master file.

Primary Key

Column Name	Ordinal Position
BUCKET_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	BUCKET_ID	NUMERIC	No
	This column stores the unique identifier for the bucket record.
2	LINE	INTEGER	No
	This column stores the line number in the results of a query. Because multiple invoices can be associated with a liability bucket, each invoice will have a unique line number.
3	INVOICE_NUMBER	VARCHAR	No
	An invoice number associated with the liability bucket.
4	HSP_ACCOUNT_ID	NUMERIC	No
	This column stores the unique identifier for the hospital account to which the liability bucket is linked.