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.
...
TABLE
...
CONSTRUCTION
...
Type
...
CONSTRUCTION
...
CONSTRUCTION_SK
...
Number
...
CONSTRUCTION
...
CONSTRUCTION_ID
...
Number
...
CONSTRUCTION
...
CONSTRUCTION_NAME
...
Text
...
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