AP_CLAIM_PX_BND_EPSD_HX

Description:

This table holds the history of the bundled episodes that have been linked to AP claim service lines.

Primary Key

Column Name	Ordinal Position
TX_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	TX_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	BND_EPSD_INST_UTC_DTTM	DATETIME (UTC)	No
	This column indicates when the related episode was linked or unlinked from this service line.
4	BND_EPSD_EPISODE_ID	NUMERIC	No
	This column defines which bundled episode is being linked or unlinked on this line.
5	BND_EPSD_ACTION_C_NAME	VARCHAR	No
	This column defines whether this history line is linking or unlinking the related episode. The categories can be referenced via Clarity table ZC_BND_EPSD_ACTION. May contain organization-specific values: No Category Entries: Link Unlink
6	BND_EPSD_SRC_C_NAME	VARCHAR	No
	This column indicates how the link or unlink of the related episode was performed, either by a user, by the system, or by configured automation. The categories can be referenced via Clarity table ZC_BND_EPSD_SRC. 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
7	BND_EPSD_USER_ID	VARCHAR	No
	This column indicates the user who linked or unlinked the episode.
8	BND_EPSD_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.