HSP_ACCT_RFND_TX

Description:

This table contains refund transaction information from the Hospital Accounts Receivable (HAR) master file.

Primary Key

Column Name	Ordinal Position
HSP_ACCOUNT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	HSP_ACCOUNT_ID	NUMERIC	No
	This column stores the unique identifier for the hospital account that has related transaction information.
2	LINE	INTEGER	No
	The line number in the results of a query. Each refund transaction will have its own line number.
3	RFND_TX_ID	NUMERIC	No
	This column stores the unique identifier for the refund transaction associated with the hospital account.
4	RFND_TX_UPDATE_DT	DATETIME	No
	The date of the last update of the refund transaction associated with the hospital account.
5	REFUND_TX_STATUS_C_NAME	VARCHAR	No
	The status of the refund transaction associated with the hospital account. i.e. 1-Posted 2-Exported 3-Comment Imported - Approved 4-Comment Imported - Rejected 5-Reversed May contain organization-specific values: No Category Entries: Posted Exported Comment Imported - Approved Comment Imported - Rejected Reversed
6	REFUND_AMOUNT_SENT	NUMERIC	No
	The amount of the refund associated with the hospital account.
7	REFUND_REF_NUMBER	VARCHAR	No
	The reference number of the refund associated with the hospital account.
8	REFUND_IP_COMMENT	VARCHAR	No
	Import comment for the refund associated with the hospital account.