Meter Maintenance Data Fields
Meter Maintenance data can be edited on either the Meter Maintenance Grid Window of the Repair Grid or the Meter Maintenance Property Sheet.
To view and edit all meter maintenance data, use the Property Sheet.
The following describes all the data which can be used to define meter maintenance.
Common Data Fields Fields that are common to the majority of objects can be found in the Common Fields topic.
Meter Maintenance Data
Database Table Name: wams_meter_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 |
|
|
|
|
|
||||||||||
|
Meter ID |
Meter identifier. |
meter_id |
Text |
40 |
|
0 |
|
|
|
|
|
||||||||||
|
Location |
Address or description of site at which asset is located. |
location |
Text |
100 |
|
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 |
10 |
|
0 |
|
|
|
|
|
||||||||||
|
X coordinate |
X coordinate of the object. |
x |
Double |
|
XY |
2 |
|
|
|
|
|
||||||||||
|
Y coordinate |
Y coordinate of the object. |
y |
Double |
|
XY |
2 |
|
|
|
|
|
||||||||||
| Valve shut off ID | ID of associated valve shut off object. | valve_shut_off_id | Text | 40 | 0 | ||||||||||||||||
|
Action taken |
The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog. |
action_taken |
Text |
40 |
0 |
|
|
|
|
|
|||||||||||
|
Recommended action |
Recommended action to be taken. |
recommended_action |
Text |
40 |
0 |
|
|
|
|
|
|||||||||||
|
Cause for maintenance |
The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog. |
cause_for_maintenance |
Text |
40 |
|
0 |
|
|
|
|
|
||||||||||
|
Defect type |
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 |
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 |
|
|
|
|
|
||||||||||
|
Condition before |
Description of condition of asset before maintenance task carried out. |
condition_before |
Text |
40 |
|
0 |
|
|
|
|
|
||||||||||
|
Condition after |
Description of condition of asset after maintenance task carried out. |
condition_after |
Text |
40 |
0 |
|
|
|
|
|
|||||||||||
|
Failure mode |
The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog. |
failure_mode |
Text |
40 |
0 |
|
|
|
|
|
|||||||||||
|
Failure date |
Date of meter failure. |
failure_date |
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 