HSP_PRE_AR_BND_EPSD_HX

Description:

This table contains bundled episode history for Hospital Billing temporary transactions. This table is limited to charge temporary transactions that have not yet been posted to the account.

Primary Key

Column Name	Ordinal Position
HTT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	HTT_ID	NUMERIC	No
	The unique identifier for the transaction 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	HTT_LINE	INTEGER	No
	Holds the line number in the charge data related group that this line corresponds to.
4	ACTION_DTTM	DATETIME (UTC)	No
	The date and time that this transaction was linked/unlinked to the bundled episode.
5	EPISODE_ID	NUMERIC	No
	Holds bundled episode records linked to this transaction.
6	ACTION_C_NAME	VARCHAR	No
	The current state of this transaction and episode, whether it is linked or unlinked. May contain organization-specific values: No Category Entries: Link Unlink
7	SOURCE_C_NAME	VARCHAR	No
	The source of the link or unlink of this bundled episode to this transaction. May contain organization-specific values: No Category Entries: User Visit Association Auto Link Auto Creation Auto Link Via Transform Auto Link Via Association Auto Removal
8	USER_ID	VARCHAR	No
	The user who performed the link or unlink of this episode to the transaction line.
9	USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.