General Asset Data Fields (Distribution)

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

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

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

Common Data Fields

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

General Asset Data

Database Table Name: wams_general_asset

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

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          
Type

Database Value

Description
Breakwater Breakwater
Embankment Embankment
Revetment Revetment
Sea wall Sea wall
Structure Structure
type Text 64              
Name Descriptive name of asset. name Text 200   0          
Owner The proprietor of the asset. owner Text 64   0          
Maintained by

Database Value

Description
Maintainer 1 Maintainer 1
Maintainer 2 Maintainer 2

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

 maintained_by Text 100              
Status

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.

 status Text 10   1          
Location Address / description of the location of the asset. location Text 100   0          
X coordinate X coordinate of the object. x Double   XY 2          
Y coordinate Y coordinate of the object. y Double   XY 2          
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       0 5
Critical A measure of the likely impact of asset failure. 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         999
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          
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 fields See Common Data Fields for details of field in the General properties section of the property sheet.                    
User defined properties 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                  
Network Data Fields

Further information about all the Network Object fields stored in the database can be found in the Network Data Fields section.

Asset Points

Asset Grid