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 EDD tables remain unversioned.

IMPORTANT: The owner of the geodatabase feature/object classes is typically the owner of the EDD tables. It is critical that the permissions for the EDD tables are consistent with those of the feature/object classes. It isn’t required that SDE be the owner, as long as they are consistent.

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

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

The domains are defined as follows:

EDM_LaborType

Code

Value

0

Internal

1

Contractor

EDM_SoilCondition

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

EDM_NetworkStatus

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

QR code for this page

Was this helpful?