Goal:
Definition:
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