Meter Test Data Fields
Meter Test data can be edited on either the Meter Test Grid Window of the Survey Grid or the Meter Test Property Sheet.
To view and edit all meter test data, use the Property Sheet.
The following describes all the data which can be used to define a meter test.
Common Data Fields Fields that are common to the majority of objects can be found in the Common Fields topic.
Meter Test Data
Database Table Name: wams_meter_test
|
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 |
ID of meter to be tested. |
meter_id |
Text |
40 |
|
0 |
|
|
|
|
|
||||||
|
Location |
Address or description of site at which associated asset is located. |
location |
Text |
100 |
|
0 |
|
|
|
|
|
||||||
|
Pass / fail |
The options available in the dropdown list depend on the choices defined in the Standards and Choice Lists dialog. |
pass_fail |
Text |
20 |
|
0 |
|
|
|
|
|
||||||
|
Overall efficiency |
Meter efficiency determined from test. |
overall_efficiency |
Double |
|
2 |
|
|
|
|
|
|||||||
|
X coordinate |
X coordinate of the object. |
x |
Double |
|
XY |
2 |
|
|
|
|
|
||||||
|
Y coordinate |
Y coordinate of the object. |
y |
Double |
|
XY |
2 |
|
|
|
|
|
||||||
|
Low flow |
Flow rate when carrying out low flow test. |
low_flow |
Double |
|
IN_Q |
2 |
|
|
|
|
|
||||||
|
Low flow pressure |
Pressure when carrying out low flow test. |
low_flow_pressure |
Double |
|
WN_P |
2 |
|
|
|
|
|
||||||
|
Low flow volume |
Volume of water recorded by meter when carrying out low flow test. |
low_flow_volume |
Double |
|
VO |
2 |
|
|
|
|
|
||||||
|
Low flow accuracy |
Percentage error of meter reading against test meter. |
low_flow_accuracy |
Double |
|
|
2 |
|
|
|
|
|
||||||
|
Low flow start |
Start date/time of low flow test. |
low_flow_start |
Date / Time |
|
0 |
|
|
|
|
|
|||||||
|
Low flow end |
End date/time of low flow test. |
low_flow_end |
Date / Time |
|
0 |
|
|
|
|
|
|||||||
|
Low side register low flow |
Flow rate when carrying out low flow test on low side register of compound meter. |
low_side_reg_low_flow |
Double |
|
IN_Q |
2 |
|
|
|
|
|
||||||
|
Low side register low flow volume |
Volume recorded by low side register of compound meter when carrying out low flow test. |
low_side_reg_low_flow_volume |
Double |
|
VO |
2 |
|
|
|
|
|
||||||
|
Low side register low flow start |
Start date/time of low flow test |
low_side_reg_low_flow_start |
Date / Time |
|
0 |
|
|
|
|
|
|||||||
|
Low side register low flow end |
End date/time of low flow test. |
low_side_reg_low_flow_end |
Date / Time |
|
0 20 |
|
|
|
|
|
|||||||
|
High side register low flow |
Flow rate when carrying out low flow test on high side register of compound meter. |
high_side_reg_low_flow |
Double |
|
IN_Q |
2 |
|
|
|
|
|
||||||
|
High side register low flow volume |
Volume recorded by high side register of compound meter when carrying out low flow test. |
high_side_reg_low_flow_volume |
Double |
|
VO |
2 |
|
|
|
|
|
||||||
|
High side register low flow start |
Start date/time of low flow test. |
high_side_reg_low_flow_start |
Date / Time |
|
0 |
|
|
|
|
|
|||||||
|
High side register low flow end |
End date/time of low flow test. |
high_side_reg_low_flow_end |
Date / Time |
|
|
0 |
|
|
|
|
|
||||||
|
Total flow low |
Sum of Low side and High side register flows for compound meters. |
total_flow_low |
Double |
|
IN_Q |
2 |
|
|
|
|
|
||||||
|
Total flow volume low |
Sum of Low side and High side register volumes for compound meters. |
total_flow_volume_low |
Double |
|
VO |
2 |
|
|
|
|
|
||||||
|
Total flow efficiency low |
Percentage error of meter reading against test meter. |
total_flow_efficiency_low |
Double |
|
|
2 |
|
|
|
|
|
||||||
|
Medium flow |
Flow rate when carrying out medium flow test |
medium_flow |
Double |
|
IN_Q |
2 |
|
|
|
|
|
||||||
|
Medium flow pressure |
Pressure when carrying out medium flow test. |
medium_flow_pressure |
Double |
|
WN_P |
2 |
|
|
|
|
|
||||||
|
Medium flow volume |
Volume of water recorded by meter when carrying out medium flow test. |
medium_flow_volume |
Double |
|
VO |
2 |
|
|
|
|
|
||||||
|
Medium flow accuracy |
Percentage error of meter reading against test meter. |
medium_flow_accuracy |
Double |
|
|
2 |
|
|
|
|
|
||||||
|
Medium flow start |
Start date/time of medium flow test. |
medium_flow_start |
Date / Time |
|
0 |
|
|
|
|
|
|||||||
|
Medium flow end |
End date/time of medium flow test. |
medium_flow_end |
Date / Time |
|
0 |
|
|
|
|
|
|||||||
|
Low side register medium flow |
Flow rate when carrying out medium flow test on low side register of compound meter |
low_side_reg_medium_flow |
Double |
|
IN_Q |
2 |
|
|
|
|
|
||||||
|
Low side register medium flow volume |
Volume recorded by low side register of compound meter when carrying out medium flow test. |
low_side_reg_medium_flow_volume |
Double |
|
VO |
2 |
|
|
|
|
|
||||||
|
Low side register medium flow start |
Start date/time of medium flow test. |
low_side_reg_medium_flow_start |
Date / Time |
|
0 |
|
|
|
|
|
|||||||
|
Low side register medium flow end |
End date/time of medium flow test. |
low_side_reg_medium_flow_end |
Date / Time |
|
0 20 |
|
|
|
|
|
|||||||
|
High side register medium flow |
Flow rate when carrying out medium flow test on high side register of compound meter. |
high_side_reg_medium_flow |
Double |
|
IN_Q |
2 |
|
|
|
|
|
||||||
|
High side register medium flow volume |
Volume recorded by high side register of compound meter when carrying out high flow test. |
high_side_reg_medium_flow_volume |
Double |
|
VO |
2 |
|
|
|
|
|
||||||
|
High side register medium flow start |
Start date/time of medium flow test. |
high_side_reg_medium_flow_start |
Date / Time |
|
0 |
|
|
|
|
|
|||||||
|
High side register medium flow end |
End date/time of medium flow test. |
high_side_reg_medium_flow_end |
Date / Time |
|
|
0 |
|
|
|
|
|
||||||
|
Total flow medium |
Sum of Low side and High side register flows for compound meters. |
total_flow_medium |
Double |
|
IN_Q |
2 |
|
|
|
|
|
||||||
|
Total flow volume medium |
Sum of Low side and High side register volumes for compound meters. |
total_flow_volume_medium |
Double |
|
VO |
2 |
|
|
|
|
|
||||||
|
Total flow efficiency medium |
Percentage error of meter reading against test meter. |
total_flow_efficiency_medium |
Double |
|
|
2 |
|
|
|
|
|
||||||
|
High flow |
Flow rate when carrying out high flow test. |
high_flow |
Double |
|
IN_Q |
2 |
|
|
|
|
|
||||||
|
High flow pressure |
Pressure when carrying out high flow test. |
high_flow_pressure |
Double |
|
WN_P |
2 |
|
|
|
|
|
||||||
|
High flow volume |
Volume of water recorded by meter when carrying out high flow test. |
high_flow_volume |
Double |
|
VO |
2 |
|
|
|
|
|
||||||
|
High flow accuracy |
Percentage error of meter reading against test meter. |
high_flow_accuracy |
Double |
|
|
2 |
|
|
|
|
|
||||||
|
High flow start |
Start date/time of high flow test. |
high_flow_start |
Date / Time |
|
0 |
|
|
|
|
|
|||||||
|
High flow end |
End date/time of high flow test. |
high_flow_end |
Date / Time |
|
0 |
|
|
|
|
|
|||||||
|
Low side register high flow |
Flow rate when carrying out high flow test on low side register of compound meter. |
low_side_reg_high_flow |
Double |
|
IN_Q |
2 |
|
|
|
|
|
||||||
|
Low side register high flow volume |
Volume recorded by low side register of compound meter when carrying out high flow test. |
low_side_reg_high_flow_volume |
Double |
|
VO |
2 |
|
|
|
|
|
||||||
|
Low side register high flow start |
Start date/time of high flow test. |
low_side_reg_high_flow_start |
Date / Time |
|
|
0 |
|
|
|
|
|
||||||
|
Low side register high flow end |
End date/time of high flow test. |
low_side_reg_high_flow_end |
Date / Time |
|
0 20 |
|
|
|
|
|
|||||||
|
High side register high flow |
Flow rate when carrying out high flow test on high side register of compound meter. |
high_side_reg_high_flow |
Double |
|
IN_Q |
2 |
|
|
|
|
|
||||||
|
High side register high flow volume |
Volume recorded by high side register of compound meter when carrying out high flow test. |
high_side_reg_high_flow_volume |
Double |
|
VO |
2 |
|
|
|
|
|
||||||
|
High side register low flow start |
Start date/time of high flow test. |
high_side_reg_low_flow_start |
Date / Time |
|
0 |
|
|
|
|
|
|||||||
|
High side register high flow end |
End date/time of high flow test. |
high_side_reg_high_flow_end |
Date / Time |
|
|
0 |
|
|
|
|
|
||||||
|
Total flow high |
Sum of Low side and High side register flows for compound meters. |
total_flow_high |
Double |
|
IN_Q |
2 |
|
|
|
|
|
||||||
|
Total flow volume high |
Sum of Low side and High side register volumes for compound meters. |
total_flow_volume_high |
Double |
|
VO |
2 |
|
|
|
|
|
||||||
|
Total flow efficiency high |
Percentage error of meter reading against test meter. |
total_flow_efficiency_high |
Double |
|
|
2 |
|
|
|
|
|
||||||
| 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 