This table contains information about Outreach campaigns.
Column Name | Type | Length | Null Allowed | Description |
---|---|---|---|---|
ID | integer | No | Identifier; primary key. | |
NCAMPAIGN_ID | varchar | 40 | No | Natural key of campaign. |
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 |