Control

Description (User Interface): Control

ShortCode: CON

Contents:

Tables
Structures

Tables

wn_ctl_fixed_head

Description (User Interface): Fixed Head

Primary Key: node_id

Name	Description	Type	Size	Flag	Unit	Notes
after_levels_profile	After Last Point	Integer		true
after_wq_profile	After Last Point	Integer		true
asset_id	Asset ID	String	30	false
before_levels_profile	Before First Point	Integer		true
before_wq_profile	Before First Point	Integer		true
fixed_level	Fixed Level	Float		true	Z
initial_age	Initial Age of Water	Float		true
initial_concentration	Initial Concentration	Float		true	WN_C
iwts_enable_surge	Enable Surge Pressure	Boolean		false
iwts_surge_pressure_time	Surge Pressure Time	Structure		false		wn_ctl_iwts_surge_pres_tme
levels	Levels	Structure		false		wn_ctl_level_profile
linear_levels_profile	Linear Profile	Boolean		true
linear_wq_profile	Linear Profile	Boolean		true
live_data_point_id	Live Data Point ID	String	100	true
node_id	Node ID	String	30	false
notes	Notes	String		false
repeat_levels_period	Repeat Period	Integer		false
repeat_levels_profile	Repeat Profile	Boolean		true
repeat_wq_period	Repeat Period	Integer		false
repeat_wq_profile	Repeat Profile	Boolean		true
time_related_concentration	Initial Concentration	Float		true	WN_C
wq_age_after_profile	After Last Point	Integer		false
wq_age_before_profile	Before First Point	Integer		false
wq_age_linear_profile	Linear Profile	Boolean		false
wq_age_profile	Water Quality Age	Structure		false		wn_ctl_node_wq_age
wq_age_repeat_period	Repeat Period	Integer		false
wq_age_repeat_profile	Repeat Profile	Boolean		false
wq_bulk_coeff	WQ Bulk Coefficient	Float		false
wq_bulk_coeff_mode	WQ Bulk Coeff Mode	Integer		false
wq_end_date_time	WQ End Date Time	DateTime		true
wq_flow_profile	Water Quality Flow	Structure		false		wn_ctl_node_wq_flow
wq_initial_turbidity	Initial Turbidity	Float		false	WN_TURBIDITY
wq_profile	Water Quality Concentration	Structure		false		wn_ctl_node_wq_conc
wq_res_bulk_coeff	WQ Res Bulk Coefficient	Float		false
wq_res_bulk_coeff_mode	WQ Res Bulk Coeff Mode	Integer		false
wq_source_type	Source Type	Integer		true
wq_start_date_time	WQ Start Date Time	DateTime		true
wq_turb_after_profile	After Last Point	Integer		false
wq_turb_before_profile	Before First Point	Integer		false
wq_turb_linear_profile	Linear Profile	Boolean		false
wq_turb_repeat_period	Repeat Period	Integer		false
wq_turb_repeat_profile	Repeat Profile	Boolean		false
wq_turb_source_type	Turbidity Source Type	Integer		false
wq_turbidity_profile	Water Quality Turbidity	Structure		false		wn_ctl_node_wq_turb

wn_ctl_float_valve

Description (User Interface): Float Valve/Inlet

Primary Key: us_node_id.ds_node_id.link_suffix (Note: This table has a multi-part primary key)

Name	Description	Type	Size	Flag	Unit	Notes
asset_id	Asset ID	String	30	false
break_diameter	Break Diameter	Float		false	PS
break_flow	Break Flow	Float		false	WN_Q
break_flow_type	Break Flow Type	String	8	true
break_split_pipe_distance	Break Split Distance	Float		false	L
ds_node_id	Node2	String	30	false
dsus_pow_cat	Category (to - from)	String	16	true
dsus_pow_cost	PoW (to - from)	Float		true	WN_VCOST
initially_open	Initially Open	Boolean		true
link_suffix	Link Suffix	String	1	false
live_data_point_id	Live Data Point ID	String	100	true
notes	Notes	String		false
pipe_closed	Pipe Closed	Boolean		true
repeat_status	Repeat Profile	Boolean		true
repeat_status_period	Repeat Period	Integer		false
status	Pipe Status	Structure		false		wn_ctl_pipe_status
us_node_id	Node1	String	30	false
usds_pow_cat	Category (from - to)	String	16	true
usds_pow_cost	PoW (from - to)	Float		true	WN_VCOST
wq_erosion_coefficient	Erosion Coefficient	Float		false	WN_RATE
wq_erosion_exponent	Erosion Exponent	Float		false
wq_init_shear_strength	Init Shear Strength	Float		false	WN_STRESS
wq_max_shear_strength	Max Shear Strength	Float		false	WN_STRESS
wq_release_coefficient	Release Coefficient	Float		false	WN_TURBLEN

wn_ctl_hydrant

Description (User Interface): Hydrant

Primary Key: node_id

