Pump Station (Distribution) Data Fields

Pump Station (Distribution) data can be edited on either the Pump Station Grid Window of the Asset Grid or the Pump Station Property Sheet.

To view and edit all pump station data, use the Property Sheet.

The following describes all the data which can be used to define a pump station.

Common Data Fields

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

Pump Station Data

Database Table Name: wams_pump_station

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

 

 

 

 

 

 

 

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 details

Address or description of site at which asset is located.

location

Text

100

 

0

 

 

 

 

 

X coord

X coordinate of the object.

x

Double

 

XY

1

 

 

 

 

 

Y coord

Y coordinate of the object.

y

Double

 

XY

1

 

 

 

 

 

Type

The type of ancillary structure.

type

Text

10

 

0

 

 

 

 

 

Number of pumps

The number of pumps in the pump station.

num_pumps

Long Integer

 

 

0

 

 

 

 

 

Duty head

Overall (designed) duty head of the pump station.

duty_head

Double

 

WN_P

2

 

 

 

 

 

Duty flow

Overall (designed) duty flow of the pump station.

duty_flow

Double

 

IN_Q

2

 

 

 

 

 

Power

Overall (designed) hydraulic power of pump station.

power

Double

 

WN_POW

2

 

 

 

 

 

Power consumption

Electrical power consumption.

power_consumption

Double

 

WN_POW

2

 

 

 

 

 

Tariff name

Name of the electricity tariff used for the pump station.

tariff_name

Text

20

 

 

 

 

 

 

 

Confined spaces classification

Code or description indicating severity of risks associated with carrying out work at the asset due to confined spaces.

confined_spaces

Text

20

 

 

 

 

 

 

 

Pump to waste facilities

Type of facilities available for pumping to waste.

pump_to_waste_facilities

Text

40

 

 

 

 

 

 

 

Locked

Check box indicating whether access to pumping station is locked.

locked

Boolean

 

 

 

 

 

 

 

 
Access for vehicle

Database Value

Description

VAN

Van

TANKER

Tanker

NONE

None

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

 vehicle_access Text 32   0          
Turning for vehicle

Database Value

Description

VAN

Van

TANKER

Tanker

NONE

None

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

 vehicle_turning Text 32   0          
Fencing

Database Value

Description

CHAIN

Chain-Link

TIMBER

Timber

OTHER

Other

NONE

None

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

 fencing Text 32   0          
Access road Name or description of location of road on which pump station site entrance is located. access_road Text 32   0          
Access difficulties Comments on any difficulties that may be encountered when entering the site. access_diff Text 32   0          
Gates

Database Value

Description

STEEL

Steel

TIMBER

Timber

OTHER

Other

NONE

None

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

 gates Text 32   0          
Surroundings

Database Value

Description

URBAN

Urban

RURAL

Rural

RESID

Residential

COMM

Commercial

IND

Industrial

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

 surroundings Text 32   0          
Non-operational areas

Database Value

Description

GRASS

Grass

SHINGLE

Shingle

OTHER

Other

NONE

None

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

 non_op_area Text 32   0          
Superstructure

Database Value

Description

BRICK

Brick

IND

Industrial

OTHER

Other

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

 superstructure Text 32   0          
Roof

Database Value

Description

PTILE

Pitched/Tile

PSLATE

Pitched/Slate

PSHEET

Pitched/Sheet

FTILE

Flat/Tile

FSLATE

Flat/Slate

FSHEET

Flat/Sheet

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

 roof Text 32   0          
Substructre

Database Value

Description

WET

Wet Well

DRY

Dry Well

SUB

Submersible

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

 substructure Text 32   0          
Access to well

Database Value

Description

NONE

None

LADDER

Ladder

OTHER

Other

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

 well_access Text 32   0          
Well construction

Database Value

Description

BRICK

Brick

PCC

Precast concrete

ISC

Insitu concrete

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

 well_constr Text 32   0          
Well ventilation

Database Value

Description

FORCE

Forced

VENT

Vent pipe

OTHER

Other

NONE

None

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

 well_ventilation Text 32   0          
Well area Area of well cover. well_area Double   NA 2          
Well cover level Height above datum of well cover. well_cover_level Double   Z 3          
Distance from habitation Distance of site from housing. dist_to_habitation Double   XY 1          
Type of starter

Database Value

Description
Softstart Softstart
VSD VSD
DOL DOL
StartDelta StartDelta

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

 type_of_starter Text 40              
Construction date Construction or installation date. This is date from which depreciation costs will be incurred for depreciation reports. constr_date Date / Time     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

2

 

 

 

 

 

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

2

 

 

 

 

 

Replacement cost

The estimated cost for completely replacing an asset.

replace_cost

Double

 

WN_COST

2

 

 

 

 

 

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 pumping station.

 

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        

 
Array                  
Available telemetry

Click the button to display details of the telemetry data available.

 

Database Table Name: wams_pump_station_telemetry

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 Telemetry source

Database Value

Description
Mains failure Mains failure
High water level in wet well High water level in wet well
High water level in dry well High water level in dry well
Motor overload Motor overload
Pump failure Pump failure
Generator running Generator running
Overflow operating Overflow operating

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

 telemetry_source Text 40          

 
Array                  
SCADA panel serial no Serial number of SCADA panel. Text 20                
SCADA pole height Height of SCADA pole. Double     Y 2          
SCADA signal tower SCADA signal tower. Text 40                
Levels

Click the button to display details of the position of electrodes/floats.

 

Database Table Name: wams_pump_station_levels

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 Position

Database Value

Description
Duty start Duty start
Assist start Assist start
Standby start Standby start
All stop All stop
High alarm level High alarm level
Overflow alarm Overflow alarm

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

 position Text 40          

 
2 TBM Level Temporary Bench Mark Level. tbm_level Double   Y        

 
3 Depth to IL Depth to Invert Level. depth_to_il Double   Y        

 
4 Level Level above datum of sensor. level Double   Z        

 
Array                  
Level controller manufacturer Manufacturer of level controller. Text 40                
Level controller model Model of level controller. Text 40                
Flow meter type

Type of flow meter:

Database Value

Description
TYPE 1 Type 1
TYPE 2 Type 2

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

 Text 40                
Flow meter manufacturer Manufacturer of flow meter. Text 40                
Flow meter model Model of flow meter. Text 40                
Main breaker size Size of main breaker. Double     A 2          
MCC panel manufacturer Manufacturer of motor control centre panel. Text 40                
MCC panel model no Model number of motor control centre panel. Text 40                
Pump starter type

Type of pump starter:

Database Value

Description
TYPE 1 Type 1
TYPE 2 Type 2

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

 Text 40                
Pump starter size Size of pump starter. Double     A 2          
Pump breaker size Size of pump breaker. Double     A 2          
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 pump station.

 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.

Pump Station (Distribution)

Asset Grid