SCRM 2006 SC_EventDetailDimension_View

SC_EventDetailDimension_View lists event properties beyond those found in the SCRM 2006 SC_EventFact_View.

SC_EventDetailDimension_View

Column	Type	Constraint	Description
Category_PK	nvarchar(50)	Not Null	A category describing the event type.
EventID_PK	int	Not Null	The ID assigned to the event by the event source.
EventSource_PK	nvarchar(255)	Not Null	The source of the event, which is often the name of the application or service that raised it.
EventSourceMessage	nvarchar(3500)	Null values allowed	The message text for the event.
Language_PK	int	Not Null	The code identifying the language used in the EventSourceMessage column.
MsgID_PK	int	Not Null	The ID assigned to the event by the event source.
SMC_InstanceID	bigint	Not Null	The surrogate key for this item.