Pump Station (Collection) Data Fields

Pump station 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: cams_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

Station 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 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

Current operational status:

Database Value

Description

AB

Abandoned

INUSE

In Use

STANDBY

Standby

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

 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

2

 

 

 

 

 

Y coord

Y coordinate of the object.

y

Double

 

XY

2

 

 

 

 

 
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

 

 

 

 

 

Substructure

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 for ancillary assets. By analogy with pipe condition grades, this is usually a number in the range 1-5. Unlike pipe condition grade, there is no distinction between structural and service condition for ancillary assets.

condition_grade

Long Integer

 

 

0

 

 

 

 

 

Critical

A measure of the likely impact of asset failure. The WRC SRM uses the codes A, B, C to represent "A" sewers where failures would be expensive to "C" where failures would be relatively cheap.

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

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

2

 

 

 

 

 

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

CHALK

Chalk

CLAY

Clay

PEAT

Peat

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: cams_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                
Available telemetry

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

 

Database Table Name: cams_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          

 
available_telemetry Array                
SCADA panel serial no

Serial number of SCADA panel.

 scada_panel_serial_no Text 20              
SCADA pole height Height of SCADA pole. scada_pole_height Double   Y 2          
SCADA signal tower SCADA signal tower. scada_signal_tower Text 40              
Levels

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

 

Database Table Name: cams_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        

 
levels Array                
Level controller manufacturer Manufacturer of level controller. level_controller_man Text 40              
Level controller model Model of level controller. level_controller_model 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.

 flow_meter_type Text 40              
Flow meter manufacturer Manufacturer of flow meter. flow_meter_man Text 40              
Flow meter model Model of flow meter. flow_meter_model Text 40              
Main breaker size Size of main breaker. main_breaker_size Double   A 2          
MCC panel manufacturer Manufacturer of motor control centre panel. mcc_panel_manufacturer Text 40              
MCC panel model no Model number of motor control centre panel. mcc_panel_model_no 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.

 pump_starter_type Text 40              
Pump starter size Size of pump starter. pump_starter_size Double   A 2          
Pump breaker size Size of pump breaker. pump_breaker_size 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 (Collection)

Asset Grid