HSP_BFH_HOSP_TXS

Description:

Table contains Hospital Billing payments that have been matched to a billing activity history record.

Primary Key

Column Name	Ordinal Position
BFH_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	BFH_ID	NUMERIC	No
	This column stores the unique identifier for the billing activity history 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	HB_TX_ID	NUMERIC	No
	This column stores the unique identifier for the payment transaction that this activity helped to generate.
4	HB_MATCHED_AMOUNT	NUMERIC	No
	Hospital Billing self-pay payment amount credited to this activity.
5	HB_MATCHED_INS_AMOUNT	NUMERIC	No
	Hospital Billing insurance payment amount credited to this activity.
6	HB_MATCHED_DATE	DATETIME	No
	The date on which the payment was matched to the billing activity.