General Maintenance Data Fields (Collection)

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

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

The following describes all the data which can be used to define general maintenance.

Common Data Fields

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

General Maintenance Data

Database Table Name: cams_general_maintenance

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

 

 

 

 

 

Maintenance type

Database Value

Description

TYPE1

Maintenance Type 1

TYPE2

Maintenance Type 2

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

maintenance_type

Text

10

 

0

 

 

 

 

 

Defect type

Database Value

Description

TYPE1

Defect Type 1

TYPE2

Defect Type 2

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

defect_type

Text

15

 

0

 

 

 

 

 

Cause of failure

Database Value

Description

TYPE1

Failure Type 1

TYPE2

Failure Type 2

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

cause_of_failure

Text

40

 

0

 

0

0

0

0

Location

Address or description of site at which asset is located.

location

Text

100

 

0

 

 

 

 

 

X coordinate

X coordinate of the object.

x

Double

 

XY

2

 

 

 

 

 

Y coordinate

Y coordinate of the object.

y

Double

 

XY

2

 

 

 

 

 
Asset type

Type of asset associated with the maintenance:

Database Value

Description
cams_ancillary User Ancillary
cams_channel Channel
cams_connection_node Connection Node
cams_connection_pipe Connection Pipe
cams_data_logger Data Logger
cams_defence_structure Defence Structure
cams_defence_area Defence Area
cams_flume Flume
cams_general_asset General Asset
cams_generator Generator
cams_manhole Node
cams_orifice Orifice
cams_outlet Outlet
cams_property Property
cams_pump Pump
cams_pump_station Pump Station
cams_screen Screen
cams_siphon Siphon
cams_sluice Sluice
cams_storage Storage Area
cams_valve Valve
cams_vortex Vortex
cams_weir Weir
cams_wtw Treatment Works
cams_zone Zone

The dropdown list will also contain every user defined asset that has been specified for the network.

 asset_type Text 100              
Asset ID Asset ID of associated asset. asset_id Text 40              
US node ID Upstream node ID of associated pipe. us_node_id Text 40   0          
DS node ID Downstream node ID of associated pipe. ds_node_id Text 40   0          
Link suffix Link suffix of associated pipe. link_suffix Text 1   0          
PLR / asset ID Pipe reference code. plr Text 40   0          
Node ID (deprecated)

Node to which maintenance object is associated.

Note that this field has been superseded by the Asset type and Asset ID fields.

The deprecated field will be retained and may still be used, however use of the newer fields is recommended.

Tip

The Asset type and Asset ID fields provide a more flexible method of associating objects with the General Maintenance.

 node_id Text 40   0          
Connection pipe ID (deprecated)

ID of associated connection pipe.

Note that this field has been superseded by the Asset type and Asset ID fields.

The deprecated field will be retained and may still be used, however use of the newer fields is recommended.

Tip

The Asset type and Asset ID fields provide a more flexible method of associating objects with the General Maintenance.

 connection_pipe_id Text 40   0          
Property ID (deprecated)

ID of associated property.

Note that this field has been superseded by the Asset type and Asset ID fields.

The deprecated field will be retained and may still be used, however use of the newer fields is recommended.

Tip

The Asset type and Asset ID fields provide a more flexible method of associating objects with the General Maintenance.

 property_id Text 40   0          
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.                    

Scheduled Tasks

Repair Grid

Network Data Fields

Common Data Fields