Goal:
Summary:
Current State: Construction name (structure ID) is not kept up to date nor is it being enforced as a required field.
Ideal State: Construction name is accurately provided for every single location to enable us to know how many individual structures exist in the out of home space.
Potential short term resolution: Use the latitude and longitude and use proximity to determine the frames that are associated with the same construction (structure).
Standard:
...
TABLE
...
CONSTRUCTION
...
Type
...
Rule
...
CONSTRUCTION
...
CONSTRUCTION_SK
...
Number
...
CONSTRUCTION
...
CONSTRUCTION_ID
...
Number
...
CONSTRUCTION
...
CONSTRUCTION_NAME
...
Text
...
No null or bank value
...
CONSTRUCTION
...
CONSTRUCTION_TYPE_SK
...
Number
...
CONSTRUCTION
...
LOCATION_SK
...
Number
...
CONSTRUCTION
...
CONSTRUCTION_DESCRIPTION
...
Text
...
CONSTRUCTION
...
CREATED_BY
...
Text
...
CONSTRUCTION
...
CREATED_DTM
...
Date
...
CONSTRUCTION
...
UPDATED_BY
...
Text
...
CONSTRUCTION
...
UPDATED_DTM
...
Date
...
CONSTRUCTION
...
CURRENT_IND
...
True/False
...
CONSTRUCTION
...
UPDATED_DESC
...
Text
...
CONSTRUCTION
...
CONSTRUCTION_COUNT
...
Number
...
TABLE
...
CONSTRUCTION_TYPE
...
Type
...
CONSTRUCTION_TYPE
...
CONSTRUCTION_TYPE_SK
...
Number
...
CONSTRUCTION_TYPE
...
CONSTRUCTION_TYPE_ID
...
Number
...
CONSTRUCTION_TYPE
...
CONSTRUCTION_TYPE_NAME
...
Text
...
CONSTRUCTION_TYPE
...
CONSTRUCTION_TYPE_DESCRIPTION
...
Text
...
CONSTRUCTION_TYPE
...
CREATED_BY
...
Text
...
CONSTRUCTION_TYPE
...
CREATED_DTM
...
Date
...
CONSTRUCTION_TYPE
...
UPDATED_BY
...
Text
...
CONSTRUCTION_TYPE
...
UPDATED_DTM
...
Date
...
CONSTRUCTION_TYPE
...
CURRENT_IND
...
True/False
...
CONSTRUCTION_TYPE
...
UPDATED_DESC
...
Text