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 |