SCRM 2006 SCRS_Advertisement_Dimension_View

SCRS_Advertisement_Dimension_View lists information about each SMS advertisement.

SCRS_Advertisement_Dimension_View

Column	Type	Constraint	Description
AdvertisementKey	int	Not Null	Foreign key that uniquely identifies each product in the SC_SMSAdvertisementDimension_Table.
AdvertisementEndTimeKey	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.
AdvertisementEndDateKey	smallint	Null values	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.
AdvertisementEndDateLineageKey	int	Null values allowedNot Null	References the DTS lineage of the package that first detected that this advertisement no longer exists in the SMS site database.
AdvertisementStartTimeKey	int	Not Null	Start of the time period that this row was known to be valid. Indicates time when item was first created by SMS.
AdvertisementStartDateKey	smallint	Not Null	Start of the time period that this row was known to be valid. Indicates time when SMS first created the item.
AdvertisementStartDateLineageKey	int	Not Null	References the DTS lineage of the package that first detected that this advertisement exists in the SMS ODB.
AdvertisementProgramCategory	nvarchar	Not Null	Category associated with the advertisement program.
AdvertisementProgramComment	nvarchar	Not Null	Comment associated with the advertisement program.
AdvertisementProgramName	nvarchar	Not Null	Identifies a program within the specified package (PackageID) to be advertised.
AdvertisementAssignedScheduleEnabled	int	Null values allowed	Indicates whether the schedule defined in AssignedSchedule is active. The default value is FALSE.
AdvertisementCollectionId	nvarchar	Not Null	Collection identifier to which the advertisement is targeted.
AdvertisementCollectionName	nvarchar	Not Null	Name of the collection to which the advertisement is targeted.
AdvertisementComment	nvarchar	Not Null	Simple description or note about the advertisement.
AdvertisementDevice	int	Null values allowed	True when OfferFlags & 0x8000 is greater than 0.
AdvertisementDownloadPriorToExecution	int	Null values allowed	Indicates whether the advertisement will be downloaded prior to its execution time.
AdvertisementExpirationTime	datetime	Null values allowed	Date and time when the advertisement is no longer available to clients. The default value is 19900101000000.000000+****.
AdvertisementExpirationTimeEnabled	int	Null values allowed	Indicates whether the advertisement expires at the predefined time. The default value is FALSE.
AdvertisementExpirationTimeIsGMT	int	Null values allowed	Indicates whether the time defined in the ExpirationTime property is in Universal Time (GMT). The default value is FALSE.
AdvertisementId	nvarchar	Not Null	Unique, auto-generated key that identifies the advertisement.
AdvertisementIncludeSubCollection	int	Null values allowed	Indicates whether the advertisement is advertised to the subcollections of the specified collection.
AdvertisementMandatory	int	Null values allowed	Indicates whether the advertisement is mandatory.
AdvertisementName	nvarchar	Not Null	Name of the advertisement.
AdvertisementPresentTime	datetime	Null values allowed	Date and time at which an advertisement is made available to clients. The default value is 19900101000000.000000+****.
AdvertisementPresentTimeEnabled	int	Null values allowed	Indicates whether the present time is enforced by SMS. The default value is TRUE.
AdvertisementPresentTimeIsGMT	int	Null values allowed	Indicates whether the time defined in PresentTime is in Coordinated Universal Time (Greenwich Mean Time). The default value is FALSE.
AdvertisementPriority	int	Null values allowed	Priority used in replicating the advertisement to child sites, using the following values (default is NORMAL): 1. High 2. Normal 3. Low
AdvertisementSourceSiteCode	nvarchar	Not Null	Site code of the site from which the package originated.

See Also

Other Resources

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