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 a 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