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.

See Also

Reference

SCRM 2006 SC_EventFact_View

Other Resources

SCRM 2006 MOM Views
SCRM 2006 Report Customization
SCRM 2006 SMS Views
SCRM 2006 Stored Procedures