Network Data Fields

The objects in the Collection Network Asset Grid are:

Network Object	Data Fields Topic	Database Table Name (for CSV Import)
Connection node	Connection Node Data Fields	cams_connection_node
Connection pipe	Connection Pipe Data Fields	cams_connection_pipe
Data logger	Data Logger Data Fields (Collection)	cams_data_logger
Defence area	Defence Area Data Fields	cams_defence_area
Defence structure	Defence Structure Data Fields	cams_defence_structure
Channel	Channel Data Fields	cams_channel
Flume	Flume Data Fields	cams_flume
Generator	Generator Data Fields (Collection)	cams_generator
Head discharge	Head Discharge Data Fields	cams_head_discharge
Node	Node Data Fields	cams_manhole
Orifice	Orifice Data Fields	cams_orifice
Outlet	Outlet Data Fields	cams_outlet
Pipe	Pipe (Collection) Data Fields	cams_pipe
Pump	Pump (Collection) Data Fields	cams_pump
Pump station	Pump Station (Collection) Data Fields	cams_pump_station
Screen	Screen Data Fields	cams_screen
Siphon	Siphon Data Fields	cams_siphon
Sluice	Sluice Data Fields	cams_sluice
Storage area	Storage Area Data Fields	cams_storage
Treatment works	Treatment Works (Collection) Data Fields	cams_wtw
User ancillary	User Defined Ancillary Data Fields	cams_ancillary
Valve	Valve (Collection) Data Fields	cams_valve
Vortex	Vortex (Collection) Data Fields	cams_vortex
Weir	Weir Data Fields	cams_weir
General asset	General Asset Data Fields (Collection)	cams_general_asset
Asset network and user defined object functionality is only available if the InfoAsset Manager Suite option is enabled on your licence. Contact Innovyze for information about adding this option to your existing licence. User defined asset	User Defined Asset Data Fields	User defined table name. See User Defined Asset Data Fields for more information.

Asset Grid (Distribution)

The objects in the Distribution Network Asset Grid are:

Network Object	Data Fields Topic	Database Table Name (for CSV Import)
Borehole	Borehole Data Fields	wams_borehole
Data logger	Data Logger Data Fields (Distribution)	wams_data_logger
Fitting	Fitting Data Fields	wams_fitting
Generator	Generator Data Fields (Distribution)	wams_generator
Hydrant	Hydrant Data Fields	wams_hydrant
Manhole	Manhole Data Fields	wams_manhole
Meter	Meter Data Fields	wams_meter
Tank	Tank Data Fields	wams_tank
Pipe	Pipe (Distribution) Data Fields	wams_pipe
Pump	Pump (Distribution) Data Fields	wams_pump
Pump station	Pump Station (Distribution) Data Fields	wams_pump_station
Surface source	Surface Source Data Fields	wams_surface_source
Treatment works	Treatment Works (Distribution) Data Fields	wams_wtw
Valve	Valve (Distribution) Data Fields	wams_valve
General asset	General Asset Data Fields (Distribution)	wams_general_asset
Asset network and user defined object functionality is only available if the InfoAsset Manager Suite option is enabled on your licence. Contact Innovyze for information about adding this option to your existing licence. User defined asset	User Defined Asset Data Fields	User defined table name. See User Defined Asset Data Fields for more information.

Asset Grid (Asset)

The objects in the Asset Network Asset Grid are:

Network Object	Data Fields Topic	Database Table Name (for CSV Import)
User defined asset	User Defined Asset Data Fields	User defined table name. See User Defined Asset Data Fields for more information.

Zones Grid

The objects in the Zones Grid are:

Network Object	Data Fields Topic	Database Table Name (for CSV Import)
Zone	Zone Data Fields (Collection) Zone Data Fields (Distribution) Zone Data Fields (Asset)	cams_zone wams_zone ams_zone
Property	Property (Collection) Data Fields Property (Distribution) Data Fields	cams_property wams)property
Work package	Work Package (Collection) Data Fields Work Package (Distribution) Data Fields Work Package (Asset) Data Fields	cams_work_package wams_work_package ams_work_package
General line	General Line Data Fields (Collection) General Line Data Fields (Distribution)	cams_general_line wams_general_line
Asset network and user defined object functionality is only available if the InfoAsset Manager Suite option is enabled on your licence. Contact Innovyze for information about adding this option to your existing licence. User defined zone	User Defined Zone Data Fields	User defined table name. See User Defined Zone Data Fields for more information.
Asset network and user defined object functionality is only available if the InfoAsset Manager Suite option is enabled on your licence. Contact Innovyze for information about adding this option to your existing licence. User defined other object	User Defined Other Object Data Fields	User defined table name. See User Defined Other Object Data Fields for more information.

