Valve Maintenance Data Fields

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

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

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

Common Data Fields

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

Valve Maintenance Data

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

Valve ID

Valve identifier.

valve_id

Text

Location

Address or description of site at which asset is located.

location

Text

100

Maintenance type

Database Value	Description
EXERCISE	Exercise
INSPECTION	Inspection
REPAIR	Repair
REPLACE	Replace

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

maintenance_type

Text

X coordinate

X coordinate of the object.

Double

Y coordinate

Y coordinate of the object.

Double

Diameter

Valve diameter.

diameter

Double

CAMS_PS

Valve shut off ID

ID of associated valve shut off object.

valve_shut_off_id

Text

Action taken

Database Value	Description
REALIGN	Realign Box
REPACK	Repack
REPAIR	Repair Nut
REPLACE	Replace Valve
UNFREEZE	Unfreeze
UNSTICK	Unstick Lid

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

action_taken

Text

Recommended action

Database Value	Description
REALIGN	Realign Box
REPACK	Repack
REPAIR	Repair Nut
REPLACE	Replace Valve
UNFREEZE	Unfreeze
UNSTICK	Unstick Lid

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

recommended_action

Text

Number of turns

Number of turns to fully open / fully close valve.

num_turns

Long Integer

Drive type

Database Value	Description
MANUAL	Manual
MOTORISED	Motorised

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

drive_type

Text

Valve control type

Database Value	Description
EP	Equal Percentage
LINEAR	Linear
QUICK	Quick Opening

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

valve_control_type

Text

Open direction

Database Value	Description
ANTI	Anticlockwise
CLOCK	Clockwise

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

open_direction

Text

Exercise %

exercise_percent

Long Integer

Initial valve position

Database Value	Description
CLOSED	Closed
OPEN	Open
PARTIAL	Partial

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

initial_valve_position

Text

Nut condition

Database Value	Description
GOOD	Good
FAIR	Fair
POOR	Poor
MISSING	Missing

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

nut_condition

Text

Stem condition

Database Value	Description
GOOD	Good
FAIR	Fair
POOR	Poor
MISSING	Missing

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

stem_condition

Text

Packing condition

Database Value	Description
GOOD	Good
FAIR	Fair
POOR	Poor
MISSING	Missing

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

packing_condition

Text

Cap condition

Database Value	Description
GOOD	Good
FAIR	Fair
POOR	Poor
MISSING	Missing

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

cap_condition

Text

Valve box type

Database Value	Description
R	Round
S	Square

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

valve_box_type

Text

Valve box size

Valve box dimension.

valve_box_size

Double

CAMS_PS

Valve box depth

Valve box dimension.

valve_box_depth

Double

CAMS_PS

Material

Database Value	Description
CI	Cast Iron
DI	Ductile Iron
C	Concrete
PE	Polyethylene

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

material

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.