Outlet Data Fields

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

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

The following describes all the data which can be used to define an outlet.

Common Data Fields

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

Outlet Data

Database Table Name: cams_outlet

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

ID

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

40

 

0

 

 

 

 

 

X coordinate

X coordinate of the object.

x

Double

 

XY

2

 

 

 

 

 

Y coordinate

Y coordinate of the object.

y

Double

 

XY

2

 

 

 

 

 

Ground level

Height above datum of ground surface.

ground_level

Double

 

Z

3

 

 

 

-99.99

999.99
System type

System type:

Database Value Description
F Foul
S Surface
C Combined
T Transition
O Overflow
U Unspecified

The options available in the dropdown list depend on which coding standard is being used. See the Standards and Choice Lists dialog for further information.

 system_type Text 100   0          
Type

Choice list of inlet/outlet:

Database Value Description
Outlet Outlet
Inlet Inlet

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

 type Text 100   0          
Zone The zone in which the asset is contained. zone Text 100              
Asset ID

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

 asset_id Text 100              
Owner The proprietor of the asset. owner Text 64   0          
Vaulted Check this option if outlet is vaulted. vaulted Boolean                
Operational status

The current operational status of the asset:

Database Value

Description

AB

Abandoned

INUSE

In Use

STANDBY

Standby

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

 status Text 100              
Description Additional details. description Text 100              
Watercourse Identifier of the watercourse to which outlet discharges. waterc Text 100              
Watercourse name Name of the watercourse to which outlet discharges. waterc_name Text 100              
Watercourse type

Type of watercourse to which outlet discharges:

Database Value Description
Stream Stream
River River
Channel Channel

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

 waterc_type Text 100              
Watercourse level Height above datum of the water level in the watercourse to which outlet discharges. waterc_level Double   Z         -99.99 999.99
Watercourse biotic index
Assessment of biological water quality of the watercourse to which outlet discharges.		 waterc_bio_index Text 100              
Watercourse quality target Water quality target values for the watercourse to which outlet discharges. waterc_qual_target Text 100              

Condition grade

A measure of asset condition for ancillary assets. By analogy with pipe condition grades, this is usually a number in the range 1-5. Unlike pipe condition grade, there is no distinction between structural and service condition for ancillary assets.

 condition_grade Long Integer     0          
Critical

A measure of the likely impact of asset failure. The WRC SRM uses the codes A, B, C to represent "A" sewers where failures would be expensive to "C" where failures would be relatively cheap.

 criticality Text 5   0          
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 10   0          
Construction date

Construction or installation date. This is date from which depreciation costs will be incurred for depreciation reports.

 constr_date Date / Time     0          
Condition survey date

Date of the most recent condition survey of the asset.

 survey_date Date / Time     0          
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 2          
Inspection cost

Estimated cost of asset inspection.

 inspection_cost Double   WN_COST 2          
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     0          
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 2          
Replacement cost

The estimated cost for completely replacing an asset.

 replace_cost Double   WN_COST 2          

Lateral US node ID

Reference ID of upstream node of pipe to which node is laterally connected.

lat_us_node_id

Text

40

 

0

 

0

0

0

0

Lateral DS node ID

Reference ID of downstream node of pipe to which node is laterally connected.

lat_ds_node_id

Text

40

 

0

 

0

0

0

0

Lateral link suffix

Link suffix of pipe to which node is laterally connected.

lat_link_suffix

Text

1

 

0

 

0

0

0

0
Lateral channel ID ID of channel to which node is laterally connected. lat_channel_id Text 40              

Lateral distance from US 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

 

L

2

 

0

0

0

0

Lateral circumferential location

Clock reference of position of node on pipe to which node is laterally connected.

lat_circ_location

Integer

 

 

0

 

0

0

0

0
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                  
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 asset.

 tsdb_links                  

Asset Grid

Nodes