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 |
...