...
TABLE | SPOT | Type | Rules |
SPOT | SPOT_SK | Number | |
SPOT | SPOT_ID | Number | |
SPOT | FACE_SK | Number | |
SPOT | PUBLISHER_UNIQUE_ID | Text | |
SPOT | SPOT_LENGTH | Number | |
SPOT | SPOT_FULL_MOTION | True/False | no nulls or blanks |
SPOT | SPOT_PARTIAL_MOTION | True/False | no nulls or blanks |
SPOT | SPOT_ROTATING | True/False | no nulls or blanks |
SPOT | SPOT_INTERACTIVE | True/False | no nulls or blanks |
SPOT | SPOT_AUDIO | True/False | no nulls or blanks |
SPOT | SHARE_OF_VOICE | Number | no nulls or blanks and not greater than 1 |
SPOT | PLANT_SPOT_ID | Text | |
SPOT | CREATED_BY | Text | |
SPOT | CREATED_DTM | Date | |
SPOT | UPDATED_BY | Text | |
SPOT | UPDATED_DTM | Date | |
SPOT | CURRENT_IND | True/False | |
SPOT | UPDATED_DESC | Text |