Name	Description	Type	Size	Flag	Unit	Notes
after_hydrant_profile	After Last Point	Integer		true
after_wq_profile	After Last Point	Integer		false
after_xd_profile	After Last Point	Integer		true
asset_id	Asset ID	String	30	false
before_hydrant_profile	Before First Point	Integer		true
before_wq_profile	Before First Point	Integer		false
before_xd_profile	Before First Point	Integer		true
hyd_lin_profile	Hydrant Linear Profile	Boolean		true
hydrant_profile	Hydrant Profile	Structure		false		wn_ctl_opening_profile
initial_age	Initial Age of Water	Float		false
initial_concentration	Initial Concentration	Float		false	WN_C
keep_local_demand	Keep Local Demand	Boolean		false
linear_profile	Linear Profile	Boolean		true
linear_wq_profile	Linear Profile	Boolean		false
live_data_point_id	Live Data Point ID	String	100	true
max_flow	Maximum Flow	Float		true	WN_Q
node_id	Node ID	String	30	false
notes	Notes	String		false
repeat_hydrant_period	Repeat Period	Integer		false
repeat_hydrant_profile	Repeat Profile	Boolean		true
repeat_wq_period	Repeat Period	Integer		false
repeat_wq_profile	Repeat Profile	Boolean		false
repeat_xd_period	Repeat Period	Integer		false
repeat_xd_profile	Repeat Profile	Boolean		true
wq_age_after_profile	After Last Point	Integer		false
wq_age_before_profile	Before First Point	Integer		false
wq_age_linear_profile	Linear Profile	Boolean		false
wq_age_profile	Water Quality Age	Structure		false		wn_ctl_node_wq_age
wq_age_repeat_period	Repeat Period	Integer		false
wq_age_repeat_profile	Repeat Profile	Boolean		false
wq_bulk_coeff	WQ Bulk Coefficient	Float		false
wq_bulk_coeff_mode	WQ Bulk Coeff Mode	Integer		false
wq_end_date_time	WQ End Date Time	DateTime		false
wq_flow_profile	Water Quality Flow	Structure		false		wn_ctl_node_wq_flow
wq_initial_turbidity	Initial Turbidity	Float		false	WN_TURBIDITY
wq_profile	Water Quality Concentration	Structure		false		wn_ctl_node_wq_conc
wq_res_bulk_coeff	WQ Res Bulk Coefficient	Float		false
wq_res_bulk_coeff_mode	WQ Res Bulk Coeff Mode	Integer		false
wq_source_type	Source Type	Integer		false
wq_start_date_time	WQ Start Date Time	DateTime		false
wq_turb_after_profile	After Last Point	Integer		false
wq_turb_before_profile	Before First Point	Integer		false
wq_turb_linear_profile	Linear Profile	Boolean		false
wq_turb_repeat_period	Repeat Period	Integer		false
wq_turb_repeat_profile	Repeat Profile	Boolean		false
wq_turb_source_type	Turbidity Source Type	Integer		false
wq_turbidity_profile	Water Quality Turbidity	Structure		false		wn_ctl_node_wq_turb
xd_flow	Exceptional Flow	Structure		false		wn_ctl_node_xd_flow

wn_ctl_meter

Description (User Interface): Meter

Primary Key: us_node_id.ds_node_id.link_suffix (Note: This table has a multi-part primary key)

Name	Description	Type	Size	Flag	Unit	Notes
asset_id	Asset ID	String	30	false
break_diameter	Break Diameter	Float		false	PS
break_flow	Break Flow	Float		false	WN_Q
break_flow_type	Break Flow Type	String	8	true
break_split_pipe_distance	Break Split Distance	Float		false	L
ds_node_id	Node2	String	30	false
dsus_pow_cat	Category (to - from)	String	16	true
dsus_pow_cost	PoW (to - from)	Float		true	WN_VCOST
link_suffix	Link Suffix	String	1	false
live_data_point_id	Live Data Point ID	String	100	true
notes	Notes	String		false
optimise	Cost Management	Boolean		true
pipe_closed	Pipe Closed	Boolean		true
repeat_status	Repeat Profile	Boolean		true
repeat_status_period	Repeat Period	Integer		false
status	Pipe Status	Structure		false		wn_ctl_pipe_status
us_node_id	Node1	String	30	false
usds_pow_cat	Category (from - to)	String	16	true
usds_pow_cost	PoW (from - to)	Float		true	WN_VCOST
wq_erosion_coefficient	Erosion Coefficient	Float		false	WN_RATE
wq_erosion_exponent	Erosion Exponent	Float		false
wq_init_shear_strength	Init Shear Strength	Float		false	WN_STRESS
wq_max_shear_strength	Max Shear Strength	Float		false	WN_STRESS
wq_release_coefficient	Release Coefficient	Float		false	WN_TURBLEN

wn_ctl_node

Description (User Interface): Node

Primary Key: node_id

