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 |
Add Comment