Meter Data Fields

Meter data can be edited on either the Meter Grid Window of the Asset Grid or the Meter Property Sheet.

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

The following describes all the data which can be used to define a meter.

Common Data Fields

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

Meter Data

Database Table Name: wams_meter

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

A unique name for the asset. Upper and lower case letters are treated as being the same.

The ID is the primary key in the database for all objects. This means that the ID field must be unique for all objects of the same object type.

node_id

Text

Asset ID

An optional reference - usually the asset database name for this network object (if applicable).

asset_id

Text

Owner

The proprietor of the asset.

owner

Text

Area code

The zone ID in which the asset is contained.

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

area_code

Text

Operational status

The current functionality of the asset:

Database Value	Description
AB	Abandoned
STANDBY	Standby
INUSE	In Use

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

operational_status

Text

Planning status

The current situation of the asset in relation to construction.

planning_status

Text

Location

Address or description of site at which asset is located.

location

Text

100

Property ID

ID of the property associated to the meter.

property_id

Text

Account number

Customer account number for billing purposes.

account_number

Text

Lateral pipe ID

The ID of the pipe to which the lateral is attached.

lat_pipe_id

Text

Lateral distance from start node

The distance along a pipe from the start node of the pipe to the location of the lateral (hydrant, fitting etc.).

lat_distance

Double

Elevation

Elevation above datum level (usually sea level).

elevation

Double

-99.99

999.99

X coord

X coordinate of the object.

Double

Y coord

Y coordinate of the object.

Double

Meter reading

Reading taken from meter at the date specified in the Date read field.

meter_reading

Double

Date read

Date at which most recent reading was taken from the meter.

date_read

Date / Time

Type

The type of meter:

Database Value	Description
BULK	Bulk
REV	Revenue
WOA	WOA
WSZ	WSZ
DMA	DMA
DOM	Domestic
IND	Industrial
TRANS	Transmission
CUR	Current
DET	Detector Check
PROP	Proportional
COMP	Compound

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

type

Text

Mechanism

Database Value	Description
EM	Electromagnetic
MECH	Mechanical
INS	Insertion Probe
PRESS	Pressure Diff
WOLT	Woltman Turbine
DISP	Pos Displacement
UNKNOWN	Unknown

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

mechanism

Text

Configuration

Database Value	Description
INLINE	Inline
BYPASS	Bypass
UNKNOWN	Unknown

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

configuration

Text

Model

Manufacturer's model number.

model

Text

Serial number

Meter serial number.

serial_number

Text

Manufacturer

The name of the company who fabricated the asset.

manufacturer

Text

Power supply

Database Value	Description
MAIN	Mains
BAT	Battery
NONE	None
UNKNOWN	Unknown

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

power_supply

Text

Battery life

Design life of meter battery.

battery_life

Double

Strainer fitted

Check box indicating whether the meter has a strainer fitted.

strainer_fitted

Boolean

Database Value	Description
ROUND	Round
RECT	Rectangular

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

register_type

Text

Meter register identifier.

register_id

Text

Flow type

Database Value	Description
UNI	Uni-directional
BI	Bi-directional

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

flow_type

Text

Monitoring type

Database Value	Description
MAN	Manual Read
TELE	Telemetry
SCADA	Scada
LOG	Logger
CHART	Chart

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

monitoring_type

Text

Monitoring frequency

Time intervals at which readings are recorded.

monitoring_frequency

Double

Measured min flow

Minimum flow recorded by meter.

measured_min_flow

Double

IN_Q

Measured max flow

Maximum flow recorded by meter.

measured_max_flow

Double

IN_Q

Min flow

Meter design minimum flow.

min_flow_rate

Double

IN_Q

Max flow

Meter design maximum flow.

max_flow_rate

Double

IN_Q

Headloss at maximum flow

The loss of pressure across the meter at maximum flow.

max_flow_headloss

Double

HEAD

Diameter

Meter diameter.

diameter

Double

CAMS_PS

Manhole

Reference ID of manhole in which meter is located.

manhole_id

Text

AMR type

Database Value	Description
T1	AMR Type 1
T2	AMR Type 2

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

amr_type

Text

AMR ID

Automatic Meter Reading identifier.

amr_id

Text

AMR read type

Database Value	Description
T	Touch
R	Radio

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

amr_read_type

Text

Condition grade

A measure of asset condition.

condition_grade

Long Integer

Critical

A measure of the likely impact of asset failure.

criticality

Text

Security

The security of the asset from unauthorised access/tampering:

Database Value	Description
A	Vulnerable
B	Moderate Risk
C	Secure

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

security

Text

Condition survey date

Date of the most recent condition survey of the asset.

survey_date

Date / Time

GPS survey date

The date of the most recent GPS survey (DD/MM/YYYY).

gps_survey_date

Date / Time

Date installed

The date when the asset was installed (DD/MM/YYYY). Used in costing reports in conjunction with the cost index.

date_installed

Date / Time

Date cleaned

The date the asset last underwent maintenance to improve performance (swabbing, scouring).

date_cleaned

Date / Time

Date renewed

The date the asset was last restored to its initial condition (replaced, relined).

date_renewed

Date / Time

Installation cost

The original installation cost of the asset. This generally includes all costs incurred (e.g. mantime, asset purchase costs etc). This information is used in depreciation reports.

install_cost

Double

WN_COST

Inspection cost

Estimated cost of asset inspection.

inspection_cost

Double

WN_COST

Expected lifetime

The expected lifetime of the asset. This is used in depreciation reports as the period over which installation costs may be depreciated.

lifetime

Long Integer

Rehabilitation cost

Rehabilitation costs to be incurred in bringing the asset to an acceptable condition. This is used in rehabilitation reports.

rehab_cost

Double

WN_COST

Replacement cost

The estimated cost for completely replacing an asset.

replace_cost

Double

WN_COST

Current value

Current value of the asset. This gives an indication of depreciation costs as depreciation cost = installation cost - current value.

current_value

Double

WN_COST

Soil type

A description of the material surrounding the asset that could influence condition grading and rehabilitation methods:

Database Value	Description
PEAT	Peat
CHALK	Chalk
CLAY	Clay
SHALE	Shale
SAND	Sand

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

soil_type

Text

Surface type

A description of the ground use in close proximity to the asset that may influence access/costs for monitoring, maintenance or construction purposes:

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

Headloss

The maximum loss in pressure, caused by the asset, across its entire length (usually at peak flow).

headloss

Double

HEAD

Name groups

Click the

button to display the Name Groups Editor, used to view and edit the Asset Name Groups to which the object belongs.

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 data fields

See Common Data Fields for details of field in the General properties section of the property sheet.

User defined properties data fields

See Common Data Fields - User Fields for details of fields in the User defined properties section of the property sheet.

Time series links

Click the button to display the Time Series Data Source Grid, which is used to specify or update the time series data streams that are linked to this meter.

tsdb_links

Meter

Asset Grid