General Maintenance Data Fields (Distribution)

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

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.

Text

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

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

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

Location

Address or description of site at which asset is located.

location

Text

100

X coordinate

X coordinate of the object.

Double

Y coordinate

Y coordinate of the object.

Double

Valve shut off ID

ID of associated valve shut off object.

valve_shut_off_id

Text

Asset type

Type of asset associated with the maintenance:

Database Value	Description
wams_borehole	Borehole
wams_data_logger	Data Logger
wams_fitting	Fitting
wams_general_asset	General asset
wams_generator	Generator
wams_hydrant	Hydrant
wams_manhole	Manhole
wams_meter	Meter
wams_pipe	Pipe
wams_property	Property
wams_pump	Pump
wams_pump_station	Pump Station
wams_surface_source	Surface Source
wams_tank	Tank
wams_valve	Valve
wams_wtw	Treatment Works
wams_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

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

Pipe ID (deprecated)

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

pipe_id

Text

Property ID (deprecated)

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

property_id

Text

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.