Frame

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:

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 greater than the face height
FRAME	FRAME_MAX_WIDTH	Number	Not greater 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