Hydrant Maintenance Data Fields
Hydrant Maintenance data can be edited on either the Hydrant Maintenance Grid Window of the Repair Grid or the Hydrant Maintenance Property Sheet.
To view and edit all hydrant maintenance data, use the Property Sheet.
The following describes all the data which can be used to define hydrant maintenance.
Common Data Fields Fields that are common to the majority of objects can be found in the Common Fields topic.
Hydrant Maintenance Data
Database Table Name: wams_hydrant_maintenance
|
Field Name |
Help Text |
Database Field |
Size |
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 |
|
|
|
|
|
||||||||||||
|
Maintenance type |
The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog. |
maintenance_type |
Text |
40 |
|
0 |
|
|
|
|
|
||||||||||||
|
Hydrant ID |
ID of hydrant to which the maintenance task applies. |
hydrant_id |
Text |
40 |
|
0 |
|
|
|
|
|
||||||||||||
| Hydrant type |
Type of hydrant maintenance is to be carried out on:
The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog. |
hydrant_type | Text | 10 | 0 | ||||||||||||||||||
| Valve shut off ID | ID of associated valve shut off object. | valve_shut_off_id | Text | 40 | 0 | ||||||||||||||||||
| Cause |
Reason maintenance is required on hydrant:
The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog. |
cause | Text | 100 | 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 |
|
|
|
|
|
||||||||||||
| Barrel diameter | Diameter of hydrant barrel. | barrel_diameter | Double | CAMS_PS | 0 | 0 | |||||||||||||||||
| Barrel height | Height of hydrant barrel. | barrel_height | Double | CAMS_PS | 0 | 0 | |||||||||||||||||
| Bury depth | Distance from hydrant inlet (top of connecting pipe) to ground level. | bury_depth | Double | Y | 0 | 0 | |||||||||||||||||
| Nozzle height | Height of nozzle. | nozzle_height | Double | CAMS_PS | 0 | 0 | |||||||||||||||||
| Nozzle diameter 1 | Diameter of hydrant nozzle 1. | nozzle_diameter_1 | Double | CAMS_PS | 0 | 0 | |||||||||||||||||
| Nozzle diameter 2 | Diameter of hydrant nozzle 2. | nozzle_diameter_2 | Double | CAMS_PS | 0 | 0 | |||||||||||||||||
| Nozzle diameter 3 | Diameter of hydrant nozzle 3. | nozzle_diameter_3 | Double | CAMS_PS | 0 | 0 | |||||||||||||||||
| Nozzle thread type |
The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog. |
nozzle_thread_type | Text | 20 | 0 | ||||||||||||||||||
| Riser length | Length of hydrant riser. | riser_length | Double | CAMS_PS | 0 | 0 | |||||||||||||||||
| Riser diameter | Diameter of hydrant riser. | riser_diameter | Double | CAMS_PS | 0 | 0 | |||||||||||||||||
| Valve size | Diameter of hydrant valve. | valve_size | Double | CAMS_PS | 0 | 0 | |||||||||||||||||
| Valve type | Type of hydrant valve. | valve_type | Text | 20 | 0 | ||||||||||||||||||
| Valve turns | Number of turns required to fully open hydrant valve from fully closed. | valve_turns | Long Integer | 0 | |||||||||||||||||||
| Valve open direction |
The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog. |
valve_open_direction | Text | 20 | 0 | ||||||||||||||||||
| Nozzle outlet configuration |
The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog. |
nozzle_outlet_config | Text | 10 | 0 | ||||||||||||||||||
| Temperature | Temperature of water at time maintenance task carried out. | temperature | Double | CF | 0 | ||||||||||||||||||
| Date out of service | Date-time at which hydrant taken out of service for maintenance. | date_out_of_service | Date / Time | 0 | |||||||||||||||||||
| Date back in service | Date-time at which hydrant was reinstated after maintenance carried out. | date_back_in_service | Date / Time | 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 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. |
button to display the 