Create Water Domains
There are several domains that may be created to work with Water Tracing. These domains provide the coded values for various functionality within Water Tracing.
CPSystemStatus
CPSystemStatus domain properties:
-
Field Type = long integer
-
Domain Type = Coded Values
-
Split Policy = Duplicate
-
Merge Policy = Default Value
CPSystemStatus domain coded values:
|
Code |
Description |
|---|---|
|
0 |
Closed |
|
1 |
Open |
GasWaterSystemStatus - String
GasWaterSystemStatus - String domain properties:
-
Field Type = text
-
Domain Type = Coded Values
-
Split Policy = Duplicate
-
Merge Policy = Default Value
GasWaterSystemStatus - String domain coded values:
|
Code |
Description |
|---|---|
|
N |
Not a Boundary |
|
Y |
Boundary |
Normal Position Domain
Normal Position domain properties:
-
Field Type = long integer
-
Domain Type = Coded Values
-
Split Policy = Duplicate
-
Merge Policy = Default Value
Normal Position domain coded values:
|
Code |
Description |
|---|---|
|
0 |
Closed |
|
1 |
Open |
Operating Classification Domain
Operating Classification domain properties:
-
Field Type = text
-
Domain Type = Coded Values
-
Split Policy = Duplicate
-
Merge Policy = Default Value
Operating Classification domain coded values:
|
Code |
Description |
|---|---|
|
CIR |
Critical/Inspection Required |
|
CINR |
Critical/Inspection Not Required |
|
NC |
Non-Critical |
Pipe Type Domain
Pipe Type domain properties:
-
Field Type = text
-
Domain Type = Coded Values
-
Split Policy = Duplicate
-
Merge Policy = Default Value
Pipe Type domain coded values:
|
Code |
Description |
|---|---|
|
P |
Pinchable |
|
NP |
Non-Pinchable |
Station Status Domain
Station Status domain properties:
-
Field Type = text
-
Domain Type = Coded Values
-
Split Policy = Duplicate
-
Merge Policy = Default Value
Station Status domain coded values:
|
Code |
Description |
|---|---|
|
OFF |
Offline |
|
ONL |
Online |
|
UNK |
Unknown |
Water Line Material Domain
Water Line Material domain properties:
-
Field Type = text
-
Domain Type = Coded Values
-
Split Policy = Duplicate
-
Merge Policy = Default Value
Water Line Material domain coded values:
|
Code |
Description |
|---|---|
|
DI |
Ductile Iron |
|
CI |
Cast Iron |
|
PVC |
Poly Vinyl Chloride |
|
AC |
Asbestos Concrete |
|
ST |
Steel |
|
WO |
Wood |
|
UNK |
Unknown |
|
OTH |
Other |
|
CL |
Clay |
|
GS |
Galvanized Steel |
Note for Cathodic Protection: Cathodic Protection traces recognize only the following values as non-conductive materials: CI, PVC, AC, WO and CL. If you elect to create a numeric domain, Cathodic Protection will recognize only 2, 3, 4, 6 and 9 as values corresponding to non-conductive material. You may edit the codes and values of this domain, however, only CI (2), PVC (3), AC (4), WO (6) and CL (9) will be recognized as non-conductive. All other values will be considered conductive.
For example, you could create the following domain with a long integer data type:
Water Line Material domain properties:
-
Field Type = long integer
-
Domain Type = Coded Values
-
Split Policy = Duplicate
-
Merge Policy = Default Value
Water Line Material domain coded values:
|
Code |
Description |
|---|---|
|
1 |
Ductile Iron |
|
2 |
Cast Iron |
|
3 |
Poly Vinyl Chloride |
|
4 |
Asbestos Concrete |
|
5 |
Steel |
|
6 |
Wood |
|
7 |
Unknown |
|
8 |
Other |
|
9 |
Clay |
|
10 |
Galvanized Steel |
Yes/No Indicator Domain
Yes/No Indicator domain properties:
-
Field Type = text
-
Domain Type = Coded Values
-
Split Policy = Duplicate
-
Merge Policy = Default Value
Yes/No Indicator domain coded values:
|
Code |
Description |
|---|---|
|
Y |
Yes |
|
N |
No |