DIM_EMAILMESSAGE_STAGE

Email sent to constituents through Luminate Online.

Fields

Field	Field Type	Null	Notes	Description
EMAILCAMPAIGNID	int			The email campaign Id for the email message
MSGID	int			The MSG Id for the email message
VARIANTID	int			The variant Id for this email message
MSGTYPEID	int	yes		The message type for the email message
LAYOUTID	int	yes		The layout Id for the email message
APPID	int	yes		The App Id for the email message
APPREFID	int	yes		The App ref Id for the email message
CATID	int	yes		The CAT Id for the email message
NAME	nvarchar(255)	yes		The name of the email message
PURPOSE	nvarchar(255)	yes		The purpose of the email message
VARIANTLABEL	nvarchar(64)	yes		The label of the variant for this email message
TENTATIVESCHEDULEDATE	datetime	yes		The tentative schedule date for the email message
USETENTATIVESCHEDULEDATE	bit	yes		Should the tentative schedule date be used for this email message?
STATE	nvarchar(32)	yes		The state of the email message
ISHIDDEN	bit	yes		Is the email message hidden?
SENDERNAME	nvarchar(255)	yes		The senders name for this email message
SENDERADDRESS	nvarchar(255)	yes		The senders address for this email message
SUBJECT	nvarchar(255)	yes		The subject of the email message
CREATIONDATE	datetime	yes		The date the email message was created
CREATEDBY	int	yes		The user that created the email message
MODIFYDATE	datetime	yes		The modify date for the email message
LASTCHANGEBY	int	yes		The user to last update the email message
LASTACTIVITY	nvarchar(255)	yes		The last updated made to the email message
DUPLICATESUPPRESSION	nvarchar(8)	yes		Is duplicate suppression being used?
INTERACTIONFILTERS	nvarchar(128)	yes		The filters for interaction for this email message
PARENTMSGID	int	yes		The parent message of this email message
MSGTEMPLATETYPEID	int	yes		The message template for the email message
INCLUDEINSTAG	bit	yes		Is included in stag?
EMAILPRODUCT	nvarchar(16)	yes		The email product for the email message