ID

integer

No

Identifier; primary key.

NCAMPAIGN_ID

varchar

40

No

Natural key of campaign.

SITE_ID

smallint

No

The site that the campaign is associated with.

START_DATE

datetime

Yes

Campaign start date.

END_DATE

datetime

Yes

Campaign end date.

DISPLAY_NAME

varchar

255

Yes

Campaign display name.

DESCRIPTION

varchar

1024

Yes

Campaign description.

TARGET_AUDIENCE

varchar

1024

Yes

Campaign target audience.

ESTIMATED_COST

varchar

1024

Yes

Campaign estimated cost.

ESTIMATED_RESPONSE_RATE

varchar

1024

Yes

Campaign estimated response rate.

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