Goal: In order to ensure the quality of Geopath’s data and address the needs of the industry we need ensure that the information we have at the frame level is valid in order to accurately determine the unique number of frame in the out of home world.
Definition: A frame is define by the area where the ad can be displayed. The space from edge to edge is defined as the frame.
...
...
Element
...
Description
...
Frame / Screen / Display
...
The surface where content is displayed
Current State: We have a fairly decent count of frames in our database. There are however a few exceptions. Tri-visions, still require an overhaul where we still are using multiple frames to describe one tri-vision. Each frame on a single tri-vision is representing a spot. There has been push back from media operators on making a change where one frame represents 3 spots such as Clear Channel.
As noted in the database rules the plant frame ID needs to be unique within an account. Frame max height and frame max width cannot be smaller than the face height and width. I have also noted the ideal state of frame media name in the media type page.
Ideal State:
Potential resolution:
Policy:
Standard Types:
Database Rules:
...
TABLE
...
FRAME
...
Type
...
Rules
...
FRAME
...
FRAME_SK
...
Number
...
FRAME
...
FRAME_ID
...
Number
...
FRAME
...
CONSTRUCTION_SK
...
Number
...
FRAME
...
PLANT_FRAME_ID
...
Text
...
no duplicate within the same Account ID
...
FRAME
...
LOCATION_SK
...
Number
...
FRAME
...
MEDIA_TYPE_SK
...
Number
...
FRAME
...
CLASSIFICATION_TYPE_SK
...
Number
...
FRAME
...
PLACEMENT_TYPE_SK
...
Number
...
FRAME
...
ILLUMINATION_START_TIME
...
Text
...
FRAME
...
ILLUMINATION_END_TIME
...
Text
...
FRAME
...
ILLUMINATION_TYPE_SK
...
Number
...
FRAME
...
FRAME_MAX_HEIGHT
...
Number
...
Not smaller than the face height
...
FRAME
...
FRAME_MAX_WIDTH
...
Number
...
Not smaller than the face width
...
FRAME
...
FRAME_MAX_PIXEL_HEIGHT
...
Number
...
FRAME
...
FRAME_MAX_PIXEL_WIDTH
...
Number
...
FRAME
...
CONSTRUCTION_DATE
...
Date
...
FRAME
...
STATUS_TYPE_SK
...
Number
...
FRAME
...
FRAME_DESCRIPTION
...
Text
...
FRAME
...
FRAME_FULL_MOTION
...
True/False
...
no nulls or blanks
...
FRAME
...
FRAME_PARTIAL_MOTION
...
True/False
...
no nulls or blanks
...
FRAME
...
FRAME_ROTATING
...
True/False
...
no nulls or blanks
...
FRAME
...
FRAME_INTERACTIVE
...
True/False
...
no nulls or blanks
...
FRAME
...
FRAME_AUDIO
...
True/False
...
no nulls or blanks
...
FRAME
...
FRAME_DIGITAL
...
True/False
...
no nulls or blanks
...
FRAME
...
FRAME_MEDIA_NAME
...
Text
...
FRAME
...
ENGAGEMENT
...
Number
...
no nulls or blanks
...
FRAME
...
NOTES
...
Text
...
FRAME
...
CREATED_BY
...
Text
...
FRAME
...
CREATED_DTM
...
Date
...
FRAME
...
UPDATED_BY
...
Text
...
FRAME
...
UPDATED_DTM
...
Date
...
FRAME
...
CURRENT_IND
...
True/False
...
FRAME
...
UPDATED_DESC
...
Text