Resource Grid

The objects in the Resource Grid are:

Network Object	Data Fields Topic	Database Table Name (for CSV Import)
Resource	Resource Data Fields (Collection) Resource Data Fields (Distribution) Resource Data Fields (Asset)	cams_resource wams_resource ams_resource
Material	Material Data Fields (Collection) Material Data Fields (Distribution) Material Data Fields (Asset)	cams_material wams_material ams_material
Approval level	Approval Level Data Fields (Collection) Approval Level Data Fields (Distribution) Approval Level Data Fields (Asset)	cams_approval_level wams_approval_level ams_approval_level
Order	Order Data Fields (Collection) Order Data Fields (Distribution) Order Data Fields (Asset)	cams_order wams)order ams_order

Network Object

Data Fields Topic

Database Table Name (for CSV Import)

Resource

Resource Data Fields (Collection)

Resource Data Fields (Distribution)

Resource Data Fields (Asset)

cams_resource

wams_resource

ams_resource

Material

Material Data Fields (Collection)

Material Data Fields (Distribution)

Material Data Fields (Asset)

cams_material

wams_material

ams_material

Approval level

Approval Level Data Fields (Collection)

Approval Level Data Fields (Distribution)

Approval Level Data Fields (Asset)

cams_approval_level

wams_approval_level

ams_approval_level

Order

Order Data Fields (Collection)

Order Data Fields (Distribution)

Order Data Fields (Asset)

cams_order

wams)order

ams_order

Survey Grid

The objects in the Survey Grid are:

Network Object	Data Fields Topic	Database Table Name (for CSV Import)
CCTV survey (Collection Network only)	CCTV Survey Data Fields	cams_cctv_survey
Cross section survey (Collection Network only)	Cross Section Survey Data Fields	cams_cross_section_survey
Dye test (Collection Network only)	Dye Test Survey Data Fields	cams_dye_test
Flood defence survey (Collection Network only)	Flood Defence Surveys Data Fields	cams_defence_survey
FOG inspection (Collection Network only)	FOG Inspection Data Fields	cams_fog_inspection
General survey	General Survey Data Fields (Collection) General Survey Data Fields (Distribution)	cams_general_survey wams_general_survey
General survey line	General Survey Line Data Fields (Collection) General Survey Line Data Fields (Distribution)	cams_general_survey_line wams_general_survey_line
GPS survey	GPS Survey Data Fields (Collection) GPS Survey Data Fields (Distribution)	cams_gps_survey wams_gps_survey
Hydrant test (Distribution Network only)	Hydrant Test Data Fields	wams_hydrant_test
Leak detection survey (Distribution Network only)	Leak Detection Survey Data Fields	wams_leak_detection
Manhole survey	Manhole Survey Data Fields (Collection) Manhole Survey Data Fields (Distribution)	cams_manhole_survey wams_manhole_survey
Meter test (Distribution Network only)	Meter Test Data Fields	wams_meter_test
Monitoring survey	Monitoring Survey Data Fields (Collection) Monitoring Survey Data Fields (Distribution)	cams_mon_survey wams_mon_survey
Pipe sample (Distribution Network only)	Pipe Sample Data Fields	wams_pipe_sample
Pump station survey	Pump Station Survey Data Fields (Collection) Pump Station Survey Data Fields (Distribution)	cams_pump_station_survey wams_pump_station_survey
Smoke defect observation(Collection Network only)	Smoke Defect Observation Data Fields	cams_smoke_defect
Smoke test (Collection Network only)	Smoke Test Survey Data Fields	cams_smoke_test
Water quality survey	Water Quality Survey Data Fields (Collection) Water Quality Survey Data Fields (Distribution)	cams_water_quality_survey wams_water_quality_survey
Asset network and user defined object functionality is only available if the InfoAsset Manager Suite option is enabled on your licence. Contact Innovyze for information about adding this option to your existing licence. User defined survey	User Defined Survey Data Fields	User defined table name. See User Defined Survey Data Fields for more information.

