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. |