DIM_EMAILCAMPAIGN_STAGE
Email sent to constituents through Luminate Online.
Fields
| Field | Field Type | Null | Notes | Description |
|---|---|---|---|---|
| EMAILCAMPAIGNID | int | The Id of the email campaign | ||
| NAME | nvarchar(255) | The name of the email campaign | ||
| PURPOSE | nvarchar(255) | yes | The purpose of the e-mail campaign | |
| CAMPAIGNTYPE | nvarchar(255) | yes | The campaign type | |
| CAMPAIGNSUBTYPE | nvarchar(255) | yes | The campaign sub type | |
| STATE | nvarchar(255) | yes | The state of the email campaign | |
| ISHIDDEN | bit | yes | Is this email campaign hidden? | |
| ISPUBLISHED | bit | yes | Is the email campaign published? | |
| ISADHOC | bit | yes | Is this email campaign ad-hoc? | |
| CREATIONDATE | datetime | yes | The date the campaign was created | |
| CREATEDBY | int | yes | The user creating the campaign | |
| MODIFYDATE | datetime | yes | The date the email campaign was modified | |
| LASTCHANGEBY | int | yes | The user to last update the email campaign | |
| LASTACTIVITY | nvarchar(255) | yes | The last activity for the email campaign |