Name	Description	Type	Size	Flag	Unit	Notes
after_hydrant_profile	After Last Point	Integer		true
after_wq_profile	After Last Point	Integer		true
after_xd_profile	After Last Point	Integer		true
asset_id	Asset ID	String	30	false
available_flow	Opening	Integer		true	WN_OPEN
before_hydrant_profile	Before First Point	Integer		true
before_wq_profile	Before First Point	Integer		true
before_xd_profile	Before First Point	Integer		true
exceptional_flow	Exceptional Flow	Float		true	WN_Q
hyd_lin_profile	Hydrant Linear Profile	Boolean		true
hydrant_flow	Hydrant Operation	Boolean		true
hydrant_profile	Hydrant Profile	Structure		false		wn_ctl_opening_profile
initial_age	Initial Age of Water	Float		false
initial_concentration	Initial Concentration	Float		true	WN_C
iwts_closing_pressure	Closing Pressure	Float		false	WN_P
iwts_closing_time	Closing Time	Float		false	TS
iwts_enable_surge_Dem	Enable Surge Dem	Boolean		false
iwts_enable_surge_SPD	Enable Surge SPD	Boolean		false
iwts_event	Node Demand Event	Structure		false		wn_ctl_node_iwts_event
iwts_exp_const	Expansion Constant	Float		false
iwts_external_pressure	External Pressure	Float		false	WN_P
iwts_fully_open_time	Fully Open Time	Float		false	TS
iwts_high_closing_time	Closing Time	Float		false	TS
iwts_high_opening_pressure	Opening Pressure	Float		false	WN_P
iwts_high_opening_time	Opening Time	Float		false	TS
iwts_hybrid_tank	Hybrid Tank	Boolean		true
iwts_inflow_diameter	Inflow Diameter	Float		false	PS
iwts_inflow_loss_coeff	Inflow Loss Coefficient	Float		false
iwts_init_gas_volume	Initial Gas Volume	Float		false	WN_RVO
iwts_init_tank_depth	Initial Tank Depth	Float		false	Y
iwts_initial_delay_time	Initial Delay Time	Float		false	TS
iwts_linear_valve_operation	Linear Valve Operation	Boolean		true
iwts_max_tank_depth	Max Tank Depth	Float		false	Y
iwts_nrv_diameter	NRV Diameter	Float		false	PS
iwts_nrv_loss_coeff	NRV Loss Coefficient	Float		false
iwts_nrv_response_time	NRV Response Time	Float		false	TS
iwts_opening_pressure	Opening Pressure	Float		false	WN_P
iwts_opening_time	Opening Time	Float		false	TS
iwts_outflow_diameter	Outflow Diameter	Float		false	PS
iwts_outflow_diameter2	Outflow Diameter 2	Float		false	PS
iwts_outflow_loss_coeff	Outflow Loss Coefficient	Float		false
iwts_preset_pressure	Preset Pressure	Float		false	WN_P
iwts_sensing_node_id	Sensing Node ID	String	30	false
iwts_spd_type	Surge Protection Device	String	10	false
iwts_SPDT_area_depth	Node Tank Depth Area	Structure		false		wn_ctl_node_iwts_tank_depth_area
iwts_switching_flow	Switching Flow	Float		false	WN_Q
iwts_switching_pressure	Switching Pressure	Float		false	WN_P
iwts_switching_type	Switching Type	String	10	false
iwts_switching_volume	Switching Volume	Float		false	WN_RVO
iwts_tank_diameter	Tank Diameter	Float		false	L
iwts_tank_volume	Tank Volume	Float		false	WN_RVO
iwts_valve_resp_time	Valve Response Time	Float		true	TS
keep_local_demand	Keep Local Demand	Boolean		false
linear_profile	Linear Profile	Boolean		true
linear_wq_profile	Linear Profile	Boolean		true
live_data_point_id	Live Data Point ID	String	100	true
maximum_pressure	Maximum Pressure	Float		true	WN_P
minimum_pressure	Minimum Pressure	Float		true	WN_P
node_id	Node ID	String	30	false
notes	Notes	String		false
optimise	Cost Management	Boolean		true
repeat_hydrant_period	Repeat Period	Integer		false
repeat_hydrant_profile	Repeat Profile	Boolean		true
repeat_wq_period	Repeat Period	Integer		false
repeat_wq_profile	Repeat Profile	Boolean		true
repeat_xd_period	Repeat Period	Integer		false
repeat_xd_profile	Repeat Profile	Boolean		true
time_related_concentration	Time Dependent Concentration	Float		true	WN_C
wq_age_after_profile	After Last Point	Integer		false
wq_age_before_profile	Before First Point	Integer		false
wq_age_linear_profile	Linear Profile	Boolean		false
wq_age_profile	Water Quality Age	Structure		false		wn_ctl_node_wq_age
wq_age_repeat_period	Repeat Period	Integer		false
wq_age_repeat_profile	Repeat Profile	Boolean		false
wq_bulk_coeff	WQ Bulk Coefficient	Float		false
wq_bulk_coeff_mode	WQ Bulk Coeff Mode	Integer		false
wq_end_date_time	WQ End Date Time	DateTime		true
wq_flow_profile	Water Quality Flow	Structure		false		wn_ctl_node_wq_flow
wq_initial_turbidity	Initial Turbidity	Float		false	WN_TURBIDITY
wq_profile	Water Quality Concentration	Structure		false		wn_ctl_node_wq_conc
wq_res_bulk_coeff	WQ Res Bulk Coefficient	Float		false
wq_res_bulk_coeff_mode	WQ Res Bulk Coeff Mode	Integer		false
wq_source_type	Source Type	Integer		true
wq_start_date_time	WQ Start Date Time	DateTime		true
wq_turb_after_profile	After Last Point	Integer		false
wq_turb_before_profile	Before First Point	Integer		false
wq_turb_linear_profile	Linear Profile	Boolean		false
wq_turb_repeat_period	Repeat Period	Integer		false
wq_turb_repeat_profile	Repeat Profile	Boolean		false
wq_turb_source_type	Turbidity Source Type	Integer		false
wq_turbidity_profile	Water Quality Turbidity	Structure		false		wn_ctl_node_wq_turb
xd_end_date_time	End Date Time	DateTime		true
xd_flow	Exceptional Flow	Structure		false		wn_ctl_node_xd_flow
xd_start_date_time	Start Date Time	DateTime		true

wn_ctl_non_return_valve

Description (User Interface): Non Return Valve

Primary Key: us_node_id.ds_node_id.link_suffix (Note: This table has a multi-part primary key)

Name	Description	Type	Size	Flag	Unit	Notes
asset_id	Asset ID	String	30	false
break_diameter	Break Diameter	Float		false	PS
break_flow	Break Flow	Float		false	WN_Q
break_flow_type	Break Flow Type	String	8	true
break_split_pipe_distance	Break Split Distance	Float		false	L
ds_node_id	Node2	String	30	false
dsus_pow_cat	Category (to - from)	String	16	true
dsus_pow_cost	PoW (to - from)	Float		true	WN_VCOST
link_suffix	Link Suffix	String	1	false
live_data_point_id	Live Data Point ID	String	100	true
notes	Notes	String		false
pipe_closed	Pipe Closed	Boolean		true
repeat_status	Repeat Profile	Boolean		true
repeat_status_period	Repeat Period	Integer		false
status	Pipe Status	Structure		false		wn_ctl_pipe_status
us_node_id	Node1	String	30	false
usds_pow_cat	Category (from - to)	String	16	true
usds_pow_cost	PoW (from - to)	Float		true	WN_VCOST
wq_erosion_coefficient	Erosion Coefficient	Float		false	WN_RATE
wq_erosion_exponent	Erosion Exponent	Float		false
wq_init_shear_strength	Init Shear Strength	Float		false	WN_STRESS
wq_max_shear_strength	Max Shear Strength	Float		false	WN_STRESS
wq_release_coefficient	Release Coefficient	Float		false	WN_TURBLEN

