Create Domain

Create the following domains. These may have been created during configuration of another ArcFM Solution tool. The coded values displayed are as they appear in the sample data. They may vary to suit your business needs.

Phase Designation

ArcFM requires that a phase be represented with one character. The domain description of a three-phase conductor has three letters or numbers (e.g., ABC or 123). However, the coded domain values must be single digits. The Minerville sample database uses integers 1 through 7 to describe the combination of phases as shown below.

Field type: Long integer

Domain type: Coded Values

Code

Description

1

C

2

B

3

BC

4

A

5

AC

6

AB

7

ABC

ULS Material Duct Bank

Field type: Text

Domain type: Coded Values

Code

Description

FIB

Fiber

STL

Steel

WOD

Wood

OTH

Other

UNK

Unknown

PVC

PVC

ULS Size

This domain holds the various duct sizes. The following values are as they appear in the sample data. You may edit these values to reflect your business standards.

NOTE: Code values must be whole numbers. No decimals nor negative integers are allowed, or data corruption could occur.The Code value drives the size of the duct. For example, you might have a Code of 5, but the Description is 2". When the user places what they think is a 2-inch duct (by the description), they'll actually be placing a 5-inch duct (using the Code value). As the example depicts below, ensure that the Code value matches the Description value when setting up this domain.

Field type: Text

Domain type: Coded Values

Code

Description

2

2"

5

5"

10

10"

4

4"

6

6"

Yes/No Indicator

Field type: Long integer

Domain type: Coded Values

IMPORTANT: For the Yes/No Indicator domain, the order of values must match the table below, where 0 (No) is first and 1 (Yes) is second. This ensures the application functions properly when utilizing this domain.

Code

Description

0

No

1

Yes

QR Code is a registered trademark of DENSO WAVE INCORPORATED in Japan and other countries.

Was this helpful?