This table contains information about individual stages within Outreach campaigns. A stage is a step or a phase in a campaign. Every campaign has an initial stage (also called the root stage) that defines the actions that begin the campaign, for example sending an e-mail to customers or displaying content on the Web site. A campaign can also have one or more child stages, which are triggered by customer responses to earlier campaign actions.
Column Name | Type | Length | Null Allowed | Description |
---|---|---|---|---|
ID | integer | No | Identifier; primary key. | |
NSTAGE_ID | varchar | 40 | No | Natural key of the campaign stage. |
CAMPAIGN_ID | integer | No | Campaign in which this stage is included. | |
PARENT_EVENT_ID | integer | Yes | A non-root stage can have a parent event. | |
DISPLAY_NAME | varchar | 254 | Yes | Stage display name. |
DESCRIPTION | varchar | 4000 | Yes | Stage description. |
RECORD_LAST_UPDATE | timestamp | Yes | Date the record was last updated. | |
RECORD_START_DATE | timestamp | Yes | Date when the information in this warehouse record became effective | |
RECORD_END_DATE | timestamp | Yes | Date when the information in this warehouse record is no longer effective. | |
MOST_RECENT | one-digit | No | Indicates that this record is the most recent. 0 = No 1 = Yes | |
DELETED | one-digit | No | Indicates that this record has been deleted. 0= No 1 = Yes |