SCRM 2006 SCRS_Collection_Dimension_View

Article
09/10/2006

SCRS_Collection_Dimension_View lists the SMS collections.

SCRS_Collection_Dimension_View

Column	Type	Constraint	Description
CollectionKey	int	Not Null	Key that uniquely identifies a given collection.
CollectionComment	nvarchar	Not Null	Comment associated with the collection.
CollectionEndTimeKey	int	Null values allowed	End of the time period that this row was valid. A `NULL` value indicates this row contains the current information. A date value indicates the last date that this row was known to be valid.
CollectionEndDateKey	smallint	Null values allowed	End of the time period that this row was valid. A `NULL` value indicates this row contains the current information. A date value indicates the last date that this row was known to be valid.
CollectionEndDateLineageKey	int	Null values allowed	Key that references the DTS lineage of the package that first detected that this collection no longer exists in the SMS site database.
CollectionStartTimeKey	int	Not Null	Start of the time period that this row was known to be valid. Indicates time that this collection was first inventoried by SMS.
CollectionStartDateKey	smallint	Not Null	Start of the time period that this row was known to be valid. Indicates time that this collection was first inventoried by SMS.
CollectionStartDateLineageKey	int	Not Null	Key that references the DTS lineage of the package that first detected that this collection exists in the SMS site database.
CollectionId	nvarchar	Null values allowed	Identifier associated with the collection.
CollectionLastChangeTime	datetime	Null values allowed	Time that the collection was last changed.
CollectionLastMemberChangeTime	datetime	Not Null	Last time that a member associated with the collection was changed.
CollectionName	nvarchar	Not Null	Name of the collection.

See Also

Other Resources

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