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