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 |