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.