Open topic with navigation

MKTSEGMENTPASSIVE (4.0SP12)

dbo-4.0-4.0SP1

Top
Primary Key
Foreign Key Fields
Fields
Indexes
Triggers

This table contains segment information specific to media outlets, time slots and marketing locations.

Primary Key
Primary Key	Field Type
ID	uniqueidentifier

Foreign Key Fields
Foreign Key	Field Type	Null	Notes	Description
VENDORID	uniqueidentifier	true	VENDOR.ID	The segment's vendor.
PARENTMEDIAOUTLETSEGMENTID	uniqueidentifier	true	MKTSEGMENT.ID	The media outlet segment to which this time slot belongs.
LOCATIONCOUNTRYID	uniqueidentifier	true	COUNTRY.ID	The marketing location's country.
LOCATIONSTATEID	uniqueidentifier	true	STATE.ID	The marketing location's state.
ADDEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.
CHANGEDBYID	uniqueidentifier	false	CHANGEAGENT.ID	FK to CHANGEAGENT.

Fields
Field	Field Type	Null	Notes	Description
IMPRESSIONS	int	false	0	The number of impressions expected for this segment.
INACTIVE	bit	false	0	Indicates that the segment is no longer active.
SCHEDULESTARTTIME	time	true		Indicates the start time of a time slot segment.
SCHEDULEENDTIME	time	true		Indicates the end time of a time slot segment.
SCHEDULEDURATION	int	false	0	The length of the time slot in seconds.
LOCATIONPOSTCODE	nvarchar(12)	false	''	The marketing location's post code.
LOCATIONCITY	nvarchar(50)	false	''	The marketing location's city.
LOCATIONADDRESSBLOCK	nvarchar(150)	false	''	The marketing location's street address.
DATEADDED	datetime	false	getdate()	Indicates the date this record was added.
DATECHANGED	datetime	false	getdate()	Indicates the date this record was last changed.
TS	timestamp	false		Timestamp.
TSLONG	bigint (Computed)	true		Numeric representation of the timestamp.
IMPRESSIONCALCULATIONMETHODCODE	tinyint	false	0	The method to be used to determine the total number of impressions contributed to a marketing effort by the segment.
IMPRESSIONCALCULATIONMETHOD	nvarchar(20) (Computed)	true		Provides a translation for the 'IMPRESSIONCALCULATIONMETHODCODE' field.

Indexes
Index Name	Field(s)	Unique	Primary	Clustered
IX_MKTSEGMENTPASSIVE_DATEADDED	DATEADDED	False	False	True
IX_MKTSEGMENTPASSIVE_DATECHANGED	DATECHANGED	False	False	False
IX_MKTSEGMENTPASSIVE_LOCATIONCOUNTRYID	LOCATIONCOUNTRYID	False	False	False
IX_MKTSEGMENTPASSIVE_LOCATIONSTATEID	LOCATIONSTATEID	False	False	False
IX_MKTSEGMENTPASSIVE_PARENTMEDIAOUTLETSEGMENTID	PARENTMEDIAOUTLETSEGMENTID	False	False	False
IX_MKTSEGMENTPASSIVE_VENDORID	VENDORID	False	False	False
PK_MKTSEGMENTPASSIVE	ID	True	True	False

Triggers
Trigger Name	Description
TR_MKTSEGMENTPASSIVE_AUDIT_UPDATE
TR_MKTSEGMENTPASSIVE_AUDIT_DELETE