Spot

Owned by Kevin Romero

Last updated: Jul 11, 2022

1 min read

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