HSP_BDC_RECV_TX

Description:

This table contains recovery payment information for Denial/Correspondence (BDC) records.

Primary Key

Column Name	Ordinal Position
BDC_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	BDC_ID	NUMERIC	No
	This column stores the unique identifier for the denial/correspondence 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	RECV_PAYMENT_TX_ID	NUMERIC	No
	This column stores the hospital payment transactions posted onto this denial record. Payment transactions posted onto a bucket with open denial record on it will be linked here from this denial record.
4	RECV_PAYMENT_TX_AMT	NUMERIC	No
	The dollar amount, corresponding to a payment transaction, posted onto this denial record.
5	PB_RECV_PMT_TX_ID	NUMERIC	No
	This column stores the professional billing payment transactions posted onto this denial record.