SCRM 2006 SCRS_StatusMessage_Dimension_View

SCRS_StatusMessage_Dimension_View lists the unique status messages that can be raised by SMS.

SCRS_StatusMessage_Dimension_View

Column	Type	Constraint	Description
StatusMessageKey	smallint	Not Null	Key that uniquely identifies a given SMS status message.
ComponentName	nvarchar	Null values allowed	Component name to which this status message pertains.
IsError	int	Null values allowed	Indicator for whether this status message is an error (Y/N).
IsInformational	int	Null values allowed	Indicator for whether this status message is informational (Y/N).
IsWarning	int	Null values allowed	Indicator for whether this status message is a warning (Y/N).
StatusMessageCategory	nvarchar	Not Null	Category of status message.
StatusMessageCategoryId	int	Null values allowed	Category identifier for the status message.
StatusMessageId	int	Null values allowed	Identifier for the status message.
StatusMessageName	nvarchar	Null values allowed	Name of status message.
StatusMessageDescription	nvarchar	Null values allowed	Description of status message.
IsInstalled	bit	Not Null	Indicator for whether the Status Message maps to the installed state of an advertisement or software update on an advanced client.
IsFailed	bit	Not Null	Indicator for whether the status message maps to the failed state of an advertisement or software update on an advanced client.