wn_ctl_open_channel

Description (User Interface): Open Channel

Primary Key: us_node_id.ds_node_id.link_suffix (Note: This table has a multi-part primary key)

Name	Description	Type	Size	Flag	Unit	Notes
asset_id	Asset ID	String	30	false
ds_node_id	Node2	String	30	false
dsus_pow_cat	Category (to - from)	String	16	false
dsus_pow_cost	PoW (to - from)	Float		false	WN_VCOST
initial_depth	Initial Depth	Float		false	Y
link_suffix	Link Suffix	String	1	false
live_data_point_id	Live Data Point ID	String	100	false
notes	Notes	String		false
optimise	Cost Management	Boolean		false
pipe_closed	Pipe Closed	Boolean		false
repeat_status	Repeat Profile	Boolean		false
repeat_status_period	Repeat Period	Integer		false
status	Pipe Status	Structure		false		wn_ctl_pipe_status
us_node_id	Node1	String	30	false
usds_pow_cat	Category (from - to)	String	16	false
usds_pow_cost	PoW (from - to)	Float		false	WN_VCOST
wq_erosion_coefficient	Erosion Coefficient	Float		false	WN_RATE
wq_erosion_exponent	Erosion Exponent	Float		false
wq_init_shear_strength	Init Shear Strength	Float		false	WN_STRESS
wq_max_shear_strength	Max Shear Strength	Float		false	WN_STRESS
wq_release_coefficient	Release Coefficient	Float		false	WN_TURBLEN

wn_ctl_pipe

Description (User Interface): Pipe

Primary Key: us_node_id.ds_node_id.link_suffix (Note: This table has a multi-part primary key)

Name	Description	Type	Size	Flag	Unit	Notes
asset_id	Asset ID	String	30	false
break_diameter	Break Diameter	Float		false	PS
break_flow	Break Flow	Float		false	WN_Q
break_flow_type	Break Flow Type	String	8	true
break_split_pipe_distance	Break Split Distance	Float		false	L
ds_node_id	Node2	String	30	false
dsus_pow_cat	Category (to - from)	String	16	true
dsus_pow_cost	PoW (to - from)	Float		true	WN_VCOST
link_suffix	Link Suffix	String	1	false
live_data_point_id	Live Data Point ID	String	100	true
notes	Notes	String		false
optimise	Cost Management	Boolean		true
pipe_closed	Pipe Closed	Boolean		true
repeat_status	Repeat Profile	Boolean		true
repeat_status_period	Repeat Period	Integer		false
status	Pipe Status	Structure		false		wn_ctl_pipe_status
us_node_id	Node1	String	30	false
usds_pow_cat	Category (from - to)	String	16	true
usds_pow_cost	PoW (from - to)	Float		true	WN_VCOST
wq_erosion_coefficient	Erosion Coefficient	Float		false	WN_RATE
wq_erosion_exponent	Erosion Exponent	Float		false
wq_init_shear_strength	Init Shear Strength	Float		false	WN_STRESS
wq_max_shear_strength	Max Shear Strength	Float		false	WN_STRESS
wq_release_coefficient	Release Coefficient	Float		false	WN_TURBLEN

wn_ctl_profile

Description (User Interface): Control Profile

Primary Key: id

Name	Description	Type	Size	Flag	Notes
after	After	Integer		false
before	Before	Integer		false
id	Id	String	30	false
linear	Linear	Boolean		false
live_data_point_id	Live Data Point Id	String	100	false
notes	Notes	String		false
profile	Profile	Structure		false	wn_ctl_profile_data
repeat	Repeat	Boolean		false
repeat_period	Repeat Period	Integer		false
type	Type	String	20	false

wn_ctl_pst

Description (User Interface): Pump Station

Primary Key: us_node_id.ds_node_id.link_suffix (Note: This table has a multi-part primary key)

Name	Description	Type	Size	Flag	Unit	Notes
after_profile	After Last Point	Integer		true
asset_id	Asset ID	String	30	false
before_profile	Before First Point	Integer		true
control_node	Control Node	String	30	true
control_pipe	Control Pipe	String	63	false
disable_upc	Disable UPC	Boolean		false
ds_node_id	Node2	String	30	false
dsus_pow_cat	Category (to - from)	String	16	true
dsus_pow_cost	PoW (to - from)	Float		true	WN_VCOST
iwts_change_type	Change Type	Integer		false
iwts_control_node	Control Node	String	30	false
iwts_control_pipe	Control Pipe	String	63	false
iwts_controller_gain	Controller Gain	Float		false
iwts_differential_time	Differential Time	Float		false	TS
iwts_enable_surge	Enable Surge	Boolean		false
iwts_enable_surge_turbine	Enable Surge Turbine	Boolean		false
iwts_event	Pump Event	Structure		false		wn_ctl_pump_iwts_event
iwts_inertia	Inertia	Float		false	WN_INERTIA
iwts_integral_time	Integral Time	Float		false	TS
iwts_pump_change	Pump Change	String	10	false
iwts_rated_efficiency	Rated Efficiency	Integer		false	WN_OPEN
iwts_trip_time	Trip Time (s)	Float		false
iwts_turbine_change	Turbine Change	Structure		false		wn_ctl_pst_turbine_change
iwts_turbine_diameter	Turbine Diameter	Float		false	WN_P
iwts_wicket_gate_change	Wicket Gate Change	Structure		false		wn_ctl_pst_wicket_gate_change
iwts_wicket_gate_init_opening	Wicket Gate Opening	Integer		false	WN_OPEN
iwtsEnableRegulation	Enable PID Regulation	Boolean		false
iwtsRegulatorType	Regulator Type	String	10	false
iwtsSetting	Setting	Float		false
linear_profile	Linear Profile	Boolean		true
link_suffix	Link Suffix	String	1	false
live_data_point_id	Live Data Point ID	String	100	true
max_power	Licensed Max Power Demand	Float		true	WN_KVA
mode	Mode	String	4	true
multi_vsp_regulation	Multi VSP Regulation	Boolean		false
notes	Notes	String		false
nrv_diameter	NRV Diameter	Float		false	PS
nrv_dont_reopen	NRV Do Not Reopen	Boolean		false
nrv_loss_coeff	NRV Loss Coeff.	Float		false
nrv_response_t	NRV Response Time (s)	Float		false
opt_max_switches	Max No. of Switches	Integer		true
opt_min_off_time	Min Off Time (mins)	Integer		true	DUR
opt_min_on_time	Min On Time (mins)	Integer		true	DUR
optimise	Cost Management	Boolean		true
override_node	Override Node	String	30	false
pipe_closed	Pipe Closed	Boolean		true
pressure_off	Pressure Off	Float		true	WN_P
pressure_on	Pressure On	Float		true	WN_P
profiles	Profiles	Structure		false		wn_ctl_pst_profiles
pumps	Initial Status	Structure		false		wn_ctl_pst_pumps
repeat_period	Repeat Period	Integer		false
repeat_profile	Repeat Profile	Boolean		true
repeat_status	Repeat Profile	Boolean		true
repeat_status_period	Repeat Period	Integer		false
system_role	System Role	String	10	true
upc_script	UPC Script	String		false
us_node_id	Node1	String	30	false
usds_pow_cat	Category (from - to)	String	16	true
usds_pow_cost	PoW (from - to)	Float		true	WN_VCOST
wq_erosion_coefficient	Erosion Coefficient	Float		false	WN_RATE
wq_erosion_exponent	Erosion Exponent	Float		false
wq_init_shear_strength	Init Shear Strength	Float		false	WN_STRESS
wq_max_shear_strength	Max Shear Strength	Float		false	WN_STRESS
wq_release_coefficient	Release Coefficient	Float		false	WN_TURBLEN

