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

QR code for this page

Was this helpful?