Valve Shut Off Data Fields

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

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

The following describes all the data which can be used to define a valve shut off.

Common Data Fields

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

Valve Shut Off Data

Database Table Name: wams_valve_shut_off

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

 

 

 

 

 
Location Address or description of site where the object is located. location text                
Valves

Valve schedule.

Show Columns

Database Names

Size, Type and Units

Defaults and Error Limits

Database Table Name: wams_valve_shut_off_valves

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
1 Valve ID Valve identifier valve_id Text 40     0      
2 Valve status

Database Value

Description
OPEN Open
CLOSED Closed
UNKNOWN Unknown

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

 status Text 20     0 0 0 0
3 Open direction

Database Value

Description
CLOCK Clockwise
ANTI Anticlockwise

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

 open_direction Text 20     0 0 0 0
4 Surface type

Database Value

Description
Road Road
Pavement Pavement
Field Field
Unpaved Unpaved

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

 surface_type Text 10     0 0 0 0
5 Additional information Any additional information regarding valve location or status. additional_information Text 50     0 0 0 0
6 Date/time closed Date-time that valve was closed. time_closed Date/Time       0 0 0 0
7 Date/time opened Date-time that valve was opened. time_opened Date/Time       0 0 0 0
8 Problem?

Database Value

Description
Yes Yes
No No

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

 problem Text 20     0 0 0 0
9 Notes Additional information notes Text 50     0 0 0 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.                    

Repairs

Scheduled Tasks

Repair Grid

Network Data Fields

Common Data Fields