wn_ctl_reservoir

Description (User Interface): Reservoir

Primary Key: node_id

Name	Description	Type	Size	Flag	Unit	Notes
after_wq_profile	After Last Point	Integer		true
after_xd_profile	After Last Point	Integer		true
asset_id	Asset ID	String	30	false
before_wq_profile	Before First Point	Integer		true
before_xd_profile	Before First Point	Integer		true
deadmain_exchange_rate	DM Exchange Rate	Float		true	WN_DMXR
deadzone_vol_fraction	DZ Volume Fraction (%)	Float		true
exceptional_flow	Exceptional Flow	Float		true	WN_Q
hydrant_flow	Hydrant Operation	Boolean		true
initial_age	Initial Age of Water	Float		true
initial_concentration	Initial Concentration	Float		true	WN_C
initial_depth	Initial Depth	Float		true	Y
io_vol_fraction	IO Volume Fraction (%)	Float		true
iwts_enable_surge	Enable Surge Pressure	Boolean		false
iwts_surge_pressure_time	Surge Pressure Time	Structure		false		wn_ctl_iwts_surge_pres_tme
keep_local_demand	Keep Local Demand	Boolean		false
linear_profile	Linear Profile	Boolean		true
linear_wq_profile	Linear Profile	Boolean		true
live_data_point_id	Live Data Point ID	String	100	true
mixing_model	Mixing Model	Integer		true
node_id	Node ID	String	30	false
notes	Notes	String		false
opt_max_volume	Max Volume (%)	Float		true
opt_min_volume	Min Volume (%)	Float		true
optimise	Cost Management	Boolean		true
repeat_wq_period	Repeat Period	Integer		false
repeat_wq_profile	Repeat Profile	Boolean		true
repeat_xd_period	Repeat Period	Integer		false
repeat_xd_profile	Repeat Profile	Boolean		true
time_related_concentration	Initial Concentration	Float		true	WN_C
wq_age_after_profile	After Last Point	Integer		false
wq_age_before_profile	Before First Point	Integer		false
wq_age_linear_profile	Linear Profile	Boolean		false
wq_age_profile	Water Quality Age	Structure		false		wn_ctl_node_wq_age
wq_age_repeat_period	Repeat Period	Integer		false
wq_age_repeat_profile	Repeat Profile	Boolean		false
wq_bulk_coeff	WQ Bulk Coefficient	Float		false
wq_bulk_coeff_mode	WQ Bulk Coeff Mode	Integer		false
wq_end_date_time	WQ End Date Time	DateTime		true
wq_flow_profile	Water Quality Flow	Structure		false		wn_ctl_node_wq_flow
wq_initial_turbidity	Initial Turbidity	Float		false	WN_TURBIDITY
wq_profile	Water Quality Concentration	Structure		false		wn_ctl_node_wq_conc
wq_res_bulk_coeff	WQ Res Bulk Coefficient	Float		false
wq_res_bulk_coeff_mode	WQ Res Bulk Coeff Mode	Integer		false
wq_source_type	Source Type	Integer		true
wq_start_date_time	WQ Start Date Time	DateTime		true
wq_turb_after_profile	After Last Point	Integer		false
wq_turb_before_profile	Before First Point	Integer		false
wq_turb_linear_profile	Linear Profile	Boolean		false
wq_turb_repeat_period	Repeat Period	Integer		false
wq_turb_repeat_profile	Repeat Profile	Boolean		false
wq_turb_source_type	Turbidity Source Type	Integer		false
wq_turbidity_profile	Water Quality Turbidity	Structure		false		wn_ctl_node_wq_turb
xd_end_date_time	End Date Time	DateTime		true
xd_flow	Exceptional Flow	Structure		false		wn_ctl_node_xd_flow
xd_start_date_time	Start Date Time	DateTime		true

wn_ctl_run

Description (User Interface): Run

Name	Description	Type	Flag	Unit
computational_accuracy	Computational Accuracy	Float	false	WN_Q
disable_upc	Disable UPC	Boolean	false
end_date_time	End Date Time	DateTime	false
pressure_related_demand	Pressure Related Demand	Boolean	false
start_date_time	Start Date Time	DateTime	false
time_step	Time Step	Float	false	WN_TS
upc_script	UPC Script	String	false

