Extended Data Definition Tables

Designer's sample data is installed with several Extended Data Definition (EDD) tables. These tables are Esri objects. If they have been converted to ArcFM or Designer Objects, use the ArcFM Solution Object Converter to convert them back to Esri objects. It is recommended that Extended Data Definition tables remain unversioned.

EDM_COMPATIBLEUNIT

This table manages the extended data for a compatible unit. No field model names exist. This table has four subtypes:

Subtype

Code

Electric

1

Gas

2

Water

3

Non-GIS

4

Subtype	Code
Electric	1
Gas	2
Water	3
Non-GIS	4

The following fields have domains associated with them:

Field

Domain

LABOR_TYPE

EDM_LaborType

SOIL_CONDITION

EDM_SoilCondition

TRAFFIC_CONDITION

EDM_TrafficCondition

NETWORK_STATUS

EDM_NetworkStatus

Field	Domain
LABOR_TYPE	EDM_LaborType
SOIL_CONDITION	EDM_SoilCondition
TRAFFIC_CONDITION	EDM_TrafficCondition
NETWORK_STATUS	EDM_NetworkStatus

The domains are defined as follows:

EDM_LaborType

Code

Value

0

Internal

1

Contractor

Code	Value
0	Internal
1	Contractor

EDM_SoilCondition

Code

Value

0

Soft Soil

1

Firm Soil

2

Hard Soil

Code	Value
0	Soft Soil
1	Firm Soil
2	Hard Soil

EDM_TrafficCondition

Code

Value

0

No Traffic

1

Light Traffic

2

Medium Traffic

3

High Traffic

Code	Value
0	No Traffic
1	Light Traffic
2	Medium Traffic
3	High Traffic

EDM_NetworkStatus

Code

Value

0

Not In Service

1

In Service

Code	Value
0	Not In Service
1	In Service

The Labor_Type, Soil_Condition, Traffic_Condition, and Network_Status fields must have a short integer data type because they appear on the Site Conditions tab in Workflow Manager. All fields on this tab must utilize a domain.

EDM_DESIGN

This table manages the extended data for a design. No field model names exist. This table uses the same domains as the EDM_COMPATIBLEUNIT table. This table does not have subtypes.

EDM_WORKLOCATION

This table manages the extended data for a work location. No field model names exist. This table uses the same domains as the EDM_COMPATIBLEUNIT table. This table does not have subtypes.

EDM_WORKREQUEST

This table manages the extended data for the work request feature. No field model names exist. This table does not have subtypes. The WORKREQUEST_TYPE field has the EDM_WorkRequestType domain associated with it.

The EDM_WorkRequestType domain is defined as follows:

Code

Value

0

None

1

Residential

2

Commercial

3

Irrigation

4

Industrial