SCRM 2006 SCRS_Collection_Dimension_View
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 |
| CollectionEndDateKey | smallint | Null values allowed | End of the time period that this row was valid. A |
| 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. |