wn_ctl_transfer_node

Description (User Interface): Transfer Node

Primary Key: node_id

Name	Description	Type	Size	Flag	Unit	Notes
after_flows_profile	After Last Point	Integer		true
after_wq_profile	After Last Point	Integer		true
asset_id	Asset ID	String	30	false
before_flows_profile	Before First Point	Integer		true
before_wq_profile	Before First Point	Integer		true
flow_factor	Flow Factor	Float		true
flows	Flows	Structure		false		wn_ctl_transfer_node_flows
initial_age	Initial Age of Water	Float		true
initial_concentration	Initial Concentration	Float		true	WN_C
linear_flows_profile	Linear Profile	Boolean		true
linear_wq_profile	Linear Profile	Boolean		true
live_data_point_id	Live Data Point ID	String	100	true
node_id	Node ID	String	30	false
notes	Notes	String		false
repeat_flows_period	Repeat Period	Integer		false
repeat_flows_profile	Repeat Profile	Boolean		true
repeat_wq_period	Repeat Period	Integer		false
repeat_wq_profile	Repeat Profile	Boolean		true
reverse_live_data_flow	Reverse Live Flow	Boolean		true
time_related_concentration	Initial Concentration	Float		true	WN_C
wq_age_after_profile	After Last Point	Integer		false
wq_age_before_profile	Before First Point	Integer		false
wq_age_linear_profile	Linear Profile	Boolean		false
wq_age_profile	Water Quality Age	Structure		false		wn_ctl_node_wq_age
wq_age_repeat_period	Repeat Period	Integer		false
wq_age_repeat_profile	Repeat Profile	Boolean		false
wq_bulk_coeff	WQ Bulk Coefficient	Float		false
wq_bulk_coeff_mode	WQ Bulk Coeff Mode	Integer		false
wq_end_date_time	WQ End Date Time	DateTime		true
wq_flow_profile	Water Quality Flow	Structure		false		wn_ctl_node_wq_flow
wq_initial_turbidity	Initial Turbidity	Float		false	WN_TURBIDITY
wq_profile	Water Quality Concentration	Structure		false		wn_ctl_node_wq_conc
wq_res_bulk_coeff	WQ Res Bulk Coefficient	Float		false
wq_res_bulk_coeff_mode	WQ Res Bulk Coeff Mode	Integer		false
wq_source_type	Source Type	Integer		true
wq_start_date_time	WQ Start Date Time	DateTime		true
wq_turb_after_profile	After Last Point	Integer		false
wq_turb_before_profile	Before First Point	Integer		false
wq_turb_linear_profile	Linear Profile	Boolean		false
wq_turb_repeat_period	Repeat Period	Integer		false
wq_turb_repeat_profile	Repeat Profile	Boolean		false
wq_turb_source_type	Turbidity Source Type	Integer		false
wq_turbidity_profile	Water Quality Turbidity	Structure		false		wn_ctl_node_wq_turb

wn_ctl_valve

Description (User Interface): Valve

Primary Key: us_node_id.ds_node_id.link_suffix (Note: This table has a multi-part primary key)

Name	Description	Type	Size	Flag	Unit	Notes
after_profile	After Last Point	Integer		true
asset_id	Asset ID	String	30	false
before_profile	Before First Point	Integer		true
break_diameter	Break Diameter	Float		false	PS
break_flow	Break Flow	Float		false	WN_Q
break_flow_type	Break Flow Type	String	8	true
break_split_pipe_distance	Break Split Distance	Float		false	L
control_node	Control Node	String	30	true
control_pipe	Control Pipe	String	63	true
disable_upc	Disable UPC	Boolean		false
ds_node_id	Node2	String	30	false
dsus_pow_cat	Category (to - from)	String	16	true
dsus_pow_cost	PoW (to - from)	Float		true	WN_VCOST
flow	Flow	Float		true	WN_Q
initial_flow	Initial Flow	Float		false	WN_Q
initial_opening	Initial Opening	Integer		true	WN_OPEN
initial_pressure	Initial Pressure	Float		false	WN_P
inoperable	Inoperable	Boolean		true
iwts_bypass	Bypass	Boolean		false
iwts_bypass_diameter	Bypass Diameter	Float		false	PS
iwts_bypass_loss_coef	Bypass Loss Coefficient	Float		false
iwts_control_node	Control Node	String	30	false
iwts_control_pipe	Control Pipe	String	63	false
iwts_controller_gain	Controller Gain	Float		false
iwts_differential_time	Differential Time	Float		false	TS
iwts_enable_surge	Enable Surge	Boolean		false
iwts_event	Valve Event	Structure		false		wn_ctl_valve_iwts_event
iwts_integral_time	Integral Time	Float		false	TS
iwts_nrv_dont_reopen	S NRV Do Not Reopen	Boolean		false
iwts_nrv_response_time	S NRV Response Time	Float		false	TS
iwts_series_nrv	Series NRV	Boolean		false
iwts_use_pid_control	Use PID Control	Boolean		false
iwtsEnableRegulation	Enable Regulation	Boolean		false
iwtsRegulatorType	Regulator Type	String	10	false
iwtsResponseTime	Response Time	Float		false	TS
iwtsSetting	Setting	Float		false
linear_profile	Linear Profile	Boolean		true
link_suffix	Link Suffix	String	1	false
live_data_point_id	Live Data Point ID	String	100	true
mode	Mode	String	4	true
notes	Notes	String		false
opening	Opening	Float		true	WN_OPEN
optimise	Cost Management	Boolean		true
pipe_closed	Pipe Closed	Boolean		true
pressure	Pressure	Float		true	WN_P
pressure_closed	Pressure Closed	Float		false	WN_P
pressure_open	Pressure Open	Float		false	WN_P
profiles	Profiles	Structure		false		wn_ctl_valve_profiles
prsv_priority	PRSV Priority Mode	String	3	false
prsv_red_ctlnode	Reducing Control Node	String	30	false
prsv_reducing_p	Reducing Pressure	Float		false	WN_P
prsv_sus_ctlnode	Sustaining Control Node	String	30	false
prsv_sustaining_p	Sustaining Pressure	Float		false	WN_P
regulation_precision	Regulation Precision (%)	Float		true
regulation_type	Regulation Type	Boolean		false
repeat_period	Repeat Period	Integer		false
repeat_profile	Repeat Profile	Boolean		true
repeat_status	Repeat Profile	Boolean		true
repeat_status_period	Repeat Period	Integer		false
status	Pipe Status	Structure		false		wn_ctl_pipe_status
upc_script	UPC Script	String		false
us_node_id	Node1	String	30	false
usds_pow_cat	Category (from - to)	String	16	true
usds_pow_cost	PoW (from - to)	Float		true	WN_VCOST
wq_erosion_coefficient	Erosion Coefficient	Float		false	WN_RATE
wq_erosion_exponent	Erosion Exponent	Float		false
wq_init_shear_strength	Init Shear Strength	Float		false	WN_STRESS
wq_max_shear_strength	Max Shear Strength	Float		false	WN_STRESS
wq_release_coefficient	Release Coefficient	Float		false	WN_TURBLEN

