Vortex Data Fields

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

US node ID

Upstream node.

us_node_id

Text

40

0

DS node ID

Downstream node.

ds_node_id

Text

40

0

Owner

The proprietor of the asset.

owner

Text

64

0

System type

System type:

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

10

0

Type

The type of ancillary structure:

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

type

Text

10

0

Operational status

Current operational status:

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

status

Text

10

1

X coord

X coordinate of the object.

x

Double

XY

2

Y coord

Y coordinate of the object.

y

Double

XY

2

Branch ID

Numeric field used to identify to which long section the link is associated. (See Defining Branches for further information).

branch_id

Long Integer

0

Serial number

Identification number on the piece of equipment.

serial_no

Text

100

0

0

0

0

Max design flow

Peak design discharge.

max_design_flow

Double

Q

3

0

Aerated

Check box defining if the vortex allows for aeration of the flow.

aerated

Boolean

0

Manufacturer

Vortex manufacturer.

manufacturer

Text

100

0

0

0

0

Inlet diameter

Vortex inlet diameter.

diameter

Double

MANH_DIM

0

0

Inlet height

Height of the inlet.

inlet_height

Double

MANH_DIM

0

Outlet diameter

Diameter of the vortex cone.

outlet_diameter

Double

MANH_DIM

0

0

Inlet level

Level of the inlet.

inlet_level

Double

Z

3

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:

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

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.

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.