Goal: To ensure the layout table is complete for all inventory
Summary:
Current State:
Ideal State:
...
TABLE
...
LAYOUT
...
Type
...
Rules
...
LAYOUT
...
LAYOUT_SK
...
Number
...
LAYOUT
...
LAYOUT_ID
...
Number
...
LAYOUT
...
FRAME_SK
...
Number
...
LAYOUT
...
LAYOUT_FULL_MOTION
...
True/False
...
no nulls or blanks
...
LAYOUT
...
LAYOUT_PARTIAL_MOTION
...
True/False
...
no nulls or blanks
...
LAYOUT
...
LAYOUT_ROTATING
...
True/False
...
no nulls or blanks
...
LAYOUT
...
LAYOUT_INTERACTIVE
...
True/False
...
no nulls or blanks
...
LAYOUT
...
LAYOUT_AUDIO
...
True/False
...
no nulls or blanks
...
LAYOUT
...
SHARE_OF_VOICE
...
Number
...
no nulls or blanks and not greater than 1
...
LAYOUT
...
CREATED_BY
...
Text
...
LAYOUT
...
CREATED_DTM
...
Date
...
LAYOUT
...
UPDATED_BY
...
Text
...
LAYOUT
...
UPDATED_DTM
...
Date
...
LAYOUT
...
CURRENT_IND
...
True/False
...
LAYOUT
...
UPDATED_DESC
...
Text