wn_ctl_well

Description (User Interface): Well

Primary Key: node_id

Name	Description	Type	Size	Flag	Unit	Notes
after_levels_profile	After Last Point	Integer		true
after_wq_profile	After Last Point	Integer		true
asset_id	Asset ID	String	30	false
before_levels_profile	Before First Point	Integer		true
before_wq_profile	Before First Point	Integer		true
drawdown_curve	Drawdown Curve	Structure		false		wn_ctl_drawdown_curve
initial_age	Initial Age of Water	Float		true
initial_concentration	Initial Concentration	Float		true	WN_C
initial_level	Initial Level	Float		true	Z
iwts_enable_surge	Enable Surge Pressure	Boolean		false
iwts_surge_pressure_time	Surge Pressure Time	Structure		false		wn_ctl_iwts_surge_pres_tme
linear_levels_profile	Linear Profile	Boolean		true
linear_wq_profile	Linear Profile	Boolean		true
live_data_point_id	Live Data Point ID	String	100	true
mode	Mode	Integer		true
node_id	Node ID	String	30	false
notes	Notes	String		false
repeat_levels_period	Repeat Period	Integer		false
repeat_levels_profile	Repeat Profile	Boolean		true
repeat_wq_period	Repeat Period	Integer		false
repeat_wq_profile	Repeat Profile	Boolean		true
rest_water_level	Rest Level	Float		true	Z
time_related_concentration	Initial Concentration	Float		true	WN_C
wq_age_after_profile	After Last Point	Integer		false
wq_age_before_profile	Before First Point	Integer		false
wq_age_linear_profile	Linear Profile	Boolean		false
wq_age_profile	Water Quality Age	Structure		false		wn_ctl_node_wq_age
wq_age_repeat_period	Repeat Period	Integer		false
wq_age_repeat_profile	Repeat Profile	Boolean		false
wq_bulk_coeff	WQ Bulk Coefficient	Float		false
wq_bulk_coeff_mode	WQ Bulk Coeff Mode	Integer		false
wq_end_date_time	WQ End Date Time	DateTime		true
wq_flow_profile	Water Quality Flow	Structure		false		wn_ctl_node_wq_flow
wq_initial_turbidity	Initial Turbidity	Float		false	WN_TURBIDITY
wq_profile	Water Quality Concentration	Structure		false		wn_ctl_node_wq_conc
wq_res_bulk_coeff	WQ Res Bulk Coefficient	Float		false
wq_res_bulk_coeff_mode	WQ Res Bulk Coeff Mode	Integer		false
wq_source_type	Source Type	Integer		true
wq_start_date_time	WQ Start Date Time	DateTime		true
wq_turb_after_profile	After Last Point	Integer		false
wq_turb_before_profile	Before First Point	Integer		false
wq_turb_linear_profile	Linear Profile	Boolean		false
wq_turb_repeat_period	Repeat Period	Integer		false
wq_turb_repeat_profile	Repeat Profile	Boolean		false
wq_turb_source_type	Turbidity Source Type	Integer		false
wq_turbidity_profile	Water Quality Turbidity	Structure		false		wn_ctl_node_wq_turb

Structures

wn_ctl_iwts_surge_pres_tme

Description (User Interface): SPD Surge Pressure Time

Name	Description	Type	Size	Flag	Unit	Notes
pressure	Pressure	Float		false	WN_P
time	Time (s)	Float		false

wn_ctl_level_profile

Description (User Interface): Levels

Name	Description	Type	Size	Flag	Unit	Notes
date_time	Date Time	DateTime		false
water_level	Water Level	Float		false	Z

wn_ctl_node_wq_age

Description (User Interface): WQ Age

Name	Description	Type	Size	Flag	Unit	Notes
wqa_age	Age of Water	Float		false
wqa_date_time	Date Time	DateTime		false

wn_ctl_node_wq_flow

Description (User Interface): Water Quality Mass Flow

Name	Description	Type	Size	Flag	Unit	Notes
wqf_additional_mass	Mass Flow	Float		false	WN_MF
wqf_date_time	Date Time	DateTime		false

wn_ctl_node_wq_conc

Description (User Interface): Water Quality

Name	Description	Type	Size	Flag	Unit	Notes
wqc_concentration	Conc.	Float		false	WN_C
wqc_date_time	Date Time	DateTime		false

wn_ctl_node_wq_turb

Description (User Interface): Water Quality Turbidity

Name	Description	Type	Size	Flag	Unit	Notes
wqt_date_time	Date Time	DateTime		false
wqt_turbidity	Turb.	Float		false	WN_TURBIDITY

