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