Share
 
 

Manufacturer Feature Class

The Manufacturer feature class manages the manufacturer data for all materials and assemblies.

You can also create models for wastewater network items to simplify the data acquisition.

  • Feature class — WW_MANUFACTURER
  • Feature type — Attribute
Name Data Type Description

COMPANY

Varchar2

The manufacturer’s company name.

COMPANY_2

Varchar2

Additional company information for this manufacturer.

DATE_CREATION

Date

The date when this item was created.

NARRATIVE

Varchar2

A description or other unique information concerning this manufacturer.

USER_FLAG

Varchar2

An operator defined work area. This attribute can be used by the operator for user defined system processes. It does not effect this item's data integrity and should not be used to store this item's data.

The Manfacturer feature class provides several model tables that store various network items.

Casing Model

The manufacturer’s detail information for casings.

  • Model table — WW_CASING_MODEL
  • Feature type — Attribute
  • Parent feature class — WW_MANUFACTURER
Name Data Type Description

CERTIFICATE

Varchar2

A description of item's DIN/ISO/DVGW/TUEV value.

DIAMETER_INSIDE

Number

The inside diameter of the section, measured in meters.

DIAMETER_NOMINAL

Varchar2

The manufacturer's designated size, or nominal diameter, rounded to the nearest unit, for the subject item. for example, 1" gas hydrant, 2" meter, 6" pipe.

DIAMETER_OUTSIDE

Number

The outside diameter of the section, measured in meters.

FID_MANUFACTURER

Number

The manufacturer of this item.

Related to:

  • WW_MANUFACTURER

HYDRAULIC_FRICTION

Number

Hydraulic friction or the roughness inside a section which decreases the pressure relative to the length.

ID_COATING_INSIDE

Number

The type of coating used on the inside of the section.

Related to:

  • WW_COATING_TBD

ID_COATING_OUTSIDE

Number

The type of coating used on the outside of the section.

Related to:

  • WW_COATING_TBD

ID_MATERIAL

Number

The material used to manufacture this item.

MODEL_NUMBER

Varchar2

The model name or number of this item.

PRESSURE_MAX

Varchar2

The manufacturer's or industry standard's maximum pressure rating for this item.

THICKNESS

Varchar2

The thickness of the section wall.

VALUE

Varchar2

A short description of the model. This value is used for the domain table representation of the model.

Cover Model

The manufacturer’s detail information for covers.

  • Model table — WW_COVER_MODEL
  • Feature type — Attribute
  • Parent feature class — WW_MANUFACTURER
Name Data Type Description

DIMENSION_1

Number

The first dimension, measured in meters.

DIMENSION_2

Number

The second dimension, measured in meters.

FID_MANUFACTURER

Number

The manufacturer of this item.

Related to:

  • WW_MANUFACTURER

ID_AERATION

Number

Defines the aeration type of the cover.

Related to:

  • WW_COVER_AER_TBD

ID_COVER_SHAPE

Number

The shape of the cover.

Related to:

  • WW_COVER_SHAPE_TBD

ID_COVER_TYPE

Number

The type of cover.

Related to:

  • WW_COVER_TYPE_TBD

ID_LOAD_CLASS

Number

The load class of the cover.

Related to:

  • WW_COVER_LOAD_TBD

ID_MATERIAL

Number

The material used to manfacture this item.

Related to:

  • WW_COVER_MAT_TBD

LOAD_LIMIT

Number

The maximum load, measured in kilograms, accepted by the cover.

MODEL_NAME

Varchar2

The name or number of the model.

Manhole Model

The manufacturer’s detail information for manholes.

  • Model table — WW_MANHOLE_MODEL
  • Feature type — Attribute
  • Parent feature class — WW_MANUFACTURER
Name Data Type Description

DEPTH

Number

The depth of the manhole.

DIMENSION_1

Number

The first dimension, measured in meters.

DIMENSION_2

Number

The second dimension, measured in meters.

FID_MANUFACTURER

Number

The manufacturer of this item.

Related to:

  • WW_MANUFACTURER

ID_MANHOLE_SHAPE

Number

The shape of the manhole.

Related to:

  • WW_MHOLE_SHAPE_TBD

ID_MANHOLE_TYPE

