Looking at the Lifecyle_Status domain in the StormWater Utility Network model, I see the codes skip numbers:
Lifecycle_Status -- Valid lifecycle states for the assets.
Code Value
0 Unknown
1 Proposed
2 Proposed - Approved
4 Under Construction
8 In Service
16 In Service - To Be Retired
32 Abandoned
There is an expanded list in Lifecycle_Combined, but still a lot of numbers are missing:
Lifecycle_Combined -- Bitwise combination of lifecycle states for subnetwork management
Code Value
0 Unknown
1 Proposed
2 Proposed - Approved
3 Proposed and Approved
4 Under Construction
6 Approved and Under Construction
7 Proposed, Approved and Under Construction
8 In Service
12 In Service and Under Construction
14 In Service, Under Construction, and Approved
15 In Service, Under Construction, Approved and Proposed
16 In Service - To Be Retired
32 Abandoned
However, I presume that the intervening numbers are used somewhere else (perhaps in a different utility domain) and the attempt is to keep the same numbering across domains for ease of use. In the future, our UN will have several different utility domains because many of the assets in our structural domain will be shared across utilities (we are a university campus that manages most of our own utilities).
That said, I need to add a code for "Removed" (it's not the same as "Abandoned") to let our utility locating people know, "That line you remembered from 5 years ago? It's no longer there, so you don't need to worry about marking it!"). Is there someplace where I can find out what the "missing" values are? There may be one for "Removed", in which case I would like to use that, and I don't want it to choose a number that is used in a different manner in similar domain in some other place/utility domain.
For example, if I hadn't looked in the Lifecycle_Combined domain and just assumed the "missing" numbers were vacant, I might have chosen "3 = Removed". Then later, if I used the Lifecycle_Combined domain, I would have a conflict because in Lifecycle_Status, 3 = Removed, whereas in Lifecycle_Combined, 3 = Proposed and Approved. This is the kind of conflict I want to avoid.
Cheryl