Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 9 Current »

Goal:

Definition:

Element 

Description 

Spot / Slot 

A description of the type of message that can be delivered to a face. (e.g. a 30 second full motion video, or a 15 second still image, or a printed vinyl)) 

Current State:

Ideal State:

Potential resolution:

Policy:

Standard Types:

Database Rules:

TABLE

SPOT

Type

Rules

SPOT

SPOT_SK

Number

SPOT

SPOT_ID

Number

SPOT

FACE_SK

Number

SPOT

PUBLISHER_UNIQUE_ID

Text

SPOT

SPOT_LENGTH

Number

see digital and rotating inventory

SPOT

SPOT_FULL_MOTION

True/False

Default is False

SPOT

SPOT_PARTIAL_MOTION

True/False

Default is False

SPOT

SPOT_ROTATING

True/False

Default is False

SPOT

SPOT_INTERACTIVE

True/False

Default is False

SPOT

SPOT_AUDIO

True/False

Default is False

SPOT

SHARE_OF_VOICE

Number

no nulls or blanks and not greater than 1

SPOT

PLANT_SPOT_ID

Text

no duplicate within the same Account ID

SPOT

CREATED_BY

Text

SPOT

CREATED_DTM

Date

SPOT

UPDATED_BY

Text

SPOT

UPDATED_DTM

Date

SPOT

CURRENT_IND

True/False

SPOT

UPDATED_DESC

Text

Ninel Roytman

  • No labels