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 |
| AdvertisementEndDateKey | smallint | Null values | End of the time period that this row was valid. A |
| 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 |
| 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 |
| 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 |
| AdvertisementExpirationTimeEnabled | int | Null values allowed | Indicates whether the advertisement expires at the predefined time. The default value is |
| AdvertisementExpirationTimeIsGMT | int | Null values allowed | Indicates whether the time defined in the ExpirationTime property is in Universal Time (GMT). The default value is |
| 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 |
| AdvertisementPresentTimeEnabled | int | Null values allowed | Indicates whether the present time is enforced by SMS. The default value is |
| 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):
|
| AdvertisementSourceSiteCode | nvarchar | Not Null | Site code of the site from which the package originated. |