Water Tracing Step 1: 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

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

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

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

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

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

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

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

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