Treatment Works (Distribution) Data Fields

Treatment Works data can be edited on either the Treatment Works Grid Window of the Asset Grid or the Treatment Works Property Sheet.

To view and edit all treatment works data, use the Property Sheet.

The following describes all the data which can be used to define a treatment works object.

Common Data Fields

Fields that are common to the majority of objects can be found in the Common Fields topic.

Treatment Works Data

Database Table Name: wams_wtw

Show Columns

Database Names

Size, Type and Units

Defaults and Error Limits

Field Name

Help Text

Database Field

Data Type

Size

Units

Precision

Default

Error Lower Limit

Error Upper Limit

Warning Lower Limit

Warning Upper Limit

ID

The name of the object.

The ID is the primary key in the database for the network object. This means that the ID field of each object must be unique for all objects of the same object type.

id

Text

40

 

0

 

 

 

 

 

Asset ID

An optional reference - usually the asset database name for this network object (if applicable).

asset_id

Text

40

 

0

 

 

 

 

 

Owner

The proprietor of the asset.

owner

Text

64

 

0

 

 

 

 

 

Area code

The zone ID in which the asset is contained.

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

area_code

Text

40

 

0

 

 

 

 

 

Operational status

The current functionality of the asset:

Database Value

Description

AB

Abandoned

STANDBY

Standby

INUSE

In Use

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

operational_status

Text

20

 

0

 

 

 

 

 

Planning status

The current situation of the asset in relation to construction.

planning_status

Text

20

 

0

 

 

 

 

 

Location

Address or description of site at which asset is located.

location

Text

100

 

0

 

 

 

 

 

X coord

X coordinate of the object.

x

Double

 

XY

2

 

 

 

 

 

Y coord

Y coordinate of the object.

y

Double

 

XY

2

 

 

 

 

 

Average daily supply

Average daily volume of water supplied by the treatment works.

ave_daily_supply

Double

 

IN_Q

2

 

 

 

 

 

Average peak supply

Average daily volume of water supplied by the treatment works under peak demand conditions.

ave_peak_supply

Double

 

IN_Q

2

 

 

 

 

 

Average daily input

Average daily volume of water supplying the treatment works.

ave_daily_input

Double

 

IN_Q

2

 

 

 

 

 

Max rated output

Maximum design daily output that can be achieved by treatment works.

max_rated_output

Double

 

IN_Q

2

 

 

 

 

 

Rated output reliability

Probability of the Max rated output being achieved.

rated_output_reliability

Double

 

 

2

 

 

 

 

 

Supervising engineer

Name of engineer responsible for site.

supervising_engineer

Text

20

 

0

 

 

 

 

 

Headloss

The maximum loss in pressure, caused by the asset, across its entire length (usually at peak flow).

headloss

Double

 

HEAD

2

 

0

 

 

 

Manufacturer

The name of the company who fabricated the asset.

manufacturer

Text

20

 

0

 

 

 

 

 

Condition grade

A measure of asset condition.

condition_grade

Long Integer

 

 

0

 

 

 

 

 

Critical

A measure of the likely impact of asset failure.

criticality

Text

5

 

0

 

 

 

 

 

Security

The security of the asset from unauthorised access/tampering:

Database Value

Description

A

Vulnerable

B

Moderate Risk

C

Secure

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

security

Text

10

 

0

 

 

 

 

 

Condition survey date

Date of the most recent condition survey of the asset.

survey_date

Date / Time

 

 

0

 

 

 

 

 

GPS survey date

The date of the most recent GPS survey (DD/MM/YYYY).

gps_survey_date

Date / Time

 

 

0

 

 

 

 

 

Date installed

The date when the asset was installed (DD/MM/YYYY). Used in costing reports in conjunction with the cost index.

date_installed

Date / Time

 

 

0

 

 

 

 

 

Date cleaned

The date the asset last underwent maintenance to improve performance (swabbing, scouring).

date_cleaned

Date / Time

 

 

0

 

 

 

 

 

Date renewed

The date the asset was last restored to its initial condition (replaced, relined).

date_renewed

Date / Time

 

 

0

 

 

 

 

 

Installation cost

The original installation cost of the asset. This generally includes all costs incurred (e.g. mantime, asset purchase costs etc). This information is used in depreciation reports.

install_cost

Double

 

WN_COST

0

 

 

 

 

 

Inspection cost

Estimated cost of asset inspection.

inspection_cost

Double

 

WN_COST

0

 

 

 

 

 

Expected lifetime

The expected lifetime of the asset. This is used in depreciation reports as the period over which installation costs may be depreciated.

lifetime

Long Integer

 

 

0

 

 

 

 

 

Rehabilitation cost

Rehabilitation costs to be incurred in bringing the asset to an acceptable condition. This is used in rehabilitation reports.

rehab_cost

Double

 

WN_COST

0

 

 

 

 

 

Replacement cost

The estimated cost for completely replacing an asset.

replace_cost

Double

 

WN_COST

0

 

 

 

 

 

Current value

Current value of the asset. This gives an indication of depreciation costs as depreciation cost = installation cost - current value.

current_value

Double

 

WN_COST

2

 

 

 

 

 

Soil type

A description of the material surrounding the asset that could influence condition grading and rehabilitation methods:

Database Value

Description

PEAT

Peat

CHALK

Chalk

CLAY

Clay

SHALE

Shale

SAND

Sand

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

soil_type

Text

10

 

0

 

 

 

 

 

Surface type

A description of the ground use in close proximity to the asset that may influence access/costs for monitoring, maintenance or construction purposes:

Database Value

Description

Road

Road

Pavement

Pavement

Field

Field

Unpaved

Unpaved

The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog.

surface_type

Text

10

 

0

 

 

 

 

 

Pumps

Click the button to display details of collections of pumps in the treatment works.

 

The Pump section is read-only. The information displayed in it is specified in the pump data fields:

Field Name

Help Text

ID

The ID of the pump.

Pump group

The name of the pump group in the associated pumping station to which the pump belongs.

 

The Pump goup section is editable, and is used to provide details of the pump group.

Database Table Name: wams_pump_station_groups

Show Columns

Database Names

Size, Type and Units

Defaults and Error Limits

Position in Data Structure

Field Name

Help Text

Database Field

Data Type

Size

Units

Default

Error Lower Limit

Error Upper Limit

Warning Lower Limit

Warning Upper Limit

1 Pump group Name of pump group. pump_groups Text 40          

 

2 Duty head Duty head of pump group. duty_head Double   WN_P        

 

3 Duty flow Duty flow of pump group. duty_flow Double   IN_Q        

 

pump_groups Array                

Manufacturer

The name of the company who fabricated the asset.

manufacturer

Text

20

 

0

 

 

 

 

 

Headloss

The maximum loss in pressure, caused by the asset, across its entire length (usually at peak flow).

headloss

Double

 

HEAD

2

 

0

 

 

 

Attachments

Click the button to display the Attachments Editor, used to attach and manage photos, sketches and other files associated with the network object.

See Attachments Editor and Common Data Fields for further details.

attachments Array                
General properties fields See Common Data Fields for details of field in the General properties section of the property sheet.                    
User defined properties fields See Common Data Fields - User Fields for details of fields in the User defined properties section of the property sheet.                    
Time series links

Click the button to display the Time Series Data Source Grid, which is used to specify or update the time series data streams that are linked to this treatment works.

tsdb_links                  

Network Data Fields

Further information about all the Network Object fields stored in the database can be found in the Network Data Fields section.

Treatment Works

Asset Grid