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.