Pump Station Mechanical Maintenance Data Fields (Collection)

Pump Station Mechanical Maintenance data can be edited on either the Pump Station Mechanical Maintenance Grid Window of the Repair Grid or the Pump Station Mechanical Maintenance Property Sheet.

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

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

Common Data Fields

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

Pump Station Mechanical Maintenance Data

Database Table Name: cams_pump_station_mm

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

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.

Text

Pump station ID

ID of pump station at which maintenance was carried out.

pump_station_id

Text

Weather

Weather conditions at time maintenance was carried out:

Database Value	Description
Dry	Dry
Showers	Showers
Rain	Rain
Heavy rain	Heavy rain
Snow	Snow

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

weather

Text

Maintenance type

Reason for maintenance:

Database Value	Description
Emergency	Emergency
Mechanical	Mechanical
Electrical	Electrical
Preventative	Preventative

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

maintenance_type

Text

Defects found

Indication of whether defects were found:

Database Value	Description
Yes	Yes
No	No
N/A	N/A

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

defects_found

Text

General comments

General comments relating to the maintenance.

general_comments

Text

255

Further action

Notes on any further action to be taken subsequent to the maintenance.

further_action

Text

100

X coordinate

X coordinate of maintenance location.

Double

Y coordinate

Y coordinate of maintenance location.

Double

Sluice valves status

Indication of status:

Database Value	Description
Inspected	Inspected
Maintained	Maintained
Problem found	Problem found
Not applicable	Not applicable
Not inspected	Not inspected
Not maintained	Not maintained

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

sluice_valves_status

Text

Compressor 1 filters

See Sluice valves status

compressor_1_filters

Text

Compressor 2 filters

See Sluice valves status

compressor_2_filters

Text

Compressor 1 oil change

See Sluice valves status

compressor_1_oil_change

Text

Compressor 2 oil change

See Sluice valves status

compressor_2_oil_change

Text

Ejector 1

See Sluice valves status

ejector_1

Text

Ejector 2

See Sluice valves status

ejector_2

Text

Comminutor 1

See Sluice valves status

comminutor_1

Text

Comminutor 2

See Sluice valves status

comminutor_2

Text

Glands

See Sluice valves status

glands

Text

Screens

See Sluice valves status

screens

Text

Grids to wet well

See Sluice valves status

grids_to_wet_well

Text

Pipework delivery

See Sluice valves status

pipework_delivery

Text

Pipework suction

See Sluice valves status

pipework_suction

Text

Submersible pumps

See Sluice valves status

submersible_pumps

Text

Safety equipment

See Sluice valves status

safety_equipment

Text

Overflow flap valve

See Sluice valves status

overflow_flap_valve

Text

Generator

See Sluice valves status

generator

Text

Rising main

See Sluice valves status

rising_main

Text

Pumps

Details of pumps in pumping station.

Database Table Name: cams_pump_station_mm_pumps

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

Pump ID

Pump identifier.

pump_id

Text

Pump

Status of pump maintainance:

Database Value	Description
Inspection complete	Inspection complete
Maintenance complete	Maintenance complete
Problem found	Problem found

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

pump

Text

Propshaft bearings

Status of propshaft bearings maintenance:

Database Value	Description
Inspection complete	Inspection complete
Greasing complete	Greasing complete
Problem found	Problem found

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

propshaft_bearings

Text

Non-return valve

Status of non-return valve maintenance:

Database Value	Description
Inspection complete	Inspection complete
Maintenance complete	Maintenance complete
Problem found	Problem found

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

non_return_valve

Text

Comments

Any additional comments regarding pump maintenance.

comments

Text

100

pumps

Array

Scheduled Task fields

See Common Data Fields - Scheduled Task fields for details of all fields in the Schedule Info, Progress Info and Resources sections of the property sheet.

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.