Number

The type of manhole.

Related to:

  • WW_MHOLE_TYPE_TBD

ID_MATERIAL

Number

The material used to manfacture this item.

Related to:

  • WW_MATERIAL_TBD

MODEL_NAME

Varchar2

The name or number of the model.

Marker Model

The manufacturer’s detail information for manholes.

  • Model table — WW_MARKER_MODEL
  • Feature type — Attribute
  • Parent feature class — WW_MANUFACTURER
Name Data Type Description

FID_MANUFACTURER

Number

The manufacturer of this item.

Related to:

  • WW_MANUFACTURER

ID_MATERIAL

Number

The material used to manfacture this item.

Related to:

  • WW_MATERIAL_TBD

MODEL_NAME

Varchar2

The name or number of the model.

SIGN_HEIGHT

Number

The height dimension of the sign, measured in meters.

SIGN_WIDTH

Number

The width dimension of the sign, measured in meters.

VALUE

Varchar2

Short description of the model. This value is used for the domain table representation of the model.

Meter Model

The manufacturer’s detail information for meters.

  • Model table — WW_METER_MODEL
  • Feature type — Attribute
  • Parent feature class — WW_MANUFACTURER
Name Data Type Description

DIMENSION_1

Number

The first dimension, measured in meters.

DIMENSION_2

Number

The second dimension, measured in meters.

FID_MANUFACTURER

Number

The manufacturer of this item.

Related to:

  • WW_MANUFACTURER

ID_METER_TYPE

Number

The type of meter.

Related to:

  • WW_METER_TYPE_TBD

MODEL_NAME

Varchar2

The name or number of the model.

Pump Model

The manufacturer’s detail information for pumps.

  • Model table — WW_PUMP_MODEL
  • Feature type — Attribute
  • Parent feature class — WW_MANUFACTURER
Name Data Type Description

FID_MANUFACTURER

Number

The manufacturer of this item.

Related to:

  • WW_MANUFACTURER

ID_COOLING_METHOD

Number

The method used to cool this pump.

Related to:

  • WW_COOLING_METHOD_TBD

ID_PUMP_TYPE

Number

The type of pump.

Related to:

  • WW_PUMP_TYPE_TBD

MODEL_NAME

Varchar2

The name or number of the model.

POWER

Number

The amount of power provided by this pump.

Section Model

The manufacturer’s detail information for sections.

  • Model table — WW_SECTION_MODEL
  • Feature type — Attribute
  • Parent feature class — WW_MANUFACTURER
Name Data Type Description

DIAMETER_INSIDE

Number

The inside diameter of the section, measured in meters.

DIAMETER_OUTSIDE

Number

The outside diameter of the section, measured in meters.

DIMENSION_1

Number

The first dimension, measured in meters.

DIMENSION_2

Number

The second dimension, measured in meters.

EXIST_SPECIAL_PROFILE

Number

The existing special profile.

FID_MANUFACTURER

Number

The manufacturer of this item.

Related to:

  • WW_MANUFACTURER

HYDRAULIC_FRICTION

Number

Hydraulic friction or the roughness inside a section which decreases the pressure relative to the length.

ID_MATERIAL

Number

The material used to manufacture this item.

ID_PROFILE

Number

The profile of the section.

MODEL_NAME

Varchar2

The name or number of the model.

THICKNESS

Varchar2

The thickness of the section wall.

VALUE

Varchar2

A short description of the model. This value is used for the domain table representation of the model.

Valve Model

The manufacturer’s detail information for valves.

  • Model table — WW_VALVE_MODEL
  • Feature type — Attribute
  • Parent feature class — WW_MANUFACTURER
Name Data Type Description

DIMENSION_1

Number

The first dimension, measured in meters.

FID_MANUFACTURER

Number

The manufacturer of this item.

Related to:

  • WW_MANUFACTURER

ID_SERVICE_TYPE

Number

The service type for the valve.

Related to:

  • WW_SERVICE_TYPE_TBD

ID_VALVE_TYPE

Number

The type of valve.

Related to:

  • WW_VALVE_TYPE_TBD

MODEL_NAME

Varchar2

The name or number of the model.

Parent topic: About the Wastewater Data Model

Was this information helpful?