wn_ctl_pipe_status

Description (User Interface): Pipe Status

Name	Description	Type	Size	Flag	Unit	Notes
ps_closed	Pipe Closed	Boolean		false
ps_date_time	Date Time	DateTime		false

wn_ctl_opening_profile

Description (User Interface): Opening Profile

Name	Description	Type	Size	Flag	Unit	Notes
date_time	Date Time	DateTime		false
value	Opening	Float		false	WN_OPEN

wn_ctl_node_xd_flow

Description (User Interface): Exceptional Flow

Name	Description	Type	Flag	Unit
exf_date_time	Date Time	DateTime	false
exf_flow	Flow	Float	false	WN_Q
exf_hydrant	Hydrant Status	Boolean	false

wn_ctl_node_iwts_event

Description (User Interface): Node Surge Demand Event

Name	Description	Type	Size	Flag	Unit	Notes
demand	Demand	Float		false	WN_DQ
time	Time (s)	Float		false

wn_ctl_node_iwts_tank_depth_area

Description (User Interface): SPD Tank Depth Area

Name	Description	Type	Size	Flag	Unit	Notes
pdArea	Area	Float		false	NA
pdDepth	Depth	Float		false	Y

wn_ctl_profile_data

Description (User Interface): Control Profile Data

Name	Description	Type	Flag	Unit
concentration	Concentration	Float	false	WN_C
date_time	Date Time	DateTime	false
depth	Depth	Float	false	Y
flow	Flow	Float	false	WN_Q
head	Head	Float	false	Z
number	Number	Float	false
opening	Opening	Float	false	WN_OPEN
pipe_status	Status	Boolean	false
pressure	Pressure	Float	false	WN_P
speed	Speed	Float	false	WN_AV

wn_ctl_pump_iwts_event

Description (User Interface): Pump Surge Event

Name	Description	Type	Size	Flag	Unit	Notes
speed	Speed	Float		false	WN_AV
time	Time (s)	Float		false

wn_ctl_pst_turbine_change

Description (User Interface): Turbine Change

Name	Description	Type	Size	Flag	Unit	Notes
iwts_speed	Speed	Float		false	WN_AV
iwts_time	Time	Float		false	TS

wn_ctl_pst_wicket_gate_change

Description (User Interface): Wicket Gate Change

Name	Description	Type	Size	Flag	Unit	Notes
iwts_opening	Opening	Float		false	WN_OPEN
iwts_time	Time	Float		false	TS

wn_ctl_pst_profiles

Description (User Interface): Profiles

Name	Description	Type	Size	Flag	Unit
date_time	Date Time	DateTime		false
pump_availability_flags	Pump Availability Flags	String	12	false
pump_status_flags	Pump Status Flags	String	12	false
speed	Initial Speed	Float		false	WN_AV
target_pressure_depth	Target Pressure Depth	Float		false	Y
total_flow	Total Flow	Float		false	WN_Q

wn_ctl_pst_pumps

Description (User Interface): Pumps

Name	Description	Type	Size	Flag	Unit	Notes
pump_initial_status	Pump Initial Status	Integer		false
speed	Initial Speed	Float		false	WN_AV

wn_ctl_transfer_node_flows

Description (User Interface): Flows

Name	Description	Type	Size	Flag	Unit	Notes
date_time	Date Time	DateTime		false
flow	Flow	Float		false	WN_Q

wn_ctl_valve_iwts_event

Description (User Interface): Valve Surge Event

Name	Description	Type	Size	Flag	Unit	Notes
opening	Valve Opening	Float		false
time	Time (s)	Float		false

wn_ctl_valve_profiles

Description (User Interface): Profiles

Name	Description	Type	Flag	Unit
date_time	Date Time	DateTime	false
depth	Depth	Float	false	Y
flow	Flow	Float	false	WN_Q
flow_when_falling	Flow When Falling	Float	false	WN_Q
flow_when_rising	Flow When Rising	Float	false	WN_Q
opening	Opening	Float	false	WN_OPEN
opening_when_falling	Opening When Falling	Float	false	WN_OPEN
opening_when_rising	Opening When Rising	Float	false	WN_OPEN
pressure	Pressure	Float	false	WN_P
pressure_closed	Pressure Closed	Float	false	WN_P
pressure_open	Pressure Open	Float	false	WN_P
red_pres	Reducing Pressure	Float	false	WN_P
sus_pres	Sustaining Pressure	Float	false	WN_P

wn_ctl_drawdown_curve

Description (User Interface): Drawdown Curve

Name	Description	Type	Size	Flag	Unit	Notes
drawdown	Drawdown	Float		false	Y
flow	Flow	Float		false	WN_Q

Control

Tables

wn_ctl_fixed_head

wn_ctl_float_valve

wn_ctl_hydrant

wn_ctl_meter

wn_ctl_node

wn_ctl_non_return_valve

wn_ctl_open_channel

wn_ctl_pipe

wn_ctl_profile

wn_ctl_pst

wn_ctl_reservoir

wn_ctl_run

wn_ctl_transfer_node

wn_ctl_valve

wn_ctl_well

Structures

wn_ctl_iwts_surge_pres_tme

wn_ctl_level_profile

wn_ctl_node_wq_age

wn_ctl_node_wq_flow

wn_ctl_node_wq_conc

wn_ctl_node_wq_turb

wn_ctl_pipe_status

wn_ctl_opening_profile

wn_ctl_node_xd_flow

wn_ctl_node_iwts_event

wn_ctl_node_iwts_tank_depth_area

wn_ctl_profile_data

wn_ctl_pump_iwts_event

wn_ctl_pst_turbine_change

wn_ctl_pst_wicket_gate_change

wn_ctl_pst_profiles

wn_ctl_pst_pumps

wn_ctl_transfer_node_flows

wn_ctl_valve_iwts_event

wn_ctl_valve_profiles

wn_ctl_drawdown_curve

Was this information helpful?