Repair Grid

The objects in the Repair Grid are:

Network Object	Data Fields Topic	Database Table Name (for CSV Import)
Manhole repair	Manhole Repair Data Fields (Collection) Manhole Repair Data Fields (Distribution)	cams_manhole_repair wams_manhole_repair
Pipe repair	Pipe Repair Data Fields (Collection) Pipe Repair Data Fields (Distribution)	cams_pipe_repair wams_pipe_repair
Pipe clean (Collection Network only)	Pipe Clean Data Fields	cams_pipe_clean
General maintenance	General Maintenance Data Fields (Collection) General Maintenance Data Fields (Distribution)	cams_general_maintenance wams_general_maintenance
Hydrant maintenance (Distribution Network only)	Hydrant Maintenance Data Fields	wams_hydrant_maintenance
Meter maintenance (Distribution Network only)	Meter Maintenance Data Fields	wams_meter_maintenance
Pump station electrical maintenance	Pump Station Electrical Maintenance Data Fields (Collection) Pump Station Electrical Maintenance Data Fields (Distribution)	cams_pump_station_em wams_pump_station_em
Pump station mechanical maintenance	Pump Station Mechanical Maintenance Data Fields (Collection) Pump Station Mechanical Maintenance Data Fields (Distribution)	cams_pump_station_mm wams_pump_station_mm
Valve maintenance (Distribution Network only)	Valve Maintenance Data Fields	wams_valve_maintenance
Asset network and user defined object functionality is only available if the InfoAsset Manager Suite option is enabled on your licence. Contact Innovyze for information about adding this option to your existing licence. User defined repair	User Defined Repair Data Fields	User defined table name. See User Defined Repair Data Fields for more information.

Incidents Grid

The objects in the Incidents Grid are:

Network Object	Data Fields Topic	Database Table Name (for CSV Import)
Blockage incident (Collection Networks only)	Blockage Incident Data Fields	cams_incident_blockage
Burst incident (Distribution Networks only)	Burst Incident Data Fields	wams_incident_burst
Collapse incident (Collection Networks only)	Collapse Incident Data Fields	cams_incident_collapse
Customer complaint	Customer Complaint Data Fields (Collection) Customer Complaint Data Fields (Distribution)	cams_incident_complaint wams_incdient_complaint
Flooding incident (Collection Networks only)	Flooding Incident Data Fields	cams_incident_flooding
General incident	General Incident Data Fields (Collection) General Incident Data Fields (Distribution)	cams_incident_general wams_incident_general
Odour incident (Collection Networks only)	Odour Incident Data Fields	cams_incident_odor
Pollution incident (Collection Networks only)	Pollution Incident Data Fields	cams_incident_pollution
Water quality incident (Distribution Networks only)	Water Quality Incident Data Fields	wams_incident_wq
Asset network and user defined object functionality is only available if the InfoAsset Manager Suite option is enabled on your licence. Contact Innovyze for information about adding this option to your existing licence. User defined incident	User Defined Incident Data Fields	User defined table name. See User Defined Incident Data Fields for more information.

Asset Name Group Grid

The objects in the Asset Name Group Grid are:

Network Object	Data Fields Topic	Database Table Name (for CSV Import)
Node name group	Asset Name Group Data Fields (Collection) Asset Name Group Data Fields (Distribution)	cams_name_group_node wams_name_group_node
Pipe name group	Asset Name Group Data Fields (Collection) Asset Name Group Data Fields (Distribution)	cams_name_group_pipe wams_name_group_pipe
Connection pipe name group	Asset Name Group Data Fields (Collection)	cams_name_group_connection_pipe

Network Object

Data Fields Topic

Database Table Name (for CSV Import)

Node name group

Asset Name Group Data Fields (Collection)

Asset Name Group Data Fields (Distribution)

cams_name_group_node

wams_name_group_node

Pipe name group

Asset Name Group Data Fields (Collection)

Asset Name Group Data Fields (Distribution)

cams_name_group_pipe

wams_name_group_pipe

Connection pipe name group

Asset Name Group Data Fields (Collection)

cams_name_group_connection_pipe