DIM_EMAILMESSAGE

Email sent to constituents through Luminate Online.

Primary Key

Primary Key	Field Type
EMAILMESSAGEDIMID	int

Fields

Field	Field Type	Null	Notes	Description
EMAILCAMPAIGNDIMID	int			Reference key to the marketing campaign dimension LO EMAIL_CAMPAIGN this message was a part of
EMAILMESSAGESYSTEMID	int			Primary key from LO EMAIL_MESSAGE.MSG_ID
EMAILMESSAGENAME	nvarchar(255)	yes		Private, admin-entered name from LO EMAIL_MESSAGE.NAME
EMAILMESSAGEPURPOSE	nvarchar(255)	yes		Private, admin-entered string from LO EMAIL_MESSAGE.PURPOSE
EMAILMESSAGEARCHIVED	bit			Boolean from LO EMAIL_MESSAGE.IS_HIDDEN
EMAILMESSAGESENDERNAME	nvarchar(255)	yes		Public-visible string from LO EMAIL_MESSAGE.SENDER_NAME
EMAILMESSAGESUBJECT	nvarchar(255)	yes		Public-visible string from LO EMAIL_MESSAGE.SUBJECT
EMAILMESSAGEDATECREATED	date			Date the LO admin created the message
EMAILMESSAGEDATECREATEDDIMID	int			Reference key to the date dimension
EMAILMESSAGEDATEMODIFIED	date	yes		Most recent date an LO admin modified the message
ISINCLUDED	bit	yes		Flag indicating when data should be included in results.
ETLCONTROLID	int	yes		ID generated through the ETL process.
SOURCEDIMID	int	yes		Source system used.

Indexes

Index Name	Fields	Unique	Primary	Clustered
PK_DIM_EMAILMESSAGE	EMAILMESSAGEDIMID	yes	yes	yes