BND_EPSD_INFO_TRANSFORM

Description:

This table contains information on how the episode was transformed from one bundled episode term to a different term.

Primary Key

Column Name	Ordinal Position
EPISODE_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	EPISODE_ID	NUMERIC	No
	This column stores the unique identifier for the bundled episode 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	ORIG_BPC_CSN	NUMERIC	No
	This column stores the original bundled episode terms' contact serial number before the transform occurred.
4	TARGET_BPC_CSN	NUMERIC	No
	Holds the new bundled episode term's contact serial number for the episode after the transform occurred.
5	TRANSFORM_TRIGGER_DATE	DATETIME	No
	Holds the date on the episode on which the bundled episode transform was triggered. Transforms on episodes are always based on the earliest non-anchor event that qualifies for the transform criteria.