HSP_TX_RFNDEXP

Description:

This table contains information in the refund transaction that gets filed after its temporary transaction gets imported back from the AP system which processes it. This table contains information that is related to the AP system and the actions taken by it during the processing of the temporary transaction.

Primary Key

Column Name	Ordinal Position
TX_ID	1

Column Information

	Name	Type	Discontinued?
1	TX_ID	NUMERIC	No
	This column stores the unique identifier for the hospital billing transaction.
2	HSP_ACCOUNT_ID	NUMERIC	No
	This column stores the unique identifier for the hospital account with which a hospital billing transaction is associated.
3	RFND_AP_DATE	DATETIME	No
	Stores the date on which the A/P system processed the temporary transaction.
4	RFND_AP_STATUS_C_NAME	VARCHAR	No
	Stores the action taken by the A/P system when it processed the temporary transaction. May contain organization-specific values: No Category Entries: Approved Rejected
5	RFND_AMT	NUMERIC	No
	The amount of the refund associated with the refund transaction.
6	REFERENCE_NUM	VARCHAR	No
	The reference number of the refund associated with the transaction. This reference number is sent back by the AP system after it processed the temporary transaction.
7	TX_COMMENT	VARCHAR	No
	This column stores the import comment for the refund associated with the hospital billing transaction. This comment is sent back by the billing system after it processed the hospital temporary transaction.