This table traces a user’s path through an Outreach campaign.

Column Name

Type

Length

Null Allowed

Description

ID

varchar

40

No

Identifier; primary key.

CAMPAIGN_ID

integer

No

Foreign key to ARF_CAMPAIGN.ID.

STAGE_ID

integer

No

Foreign key to ARF_CAMPAIGN_STAGE.ID.

ACTION_ID

integer

No

Foreign key to ARF_CAMPAIGN_ACTION.ID.

EVENT_ID

integer

No

Foreign key to ARF_CAMPAIGN_EVENT.ID.

PARTICIPANT_ID

integer

No

Foreign key to ARF_USER.ID.

SEGMENT_CLUSTER_ID

integer

No

Foreign key to ARF_SEGCLSTR.ID.

DAY_ID

varchar

40

No

Foreign key to ARF_TIME_DAY.ID.

TIME_ID

integer

No

Foreign key to ARF_TIME_TOD.ID.

LABEL

varchar

254

Yes

Campaign authors can assign a label for a given event.