SCRM 2006 SCRS_CollectionMemberUser_FACT_VIEW

Article
09/10/2006

SCRS_CollectionMemberUser_FACT_VIEW lists the users and user groups that are members of each SMS collection.

SCRS_CollectionMemberUser_FACT_VIEW

Column	Type	Constraint	Description
CollectionKey	int	Not Null	Foreign key that references a unique SMS collection in the Collection dimension.
CollectionMemberEndTimeKey	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 non-NULL value indicates the last time that this row was known to be valid.
CollectionMemberEndDateKey	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 non-`NULL` value indicates the last date that this row was known to be valid.
CollectionMemberEndDateTime	datetime	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 and time that this row was known to be valid.
CollectionMemberEndDateLineageKey	int	Null values allowed	References the DTS lineage of the package that first detected that this SMS collection had been deleted from SMS site database.
CollectionMemberStartTimeKey	int	Not Null	Start of the time period that this row was known to be valid. Indicates time that the SMS collection entry was first inventoried by SMS.
CollectionMemberStartDateKey	smallint	Not Null	Start of the time period that this row was known to be valid. Indicates date that the SMS collection entry was first inventoried by SMS.
CollectionMemberStartDateTime	datetime	Not Null	Start of the time period that this row was known to be valid. Indicates date and time that the SMS collection entry was first inventoried by SMS.
CollectionMemberStartDateLineageKey	int	Not Null	References the DTS lineage of the package that first detected that this SMS collection entry had been inserted into SMS site database.
UserKey	int	Not Null	Foreign key that references a unique user in the User dimension.

See Also

Other Resources

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