Pump (Collection) Data Fields

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

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

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

Common Data Fields

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

Pump Data

Database Table Name: cams_pump

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

 

 

 

 

 

US node ID

Upstream node.

us_node_id

Text

40

 

0

 

 

 

 

 

DS node ID

Downstream node.

ds_node_id

Text

40

 

0

 

 

 

 

 

Owner

The proprietor of the asset.

owner

Text

64

 

0

 

 

 

 

 

System type

System type:

Database Value

Description

F

Foul

S

Surface

C

Combined

T

Transition

O

Overflow

U

Unspecified

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

system_type

Text

10

 

0

 

 

 

 

 

Type

The type of ancillary structure.

Database Value

Description

F

Fixed Discharge

R

Rotodynamic

S

Screw (Archimedean)

V

Variable Speed

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

type

Text

10

 

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

10

 

1

 

 

 

 

 
Pump station ID ID of pump station where the pump is located. pump_station_id Text 40   0          
Treatment works ID ID of the treatment works where the pump is located. pump_station_id Text 40   0          
Pump group

Pump group in the associated pumping station to which the pump belongs.

Pump group details are stored in the pumping station object.

 pump_group Text 40   0          

X Coord

X coordinate of the object.

x

Double

 

XY

2

 

 

 

 

 

Y Coord

Y coordinate of the object.

y

Double

 

XY

2

 

 

 

 

 

Branch ID

Numeric field used to identify to which long section the link is associated. (See Defining Branches for further information).

branch_id

Long Integer

 

 

0

 

 

 

 

 

Make

Pump make or manufacturer.

make

Text

30

 

1

 

 

 

 

 

Model

Pump model number.

model

Text

30

 

1

 

 

 

 

 

Serial No

Pump serial number.

serial_no

Text

30

 

1

 

 

 

 

 

Capacity

Rated discharge of pump.

capacity

Double

 

 

1

 

 

 

 

 

Switch on level

The upstream level at which the pump operates.

level_on

Double

 

Z

3

 

 

 

 

 

Switch off level

The upstream level at which the pump ceases operation.

level_off

Double

 

Z

3

 

 

 

 

 

Delay

The run-up time before the pump is operational at its design discharge.

delay

Double

 

TS

1

 

 

 

 

 

Discharge

Rate of flow delivered by pump.

discharge

Double

 

Q

3

 

 

 

 

 
Suction diameter Suction (inlet) diameter of the pump. suction_diameter Double   CAMS_PS 0          
Pressure diameter Pressure (outlet) diameter of the pump. pressure_diameter Double   CAMS_PS 0          
Nominal speed Rated speed from manufacturers documentation. nominal_speed Double   WN_AV 0          
Nominal flow Rated flow from manufacturers documentation. nominal_flow Double   IN_Q 2          
Nominal head Rated head from manufacturers documentation. nominal_head Double   WN_P 2          
Pump impeller Type of impeller. pump_impeller Text 40              
Manhole Manhole at which pump is located. manhole_id Text 40   0          
Number of stages Number of pump stages for multi-stage pumps. num_stages Long Integer     0          
Date serviced Date pump was last serviced. date_serviced Date / Time     0          
Control mechanism

Method by which pump state is controlled:

Database Value

Description
LEVEL Level
TIMED Timed

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

 control Text 10   0          
Power Power rating of pump. power Double   WN_POW 2          
Head discharge ID

The identifier of the head discharge table used by the pump.

Head discharge objects are defined on the Head discharge tab of the Asset Grid.

A new head discharge object can also be added using the button, located to the left of the Head discharge ID field. This displays the Insert New Head discharge Object option that allows you to add the new object.

 head_discharge_id Text 64   0          
Motor type Type of motor. motor_type Text 40              
Motor manufacturer The name of the company who fabricated the asset. motor_manufacturer Text 40              
Motor model Model number of the pump motor. motor_model Text 40              
Motor serial number Serial number of pump motor. motor_serial_number Text 30   0          
Motor capacity Capacity of the pump motor. motor_capacity Text 40              
Date motor installed The date of installation of the pump motor. date_motor_installed 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

 

 

 

 

 

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

Date of the most recent condition survey of the asset.

survey_date

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

 

 

 

 

 
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 data fields See Common Data Fields for details of field in the General properties section of the property sheet.                    
User defined properties data 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.

 tsdb_links                  

Pump (Collection)

Asset Grid